eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAAPIMP_PKG dependencies on AP_INVOICES

Line 369: p_invoice_source1 IN ap_invoices.source%TYPE,

365: /* IC Upgrade: transaction source variables are now initialize after we fetched
366: the record from the cursor
367: P_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
368: p_user_transaction_source IN pa_transaction_interface.user_transaction_source%TYPE,*/
369: p_invoice_source1 IN ap_invoices.source%TYPE,
370: p_invoice_source2 IN ap_invoices.source%TYPE,
371: p_invoice_source3 IN ap_invoices.source%TYPE,
372: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
373: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,

Line 370: p_invoice_source2 IN ap_invoices.source%TYPE,

366: the record from the cursor
367: P_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
368: p_user_transaction_source IN pa_transaction_interface.user_transaction_source%TYPE,*/
369: p_invoice_source1 IN ap_invoices.source%TYPE,
370: p_invoice_source2 IN ap_invoices.source%TYPE,
371: p_invoice_source3 IN ap_invoices.source%TYPE,
372: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
373: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,
374: p_process_receipts IN VARCHAR2

Line 371: p_invoice_source3 IN ap_invoices.source%TYPE,

367: P_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
368: p_user_transaction_source IN pa_transaction_interface.user_transaction_source%TYPE,*/
369: p_invoice_source1 IN ap_invoices.source%TYPE,
370: p_invoice_source2 IN ap_invoices.source%TYPE,
371: p_invoice_source3 IN ap_invoices.source%TYPE,
372: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
373: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,
374: p_process_receipts IN VARCHAR2
375: ) IS

Line 372: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,

368: p_user_transaction_source IN pa_transaction_interface.user_transaction_source%TYPE,*/
369: p_invoice_source1 IN ap_invoices.source%TYPE,
370: p_invoice_source2 IN ap_invoices.source%TYPE,
371: p_invoice_source3 IN ap_invoices.source%TYPE,
372: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
373: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,
374: p_process_receipts IN VARCHAR2
375: ) IS
376:

Line 1082: p_invoice_id IN ap_invoices.invoice_id%TYPE,

1078:
1079:
1080: FUNCTION create_new_org_transref (
1081: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1082: p_invoice_id IN ap_invoices.invoice_id%TYPE,
1083: p_invoice_distribution_id IN ap_invoice_distributions.invoice_distribution_id%TYPE)
1084: RETURN pa_transaction_interface.orig_transaction_reference%TYPE IS
1085:
1086: BEGIN

Line 1355: FROM AP_INVOICES inv

