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 1100: p_invoice_id IN ap_invoices.invoice_id%TYPE,

1096:
1097:
1098: FUNCTION create_new_org_transref (
1099: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1100: p_invoice_id IN ap_invoices.invoice_id%TYPE,
1101: p_invoice_distribution_id IN ap_invoice_distributions.invoice_distribution_id%TYPE)
1102: RETURN pa_transaction_interface.orig_transaction_reference%TYPE IS
1103:
1104: BEGIN

Line 1379: FROM AP_INVOICES inv

1375: AND dist.Expenditure_Item_Date <= NVL(G_TRANSACTION_DATE,dist.Expenditure_Item_Date)
1376: --Bug 14320909 ends
1377:
1378: AND EXISTS (SELECT invoice_id
1379: FROM AP_INVOICES inv
1380: WHERE inv.invoice_id = DIST.invoice_id
1381: AND inv.invoice_type_lookup_code = 'EXPENSE REPORT')
1382: AND ( --( nvl(dist.encumbered_flag,'N') = 'R' ) OR /* Coomented for bug#13940879 */
1383: (dist.line_type_lookup_code ='NONREC_TAX' AND nvl(dist.base_amount,dist.amount)=0)) /*Added for bug:7622893*/

Line 1416: FROM AP_INVOICES inv

1412: WHERE dist.pa_addition_flag IN ('N', 'S', 'A', 'B', 'C', 'D', 'I', 'J', 'K', 'M', 'P', 'V', 'X', 'W')
1413: AND dist.posted_flag||'' = 'Y'
1414: AND dist.project_id = G_PROJECT_ID
1415: AND EXISTS (SELECT invoice_id
1416: FROM AP_INVOICES inv
1417: WHERE inv.invoice_id = DIST.invoice_id
1418: AND inv.invoice_type_lookup_code = 'EXPENSE REPORT')
1419: AND ( -- ( nvl(dist.encumbered_flag,'N') = 'R' ) OR /* Commented for bug#13940879 */
1420: (dist.line_type_lookup_code ='NONREC_TAX' AND nvl(dist.base_amount,dist.amount)=0))

Line 1480: FROM AP_INVOICES inv

1476: /* 12773881 AND 'N' = (select cost_rate_flag
1477: from pa_expenditure_types
1478: where expenditure_type = dist.expenditure_type) */
1479: AND EXISTS (SELECT invoice_id
1480: FROM AP_INVOICES inv
1481: WHERE inv.invoice_id = DIST.invoice_id
1482: AND inv.invoice_type_lookup_code = 'EXPENSE REPORT')
1483: AND ( --( nvl(dist.encumbered_flag,'N') = 'R' ) OR /* Commented for bug#13940879 */
1484: (dist.line_type_lookup_code ='NONREC_TAX' AND nvl(dist.base_amount,dist.amount)=0)) /*Added for bug:7622893*/

Line 1524: FROM AP_INVOICES inv

1520: WHERE dist.pa_addition_flag IN ('N', 'S', 'A', 'B', 'C', 'D', 'I', 'J', 'K', 'M', 'P', 'V', 'X', 'W')
1521: AND dist.posted_flag||'' = 'Y'
1522: AND dist.project_id > 0
1523: AND EXISTS (SELECT invoice_id
1524: FROM AP_INVOICES inv
1525: WHERE inv.invoice_id = DIST.invoice_id
1526: AND inv.invoice_type_lookup_code = 'EXPENSE REPORT')
1527: AND ( -- ( nvl(dist.encumbered_flag,'N') = 'R' ) OR /* Commented for bug#13940879 */
1528: (dist.line_type_lookup_code ='NONREC_TAX' AND nvl(dist.base_amount,dist.amount)=0))

Line 1604: FROM AP_INVOICES inv

