Supplier One time insert

Text Data

insert into AP_SUPPlIERS_INT(VENDOR_INTERFACE_ID,VENDOR_NAME) values (ap_suppliers_int_s.NEXTVAL,'ICICI222')

insert into ap_supplier_sites_int(vendor_interface_id,vendor_site_interface_id,VENDOR_SITE_CODE,COUNTRY,ADDRESS_LINE1,org_id)

values(ap_suppliers_int_s.currval,ap_supplier_sites_int_s.NEXTVAL,'Hyderabad','IN','SRNAGAR',204)

select status from ap_suppliers_int where vendor_name = 'ICICI222' --and status is null

select * from ap_supplier_sites_int where vendor_interface_id = 13006 --vendor_site_code = 'Hyderabad'

select * from fnd_user where user_name = 'OPERATIONS'

select * from fnd_responsibility where RESPONSIBILITY_KEY = 'PAYABLES_OPERATION'

select * from ap_suppliers_int

delete from ap_suppliers_int

select * from ap_supplier_sites_int

delete from ap_supplier_sites_int

 concurrent program -- supplier open interface import

 short name-----APXSUIMP

 resp id --50554

 resp_app_id--200

 user_id--1318

 

commit

select * from ap_suppliers where vendor_name='ICICI999'

select * from ap_supplier_sites_all where vendor_id =47189

Submit Request for supplier

=======================================

declare

v_request_id number;

begin

FND_GLOBAL.APPS_INITIALIZE(1318,50554,200);

v_request_id := FND_REQUEST.SUBMIT_REQUEST

                ('SQLAP',

                 'APXSUIMP',

                 null,

                 sysdate,

                 TRUE,

                  'ALL',

                 1000,

                 'N',

                 'N',

                 'N');

if v_request_id > 0 then

dbms_output.put_line('Request submitted successfully');

dbms_output.put_line(v_request_id);

else

dbms_output.put_line('Request submission failure');

dbms_output.put_line('errmsg:-'||sqlerrm);

dbms_output.put_line('errcode:-'||sqlcode);

end if;

commit;

end;

2) submit request for supplier sites

===============================================

declare

v_request_id number;

begin

FND_GLOBAL.APPS_INITIALIZE(1318,50554,200);

v_request_id := FND_REQUEST.SUBMIT_REQUEST

                ('SQLAP',

                 'APXSSIMP',

                 null,

                 sysdate,

                 TRUE,

                  'ALL',

                 1000,

                 'N',

                 'N',

                 'N');

if v_request_id > 0 then

dbms_output.put_line('Request submitted successfully');

dbms_output.put_line(v_request_id);

else

dbms_output.put_line('Request submission failure');

dbms_output.put_line('errmsg:-'||sqlerrm);

dbms_output.put_line('errcode:-'||sqlcode);

end if;

commit;end;

insert into AP_SUP_SITE_CONTACT_INT(LAST_NAME,ORG_ID,VENDOR_CONTACT_INTERFACE_ID,VENDOR_INTERFACE_ID,PHONE,vendor_id,vendor_site_id)                                     

values('nalam',204,AP_SUP_SITE_CONTACT_INT_S.NEXTVAL,ap_suppliers_int_s.currval,9959666537,47192,) 

3) Submit Request for contact Information

===================================================

declare

v_request_id number;

begin

FND_GLOBAL.APPS_INITIALIZE(1318,50554,200);

v_request_id := FND_REQUEST.SUBMIT_REQUEST

                ('SQLAP',

                 'APXSCIMP',

                 null,

                 sysdate,

                 TRUE,

                  'ALL',

                 1000,

                 'N',

                 'N',

                 'N');

if v_request_id > 0 then

dbms_output.put_line('Request submitted successfully');

dbms_output.put_line(v_request_id);

else

dbms_output.put_line('Request submission failure');

dbms_output.put_line('errmsg:-'||sqlerrm);

dbms_output.put_line('errcode:-'||sqlcode);

end if;

commit;end;

supplier Api

===================================================

ap_vendor_pub_pkg

POS_SUPP_CONTACT_PKG

fnd_api

select * from all_tables where table_name like 'FND%REQUEST%'

SELECT * FROM FND_CONCURRENT_REQUESTS WHERE TRUNC(SYSDATE)=TRUNC(REQUEST_DATE)

AND CONCURRENT_PROGRAM_ID = 47176

ORDER BY 1 DESC