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.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_PREPAY_APP_DISTS

Line 102: ap_prepay_app_dists apad,

98: FROM dual
99: WHERE EXISTS
100: (SELECT 1
101: FROM ap_prepay_history_all apph,
102: ap_prepay_app_dists apad,
103: ap_prepay_app_dists apad_rel,
104: ap_prepay_history_all apph_rel
105: WHERE apph.accounting_event_id = P_XLA_Event_Rec.Event_ID
106: AND apph.prepay_history_id = apad.prepay_history_id

Line 103: ap_prepay_app_dists apad_rel,

99: WHERE EXISTS
100: (SELECT 1
101: FROM ap_prepay_history_all apph,
102: ap_prepay_app_dists apad,
103: ap_prepay_app_dists apad_rel,
104: ap_prepay_history_all apph_rel
105: WHERE apph.accounting_event_id = P_XLA_Event_Rec.Event_ID
106: AND apph.prepay_history_id = apad.prepay_history_id
107: AND apad.reversed_prepay_app_dist_id = apad_rel.prepay_app_dist_id

Line 148: FROM AP_Prepay_App_Dists APAD,

144: 'PREPAYMENT APPLICATION ADJ',
145: DECODE(SIGN(SUM(APAD.Base_Amount - APAD.Base_Amt_At_Prepay_XRate)),
146: -1, 'G', 1, 'L',
147: 0, l_gain_loss_indicator_parent)) -- bug9175969
148: FROM AP_Prepay_App_Dists APAD,
149: AP_System_Parameters_ALL ASP
150: WHERE ASP.Org_ID = APH.Org_ID
151: AND APAD.Prepay_History_ID = APH.Prepay_History_ID
152: AND APAD.Accounting_Event_ID = p_xla_event_rec.event_id

Line 1066: AP_Prepay_App_Dists APAD,

1062: AID.Base_Amount_Variance,
1063: AID.Historical_Flag, -- bug fix 6674279
1064: AID.Accounting_Event_Id -- bug fix 6674279
1065: FROM AP_Invoice_Distributions_All AID,
1066: AP_Prepay_App_Dists APAD,
1067: Financials_System_Params_All FSP
1068: WHERE AID.Invoice_ID = P_Invoice_ID
1069: AND NVL(AID.Reversal_Flag,'N') <> 'Y'
1070: AND NVL(AID.Accounting_Event_ID,-99) <> P_Event_ID

Line 1272: FROM ap_prepay_app_dists

1268: IF l_inv_dist_rec.parent_reversal_id IS NOT NULL THEN
1269:
1270: SELECT count(*)
1271: INTO l_prepay_dist_cnt
1272: FROM ap_prepay_app_dists
1273: WHERE invoice_distribution_id = l_inv_dist_rec.parent_reversal_id;
1274:
1275: END IF;
1276:

Line 1425: FROM AP_Prepay_App_Dists APAD2

1421: AND prepay_invoice_id = l_prepay_hist_rec.prepay_invoice_id
1422: AND invoice_id = l_prepay_hist_rec.invoice_id
1423: /* bug12858105 - start */
1424: AND EXISTS (SELECT 1
1425: FROM AP_Prepay_App_Dists APAD2
1426: WHERE 1=1
1427: AND APAD2.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1428: AND APAD2.Prepay_Dist_Lookup_Code IN ('PREPAY APPL',
1429: 'PREPAY APPL REC TAX',

Line 1433: FROM ap_prepay_app_dists apad2_rev,

1429: 'PREPAY APPL REC TAX',
1430: 'PREPAY APPL NONREC TAX')
1431: AND APAD2.Reversed_Prepay_App_Dist_Id IS NULL
1432: AND NOT EXISTS (SELECT 1
1433: FROM ap_prepay_app_dists apad2_rev,
1434: ap_prepay_history_all apph_rev
1435: WHERE apad2_rev.reversed_prepay_app_dist_id = APAD2.prepay_app_dist_id
1436: AND apad2_rev.prepay_history_id = apph_rev.prepay_history_id
1437: AND apph_rev.invoice_id = apph.invoice_id)

Line 1451: FROM AP_Prepay_App_Dists APAD,

1447: 'PREPAY APPL NONREC TAX', APAD.Amount, 0)),
1448: SUM(DECODE(APAD.Prepay_Dist_Lookup_Code, 'TAX DIFF', APAD.Amount, 0))
1449: INTO l_sum_prepaid_amount,
1450: l_sum_tax_diff_amount
1451: FROM AP_Prepay_App_Dists APAD,
1452: ap_invoice_distributions_all aid
1453: WHERE APAD.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1454: AND apad.invoice_distribution_id = aid.invoice_distribution_id
1455: AND aid.invoice_id = l_prepay_dist_rec.invoice_id;