1351: AND 'N' = (select cost_rate_flag
1352: from pa_expenditure_types
1353: where expenditure_type = dist.expenditure_type)
1354: AND EXISTS (SELECT invoice_id
1355: FROM AP_INVOICES inv
1356: WHERE inv.invoice_id = DIST.invoice_id
1357: AND inv.invoice_type_lookup_code = 'EXPENSE REPORT')
1358: AND ( nvl(dist.encumbered_flag,'N') = 'R' )
1359: AND NOT EXISTS (SELECT NULL

Line 1412: FROM AP_INVOICES inv

1408: AND 'N' = (select cost_rate_flag
1409: from pa_expenditure_types
1410: where expenditure_type = dist.expenditure_type)
1411: AND EXISTS (SELECT invoice_id
1412: FROM AP_INVOICES inv
1413: WHERE inv.invoice_id = DIST.invoice_id
1414: AND inv.invoice_type_lookup_code = 'EXPENSE REPORT')
1415: AND ( nvl(dist.encumbered_flag,'N') = 'R' )
1416: AND NOT EXISTS (SELECT NULL

Line 1485: FROM AP_INVOICES inv

1481: AND dist.parent_reversal_id = dist1.invoice_distribution_id
1482: AND dist1.pa_addition_flag = 'T'
1483: AND dist1.encumbered_flag = 'R')
1484: AND EXISTS (SELECT invoice_id
1485: FROM AP_INVOICES inv
1486: WHERE inv.invoice_id = DIST.invoice_id
1487: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT');
1488:
1489: write_log(LOG, 'Updated '||to_char(SQL%ROWCOUNT)|| 'invoice distributions to Z for Encumbrance');

Line 1537: FROM AP_INVOICES inv

1533: AND dist.parent_reversal_id = dist1.invoice_distribution_id
1534: AND dist1.pa_addition_flag = 'T'
1535: AND dist1.encumbered_flag = 'R')
1536: AND EXISTS (SELECT invoice_id
1537: FROM AP_INVOICES inv
1538: WHERE inv.invoice_id = DIST.invoice_id
1539: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT');
1540:
1541: write_log(LOG, 'Updated '||to_char(SQL%ROWCOUNT)|| 'invoice distributions to Z for Encumbrance');

Line 1661: FROM AP_INVOICES inv,

1657: AND DIST.project_id > 0
1658: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1659: AND ((
1660: exists (SELECT NULL
1661: FROM AP_INVOICES inv,
1662: AP_Invoice_distributions DIST1,
1663: PO_VENDORS vend
1664: WHERE inv.invoice_id = DIST1.invoice_id
1665: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id

Line 1679: ap_invoices inv1,

1675: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1676: OR
1677: (EXISTS ( SELECT NULL
1678: FROM PO_VENDORS vend1,
1679: ap_invoices inv1,
1680: ap_invoice_distributions dist2
1681: WHERE inv1.invoice_id = dist2.invoice_id
1682: AND inv1.invoice_id = dist.invoice_id
1683: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )

Line 1727: FROM AP_INVOICES inv,

1723: AND dist.prepay_distribution_id is not null
1724: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
1725: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
1726: AND exists (SELECT NULL
1727: FROM AP_INVOICES inv,
1728: PO_VENDORS vend
1729: WHERE inv.invoice_id = DIST.invoice_id
1730: AND inv.vendor_id = vend.vendor_id
1731: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 1739: FROM AP_INVOICES inv,

1735: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
1736: AND inv.source in ('CREDIT CARD','Both Pay')
1737: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)))
1738: AND exists(SELECT inv.invoice_id
1739: FROM AP_INVOICES inv,
1740: AP_Invoice_Distributions_all aid
1741: WHERE aid.invoice_id = inv.invoice_id
1742: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
1743: AND aid.historical_flag = 'Y'

Line 1770: FROM AP_INVOICES inv,

1766: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
1767: AND DIST.project_id > 0
1768: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1769: AND exists (SELECT NULL
1770: FROM AP_INVOICES inv,
1771: PO_VENDORS vend
1772: WHERE inv.invoice_id = DIST.invoice_id
1773: AND inv.vendor_id = vend.vendor_id
1774: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 1811: FROM AP_INVOICES inv,

1807: AND DIST.project_id > 0
1808: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1809: AND (
1810: (exists (SELECT NULL
1811: FROM AP_INVOICES inv,
1812: AP_Invoice_distributions DIST1,
1813: PO_VENDORS vend
1814: WHERE inv.invoice_id = DIST1.invoice_id
1815: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id

Line 1829: ap_invoices inv1, ap_invoice_distributions dist2

1825: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1826: OR
1827: (EXISTS ( SELECT NULL
1828: FROM PO_VENDORS vend1,
1829: ap_invoices inv1, ap_invoice_distributions dist2
1830: WHERE inv1.invoice_id = dist2.invoice_id
1831: AND inv1.invoice_id = dist.invoice_id
1832: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )
1833: AND dist2.invoice_distribution_id = dist.parent_reversal_id --Process Historical data reversals as Invoices in Cash based

Line 1873: FROM AP_INVOICES_ALL inv,

1869: AND dist.prepay_distribution_id is not null
1870: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
1871: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
1872: AND exists (SELECT NULL
1873: FROM AP_INVOICES_ALL inv,
1874: PO_VENDORS vend
1875: WHERE inv.invoice_id = DIST.invoice_id
1876: AND inv.vendor_id = vend.vendor_id
1877: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 1885: FROM AP_INVOICES_ALL inv,

1881: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
1882: AND inv.source in ('CREDIT CARD','Both Pay')
1883: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)))
1884: AND exists(SELECT inv.invoice_id
1885: FROM AP_INVOICES_ALL inv,
1886: AP_Invoice_Distributions_all aid
1887: WHERE aid.invoice_id = inv.invoice_id
1888: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
1889: AND aid.historical_flag = 'Y'

Line 1916: FROM AP_INVOICES_ALL inv,

1912: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
1913: AND DIST.project_id > 0
1914: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1915: AND exists (SELECT invoice_id
1916: FROM AP_INVOICES_ALL inv,
1917: PO_VENDORS vend
1918: WHERE inv.invoice_id = DIST.invoice_id
1919: AND inv.vendor_id = vend.vendor_id
1920: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 1984: FROM ap_invoices_all inv,

1980: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1981: AND (
1982: EXISTS (
1983: SELECT NULL
1984: FROM ap_invoices_all inv,
1985: po_distributions_all PO,
1986: ap_invoice_distributions_all dist2
1987: WHERE inv.invoice_id = dist2.invoice_id
1988: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2005: FROM ap_invoices_all inv1,

2001: )
2002: OR
2003: EXISTS (
2004: SELECT NULL
2005: FROM ap_invoices_all inv1,
2006: ap_invoice_distributions_all dist3
2007: WHERE inv1.invoice_id = dist3.invoice_id
2008: AND inv1.invoice_id = dist.invoice_id
2009: AND inv1.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 2072: FROM ap_invoices inv

2068: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2069: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2070: AND EXISTS (
2071: SELECT NULL
2072: FROM ap_invoices inv
2073: WHERE inv.invoice_id = dist.invoice_id
2074: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
2075: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
2076: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting',

Line 2079: FROM AP_INVOICES inv,

2075: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
2076: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting',
2077: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') )
2078: AND exists(SELECT inv.invoice_id
2079: FROM AP_INVOICES inv,
2080: AP_Invoice_Distributions_all aid
2081: WHERE aid.invoice_id = inv.invoice_id
2082: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2083: AND aid.historical_flag = 'Y'

Line 2143: FROM ap_invoices_all inv,

2139: AND DIST.project_id = G_PROJECT_ID
2140: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2141: AND EXISTS (
2142: SELECT NULL
2143: FROM ap_invoices_all inv,
2144: po_distributions_all PO,
2145: ap_invoice_distributions_all dist2
2146: WHERE inv.invoice_id = dist2.invoice_id
2147: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2224: FROM ap_invoices_all inv,

2220: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2221: AND (
2222: EXISTS (
2223: SELECT NULL
2224: FROM ap_invoices_all inv,
2225: po_distributions_all PO,
2226: ap_invoice_distributions_all dist2
2227: WHERE inv.invoice_id = dist2.invoice_id
2228: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2244: FROM ap_invoices inv1,

2240: )
2241: OR
2242: EXISTS (
2243: SELECT NULL
2244: FROM ap_invoices inv1,
2245: ap_invoice_distributions dist3
2246: WHERE inv1.invoice_id = dist3.invoice_id
2247: AND inv1.invoice_id = dist.invoice_id
2248: AND inv1.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 2310: FROM ap_invoices inv

2306: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2307: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2308: AND EXISTS (
2309: SELECT NULL
2310: FROM ap_invoices inv
2311: WHERE inv.invoice_id = dist.invoice_id
2312: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
2313: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
2314: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting',

Line 2317: FROM AP_INVOICES_all inv,

2313: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
2314: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting',
2315: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') )
2316: AND exists(SELECT inv.invoice_id
2317: FROM AP_INVOICES_all inv,
2318: AP_Invoice_Distributions_all aid
2319: WHERE aid.invoice_id = inv.invoice_id
2320: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2321: AND aid.historical_flag = 'Y'

Line 2381: FROM ap_invoices_all inv,

2377: trunc(NVL(G_TRANSACTION_DATE, DIST.Expenditure_Item_Date)) /*GSCC*/
2378: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2379: AND EXISTS (
2380: SELECT NULL
2381: FROM ap_invoices_all inv,
2382: po_distributions_all PO,
2383: ap_invoice_distributions_all dist2
2384: WHERE inv.invoice_id = dist2.invoice_id
2385: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2463: v_prev_invoice_source ap_invoices.source%TYPE := NULL;

2459: v_prev_vendor_id NUMBER := 0;
2460: v_old_stack VARCHAR2(630);
2461: v_err_message VARCHAR2(220);
2462: v_all_done NUMBER := 0;
2463: v_prev_invoice_source ap_invoices.source%TYPE := NULL;
2464: v_prev_transaction_source pa_transaction_sources.transaction_source%TYPE;
2465: v_num_tax_lines_fetched NUMBER:=0;
2466: v_num_inv_variance_fetched NUMBER:=0; --NEW
2467: v_num_inv_erv_fetched NUMBER:=0; --NEW

Line 3121: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

3117: IF l_source_tbl(i) = 'PA_IP_INVOICES' THEN
3118:
3119: G_err_stage := 'Invoice source is Inter-Company Invoice';
3120: write_log(LOG, G_err_stage);
3121: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
3122: v_prev_transaction_source := G_TRANSACTION_SOURCE;
3123: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
3124:
3125: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

Line 3125: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

3121: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
3122: v_prev_transaction_source := G_TRANSACTION_SOURCE;
3123: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
3124:
3125: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
3126: l_ip_inv_flag := 'Y' ;
3127:
3128: ELSIF (l_source_tbl(i) = 'XpenseXpress' OR
3129: /* if its a Credit card txn, treat like expense report*/

Line 3854: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.

3850: v_inv_batch_size := v_num_distributions_fetched - v_num_tax_lines_fetched -
3851: v_num_inv_variance_fetched - v_num_inv_frt_fetched;
3852:
3853: write_log(LOG,'Before calling trx_import for invoices with interface_id:'||G_INTERFACE_ID);
3854: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
3855:
3856: IF (l_ap_inv_flag ='Y' ) THEN
3857:
3858: write_log(LOG,'Before calling trx_import for AP invoices');

Line 3858: write_log(LOG,'Before calling trx_import for AP invoices');

3854: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
3855:
3856: IF (l_ap_inv_flag ='Y' ) THEN
3857:
3858: write_log(LOG,'Before calling trx_import for AP invoices');
3859: trans_import('AP INVOICE', G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);
3860: tieback_AP_ER('AP INVOICE', G_BATCH_NAME, G_INTERFACE_ID);
3861:
3862: END IF;

Line 3877: --End of logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.

3873: trans_import(G_TRANSACTION_SOURCE, G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);
3874: tieback_AP_ER(G_TRANSACTION_SOURCE, G_BATCH_NAME, G_INTERFACE_ID);
3875:
3876: END IF;
3877: --End of logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
3878:
3879:
3880: IF (nvl(v_num_tax_lines_fetched,0) > 0 AND
3881: (G_INVOICE_TYPE IS NULL OR G_INVOICE_TYPE = 'EXPENSE REPORT')) THEN

Line 4189: FROM AP_INVOICES_ALL inv,

4185: FROM ap_payment_history_all hist
4186: WHERE hist.payment_history_id = dist.payment_history_id
4187: AND hist.posted_flag = 'Y')
4188: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4189: FROM AP_INVOICES_ALL inv,
4190: AP_Invoice_Distributions_all aid,
4191: ap_invoice_payments_all aip
4192: WHERE inv.invoice_id = aip.invoice_id
4193: AND aid.invoice_id = inv.invoice_id

Line 4455: FROM AP_INVOICES_ALL inv,

4451: FROM ap_payment_history_all hist
4452: WHERE hist.payment_history_id = dist.payment_history_id
4453: AND hist.posted_flag = 'Y')
4454: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4455: FROM AP_INVOICES_ALL inv,
4456: AP_Invoice_Distributions_all aid,
4457: ap_invoice_payments_all aip
4458: WHERE inv.invoice_id = aip.invoice_id
4459: AND aid.invoice_id = inv.invoice_id

Line 4493: FROM AP_INVOICES_ALL inv,

4489: FROM ap_payment_history_all hist
4490: WHERE hist.payment_history_id = dist.payment_history_id
4491: AND hist.posted_flag = 'Y')
4492: AND exists(SELECT/*+ no_unnest */ inv.invoice_id
4493: FROM AP_INVOICES_ALL inv,
4494: PO_Distributions_all PO,
4495: AP_Invoice_Distributions_all aid,
4496: ap_invoice_payments_all aip
4497: WHERE inv.invoice_id = aip.invoice_id

Line 4551: FROM AP_INVOICES_ALL inv,

4547: FROM ap_payment_history_all hist
4548: WHERE hist.payment_history_id = dist.payment_history_id
4549: AND hist.posted_flag = 'Y')
4550: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4551: FROM AP_INVOICES_ALL inv,
4552: AP_Invoice_Distributions_all aid,
4553: ap_invoice_payments_all aip
4554: WHERE inv.invoice_id = aip.invoice_id
4555: AND aid.invoice_id = inv.invoice_id

Line 4585: FROM AP_INVOICES_ALL inv,

4581: FROM ap_payment_history_all hist
4582: WHERE hist.payment_history_id = dist.payment_history_id
4583: AND hist.posted_flag = 'Y')
4584: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
4585: FROM AP_INVOICES_ALL inv,
4586: PO_Distributions_all PO,
4587: AP_Invoice_Distributions_all aid,
4588: ap_invoice_payments_all aip
4589: WHERE inv.invoice_id = aip.invoice_id

Line 7390: write_log(LOG,'number of ap invoices locked:'||l_num_rows);

7386: AND dist.pa_addition_flag = 'N';
7387:
7388: l_num_rows := SQL%ROWCOUNT;
7389:
7390: write_log(LOG,'number of ap invoices locked:'||l_num_rows);
7391:
7392: EXCEPTION
7393: WHEN NO_DATA_FOUND THEN
7394: NULL;

Line 7418: write_log(LOG,'number of ap invoices unlocked:'||l_num_rows);

7414: WHERE dist.pa_addition_flag = 'L';
7415:
7416: l_num_rows := SQL%ROWCOUNT;
7417:
7418: write_log(LOG,'number of ap invoices unlocked:'||l_num_rows);
7419:
7420: EXCEPTION
7421: WHEN NO_DATA_FOUND THEN
7422: NULL;

Line 7484: FROM ap_invoices inv, ap_invoice_distributions_all dist

7480: program_application_id= G_PROG_APPL_ID,
7481: program_update_date=SYSDATE
7482: WHERE rowid IN (
7483: SELECT dist.rowid
7484: FROM ap_invoices inv, ap_invoice_distributions_all dist
7485: WHERE inv.invoice_id = dist.invoice_id
7486: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','NONREC_TAX')
7487: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
7488: AND EXISTS (SELECT 'X'

Line 7560: FROM ap_invoices inv,

7556: program_application_id= G_PROG_APPL_ID,
7557: program_update_date=SYSDATE
7558: WHERE rowid in (
7559: SELECT dist.rowid
7560: FROM ap_invoices inv,
7561: po_distributions po,
7562: ap_invoice_distributions_all dist
7563: WHERE inv.invoice_id = dist.invoice_id
7564: AND po.po_distribution_id = dist.po_distribution_id

Line 7614: FROM ap_invoices inv, ap_invoice_distributions_all dist

7610: program_application_id= G_PROG_APPL_ID,
7611: program_update_date=SYSDATE
7612: WHERE rowid IN (
7613: SELECT dist.rowid
7614: FROM ap_invoices inv, ap_invoice_distributions_all dist
7615: WHERE inv.invoice_id = dist.invoice_id
7616: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','NONREC_TAX')
7617: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
7618: AND EXISTS (SELECT 'X'

Line 7689: FROM ap_invoices inv,

7685: program_application_id= G_PROG_APPL_ID,
7686: program_update_date=SYSDATE
7687: WHERE rowid in (
7688: SELECT dist.rowid
7689: FROM ap_invoices inv,
7690: po_distributions po,
7691: ap_invoice_distributions_all dist
7692: WHERE inv.invoice_id = dist.invoice_id
7693: AND po.po_distribution_id = dist.po_distribution_id

Line 8913: FROM AP_INVOICES inv,

8909: FROM ap_payment_history_all hist
8910: WHERE hist.payment_history_id = dist.payment_history_id
8911: AND hist.posted_flag = 'Y')
8912: AND exists (SELECT inv.invoice_id
8913: FROM AP_INVOICES inv,
8914: PO_VENDORS vend,
8915: AP_Invoice_Distributions_all aid,
8916: ap_invoice_payments_all aip
8917: WHERE inv.invoice_id = aid.invoice_id

Line 8953: FROM AP_INVOICES_ALL inv,

8949: program_update_date=SYSDATE
8950: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8951: AND dist.amount <>0
8952: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
8953: FROM AP_INVOICES_ALL inv,
8954: PO_VENDORS vend,
8955: PO_Distributions_all PO,
8956: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
8957: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

Line 9003: FROM AP_INVOICES_ALL inv,

8999: FROM ap_payment_history_all hist
9000: WHERE hist.payment_history_id = dist.payment_history_id
9001: AND hist.posted_flag = 'Y')
9002: AND exists (SELECT inv.invoice_id
9003: FROM AP_INVOICES_ALL inv,
9004: PO_VENDORS vend,
9005: AP_Invoice_Distributions_all aid,
9006: ap_invoice_payments_all aip
9007: WHERE inv.vendor_id = vend.vendor_id

Line 9044: FROM AP_INVOICES_ALL inv,

9040: program_update_date=SYSDATE
9041: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
9042: AND dist.amount <>0
9043: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9044: FROM AP_INVOICES_ALL inv,
9045: PO_VENDORS vend,
9046: PO_Distributions_all PO,
9047: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
9048: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

Line 9108: FROM AP_INVOICES_ALL inv,

9104: FROM ap_payment_history_all hist
9105: WHERE hist.payment_history_id = dist.payment_history_id
9106: AND hist.posted_flag = 'Y')
9107: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9108: FROM AP_INVOICES_ALL inv,
9109: PO_Distributions_all PO,
9110: AP_Invoice_Distributions_all aid,
9111: ap_invoice_payments_all aip
9112: WHERE inv.invoice_id = aip.invoice_id

Line 9155: FROM AP_INVOICES_ALL inv,

9151: program_update_date=SYSDATE
9152: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
9153: AND dist.amount <> 0
9154: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9155: FROM AP_INVOICES_ALL inv,
9156: PO_Distributions_all PO,
9157: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
9158: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
9159: WHERE aid.invoice_id = inv.invoice_id

Line 9210: FROM AP_INVOICES_ALL inv,

9206: FROM ap_payment_history_all hist
9207: WHERE hist.payment_history_id = dist.payment_history_id
9208: AND hist.posted_flag = 'Y')
9209: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9210: FROM AP_INVOICES_ALL inv,
9211: PO_Distributions_all PO,
9212: AP_Invoice_Distributions_all aid,
9213: ap_invoice_payments_all aip
9214: WHERE inv.invoice_id = aip.invoice_id

Line 9257: FROM AP_INVOICES_ALL inv,

9253: program_update_date=SYSDATE
9254: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
9255: AND dist.amount <> 0
9256: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9257: FROM AP_INVOICES_ALL inv,
9258: PO_Distributions_all PO,
9259: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
9260: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
9261: WHERE aid.invoice_id = inv.invoice_id

Line 9319: v_prev_invoice_source ap_invoices.source%TYPE := NULL;

9315: v_prev_vendor_id NUMBER := 0;
9316: v_old_stack VARCHAR2(630);
9317: v_err_message VARCHAR2(220);
9318: v_all_done NUMBER := 0;
9319: v_prev_invoice_source ap_invoices.source%TYPE := NULL;
9320: v_prev_transaction_source pa_transaction_sources.transaction_source%TYPE;
9321: v_num_tax_lines_fetched NUMBER:=0;
9322: v_num_inv_variance_fetched NUMBER:=0; --NEW
9323: v_num_inv_erv_fetched NUMBER:=0; --NEW

Line 9906: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

9902: IF l_source_tbl(i) = 'PA_IP_INVOICES' THEN
9903:
9904: G_err_stage := 'Invoice source is Inter-Company Invoice';
9905: write_log(LOG, G_err_stage);
9906: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
9907: v_prev_transaction_source := G_TRANSACTION_SOURCE;
9908: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
9909:
9910: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

Line 9910: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

9906: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
9907: v_prev_transaction_source := G_TRANSACTION_SOURCE;
9908: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
9909:
9910: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
9911: l_ip_inv_flag := 'Y' ;
9912:
9913: ELSIF (l_source_tbl(i) = 'XpenseXpress' OR
9914: /* if its a Credit card txn, treat like expense report*/

Line 10442: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.

10438: v_inv_batch_size := v_num_distributions_fetched - v_num_tax_lines_fetched -
10439: v_num_inv_variance_fetched - v_num_inv_frt_fetched;
10440:
10441: write_log(LOG,'Before calling trx_import for invoices with interface_id:'||G_INTERFACE_ID);
10442: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
10443:
10444: IF (l_ap_inv_flag ='Y' ) THEN
10445:
10446: trans_import('AP INVOICE', G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);

Line 10462: --End of logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.

10458: trans_import(G_TRANSACTION_SOURCE, G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);
10459: tieback_payment_AP_ER(G_TRANSACTION_SOURCE, G_BATCH_NAME,'PAY', G_INTERFACE_ID);
10460:
10461: END IF;
10462: --End of logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
10463:
10464: IF (nvl(v_num_tax_lines_fetched,0) > 0 AND
10465: (G_INVOICE_TYPE IS NULL OR G_INVOICE_TYPE = 'EXPENSE REPORT')) THEN
10466: