APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_INT_REJECTIONS

Line 59: l_debug_info := '(Insert Rejections 1) Insert into AP_SUPPLIER_INT_REJECTIONS, '||

55: ||', p_parent_id: '||to_char(p_parent_id)
56: ||', p_reject_code: '||p_reject_code);
57: END IF;
58: --
59: l_debug_info := '(Insert Rejections 1) Insert into AP_SUPPLIER_INT_REJECTIONS, '||
60: 'REJECT CODE:'||p_reject_code;
61: --
62: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
63: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 66: INSERT INTO AP_SUPPLIER_INT_REJECTIONS(

62: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
63: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
64: END IF;
65:
66: INSERT INTO AP_SUPPLIER_INT_REJECTIONS(
67: parent_table,
68: parent_id,
69: reject_lookup_code,
70: last_updated_by,

Line 15827: DELETE AP_SUPPLIER_INT_REJECTIONS

15823: WHERE fcr.request_id = api.import_request_id
15824: AND fcr.phase_code = 'C' );
15825: -- udhenuko Bug 6823885 End
15826: --bug 5591652
15827: DELETE AP_SUPPLIER_INT_REJECTIONS
15828: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';
15829: -- Updating Interface Record with request id
15830:
15831: UPDATE Ap_Suppliers_Int

Line 16689: DELETE AP_SUPPLIER_INT_REJECTIONS

16685: ;
16686:
16687: -- udhenuko Bug 6823885 End
16688: --bug 5584046
16689: DELETE AP_SUPPLIER_INT_REJECTIONS
16690: WHERE PARENT_TABLE='AP_SUPPLIER_SITES_INT';
16691:
16692: -- Updating Interface Record with request id
16693:

Line 16715: INSERT INTO Ap_Supplier_Int_Rejections

16711: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16712: ;
16713:
16714: --bug 5584046
16715: INSERT INTO Ap_Supplier_Int_Rejections
16716: (parent_table,
16717: parent_id,
16718: reject_lookup_code,
16719: last_updated_by,

Line 17604: DELETE AP_SUPPLIER_INT_REJECTIONS

17600: WHERE fcr.request_id = api.import_request_id
17601: AND fcr.phase_code = 'C' );
17602: --udhenuko Bug 6823885 End
17603: --bug 5591652
17604: DELETE AP_SUPPLIER_INT_REJECTIONS
17605: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';
17606: -- Updating Interface Record with request id
17607:
17608: UPDATE Ap_Sup_Site_Contact_Int

Line 17628: insert into ap_supplier_int_rejections

17624: (vendor_id in(select vendor_id from ap_suppliers
17625: where vendor_type_lookup_code = 'EMPLOYEE')));
17626:
17627: --bug 5591652
17628: insert into ap_supplier_int_rejections
17629: /* Bug 12590128 start */
17630: /*(select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',
17631: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
17632: from ap_sup_site_contact_int