供应商导入的API补充(详解EBS接口开发之供应商导入)

来源:互联网 发布:linux网络配置文件 编辑:程序博客网 时间:2024/05/01 00:06
--供应商--创建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);

原创粉丝点击