Line 1468: UPDATE AP_Prepay_App_Dists APAD

1464:
1465: -- bug 9240725
1466: IF(l_inv_rec.invoice_currency_code=ap_accounting_pay_pkg.g_base_currency_code) THEN
1467:
1468: UPDATE AP_Prepay_App_Dists APAD
1469: SET APAD.Amount = APAD.Amount - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount,
1470: APAD.BASE_AMT_AT_PREPAY_XRATE = APAD.BASE_AMT_AT_PREPAY_XRATE - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount,
1471: APAD.BASE_AMT_AT_PREPAY_PAY_XRATE=APAD.BASE_AMT_AT_PREPAY_PAY_XRATE - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount,
1472: APAD.BASE_AMOUNT=APAD.BASE_AMOUNT - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount,

Line 1476: FROM AP_Prepay_App_Dists APAD1

1472: APAD.BASE_AMOUNT=APAD.BASE_AMOUNT - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount,
1473: APAD.BASE_AMT_AT_PREPAY_CLR_XRATE=APAD.BASE_AMT_AT_PREPAY_CLR_XRATE - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount, rounding_amt = nvl(l_sum_prepaid_amount, 0) + l_prepay_dist_rec.amount
1474: WHERE APAD.Invoice_Distribution_ID =
1475: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1476: FROM AP_Prepay_App_Dists APAD1
1477: WHERE APAD1.Accounting_Event_ID = p_xla_event_rec.event_id
1478: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1479: AND APAD1.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
1480: 'PREPAY APPL NONREC TAX')

Line 1483: FROM AP_Prepay_App_Dists APAD2

1479: AND APAD1.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
1480: 'PREPAY APPL NONREC TAX')
1481: AND ABS(APAD1.Amount) =
1482: (SELECT MAX(ABS(APAD2.Amount)) -- added ABS for bug12858105
1483: FROM AP_Prepay_App_Dists APAD2
1484: WHERE APAD2.Accounting_Event_ID = p_xla_event_rec.event_id
1485: AND APAD2.Prepay_App_Distribution_ID
1486: = l_prepay_dist_rec.invoice_distribution_id
1487: AND APAD2.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',

Line 1492: FROM ap_prepay_app_dists apad2_rev,

1488: 'PREPAY APPL NONREC TAX')
1489: /* bug12858105 - start */
1490: AND APAD2.Reversed_Prepay_App_Dist_Id IS NULL
1491: AND NOT EXISTS (SELECT 1
1492: FROM ap_prepay_app_dists apad2_rev,
1493: ap_prepay_history_all apph
1494: WHERE apad2_rev.reversed_prepay_app_dist_id = APAD2.prepay_app_dist_id
1495: AND apad2_rev.prepay_history_id = apph.prepay_history_id
1496: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1502: FROM ap_prepay_app_dists apad1_rev,

1498: )
1499: /* bug12858105 - start */
1500: AND APAD1.Reversed_Prepay_App_Dist_Id IS NULL
1501: AND NOT EXISTS (SELECT 1
1502: FROM ap_prepay_app_dists apad1_rev,
1503: ap_prepay_history_all apph
1504: WHERE apad1_rev.reversed_prepay_app_dist_id = APAD1.prepay_app_dist_id
1505: AND apad1_rev.prepay_history_id = apph.prepay_history_id
1506: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1518: UPDATE AP_Prepay_App_Dists APAD

1514:
1515: ELSE
1516:
1517: /* Updating the prorated prepaid amounts for any rounding */
1518: UPDATE AP_Prepay_App_Dists APAD
1519: SET APAD.Amount = APAD.Amount - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount
1520: WHERE APAD.Invoice_Distribution_ID =
1521: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1522: FROM AP_Prepay_App_Dists APAD1

Line 1522: FROM AP_Prepay_App_Dists APAD1

1518: UPDATE AP_Prepay_App_Dists APAD
1519: SET APAD.Amount = APAD.Amount - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount
1520: WHERE APAD.Invoice_Distribution_ID =
1521: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1522: FROM AP_Prepay_App_Dists APAD1
1523: WHERE APAD1.Accounting_Event_ID = p_xla_event_rec.event_id
1524: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1525: AND APAD1.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
1526: 'PREPAY APPL NONREC TAX')

