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 60: FROM AP_Prepay_App_Dists APAD

56: -1, 'G', 1, 'L', NULL),
57: 'PREPAYMENT UNAPPLIED',
58: DECODE(SIGN(SUM(APAD.Base_Amount - APAD.Base_Amt_At_Prepay_XRate)),
59: 1, 'G', -1, 'L', NULL))
60: FROM AP_Prepay_App_Dists APAD
61: WHERE APAD.Prepay_History_ID = APH.Prepay_History_ID
62: AND APAD.Accounting_Event_ID = p_xla_event_rec.event_id)
63: WHERE APH.Accounting_Event_ID = p_xla_event_rec.event_id;
64:

Line 702: AP_Prepay_App_Dists APAD,

698: AID.Base_Amount_Variance,
699: AID.Historical_Flag, -- bug fix 6674279
700: AID.Accounting_Event_Id -- bug fix 6674279
701: FROM AP_Invoice_Distributions_All AID,
702: AP_Prepay_App_Dists APAD,
703: Financials_System_Params_All FSP
704: WHERE AID.Invoice_ID = P_Invoice_ID
705: AND NVL(AID.Reversal_Flag,'N') <> 'Y'
706: AND NVL(AID.Accounting_Event_ID,-99) <> P_Event_ID

Line 888: FROM ap_prepay_app_dists

884: IF l_inv_dist_rec.parent_reversal_id IS NOT NULL THEN
885:
886: SELECT count(*)
887: INTO l_prepay_dist_cnt
888: FROM ap_prepay_app_dists
889: WHERE invoice_distribution_id = l_inv_dist_rec.parent_reversal_id;
890:
891: END IF;
892:

Line 1018: FROM AP_Prepay_App_Dists APAD,

1014: 'PREPAY APPL NONREC TAX', APAD.Amount, 0)),
1015: SUM(DECODE(APAD.Prepay_Dist_Lookup_Code, 'TAX DIFF', APAD.Amount, 0))
1016: INTO l_sum_prepaid_amount,
1017: l_sum_tax_diff_amount
1018: FROM AP_Prepay_App_Dists APAD,
1019: ap_invoice_distributions_all aid
1020: WHERE APAD.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1021: AND apad.invoice_distribution_id = aid.invoice_distribution_id
1022: AND aid.invoice_id = l_prepay_dist_rec.invoice_id;

Line 1032: UPDATE AP_Prepay_App_Dists APAD

1028: END IF;
1029:
1030:
1031: /* Updating the prorated prepaid amounts for any rounding */
1032: UPDATE AP_Prepay_App_Dists APAD
1033: SET APAD.Amount = APAD.Amount - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount
1034: WHERE APAD.Invoice_Distribution_ID =
1035: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1036: FROM AP_Prepay_App_Dists APAD1

Line 1036: FROM AP_Prepay_App_Dists APAD1

1032: UPDATE AP_Prepay_App_Dists APAD
1033: SET APAD.Amount = APAD.Amount - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount
1034: WHERE APAD.Invoice_Distribution_ID =
1035: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1036: FROM AP_Prepay_App_Dists APAD1
1037: WHERE APAD1.Accounting_Event_ID = p_xla_event_rec.event_id
1038: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1039: AND APAD1.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
1040: 'PREPAY APPL NONREC TAX')

Line 1043: FROM AP_Prepay_App_Dists APAD2

