oracle供应商导入,供应商导入的API补充（详解EBS接口开发之供应商导入）

--供应商

--创建

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_ret