--供应商--创建AP_VENDOR_PUB_PKG.Create_Vendor( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_recINr_vendor_rec_type,x_vendor_idOUTNOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE,x_party_idOUTNOCOPY HZ_PARTIES.PARTY_ID%TYPE);--更新AP_VENDOR_PUB_PKG.Update_Vendor( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_recINr_vendor_rec_type,p_vendor_idINNUMBER);--验证AP_VENDOR_PUB_PKG.Validate_Vendor( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_recIN OUTNOCOPY r_vendor_rec_type,p_modeINVARCHAR2,p_calling_progINVARCHAR2,x_party_validOUTNOCOPY VARCHAR2,x_payee_validOUTNOCOPY VARCHAR2,p_vendor_idINNUMBER);--供应商地点--创建AP_VENDOR_PUB_PKG.Create_Vendor_Site( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_site_recINr_vendor_site_rec_type,x_vendor_site_idOUTNOCOPY NUMBER,x_party_site_idOUTNOCOPY NUMBER,x_location_idOUTNOCOPY NUMBER);--更新AP_VENDOR_PUB_PKG.Update_Vendor_Site( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_site_recINr_vendor_site_rec_type,p_vendor_site_idINNUMBER,p_calling_progINVARCHAR2 DEFAULT 'NOT ISETUP');--验证AP_VENDOR_PUB_PKG.Validate_Vendor_Site( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_site_recIN OUTNOCOPY r_vendor_site_rec_type,p_modeINVARCHAR2,p_calling_progINVARCHAR2,x_party_site_validOUTNOCOPY VARCHAR2,x_location_validOUTNOCOPY VARCHAR2,x_payee_validOUTNOCOPY VARCHAR2,p_vendor_site_idINNUMBER);--供应商联系人--创建AP_VENDOR_PUB_PKG.Create_Vendor_Contact( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_contact_recINr_vendor_contact_rec_type,x_vendor_contact_idOUTNOCOPY NUMBER,x_per_party_idOUTNOCOPY NUMBER,x_rel_party_idOUT NOCOPY NUMBER,x_rel_idOUTNOCOPY NUMBER,x_org_contact_idOUTNOCOPY NUMBER,x_party_site_idOUTNOCOPY NUMBER);--更新AP_VENDOR_PUB_PKG.Update_Vendor_Contact( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER:= FND_API.G_VALID_LEVEL_FULL,p_vendor_contact_recINr_vendor_contact_rec_type,x_return_statusOUTNOCOPY VARCHAR2 ,x_msg_count OUTNOCOPY NUMBER,x_msg_data OUTNOCOPY VARCHAR2);--验证AP_VENDOR_PUB_PKG.Validate_Vendor_Contact( p_api_version INNUMBER, p_init_msg_listINVARCHAR2 := FND_API.G_FALSE,p_commit IN VARCHAR2 := FND_API.G_FALSE,p_validation_levelIN NUMBER := FND_API.G_VALID_LEVEL_FULL,x_return_statusOUTNOCOPY VARCHAR2,x_msg_countOUTNOCOPY NUMBER,x_msg_dataOUTNOCOPY VARCHAR2,p_vendor_contact_recIN OUTNOCOPY r_vendor_contact_rec_type,x_rel_party_valid OUT NOCOPY VARCHAR2,x_per_party_valid OUT NOCOPY VARCHAR2,x_rel_valid OUT NOCOPY VARCHAR2,x_org_party_idOUTNOCOPY NUMBER,x_org_contact_valid OUT NOCOPY VARCHAR2,x_location_idOUT NOCOPY NUMBER, x_party_site_valid OUT NOCOPY VARCHAR2);--导入供应商--供应商AP_VENDOR_PUB_PKG.Import_Vendors( p_api_version IN NUMBER, p_source IN VARCHAR2 DEFAULT 'IMPORT', p_what_to_import IN VARCHAR2 DEFAULT NULL, p_commit_size IN NUMBER DEFAULT 1000, x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2);--地点AP_VENDOR_PUB_PKG.Import_Vendor_Sites( p_api_version IN NUMBER, p_source IN VARCHAR2 DEFAULT 'IMPORT', p_what_to_import IN VARCHAR2 DEFAULT NULL, p_commit_size IN NUMBER DEFAULT 1000, p_org_id IN NUMBER DEFAULT NULL, --bug13801271 x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2);--联系人AP_VENDOR_PUB_PKG.Import_Vendor_Contacts( p_api_version IN NUMBER, p_source IN VARCHAR2 DEFAULT 'IMPORT', p_what_to_import IN VARCHAR2 DEFAULT NULL, p_commit_size IN NUMBER DEFAULT 1000, x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2);