1600: AND dist1.pa_addition_flag = 'T'
1601: AND dist1.encumbered_flag = 'R'
1602: )
1603: AND EXISTS (SELECT invoice_id
1604: FROM AP_INVOICES inv
1605: WHERE inv.invoice_id = DIST.invoice_id
1606: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT');
1607:
1608: write_log(LOG, 'Updated '||to_char(SQL%ROWCOUNT)|| 'invoice distributions to Z for Encumbrance');

Line 1647: FROM AP_INVOICES inv

1643: AND dist1.pa_addition_flag = 'T'
1644: AND dist1.encumbered_flag = 'R'
1645: )
1646: AND EXISTS (SELECT invoice_id
1647: FROM AP_INVOICES inv
1648: WHERE inv.invoice_id = DIST.invoice_id
1649: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT');
1650:
1651: write_log(LOG, 'Updated '||to_char(SQL%ROWCOUNT)|| 'Self Assessed Tax invoice distributions to Z for Encumbrance');

Line 1708: FROM AP_INVOICES inv

1704: AND dist1.pa_addition_flag = 'T'
1705: AND dist1.encumbered_flag = 'R'
1706: )
1707: AND EXISTS (SELECT invoice_id
1708: FROM AP_INVOICES inv
1709: WHERE inv.invoice_id = DIST.invoice_id
1710: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT');
1711:
1712: write_log(LOG, 'Updated '||to_char(SQL%ROWCOUNT)|| 'invoice distributions to Z for Encumbrance');

Line 1750: FROM AP_INVOICES inv

1746: AND dist1.pa_addition_flag = 'T'
1747: AND dist1.encumbered_flag = 'R'
1748: )
1749: AND EXISTS (SELECT invoice_id
1750: FROM AP_INVOICES inv
1751: WHERE inv.invoice_id = DIST.invoice_id
1752: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT');
1753:
1754: write_log(LOG, 'Updated '||to_char(SQL%ROWCOUNT)|| 'Self Assessed Tax invoice distributions to Z for Encumbrance');

Line 1880: FROM AP_INVOICES inv,

1876: AND DIST.project_id > 0
1877: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1878: AND ((
1879: exists (SELECT NULL
1880: FROM AP_INVOICES inv,
1881: AP_Invoice_distributions DIST1,
1882: PO_VENDORS vend
1883: WHERE inv.invoice_id = DIST1.invoice_id
1884: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id

Line 1907: ap_invoices inv1,

1903: )))
1904: OR
1905: (EXISTS ( SELECT NULL
1906: FROM PO_VENDORS vend1,
1907: ap_invoices inv1,
1908: ap_invoice_distributions dist2
1909: WHERE inv1.invoice_id = dist2.invoice_id
1910: AND inv1.invoice_id = dist.invoice_id
1911: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )

Line 1957: FROM AP_INVOICES inv,

1953: AND DIST.project_id > 0
1954: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1955: AND ((
1956: exists (SELECT NULL
1957: FROM AP_INVOICES inv,
1958: ap_self_assessed_tax_dist DIST1,
1959: PO_VENDORS vend
1960: WHERE inv.invoice_id = DIST1.invoice_id
1961: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id

Line 1984: ap_invoices inv1,

1980: )))
1981: OR
1982: (EXISTS ( SELECT NULL
1983: FROM PO_VENDORS vend1,
1984: ap_invoices inv1,
1985: ap_self_assessed_tax_dist dist2
1986: WHERE inv1.invoice_id = dist2.invoice_id
1987: AND inv1.invoice_id = dist.invoice_id
1988: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )

Line 2042: FROM AP_INVOICES inv,

2038: AND dist.prepay_distribution_id is not null
2039: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2040: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2041: AND exists (SELECT NULL
2042: FROM AP_INVOICES inv,
2043: PO_VENDORS vend
2044: WHERE inv.invoice_id = DIST.invoice_id
2045: AND inv.vendor_id = vend.vendor_id
2046: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2063: FROM AP_INVOICES inv,

2059: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID
2060: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2061: ))
2062: AND exists(SELECT inv.invoice_id
2063: FROM AP_INVOICES inv,
2064: AP_Invoice_Distributions_all aid
2065: WHERE aid.invoice_id = inv.invoice_id
2066: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2067: AND aid.historical_flag = 'Y'

Line 2095: FROM AP_INVOICES inv,

2091: AND dist.prepay_distribution_id is not null
2092: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2093: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2094: AND exists (SELECT NULL
2095: FROM AP_INVOICES inv,
2096: PO_VENDORS vend
2097: WHERE inv.invoice_id = DIST.invoice_id
2098: AND inv.vendor_id = vend.vendor_id
2099: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2115: FROM AP_INVOICES inv,

2111: and PPL.PERSON_ID = ASGN.PERSON_ID
2112: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID
2113: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))))
2114: AND exists(SELECT inv.invoice_id
2115: FROM AP_INVOICES inv,
2116: ap_self_assessed_tax_dist_all aid
2117: WHERE aid.invoice_id = inv.invoice_id
2118: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2119: --aND aid.historical_flag = 'Y'

Line 2146: FROM AP_INVOICES inv,

2142: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
2143: AND DIST.project_id > 0
2144: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2145: AND exists (SELECT NULL
2146: FROM AP_INVOICES inv,
2147: PO_VENDORS vend
2148: WHERE inv.invoice_id = DIST.invoice_id
2149: AND inv.vendor_id = vend.vendor_id
2150: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2191: FROM AP_INVOICES inv,

2187: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
2188: AND DIST.project_id > 0
2189: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2190: AND exists (SELECT NULL
2191: FROM AP_INVOICES inv,
2192: PO_VENDORS vend
2193: WHERE inv.invoice_id = DIST.invoice_id
2194: AND inv.vendor_id = vend.vendor_id
2195: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2242: FROM AP_INVOICES inv,

2238: AND DIST.project_id > 0
2239: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2240: AND (
2241: (exists (SELECT NULL
2242: FROM AP_INVOICES inv,
2243: AP_Invoice_distributions DIST1,
2244: PO_VENDORS vend
2245: WHERE inv.invoice_id = DIST1.invoice_id
2246: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id

Line 2269: ap_invoices inv1, ap_invoice_distributions dist2

2265: )))
2266: OR
2267: (EXISTS ( SELECT NULL
2268: FROM PO_VENDORS vend1,
2269: ap_invoices inv1, ap_invoice_distributions dist2
2270: WHERE inv1.invoice_id = dist2.invoice_id
2271: AND inv1.invoice_id = dist.invoice_id
2272: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )
2273: AND dist2.invoice_distribution_id = dist.parent_reversal_id --Process Historical data reversals as Invoices in Cash based

Line 2317: FROM AP_INVOICES inv,

2313: AND DIST.project_id > 0
2314: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2315: AND (
2316: (exists (SELECT NULL
2317: FROM AP_INVOICES inv,
2318: AP_self_assessed_tax_dist DIST1,
2319: PO_VENDORS vend
2320: WHERE inv.invoice_id = DIST1.invoice_id
2321: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id

Line 2344: ap_invoices inv1, ap_invoice_distributions dist2

2340: )))
2341: OR
2342: (EXISTS ( SELECT NULL
2343: FROM PO_VENDORS vend1,
2344: ap_invoices inv1, ap_invoice_distributions dist2
2345: WHERE inv1.invoice_id = dist2.invoice_id
2346: AND inv1.invoice_id = dist.invoice_id
2347: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )
2348: AND dist2.invoice_distribution_id = dist.parent_reversal_id --Process Historical data reversals as Invoices in Cash based

Line 2398: FROM AP_INVOICES_ALL inv,

2394: AND dist.prepay_distribution_id is not null
2395: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2396: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2397: AND exists (SELECT NULL
2398: FROM AP_INVOICES_ALL inv,
2399: PO_VENDORS vend
2400: WHERE inv.invoice_id = DIST.invoice_id
2401: AND inv.vendor_id = vend.vendor_id
2402: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2419: FROM AP_INVOICES_ALL inv,

2415: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID
2416: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2417: ))
2418: AND exists(SELECT inv.invoice_id
2419: FROM AP_INVOICES_ALL inv,
2420: AP_Invoice_Distributions_all aid
2421: WHERE aid.invoice_id = inv.invoice_id
2422: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2423: AND aid.historical_flag = 'Y'

Line 2450: FROM AP_INVOICES_ALL inv,

2446: AND dist.prepay_distribution_id is not null
2447: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2448: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2449: AND exists (SELECT NULL
2450: FROM AP_INVOICES_ALL inv,
2451: PO_VENDORS vend
2452: WHERE inv.invoice_id = DIST.invoice_id
2453: AND inv.vendor_id = vend.vendor_id
2454: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2470: FROM AP_INVOICES_ALL inv,

2466: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID
2467: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2468: ))
2469: AND exists(SELECT inv.invoice_id
2470: FROM AP_INVOICES_ALL inv,
2471: ap_self_assessed_tax_dist_all aid
2472: WHERE aid.invoice_id = inv.invoice_id
2473: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2474: --AND aid.historical_flag = 'Y'

Line 2501: FROM AP_INVOICES_ALL inv,

2497: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
2498: AND DIST.project_id > 0
2499: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2500: AND exists (SELECT invoice_id
2501: FROM AP_INVOICES_ALL inv,
2502: PO_VENDORS vend
2503: WHERE inv.invoice_id = DIST.invoice_id
2504: AND inv.vendor_id = vend.vendor_id
2505: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2543: FROM AP_INVOICES_ALL inv,

2539: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
2540: AND DIST.project_id > 0
2541: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2542: AND exists (SELECT invoice_id
2543: FROM AP_INVOICES_ALL inv,
2544: PO_VENDORS vend
2545: WHERE inv.invoice_id = DIST.invoice_id
2546: AND inv.vendor_id = vend.vendor_id
2547: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2620: FROM ap_invoices_all inv,

2616: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2617: AND (
2618: EXISTS (
2619: SELECT NULL
2620: FROM ap_invoices_all inv,
2621: po_distributions_all PO,
2622: ap_invoice_distributions_all dist2
2623: WHERE inv.invoice_id = dist2.invoice_id
2624: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2642: FROM ap_invoices_all inv1,

2638: )
2639: OR
2640: EXISTS (
2641: SELECT NULL
2642: FROM ap_invoices_all inv1,
2643: ap_invoice_distributions_all dist3
2644: WHERE inv1.invoice_id = dist3.invoice_id
2645: AND inv1.invoice_id = dist.invoice_id
2646: AND inv1.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 2727: FROM ap_invoices inv

2723: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2724: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2725: AND EXISTS (
2726: SELECT NULL
2727: FROM ap_invoices inv
2728: WHERE inv.invoice_id = dist.invoice_id
2729: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
2730: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
2731: AND inv.source not in ('CREDIT CARD','Both Pay') /* Added for bug 8977795 */

Line 2735: FROM AP_INVOICES inv,

2731: AND inv.source not in ('CREDIT CARD','Both Pay') /* Added for bug 8977795 */
2732: AND nvl(INV.source, 'xx' ) NOT IN (
2733: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') ) /* Removed 'Oracle Project Accounting' */
2734: AND exists(SELECT inv.invoice_id
2735: FROM AP_INVOICES inv,
2736: AP_Invoice_Distributions_all aid
2737: WHERE aid.invoice_id = inv.invoice_id
2738: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2739: AND aid.historical_flag = 'Y'

Line 2811: FROM ap_invoices inv

2807: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2808: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2809: AND EXISTS (
2810: SELECT NULL
2811: FROM ap_invoices inv
2812: WHERE inv.invoice_id = dist.invoice_id
2813: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
2814: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
2815: AND inv.source not in ('CREDIT CARD','Both Pay')

Line 2819: FROM AP_INVOICES inv,

2815: AND inv.source not in ('CREDIT CARD','Both Pay')
2816: AND nvl(INV.source, 'xx' ) NOT IN (
2817: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') )
2818: AND exists(SELECT inv.invoice_id
2819: FROM AP_INVOICES inv,
2820: AP_SELF_ASSESSED_TAX_DIST_ALL aid
2821: WHERE aid.invoice_id = inv.invoice_id
2822: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2823: -- AND aid.historical_flag = 'Y' /*doubt*/

Line 2892: FROM ap_invoices_all inv,

2888: AND DIST.project_id = G_PROJECT_ID
2889: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2890: AND EXISTS (
2891: SELECT NULL
2892: FROM ap_invoices_all inv,
2893: po_distributions_all PO,
2894: ap_invoice_distributions_all dist2
2895: WHERE inv.invoice_id = dist2.invoice_id
2896: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2974: FROM ap_invoices_all inv,

2970: AND DIST.project_id = G_PROJECT_ID
2971: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2972: AND EXISTS (
2973: SELECT NULL
2974: FROM ap_invoices_all inv,
2975: po_distributions_all PO,
2976: AP_SELF_ASSESSED_TAX_DIST dist2
2977: WHERE inv.invoice_id = dist2.invoice_id
2978: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 3065: FROM ap_invoices_all inv,

3061: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
3062: AND (
3063: EXISTS (
3064: SELECT NULL
3065: FROM ap_invoices_all inv,
3066: po_distributions_all PO,
3067: ap_invoice_distributions_all dist2
3068: WHERE inv.invoice_id = dist2.invoice_id
3069: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 3086: FROM ap_invoices inv1,

3082: )
3083: OR
3084: EXISTS (
3085: SELECT NULL
3086: FROM ap_invoices inv1,
3087: ap_invoice_distributions dist3
3088: WHERE inv1.invoice_id = dist3.invoice_id
3089: AND inv1.invoice_id = dist.invoice_id
3090: AND inv1.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 3170: FROM ap_invoices inv

3166: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
3167: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
3168: AND EXISTS (
3169: SELECT NULL
3170: FROM ap_invoices inv
3171: WHERE inv.invoice_id = dist.invoice_id
3172: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
3173: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
3174: AND inv.source not in ('CREDIT CARD','Both Pay') /* Added for bug 8977795 */

Line 3178: FROM AP_INVOICES_all inv,

3174: AND inv.source not in ('CREDIT CARD','Both Pay') /* Added for bug 8977795 */
3175: AND nvl(INV.source, 'xx' ) NOT IN (
3176: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') ) /* Removed 'Oracle Project Accounting' */
3177: AND exists(SELECT inv.invoice_id
3178: FROM AP_INVOICES_all inv,
3179: AP_Invoice_Distributions_all aid
3180: WHERE aid.invoice_id = inv.invoice_id
3181: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
3182: AND aid.historical_flag = 'Y'

Line 3252: FROM ap_invoices inv

3248: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
3249: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
3250: AND EXISTS (
3251: SELECT NULL
3252: FROM ap_invoices inv
3253: WHERE inv.invoice_id = dist.invoice_id
3254: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
3255: AND inv.PAID_ON_BEHALF_EMPLOYEE_ID IS NULL
3256: AND inv.source not in ('CREDIT CARD','Both Pay')

Line 3260: FROM AP_INVOICES_all inv,

3256: AND inv.source not in ('CREDIT CARD','Both Pay')
3257: AND nvl(INV.source, 'xx' ) NOT IN (
3258: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') )
3259: AND exists(SELECT inv.invoice_id
3260: FROM AP_INVOICES_all inv,
3261: AP_SELF_ASSESSED_TAX_DIST_ALL aid
3262: WHERE aid.invoice_id = inv.invoice_id
3263: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
3264: -- AND aid.historical_flag = 'Y' /*doubt*/

Line 3333: FROM ap_invoices_all inv,

3329: trunc(NVL(G_TRANSACTION_DATE, DIST.Expenditure_Item_Date)) /*GSCC*/
3330: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
3331: AND EXISTS (
3332: SELECT NULL
3333: FROM ap_invoices_all inv,
3334: po_distributions_all PO,
3335: ap_invoice_distributions_all dist2
3336: WHERE inv.invoice_id = dist2.invoice_id
3337: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 3418: FROM ap_invoices_all inv,

3414: trunc(NVL(G_TRANSACTION_DATE, DIST.Expenditure_Item_Date)) /*GSCC*/
3415: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
3416: AND EXISTS (
3417: SELECT NULL
3418: FROM ap_invoices_all inv,
3419: po_distributions_all PO,
3420: AP_SELF_ASSESSED_TAX_DIST dist2
3421: WHERE inv.invoice_id = dist2.invoice_id
3422: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

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

3501: v_prev_vendor_id NUMBER := 0;
3502: v_old_stack VARCHAR2(630);
3503: v_err_message VARCHAR2(220);
3504: v_all_done NUMBER := 0;
3505: v_prev_invoice_source ap_invoices.source%TYPE := NULL;
3506: v_prev_transaction_source pa_transaction_sources.transaction_source%TYPE;
3507: v_num_tax_lines_fetched NUMBER:=0;
3508: v_num_inv_variance_fetched NUMBER:=0; --NEW
3509: v_num_inv_erv_fetched NUMBER:=0; --NEW

Line 4223: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

4219: IF l_source_tbl(i) = 'PA_IP_INVOICES' THEN
4220:
4221: G_err_stage := 'Invoice source is Inter-Company Invoice';
4222: write_log(LOG, G_err_stage);
4223: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
4224: v_prev_transaction_source := G_TRANSACTION_SOURCE;
4225: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
4226:
4227: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

Line 4227: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

4223: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
4224: v_prev_transaction_source := G_TRANSACTION_SOURCE;
4225: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
4226:
4227: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
4228: l_ip_inv_flag := 'Y' ;
4229:
4230: ELSIF (l_source_tbl(i) = 'XpenseXpress' OR
4231: /* if its a Credit card txn, treat like expense report*/

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

4986: v_inv_batch_size := v_num_distributions_fetched - v_num_tax_lines_fetched -
4987: v_num_inv_variance_fetched - v_num_inv_frt_fetched;
4988:
4989: write_log(LOG,'Before calling trx_import for invoices with interface_id:'||G_INTERFACE_ID);
4990: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
4991:
4992: IF (l_ap_inv_flag ='Y' ) THEN
4993:
4994: write_log(LOG,'Before calling trx_import for AP invoices');

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

4990: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
4991:
4992: IF (l_ap_inv_flag ='Y' ) THEN
4993:
4994: write_log(LOG,'Before calling trx_import for AP invoices');
4995: trans_import('AP INVOICE', G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);
4996: tieback_AP_ER('AP INVOICE', G_BATCH_NAME, G_INTERFACE_ID);
4997:
4998: END IF;

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

5009: trans_import(G_TRANSACTION_SOURCE, G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);
5010: tieback_AP_ER(G_TRANSACTION_SOURCE, G_BATCH_NAME, G_INTERFACE_ID);
5011:
5012: END IF;
5013: --End of logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
5014:
5015:
5016: IF (nvl(v_num_tax_lines_fetched,0) > 0 AND
5017: (G_INVOICE_TYPE IS NULL OR G_INVOICE_TYPE = 'EXPENSE REPORT')) THEN

Line 5344: FROM AP_INVOICES_ALL inv,

5340: FROM ap_payment_history_all hist
5341: WHERE hist.payment_history_id = dist.payment_history_id
5342: AND hist.posted_flag = 'Y')
5343: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
5344: FROM AP_INVOICES_ALL inv,
5345: AP_Invoice_Distributions_all aid,
5346: ap_invoice_payments_all aip
5347: WHERE inv.invoice_id = aip.invoice_id
5348: AND aid.invoice_id = inv.invoice_id

Line 5611: FROM AP_INVOICES_ALL inv,

5607: FROM ap_payment_history_all hist
5608: WHERE hist.payment_history_id = dist.payment_history_id
5609: AND hist.posted_flag = 'Y')
5610: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5611: FROM AP_INVOICES_ALL inv,
5612: AP_Invoice_Distributions_all aid,
5613: ap_invoice_payments_all aip
5614: WHERE inv.invoice_id = aip.invoice_id
5615: AND aid.invoice_id = inv.invoice_id

Line 5652: FROM AP_INVOICES_ALL inv,

5648: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5649: and hist.transaction_type in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5650: AND hist.posted_flag = 'Y')
5651: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5652: FROM AP_INVOICES_ALL inv,
5653: PO_Distributions_all PO,
5654: AP_Invoice_Distributions_all aid,
5655: ap_invoice_payments_all aip
5656: WHERE inv.invoice_id = aip.invoice_id

Line 5711: FROM AP_INVOICES_ALL inv,

5707: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5708: and hist.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5709: AND hist.posted_flag = 'Y')
5710: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5711: FROM AP_INVOICES_ALL inv,
5712: PO_Distributions_all PO,
5713: AP_Invoice_Distributions_all aid,
5714: ap_invoice_payments_all aip
5715: WHERE inv.invoice_id = aip.invoice_id

Line 5768: FROM AP_INVOICES_ALL inv,

5764: FROM ap_payment_history_all hist
5765: WHERE hist.payment_history_id = dist.payment_history_id
5766: AND hist.posted_flag = 'Y')
5767: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5768: FROM AP_INVOICES_ALL inv,
5769: AP_Invoice_Distributions_all aid,
5770: ap_invoice_payments_all aip
5771: WHERE inv.invoice_id = aip.invoice_id
5772: AND aid.invoice_id = inv.invoice_id

Line 5805: FROM AP_INVOICES_ALL inv,

5801: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5802: and hist.transaction_type in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5803: AND hist.posted_flag = 'Y')
5804: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5805: FROM AP_INVOICES_ALL inv,
5806: PO_Distributions_all PO,
5807: AP_Invoice_Distributions_all aid,
5808: ap_invoice_payments_all aip
5809: WHERE inv.invoice_id = aip.invoice_id

Line 5863: FROM AP_INVOICES_ALL inv,

5859: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5860: and hist.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5861: AND hist.posted_flag = 'Y')
5862: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5863: FROM AP_INVOICES_ALL inv,
5864: PO_Distributions_all PO,
5865: AP_Invoice_Distributions_all aid,
5866: ap_invoice_payments_all aip
5867: WHERE inv.invoice_id = aip.invoice_id

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

8879: AND dist.pa_addition_flag = 'N';
8880:
8881: l_num_rows := SQL%ROWCOUNT;
8882:
8883: write_log(LOG,'number of ap invoices locked:'||l_num_rows);
8884:
8885: EXCEPTION
8886: WHEN NO_DATA_FOUND THEN
8887: NULL;

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

8907: WHERE dist.pa_addition_flag = 'L';
8908:
8909: l_num_rows := SQL%ROWCOUNT;
8910:
8911: write_log(LOG,'number of ap invoices unlocked:'||l_num_rows);
8912:
8913: EXCEPTION
8914: WHEN NO_DATA_FOUND THEN
8915: NULL;

Line 8977: FROM ap_invoices inv, ap_invoice_distributions_all dist

8973: program_application_id= G_PROG_APPL_ID,
8974: program_update_date=SYSDATE
8975: WHERE rowid IN (
8976: SELECT dist.rowid
8977: FROM ap_invoices inv, ap_invoice_distributions_all dist
8978: WHERE inv.invoice_id = dist.invoice_id
8979: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
8980: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
8981: AND EXISTS (SELECT 'X'

Line 9009: ap_invoices_all ap1 /Changes for bug 7650946 -- Start /

9005: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9006: )
9007: AND ( EXISTS (SELECT NULL
9008: FROM ap_invoice_distributions_all apdist1,
9009: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start */
9010: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9011: AND ap1.invoice_id = apdist1.invoice_id /*Added for bug 7650946 */
9012: AND apdist1.po_distribution_id = dist.po_distribution_id
9013: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 9059: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist

9055: program_application_id= G_PROG_APPL_ID,
9056: program_update_date=SYSDATE
9057: WHERE rowid IN (
9058: SELECT dist.rowid
9059: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist
9060: WHERE inv.invoice_id = dist.invoice_id
9061: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9062: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9063: AND EXISTS (SELECT 'X'

Line 9084: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start

9080: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9081: )
9082: AND ( EXISTS (SELECT NULL
9083: FROM ap_self_assessed_tax_dist_all apdist1,
9084: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start
9085: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9086: AND ap1.invoice_id = apdist1.invoice_id /*Added for bug 7650946
9087: AND apdist1.po_distribution_id = dist.po_distribution_id
9088: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 9139: FROM ap_invoices inv,

9135: program_application_id= G_PROG_APPL_ID,
9136: program_update_date=SYSDATE
9137: WHERE rowid in (
9138: SELECT dist.rowid
9139: FROM ap_invoices inv,
9140: po_distributions po,
9141: ap_invoice_distributions_all dist
9142: WHERE inv.invoice_id = dist.invoice_id
9143: AND po.po_distribution_id = dist.po_distribution_id

Line 9198: FROM ap_invoices inv, ap_invoice_distributions_all dist

9194: program_application_id= G_PROG_APPL_ID,
9195: program_update_date=SYSDATE
9196: WHERE rowid IN (
9197: SELECT dist.rowid
9198: FROM ap_invoices inv, ap_invoice_distributions_all dist
9199: WHERE inv.invoice_id = dist.invoice_id
9200: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9201: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9202: AND EXISTS (SELECT 'X'

Line 9230: ap_invoices_all ap1 /Changes for bug 7650946 -- Start /

9226: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9227: )
9228: AND ( EXISTS (SELECT NULL
9229: FROM ap_invoice_distributions_all apdist1,
9230: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start */
9231: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9232: AND ap1.invoice_id = apdist1.invoice_id
9233: AND apdist1.po_distribution_id = dist.po_distribution_id
9234: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 9281: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist

9277: program_application_id= G_PROG_APPL_ID,
9278: program_update_date=SYSDATE
9279: WHERE rowid IN (
9280: SELECT dist.rowid
9281: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist
9282: WHERE inv.invoice_id = dist.invoice_id
9283: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9284: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9285: AND EXISTS (SELECT 'X'

Line 9305: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start

9301: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9302: )
9303: AND ( EXISTS (SELECT NULL
9304: FROM ap_self_assessed_tax_dist_all apdist1,
9305: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start
9306: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9307: AND ap1.invoice_id = apdist1.invoice_id
9308: AND apdist1.po_distribution_id = dist.po_distribution_id
9309: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 9360: FROM ap_invoices inv,

9356: program_application_id= G_PROG_APPL_ID,
9357: program_update_date=SYSDATE
9358: WHERE rowid in (
9359: SELECT dist.rowid
9360: FROM ap_invoices inv,
9361: po_distributions po,
9362: ap_invoice_distributions_all dist
9363: WHERE inv.invoice_id = dist.invoice_id
9364: AND po.po_distribution_id = dist.po_distribution_id

Line 10631: FROM AP_INVOICES inv,

10627: FROM ap_payment_history_all hist
10628: WHERE hist.payment_history_id = dist.payment_history_id
10629: AND hist.posted_flag = 'Y')
10630: AND exists (SELECT inv.invoice_id
10631: FROM AP_INVOICES inv,
10632: PO_VENDORS vend,
10633: AP_Invoice_Distributions_all aid,
10634: ap_invoice_payments_all aip
10635: WHERE inv.invoice_id = aid.invoice_id

Line 10671: FROM AP_INVOICES_ALL inv,

10667: program_update_date=SYSDATE
10668: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10669: AND dist.amount <>0
10670: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10671: FROM AP_INVOICES_ALL inv,
10672: PO_VENDORS vend,
10673: PO_Distributions_all PO,
10674: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10675: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

Line 10721: FROM AP_INVOICES_ALL inv,

10717: FROM ap_payment_history_all hist
10718: WHERE hist.payment_history_id = dist.payment_history_id
10719: AND hist.posted_flag = 'Y')
10720: AND exists (SELECT inv.invoice_id
10721: FROM AP_INVOICES_ALL inv,
10722: PO_VENDORS vend,
10723: AP_Invoice_Distributions_all aid,
10724: ap_invoice_payments_all aip
10725: WHERE inv.vendor_id = vend.vendor_id

Line 10762: FROM AP_INVOICES_ALL inv,

10758: program_update_date=SYSDATE
10759: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10760: AND dist.amount <>0
10761: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10762: FROM AP_INVOICES_ALL inv,
10763: PO_VENDORS vend,
10764: PO_Distributions_all PO,
10765: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10766: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

Line 10826: FROM AP_INVOICES_ALL inv,

10822: FROM ap_payment_history_all hist
10823: WHERE hist.payment_history_id = dist.payment_history_id
10824: AND hist.posted_flag = 'Y')
10825: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10826: FROM AP_INVOICES_ALL inv,
10827: PO_Distributions_all PO,
10828: AP_Invoice_Distributions_all aid,
10829: ap_invoice_payments_all aip
10830: WHERE inv.invoice_id = aip.invoice_id

Line 10873: FROM AP_INVOICES_ALL inv,

10869: program_update_date=SYSDATE
10870: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10871: AND dist.amount <> 0
10872: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10873: FROM AP_INVOICES_ALL inv,
10874: PO_Distributions_all PO,
10875: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10876: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10877: WHERE aid.invoice_id = inv.invoice_id

Line 10928: FROM AP_INVOICES_ALL inv,

10924: FROM ap_payment_history_all hist
10925: WHERE hist.payment_history_id = dist.payment_history_id
10926: AND hist.posted_flag = 'Y')
10927: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10928: FROM AP_INVOICES_ALL inv,
10929: PO_Distributions_all PO,
10930: AP_Invoice_Distributions_all aid,
10931: ap_invoice_payments_all aip
10932: WHERE inv.invoice_id = aip.invoice_id

Line 10975: FROM AP_INVOICES_ALL inv,

10971: program_update_date=SYSDATE
10972: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10973: AND dist.amount <> 0
10974: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10975: FROM AP_INVOICES_ALL inv,
10976: PO_Distributions_all PO,
10977: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10978: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10979: WHERE aid.invoice_id = inv.invoice_id

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

11033: v_prev_vendor_id NUMBER := 0;
11034: v_old_stack VARCHAR2(630);
11035: v_err_message VARCHAR2(220);
11036: v_all_done NUMBER := 0;
11037: v_prev_invoice_source ap_invoices.source%TYPE := NULL;
11038: v_prev_transaction_source pa_transaction_sources.transaction_source%TYPE;
11039: v_num_tax_lines_fetched NUMBER:=0;
11040: v_num_inv_variance_fetched NUMBER:=0; --NEW
11041: v_num_inv_erv_fetched NUMBER:=0; --NEW

Line 11661: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

11657: IF l_source_tbl(i) = 'PA_IP_INVOICES' THEN
11658:
11659: G_err_stage := 'Invoice source is Inter-Company Invoice';
11660: write_log(LOG, G_err_stage);
11661: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
11662: v_prev_transaction_source := G_TRANSACTION_SOURCE;
11663: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
11664:
11665: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

Line 11665: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';

11661: G_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
11662: v_prev_transaction_source := G_TRANSACTION_SOURCE;
11663: G_USER_TRANSACTION_SOURCE := 'Oracle Inter-Project Invoices';
11664:
11665: L_IP_TRANSACTION_SOURCE := 'INTERPROJECT_AP_INVOICES';
11666: l_ip_inv_flag := 'Y' ;
11667:
11668: ELSIF (l_source_tbl(i) = 'XpenseXpress' OR
11669: /* if its a Credit card txn, treat like expense report*/

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

12199: v_inv_batch_size := v_num_distributions_fetched - v_num_tax_lines_fetched -
12200: v_num_inv_variance_fetched - v_num_inv_frt_fetched;
12201:
12202: write_log(LOG,'Before calling trx_import for invoices with interface_id:'||G_INTERFACE_ID);
12203: --Logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
12204:
12205: IF (l_ap_inv_flag ='Y' ) THEN
12206:
12207: trans_import('AP INVOICE', G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);

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

12219: trans_import(G_TRANSACTION_SOURCE, G_BATCH_NAME, G_INTERFACE_ID, G_USER_ID);
12220: tieback_payment_AP_ER(G_TRANSACTION_SOURCE, G_BATCH_NAME,'PAY', G_INTERFACE_ID);
12221:
12222: END IF;
12223: --End of logic to handle IP and AP INVOICES getting interfaced in the same run.Bug#4764470.
12224:
12225: IF (nvl(v_num_tax_lines_fetched,0) > 0 AND
12226: (G_INVOICE_TYPE IS NULL OR G_INVOICE_TYPE = 'EXPENSE REPORT')) THEN
12227: