APPS.PSA_UTILS dependencies on AP_INVOICES

Line 273: IF (p_entity_rec.application_id = 200 AND p_entity_rec.entity_code = 'AP_INVOICES') THEN

269: p_errbuf := NULL;
270: l_path_name := g_path_name || '.end_xla_audit';
271:
272: l_backup_string := LPAD(TO_CHAR (p_audit_id), 10, '0');
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;

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 1111: l_entity_code := 'AP_INVOICES';

1107:
1108: IF (p_retcode = g_SUCCESS) THEN
1109: mo_global.set_policy_context('S',p_org_id);
1110: l_application_id := 200;
1111: l_entity_code := 'AP_INVOICES';
1112: debug_other_string(g_state_level,l_path_name, 'Calling Generic undo_xla_accounting' );
1113: undo_xla_accounting
1114: (
1115: p_errbuf => p_errbuf,

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 1873: FROM ap_invoices

1869: SELECT org_id,
1870: invoice_num
1871: INTO p_org_id,
1872: p_invoice_num
1873: FROM ap_invoices
1874: WHERE invoice_id = p_invoice_id;
1875:
1876: mo_utils.get_ledger_info(p_org_id, p_ledger_id, l_ledger_name);
1877:

Line 1883: undo_error ('Selecting ap_invoices: '||SQLERRM);

1879: WHEN NO_DATA_FOUND THEN
1880: undo_error ('Invalid Invoice Id or User does not have access to Invoice Id: '||p_invoice_id);
1881: RAISE;
1882: WHEN OTHERS THEN
1883: undo_error ('Selecting ap_invoices: '||SQLERRM);
1884: RAISE;
1885: END;
1886:
1887: PROCEDURE validate_po_header_id

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

Line 1921: undo_error ('Selecting ap_invoices: '||SQLERRM);

1917: WHEN NO_DATA_FOUND THEN
1918: undo_error ('Invalid PO Header Id or User does not have access to PO Header Id: '||p_po_header_id);
1919: RAISE;
1920: WHEN OTHERS THEN
1921: undo_error ('Selecting ap_invoices: '||SQLERRM);
1922: RAISE;
1923: END;
1924:
1925: PROCEDURE validate_gl_date