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 12792: DELETE AP_SUPPLIER_INT_REJECTIONS

12788: WHERE fcr.request_id = api.import_request_id
12789: AND fcr.phase_code = 'C' );
12790: -- udhenuko Bug 6823885 End
12791: --bug 5591652
12792: DELETE AP_SUPPLIER_INT_REJECTIONS
12793: WHERE PARENT_TABLE='AP_SUPPLIERS_INT';
12794: -- Updating Interface Record with request id
12795:
12796: UPDATE Ap_Suppliers_Int

Line 13359: DELETE AP_SUPPLIER_INT_REJECTIONS

13355: WHERE fcr.request_id = api.import_request_id
13356: AND fcr.phase_code = 'C' );
13357: -- udhenuko Bug 6823885 End
13358: --bug 5584046
13359: DELETE AP_SUPPLIER_INT_REJECTIONS
13360: WHERE PARENT_TABLE='AP_SUPPLIER_SITES_INT';
13361:
13362: -- Updating Interface Record with request id
13363:

Line 13379: INSERT INTO Ap_Supplier_Int_Rejections

13375: WHERE (operating_unit_name IS NULL AND org_id IS NULL) OR
13376: vendor_id IS NULL ;
13377:
13378: --bug 5584046
13379: INSERT INTO Ap_Supplier_Int_Rejections
13380: (SELECT 'AP_SUPPLIER_SITES_INT',vendor_site_interface_id,'AP_ORG_INFO_NULL',
13381: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
13382: FROM Ap_Supplier_Sites_Int
13383: WHERE STATUS='REJECTED'

Line 13974: DELETE AP_SUPPLIER_INT_REJECTIONS

13970: WHERE fcr.request_id = api.import_request_id
13971: AND fcr.phase_code = 'C' );
13972: --udhenuko Bug 6823885 End
13973: --bug 5591652
13974: DELETE AP_SUPPLIER_INT_REJECTIONS
13975: WHERE PARENT_TABLE='AP_SUP_SITE_CONTACT_INT';
13976: -- Updating Interface Record with request id
13977:
13978: UPDATE Ap_Sup_Site_Contact_Int

Line 13998: insert into ap_supplier_int_rejections

13994: (vendor_id in(select vendor_id from ap_suppliers
13995: where vendor_type_lookup_code = 'EMPLOYEE')));
13996:
13997: --bug 5591652
13998: insert into ap_supplier_int_rejections
13999: (select 'AP_SUP_SITE_CONTACT_INT',vendor_contact_interface_id,'AP_ORG_INFO_NULL',
14000: g_user_id,SYSDATE,g_login_id,g_user_id,SYSDATE
14001: from ap_sup_site_contact_int
14002: where status='REJECTED'