Entries by Oracle ERP Apps Guide

, ,

API – Vendor Site Update

l_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;   l_vendor_site_rec.vendor_id := v_vendor_id;     — Supplier Id  l_vendor_site_rec.org_id    := v_org_id;          — Operating Unit id  x_vendor_site_id            :=v_site_id;             — Site Id to be updated    l_vendor_site_rec.email_address := ‘[email protected]‘;  — eg: Email address update AP_VENDOR_PUB_PKG.Update_Vendor_Site                    (   p_api_version     => 1,                        x_return_status   => x_return_status,                        x_msg_count       => x_msg_count,                        x_msg_data        => x_msg_data,                        p_vendor_site_rec => l_vendor_site_rec,                        p_vendor_site_id  => […]

/by
, ,

API – Supplier & Supplier Site Creation

declare        l_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;        l_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;        x_return_status VARCHAR2(2000);        x_msg_count NUMBER;        x_msg_data VARCHAR2(2000);        l_upd number := 0;        x_vendor_id number;        x_party_id number;        x_vendor_site_id number;        x_party_site_id number;        x_location_id number;        l_party_site_id number;        l_organization_id number;begin     –mo_global.set_policy_context(‘S’,1650);          l_vendor_rec.SEGMENT1     := ‘1234577’;          l_vendor_rec.VENDOR_NAME  := ‘TESTSUPPLIER’;          l_vendor_rec.SUMMARY_FLAG := ‘N’;          l_vendor_rec.ENABLED_FLAG := ‘Y’;           AP_VENDOR_PUB_PKG.Create_Vendor            ( p_api_version    => 1,              x_return_status  => x_return_status,              x_msg_count      => x_msg_count,              x_msg_data       => […]

/by
, ,

API – AR Cash Receipt

CREATE OR REPLACE PROCEDURE APPS.XX_CREATE_CASH_RECEIPT_APPLY(errbuf out NOCOPY varchar2,retcode out NOCOPY varchar2) ISL_RETURN_STATUS VARCHAR2(240);L_MSG_COUNT NUMBER;L_MSG_DATA VARCHAR2(240);L_CASH_RECEIPT_ID NUMBER;v_customer_number VARCHAR2(240);v_cust_name VARCHAR(240);v_amount NUMBER;v_receipt_number NUMBER; CURSOR C1ISSELECT * FROM XX_AR_RECEIPTS_GMC; BEGIN BEGINMO_GLOBAL.SET_POLICY_CONTEXT(‘S’,150);END;FOR I IN C1 LOOP BEGIN v_cust_name := I.customer_name; –substr(I.CUSTOMER_NAME,1,length(I.CUSTOMER_NAME)-1);SELECT DISTINCT ARC.CUSTOMER_NUMBERINTO v_customer_numberFROM AR_CUSTOMERS ARC,HZ_CUST_ACCOUNTS_ALL HCA ,HZ_CUST_ACCT_SITES_ALL HCASWHERE HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_IDAND HCA.CUST_ACCOUNT_ID = ARC.CUSTOMER_IDAND HCAS.ORG_ID = 150 AND LTRIM(RTRIM(UPPER(ARC.CUSTOMER_NAME))) […]

/by
,

API – Inventory Item Category Combination Creation

CREATE OR REPLACE PROCEDURE APPS.xx_create_new_item_categoryIS l_category_rec inv_item_category_pub.category_rec_type;/* Query to check results SELECT M1.SEGMENT1||’.’||M1.SEGMENT2||’.’||M1.SEGMENT3||’.’||M1.SEGMENT4||’.’||M1.SEGMENT5||’.’||M1.SEGMENT6 FROM MTL_CATEGORIES_B M1, MTL_CATEGORIES_TL M2 WHERE M1.CATEGORY_ID = M2.CATEGORY_ID AND M2.LANGUAGE = ‘US’ Table Structure CREATE TABLE XX_CREATE_NEW_CATEGORY ( STRUCTURE_ID NUMBER, SEGMENT1 VARCHAR2(2000 BYTE), SEGMENT2 VARCHAR2(2000 BYTE), SEGMENT3 VARCHAR2(2000 BYTE), SEGMENT4 VARCHAR2(2000 BYTE), SEGMENT5 VARCHAR2(2000 BYTE), SEGMENT6 VARCHAR2(2000 BYTE) )*/ CURSOR c_cat […]

/by
, ,

API – Update Contact details of Contact Person(Suppliers)

declare l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type; l_email_rec         HZ_CONTACT_POINT_V2PUB.email_rec_type; l_contact_point_id  NUMBER; x_return_status VARCHAR2(2000); x_msg_count NUMBER; x_msg_data VARCHAR2(2000);begin    l_contact_point_rec.owner_table_id := 226285;                     l_contact_point_rec.contact_point_type :=’EMAIL’;    l_contact_point_rec.owner_table_name := ‘HZ_PARTIES’;    l_contact_point_rec.created_by_module :=’POS_SUPPLIER_MGMT’;    l_email_rec.email_address := ‘[email protected]‘ ; HZ_CONTACT_POINT_V2PUB.create_email_contact_point   (    p_contact_point_rec =>  l_contact_point_rec,       p_email_rec         =>  l_email_rec,      x_contact_point_id  =>  l_contact_point_id,             x_return_status     =>  x_return_status,    x_msg_count         =>  x_msg_count,    x_msg_data          =>  x_msg_data  );  if (x_return_status <> ‘S’) then                    dbms_output.put_line(‘Encountered ERROR in supplier contact […]

/by