Line 1529: FROM AP_Prepay_App_Dists APAD2

1525: AND APAD1.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
1526: 'PREPAY APPL NONREC TAX')
1527: AND ABS(APAD1.Amount) =
1528: (SELECT MAX(ABS(APAD2.Amount)) -- adding ABS for bug12858105
1529: FROM AP_Prepay_App_Dists APAD2
1530: WHERE APAD2.Accounting_Event_ID = p_xla_event_rec.event_id
1531: AND APAD2.Prepay_App_Distribution_ID
1532: = l_prepay_dist_rec.invoice_distribution_id
1533: AND APAD2.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',

Line 1538: FROM ap_prepay_app_dists apad2_rev,

1534: 'PREPAY APPL NONREC TAX')
1535: /* bug12858105 - start */
1536: AND APAD2.Reversed_Prepay_App_Dist_Id IS NULL
1537: AND NOT EXISTS (SELECT 1
1538: FROM ap_prepay_app_dists apad2_rev,
1539: ap_prepay_history_all apph
1540: WHERE apad2_rev.reversed_prepay_app_dist_id = APAD2.prepay_app_dist_id
1541: AND apad2_rev.prepay_history_id = apph.prepay_history_id
1542: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1548: FROM ap_prepay_app_dists apad1_rev,

1544: )
1545: /* bug12858105 - start */
1546: AND APAD1.Reversed_Prepay_App_Dist_Id IS NULL
1547: AND NOT EXISTS (SELECT 1
1548: FROM ap_prepay_app_dists apad1_rev,
1549: ap_prepay_history_all apph
1550: WHERE apad1_rev.reversed_prepay_app_dist_id = APAD1.prepay_app_dist_id
1551: AND apad1_rev.prepay_history_id = apph.prepay_history_id
1552: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1575: UPDATE AP_Prepay_App_Dists APAD

1571:
1572:
1573: /* Updating the prorated tax diff amounts for any rounding */
1574: /* -- commented for bug 12858105
1575: UPDATE AP_Prepay_App_Dists APAD
1576: SET APAD.Amount = APAD.Amount - NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount
1577: WHERE APAD.Invoice_Distribution_ID =
1578: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1579: FROM AP_Prepay_App_Dists APAD1

Line 1579: FROM AP_Prepay_App_Dists APAD1

1575: UPDATE AP_Prepay_App_Dists APAD
1576: SET APAD.Amount = APAD.Amount - NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount
1577: WHERE APAD.Invoice_Distribution_ID =
1578: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1579: FROM AP_Prepay_App_Dists APAD1
1580: WHERE APAD1.Accounting_Event_ID = p_xla_event_rec.event_id
1581: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1582: AND APAD1.Prepay_Dist_Lookup_Code = 'TAX DIFF'
1583: AND ABS(APAD1.Amount) =

Line 1585: FROM AP_Prepay_App_Dists APAD2

1581: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1582: AND APAD1.Prepay_Dist_Lookup_Code = 'TAX DIFF'
1583: AND ABS(APAD1.Amount) =
1584: (SELECT MAX(APAD2.Amount)
1585: FROM AP_Prepay_App_Dists APAD2
1586: WHERE APAD2.Accounting_Event_ID = p_xla_event_rec.event_id
1587: AND APAD2.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1588: AND APAD2.Prepay_Dist_Lookup_Code = 'TAX DIFF'))
1589: AND APAD.Prepay_Dist_Lookup_Code = 'TAX DIFF'

Line 1596: UPDATE AP_Prepay_App_Dists APAD

1592:
1593: /* bug12858105 - start */
1594: IF(l_inv_rec.invoice_currency_code=ap_accounting_pay_pkg.g_base_currency_code) THEN
1595:
1596: UPDATE AP_Prepay_App_Dists APAD
1597: SET APAD.Amount = APAD.Amount- NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount ,
1598: APAD.BASE_AMT_AT_PREPAY_XRATE = APAD.BASE_AMT_AT_PREPAY_XRATE
1599: - NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount,
1600: APAD.BASE_AMT_AT_PREPAY_PAY_XRATE=APAD.BASE_AMT_AT_PREPAY_PAY_XRATE

Line 1608: FROM AP_Prepay_App_Dists APAD1

1604: APAD.BASE_AMT_AT_PREPAY_CLR_XRATE=APAD.BASE_AMT_AT_PREPAY_CLR_XRATE
1605: - NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount
1606: WHERE APAD.Invoice_Distribution_ID =
1607: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1608: FROM AP_Prepay_App_Dists APAD1
1609: WHERE APAD1.Accounting_Event_ID = p_xla_event_rec.event_id
1610: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1611: AND APAD1.Prepay_Dist_Lookup_Code IN ('TAX DIFF')
1612: AND ABS(APAD1.Amount) =

Line 1614: FROM AP_Prepay_App_Dists APAD2

1610: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1611: AND APAD1.Prepay_Dist_Lookup_Code IN ('TAX DIFF')
1612: AND ABS(APAD1.Amount) =
1613: (SELECT MAX(ABS(APAD2.Amount))
1614: FROM AP_Prepay_App_Dists APAD2
1615: WHERE APAD2.Accounting_Event_ID = p_xla_event_rec.event_id
1616: AND APAD2.Prepay_App_Distribution_ID
1617: = l_prepay_dist_rec.invoice_distribution_id
1618: AND APAD2.Prepay_Dist_Lookup_Code IN ('TAX DIFF')

Line 1621: FROM ap_prepay_app_dists apad2_rev,

1617: = l_prepay_dist_rec.invoice_distribution_id
1618: AND APAD2.Prepay_Dist_Lookup_Code IN ('TAX DIFF')
1619: AND APAD2.Reversed_Prepay_App_Dist_Id IS NULL
1620: AND NOT EXISTS (SELECT 1
1621: FROM ap_prepay_app_dists apad2_rev,
1622: ap_prepay_history_all apph
1623: WHERE apad2_rev.reversed_prepay_app_dist_id = APAD2.prepay_app_dist_id
1624: AND apad2_rev.prepay_history_id = apph.prepay_history_id
1625: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1629: FROM ap_prepay_app_dists apad1_rev,

1625: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)
1626: )
1627: AND APAD1.Reversed_Prepay_App_Dist_Id IS NULL
1628: AND NOT EXISTS (SELECT 1
1629: FROM ap_prepay_app_dists apad1_rev,
1630: ap_prepay_history_all apph
1631: WHERE apad1_rev.reversed_prepay_app_dist_id = APAD1.prepay_app_dist_id
1632: AND apad1_rev.prepay_history_id = apph.prepay_history_id
1633: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1643: UPDATE AP_Prepay_App_Dists APAD

1639:
1640: ELSE
1641:
1642: /* Updating the prorated prepaid amounts for any rounding */
1643: UPDATE AP_Prepay_App_Dists APAD
1644: SET APAD.Amount = APAD.Amount- NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount
1645: WHERE APAD.Invoice_Distribution_ID =
1646: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1647: FROM AP_Prepay_App_Dists APAD1

Line 1647: FROM AP_Prepay_App_Dists APAD1

1643: UPDATE AP_Prepay_App_Dists APAD
1644: SET APAD.Amount = APAD.Amount- NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount
1645: WHERE APAD.Invoice_Distribution_ID =
1646: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1647: FROM AP_Prepay_App_Dists APAD1
1648: WHERE APAD1.Accounting_Event_ID = p_xla_event_rec.event_id
1649: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1650: AND APAD1.Prepay_Dist_Lookup_Code IN ('TAX DIFF')
1651: AND ABS(APAD1.Amount) =

Line 1653: FROM AP_Prepay_App_Dists APAD2

1649: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1650: AND APAD1.Prepay_Dist_Lookup_Code IN ('TAX DIFF')
1651: AND ABS(APAD1.Amount) =
1652: (SELECT MAX(ABS(APAD2.Amount))
1653: FROM AP_Prepay_App_Dists APAD2
1654: WHERE APAD2.Accounting_Event_ID = p_xla_event_rec.event_id
1655: AND APAD2.Prepay_App_Distribution_ID
1656: = l_prepay_dist_rec.invoice_distribution_id
1657: AND APAD2.Prepay_Dist_Lookup_Code IN ('TAX DIFF')

Line 1660: FROM ap_prepay_app_dists apad2_rev,

1656: = l_prepay_dist_rec.invoice_distribution_id
1657: AND APAD2.Prepay_Dist_Lookup_Code IN ('TAX DIFF')
1658: AND APAD2.Reversed_Prepay_App_Dist_Id IS NULL
1659: AND NOT EXISTS (SELECT 1
1660: FROM ap_prepay_app_dists apad2_rev,
1661: ap_prepay_history_all apph
1662: WHERE apad2_rev.reversed_prepay_app_dist_id = APAD2.prepay_app_dist_id
1663: AND apad2_rev.prepay_history_id = apph.prepay_history_id
1664: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1668: FROM ap_prepay_app_dists apad1_rev,

1664: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)
1665: )
1666: AND APAD1.Reversed_Prepay_App_Dist_Id IS NULL
1667: AND NOT EXISTS (SELECT 1
1668: FROM ap_prepay_app_dists apad1_rev,
1669: ap_prepay_history_all apph
1670: WHERE apad1_rev.reversed_prepay_app_dist_id = APAD1.prepay_app_dist_id
1671: AND apad1_rev.prepay_history_id = apph.prepay_history_id
1672: AND apph.invoice_id = p_xla_event_rec.source_id_int_1)

Line 1779: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1775: l_base_qty_variance NUMBER;
1776: l_amt_variance NUMBER;
1777: l_base_amt_variance NUMBER;
1778: --l_awt_prorated_amt NUMBER; --8364229 --commenting for bug8882706
1779: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1780:
1781: -- Logging Infra:
1782: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Proc';
1783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1884: FROM ap_prepay_app_dists apad

1880: ELSE
1881: --commenting out the following code for bug8882706 as the same will be handled
1882: --now in ap_accounting_pay_pkg.get_prepay_sum
1883: /*SELECT SUM(apad.amount) INTO l_awt_prorated_amt
1884: FROM ap_prepay_app_dists apad
1885: WHERE apad.prepay_dist_lookup_code = 'AWT'
1886: AND apad.awt_related_id = p_inv_dist_rec.invoice_distribution_id
1887: AND apad.invoice_distribution_id in
1888: (SELECT invoice_distribution_id

Line 2266: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

2262: l_prorated_amount NUMBER;
2263: l_prorated_pay_amt NUMBER;
2264: l_prorated_clr_amt NUMBER;
2265:
2266: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2267:
2268: -- Logging Infra:
2269: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Tax_Diff';
2270: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2468: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

2464: l_po_pay_exchange_rate NUMBER;
2465: l_pay_erv_amount NUMBER;
2466: l_clr_erv_amount NUMBER;
2467: l_inv_erv_amount NUMBER;
2468: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2469:
2470: -- Logging Infra:
2471: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_ERV';
2472: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2669: INSERT INTO AP_Prepay_App_Dists

2665: -- an Accounting_event_id appropriately, if present on the
2666: -- corresponding Prepayment History Record
2667: --
2668:
2669: INSERT INTO AP_Prepay_App_Dists
2670: (Prepay_App_Dist_ID,
2671: Prepay_Dist_Lookup_Code,
2672: Invoice_Distribution_ID,
2673: Prepay_App_Distribution_ID,

Line 2707: SELECT AP_Prepay_App_Dists_S.nextval,

2703: Program_ID,
2704: Program_Update_Date,
2705: Request_ID
2706: )
2707: SELECT AP_Prepay_App_Dists_S.nextval,
2708: APAD.Prepay_Dist_Lookup_Code,
2709: APAD.Invoice_Distribution_ID,
2710: p_prepay_inv_dist_id,
2711: xer.event_id, --p_xla_event_rec.event_id,

Line 2743: FROM AP_Prepay_App_Dists APAD,

2739: FND_GLOBAL.Prog_Appl_ID,
2740: FND_GLOBAL.Conc_Program_ID,
2741: SYSDATE,
2742: FND_GLOBAL.Conc_Request_ID
2743: FROM AP_Prepay_App_Dists APAD,
2744: ap_prepay_history_all aph, --Bug 9112240
2745: ap_prepay_history_all aphr,
2746: xla_events xer
2747: WHERE apad.Prepay_App_Distribution_ID = P_Prepay_Reversal_ID

Line 2755: INSERT INTO AP_Prepay_App_Dists

2751: AND xer.application_id(+) = 200;
2752:
2753: ELSIF p_inv_reversal_id IS NOT NULL THEN
2754:
2755: INSERT INTO AP_Prepay_App_Dists
2756: (Prepay_App_Dist_ID,
2757: Prepay_Dist_Lookup_Code,
2758: Invoice_Distribution_ID,
2759: Prepay_App_Distribution_ID,

Line 2793: SELECT AP_Prepay_App_Dists_S.nextval,

2789: Program_ID,
2790: Program_Update_Date,
2791: Request_ID
2792: )
2793: SELECT AP_Prepay_App_Dists_S.nextval,
2794: APAD.Prepay_Dist_Lookup_Code,
2795: p_inv_dist_id, -- Bug 7134020
2796: APAD.Prepay_App_Distribution_ID,
2797: p_xla_event_rec.event_id,

Line 2829: FROM AP_Prepay_App_Dists APAD,

2825: FND_GLOBAL.Prog_Appl_ID,
2826: FND_GLOBAL.Conc_Program_ID,
2827: SYSDATE,
2828: FND_GLOBAL.Conc_Request_ID
2829: FROM AP_Prepay_App_Dists APAD,
2830: ap_prepay_history_all aph --Bug 9112240
2831: WHERE apad.prepay_history_id = aph.prepay_history_id --Bug 9112240
2832: AND APAD.Prepay_App_Distribution_ID = nvl(p_prepay_inv_dist_id,APAD.Prepay_App_Distribution_ID) --7686421
2833: AND APAD.Invoice_Distribution_Id = p_inv_reversal_id --bug9440073

Line 2863: -- into the ap_prepay_app_dists table

2859:
2860: ----------------------------------------------------------------------------------
2861: -- PROCEDURE Prepay_Dist_Insert
2862: -- This procedure is used to insert the prepay application payment distributions
2863: -- into the ap_prepay_app_dists table
2864: ----------------------------------------------------------------------------------
2865:
2866: PROCEDURE Prepay_Dist_Insert
2867: (P_PAD_Rec IN AP_PREPAY_APP_DISTS%ROWTYPE

Line 2867: (P_PAD_Rec IN AP_PREPAY_APP_DISTS%ROWTYPE

2863: -- into the ap_prepay_app_dists table
2864: ----------------------------------------------------------------------------------
2865:
2866: PROCEDURE Prepay_Dist_Insert
2867: (P_PAD_Rec IN AP_PREPAY_APP_DISTS%ROWTYPE
2868: ,P_Calling_Sequence IN VARCHAR2
2869: ) IS
2870:
2871: l_curr_calling_sequence VARCHAR2(2000);

Line 2889: INSERT INTO AP_Prepay_App_Dists

2885: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2886: END IF;
2887:
2888:
2889: INSERT INTO AP_Prepay_App_Dists
2890: (Prepay_App_Dist_ID,
2891: Prepay_Dist_Lookup_Code,
2892: Invoice_Distribution_ID,
2893: Prepay_App_Distribution_ID,

Line 2927: VALUES (AP_Prepay_App_Dists_S.nextval,

2923: Program_ID,
2924: Program_Update_Date,
2925: Request_ID
2926: )
2927: VALUES (AP_Prepay_App_Dists_S.nextval,
2928: P_PAD_Rec.Prepay_Dist_Lookup_Code,
2929: P_PAD_Rec.Invoice_Distribution_ID,
2930: P_PAD_Rec.Prepay_App_Distribution_ID,
2931: P_PAD_Rec.Accounting_Event_ID,

Line 3022: -- delete from AP_Prepay_history_all is placed after delete from AP_Prepay_App_Dists

3018:
3019: -- Bug fix 5634515
3020: -- rewrite the query to delete the correct prepay application dist record.
3021:
3022: -- delete from AP_Prepay_history_all is placed after delete from AP_Prepay_App_Dists
3023: -- due to bug 7264479
3024:
3025: -- Bug fix 5634515
3026: -- rewrite the query to delete the correct prepay history record.

Line 3038: DELETE FROM ap_prepay_app_dists apad1

3034: -- bug9038462, the previous bug tags have been retained, but for the sake
3035: -- of code cleanliness, I am removing the old sqls used for deletions. Please
3036: -- refer to the prior versions if changes have to be compared
3037: --
3038: DELETE FROM ap_prepay_app_dists apad1
3039: WHERE apad1.prepay_history_id IN
3040: (SELECT apph.prepay_history_id
3041: FROM ap_prepay_history_all apph
3042: WHERE nvl(apph.posted_flag, 'N') <> 'Y'

Line 3047: FROM ap_prepay_app_dists apad,

3043: AND apph.invoice_id = p_invoice_id
3044: AND apph.transaction_type <> 'PREPAYMENT APPLICATION ADJ' --bug9973070
3045: AND NOT EXISTS
3046: (SELECT /*+ no_unnest */ 1 --bug12337556
3047: FROM ap_prepay_app_dists apad,
3048: ap_invoice_distributions_all aid
3049: WHERE apad.prepay_history_id = apph.prepay_history_id
3050: AND apad.prepay_app_distribution_id = aid.invoice_distribution_id
3051: AND (aid.posted_flag = 'Y' OR aid.encumbered_flag = 'Y')));