1039: AND APAD1.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
1040: 'PREPAY APPL NONREC TAX')
1041: AND ABS(APAD1.Amount) =
1042: (SELECT MAX(APAD2.Amount)
1043: FROM AP_Prepay_App_Dists APAD2
1044: WHERE APAD2.Accounting_Event_ID = p_xla_event_rec.event_id
1045: AND APAD2.Prepay_App_Distribution_ID
1046: = l_prepay_dist_rec.invoice_distribution_id
1047: AND APAD2.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',

Line 1063: UPDATE AP_Prepay_App_Dists APAD

1059:
1060: /* Updating the prorated tax diff amounts for any rounding */
1061: IF (l_prepay_dist_rec.prepay_tax_diff_amount <> 0) THEN
1062:
1063: UPDATE AP_Prepay_App_Dists APAD
1064: SET APAD.Amount = APAD.Amount - NVL(l_sum_tax_diff_amount,0)
1065: + l_prepay_dist_rec.prepay_tax_diff_amount
1066: WHERE APAD.Invoice_Distribution_ID =
1067: (SELECT MAX(APAD1.Invoice_Distribution_ID)

Line 1068: FROM AP_Prepay_App_Dists APAD1

1064: SET APAD.Amount = APAD.Amount - NVL(l_sum_tax_diff_amount,0)
1065: + l_prepay_dist_rec.prepay_tax_diff_amount
1066: WHERE APAD.Invoice_Distribution_ID =
1067: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1068: FROM AP_Prepay_App_Dists APAD1
1069: WHERE APAD1.Accounting_Event_ID = p_xla_event_rec.event_id
1070: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1071: AND APAD1.Prepay_Dist_Lookup_Code = 'TAX DIFF'
1072: AND ABS(APAD1.Amount) =

Line 1074: FROM AP_Prepay_App_Dists APAD2

1070: AND APAD1.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1071: AND APAD1.Prepay_Dist_Lookup_Code = 'TAX DIFF'
1072: AND ABS(APAD1.Amount) =
1073: (SELECT MAX(APAD2.Amount)
1074: FROM AP_Prepay_App_Dists APAD2
1075: WHERE APAD2.Accounting_Event_ID = p_xla_event_rec.event_id
1076: AND APAD2.Prepay_App_Distribution_ID
1077: = l_prepay_dist_rec.invoice_distribution_id
1078: AND APAD2.Prepay_Dist_Lookup_Code = 'TAX DIFF'))

Line 1181: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1177: l_base_qty_variance NUMBER;
1178: l_amt_variance NUMBER;
1179: l_base_amt_variance NUMBER;
1180:
1181: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1182:
1183: -- Logging Infra:
1184: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Proc';
1185: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1599: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1595: l_prorated_amount NUMBER;
1596: l_prorated_pay_amt NUMBER;
1597: l_prorated_clr_amt NUMBER;
1598:
1599: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1600:
1601: -- Logging Infra:
1602: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_Tax_Diff';
1603: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1801: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1797: l_po_pay_exchange_rate NUMBER;
1798: l_pay_erv_amount NUMBER;
1799: l_clr_erv_amount NUMBER;
1800: l_inv_erv_amount NUMBER;
1801: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1802:
1803: -- Logging Infra:
1804: l_procedure_name CONSTANT VARCHAR2(30) := 'Prepay_Dist_ERV';
1805: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1994: INSERT INTO AP_Prepay_App_Dists

1990: -- Bug 6698125. Added if condition to correctly reverse the prepay app
1991: -- distributions based on if reversed for prepayment unapplication or
1992: -- prepayment application adjusted events.
1993: IF p_prepay_reversal_id IS NOT NULL THEN
1994: INSERT INTO AP_Prepay_App_Dists
1995: (Prepay_App_Dist_ID,
1996: Prepay_Dist_Lookup_Code,
1997: Invoice_Distribution_ID,
1998: Prepay_App_Distribution_ID,

Line 2032: SELECT AP_Prepay_App_Dists_S.nextval,

2028: Program_ID,
2029: Program_Update_Date,
2030: Request_ID
2031: )
2032: SELECT AP_Prepay_App_Dists_S.nextval,
2033: APAD.Prepay_Dist_Lookup_Code,
2034: APAD.Invoice_Distribution_ID,
2035: p_prepay_inv_dist_id,
2036: NULL, --p_xla_event_rec.event_id,

Line 2068: FROM AP_Prepay_App_Dists APAD

2064: FND_GLOBAL.Prog_Appl_ID,
2065: FND_GLOBAL.Conc_Program_ID,
2066: SYSDATE,
2067: FND_GLOBAL.Conc_Request_ID
2068: FROM AP_Prepay_App_Dists APAD
2069: WHERE Prepay_App_Distribution_ID = P_Prepay_Reversal_ID;
2070:
2071: ELSIF p_inv_reversal_id IS NOT NULL THEN
2072:

Line 2073: INSERT INTO AP_Prepay_App_Dists

2069: WHERE Prepay_App_Distribution_ID = P_Prepay_Reversal_ID;
2070:
2071: ELSIF p_inv_reversal_id IS NOT NULL THEN
2072:
2073: INSERT INTO AP_Prepay_App_Dists
2074: (Prepay_App_Dist_ID,
2075: Prepay_Dist_Lookup_Code,
2076: Invoice_Distribution_ID,
2077: Prepay_App_Distribution_ID,

Line 2111: SELECT AP_Prepay_App_Dists_S.nextval,

2107: Program_ID,
2108: Program_Update_Date,
2109: Request_ID
2110: )
2111: SELECT AP_Prepay_App_Dists_S.nextval,
2112: APAD.Prepay_Dist_Lookup_Code,
2113: p_inv_dist_id, -- Bug 7134020
2114: APAD.Prepay_App_Distribution_ID,
2115: p_xla_event_rec.event_id,

Line 2147: FROM AP_Prepay_App_Dists APAD

2143: FND_GLOBAL.Prog_Appl_ID,
2144: FND_GLOBAL.Conc_Program_ID,
2145: SYSDATE,
2146: FND_GLOBAL.Conc_Request_ID
2147: FROM AP_Prepay_App_Dists APAD
2148: WHERE Invoice_Distribution_ID = P_Inv_Reversal_ID;
2149:
2150: END IF;
2151:

Line 2175: -- into the ap_prepay_app_dists table

2171:
2172: ----------------------------------------------------------------------------------
2173: -- PROCEDURE Prepay_Dist_Insert
2174: -- This procedure is used to insert the prepay application payment distributions
2175: -- into the ap_prepay_app_dists table
2176: ----------------------------------------------------------------------------------
2177:
2178: PROCEDURE Prepay_Dist_Insert
2179: (P_PAD_Rec IN AP_PREPAY_APP_DISTS%ROWTYPE

Line 2179: (P_PAD_Rec IN AP_PREPAY_APP_DISTS%ROWTYPE

2175: -- into the ap_prepay_app_dists table
2176: ----------------------------------------------------------------------------------
2177:
2178: PROCEDURE Prepay_Dist_Insert
2179: (P_PAD_Rec IN AP_PREPAY_APP_DISTS%ROWTYPE
2180: ,P_Calling_Sequence IN VARCHAR2
2181: ) IS
2182:
2183: l_curr_calling_sequence VARCHAR2(2000);

Line 2201: INSERT INTO AP_Prepay_App_Dists

2197: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
2198: END IF;
2199:
2200:
2201: INSERT INTO AP_Prepay_App_Dists
2202: (Prepay_App_Dist_ID,
2203: Prepay_Dist_Lookup_Code,
2204: Invoice_Distribution_ID,
2205: Prepay_App_Distribution_ID,

Line 2239: VALUES (AP_Prepay_App_Dists_S.nextval,

2235: Program_ID,
2236: Program_Update_Date,
2237: Request_ID
2238: )
2239: VALUES (AP_Prepay_App_Dists_S.nextval,
2240: P_PAD_Rec.Prepay_Dist_Lookup_Code,
2241: P_PAD_Rec.Invoice_Distribution_ID,
2242: P_PAD_Rec.Prepay_App_Distribution_ID,
2243: P_PAD_Rec.Accounting_Event_ID,

Line 2330: --DELETE FROM AP_Prepay_App_Dists apad

2326:
2327:
2328: -- Bug fix 5634515
2329: -- rewrite the query to delete the correct prepay application dist record.
2330: --DELETE FROM AP_Prepay_App_Dists apad
2331: --WHERE prepay_history_id in (
2332: -- select aph.prepay_history_id
2333: -- from ap_prepay_history_all aph,ap_prepay_app_dists apad1
2334: -- where aph.prepay_history_id=apad1.prepay_history_id

Line 2333: -- from ap_prepay_history_all aph,ap_prepay_app_dists apad1

2329: -- rewrite the query to delete the correct prepay application dist record.
2330: --DELETE FROM AP_Prepay_App_Dists apad
2331: --WHERE prepay_history_id in (
2332: -- select aph.prepay_history_id
2333: -- from ap_prepay_history_all aph,ap_prepay_app_dists apad1
2334: -- where aph.prepay_history_id=apad1.prepay_history_id
2335: -- and aph.accounting_event_id is null
2336: -- and aph.bc_event_id is not null
2337: -- and aph.invoice_id=p_invoice_id

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

2340: -- apad1.prepay_app_distribution_id
2341: -- and nvl(aid.encumbered_flag,'N')='Y'));
2342:
2343:
2344: --- delete from AP_Prepay_history_all is placed after delete from AP_Prepay_App_Dists
2345: --- due to bug 7264479
2346:
2347: DELETE FROM AP_Prepay_App_Dists apad
2348: WHERE prepay_history_id in (

Line 2347: DELETE FROM AP_Prepay_App_Dists apad

2343:
2344: --- delete from AP_Prepay_history_all is placed after delete from AP_Prepay_App_Dists
2345: --- due to bug 7264479
2346:
2347: DELETE FROM AP_Prepay_App_Dists apad
2348: WHERE prepay_history_id in (
2349: select aph.prepay_history_id
2350: from ap_prepay_history_all aph,ap_prepay_app_dists apad1
2351: where aph.prepay_history_id=apad1.prepay_history_id

Line 2350: from ap_prepay_history_all aph,ap_prepay_app_dists apad1

2346:
2347: DELETE FROM AP_Prepay_App_Dists apad
2348: WHERE prepay_history_id in (
2349: select aph.prepay_history_id
2350: from ap_prepay_history_all aph,ap_prepay_app_dists apad1
2351: where aph.prepay_history_id=apad1.prepay_history_id
2352: and aph.accounting_event_id is null
2353: and (aph.bc_event_id is null or
2354: (aph.bc_event_id is not null

Line 2373: -- AND not exists(select 1 from AP_Prepay_App_Dists apad,

2369: --DELETE FROM AP_Prepay_history_all aph
2370: --WHERE Accounting_Event_ID is null
2371: -- AND bc_event_id is not null
2372: -- AND Invoice_id =p_invoice_id
2373: -- AND not exists(select 1 from AP_Prepay_App_Dists apad,
2374: -- ap_invoice_distributions_all aid
2375: -- where aid.invoice_distribution_id=
2376: -- apad.invoice_distribution_id
2377: -- and aph.prepay_history_id=apad.prepay_history_id

Line 2385: AND not exists(select 1 from AP_Prepay_App_Dists apad,

2381: WHERE Accounting_Event_ID is null
2382: AND (bc_event_id is null or
2383: (bc_event_id is not null
2384: AND Invoice_id = p_invoice_id
2385: AND not exists(select 1 from AP_Prepay_App_Dists apad,
2386: ap_invoice_distributions_all aid
2387: -- Bug fix 5634515
2388: -- replace invoice_distribution_id with prepay_app_distribution_id
2389: -- since the original one can only derive other invoice lines except