APPS.PSA_UTILS dependencies on AP_INVOICES_ALL

Line 277: SELECT * FROM AP_INVOICES_ALL WHERE INVOICE_ID = '||p_entity_rec.source_id_int_1;

273: IF (p_entity_rec.application_id = 200 AND p_entity_rec.entity_code = 'AP_INVOICES') THEN
274: IF (p_retcode = g_SUCCESS) THEN
275: BEGIN
276: l_string := 'CREATE TABLE PSA_BKP_AP_INV_HDRS_'||l_backup_string||' AS
277: SELECT * FROM AP_INVOICES_ALL WHERE INVOICE_ID = '||p_entity_rec.source_id_int_1;
278: EXECUTE IMMEDIATE l_string;
279: EXCEPTION
280: WHEN OTHERS THEN
281: log(l_path_name, 'EXCEPTION: '|| SQLERRM(sqlcode));

Line 1316: l_invoice_num ap_invoices_all.invoice_num%TYPE;

1312: l_start_log_id NUMBER;
1313: l_end_log_id NUMBER;
1314: l_org_id NUMBER;
1315: l_ledger_id NUMBER;
1316: l_invoice_num ap_invoices_all.invoice_num%TYPE;
1317:
1318: BEGIN
1319: l_retcode := g_SUCCESS;
1320:

Line 1854: p_invoice_num OUT NOCOPY ap_invoices_all.invoice_num%TYPE,

1850: (
1851: p_user_id IN NUMBER,
1852: p_resp_id IN NUMBER,
1853: p_invoice_id IN NUMBER,
1854: p_invoice_num OUT NOCOPY ap_invoices_all.invoice_num%TYPE,
1855: p_org_id OUT NOCOPY NUMBER,
1856: p_ledger_id OUT NOCOPY NUMBER
1857: )
1858: IS

Line 1892: p_po_num OUT NOCOPY ap_invoices_all.invoice_num%TYPE,

1888: (
1889: p_user_id IN NUMBER,
1890: p_resp_id IN NUMBER,
1891: p_po_header_id IN NUMBER,
1892: p_po_num OUT NOCOPY ap_invoices_all.invoice_num%TYPE,
1893: p_org_id OUT NOCOPY NUMBER,
1894: p_ledger_id OUT NOCOPY NUMBER
1895: )
1896: IS