Line 3062: FROM ap_prepay_app_dists apad,

3058: AND apph.invoice_id = p_invoice_id
3059: AND apph.transaction_type <> 'PREPAYMENT APPLICATION ADJ' --bug9973070
3060: AND NOT EXISTS
3061: (SELECT /*+ no_unnest */ 1 --bug12337556
3062: FROM ap_prepay_app_dists apad,
3063: ap_invoice_distributions_all aid
3064: WHERE apad.prepay_history_id = apph.prepay_history_id
3065: AND apad.prepay_app_distribution_id = aid.invoice_distribution_id
3066: AND (aid.posted_flag = 'Y' OR aid.encumbered_flag = 'Y')));

Line 3420: AP_Prepay_App_Dists APAD,

3416: FROM AP_Invoices_All AI,
3417: AP_System_Parameters_All ASP,
3418: XLA_Transaction_Entities_upg XTE,
3419: XLA_Events XLE,
3420: AP_Prepay_App_Dists APAD,
3421: AP_Invoice_Distributions_All AID,
3422: XLA_AE_Headers AEH,
3423: XLA_AE_Lines AEL
3424: WHERE XLE.event_id = p_accounting_event_id

Line 3522: AP_Prepay_App_Dists APAD,

3518: FROM AP_Invoices_All AI,
3519: AP_System_Parameters_All ASP,
3520: XLA_Transaction_Entities_upg XTE,
3521: XLA_Events XLE,
3522: AP_Prepay_App_Dists APAD,
3523: AP_Invoice_Distributions_All AID,
3524: XLA_AE_Headers AEH,
3525: XLA_AE_Lines AEL
3526: WHERE XLE.event_id = p_accounting_event_id