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_ALLOCATION_RULES_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 321: INSERT INTO ap_allocation_rule_lines (

317: --------------------------------------------------------------
318: -- Step 6 - Insert Allocation Rule Lines
319: --------------------------------------------------------------
320: BEGIN
321: INSERT INTO ap_allocation_rule_lines (
322: invoice_id,
323: chrg_invoice_line_number,
324: to_invoice_line_number,
325: amount,

Line 381: FROM ap_allocation_rule_lines

377: --------------------------------------------------------------
378: BEGIN
379: SELECT SUM(amount)
380: INTO l_total_prorated
381: FROM ap_allocation_rule_lines
382: WHERE invoice_id = X_invoice_id
383: AND chrg_invoice_line_number = X_line_number;
384:
385: IF (l_amount_to_prorate <> l_total_prorated) THEN

Line 386: UPDATE ap_allocation_rule_lines

382: WHERE invoice_id = X_invoice_id
383: AND chrg_invoice_line_number = X_line_number;
384:
385: IF (l_amount_to_prorate <> l_total_prorated) THEN
386: UPDATE ap_allocation_rule_lines
387: SET amount = amount + (l_amount_to_prorate - l_total_prorated)
388: WHERE invoice_id = X_invoice_id
389: AND chrg_invoice_line_number = X_line_number
390: AND to_invoice_line_number =

Line 472: l_debug_info := 'Inserting record into AP_ALLOCATION_RULE_LINES';

468: NULL,
469: NULL);
470:
471:
472: l_debug_info := 'Inserting record into AP_ALLOCATION_RULE_LINES';
473:
474: Insert Into ap_allocation_rule_lines (
475: Invoice_id,
476: chrg_invoice_line_number,

Line 474: Insert Into ap_allocation_rule_lines (

470:
471:
472: l_debug_info := 'Inserting record into AP_ALLOCATION_RULE_LINES';
473:
474: Insert Into ap_allocation_rule_lines (
475: Invoice_id,
476: chrg_invoice_line_number,
477: to_invoice_line_number,
478: percentage,

Line 810: FROM ap_allocation_rule_lines

806: BEGIN
807: l_alloc_rule_lines := 0;
808: SELECT COUNT(*)
809: INTO l_alloc_rule_lines
810: FROM ap_allocation_rule_lines
811: WHERE invoice_id = X_invoice_id
812: AND chrg_invoice_line_number = X_chrg_line_number;
813:
814: IF (l_rule_type ='PRORATION') THEN

Line 927: INSERT INTO ap_allocation_rule_lines_gt(

923:
924: IF X_window_context = 'ALLOCATIONS' then
925:
926: BEGIN
927: INSERT INTO ap_allocation_rule_lines_gt(
928: invoice_id,
929: chrg_invoice_line_number,
930: to_invoice_line_number,
931: amount,

Line 982: INSERT INTO ap_allocation_rule_lines(

978:
979: ELSE
980:
981: BEGIN
982: INSERT INTO ap_allocation_rule_lines(
983: invoice_id,
984: chrg_invoice_line_number,
985: to_invoice_line_number,
986: amount,

Line 1046: FROM ap_allocation_rule_lines_gt

1042: IF X_window_context = 'ALLOCATIONS' then
1043: BEGIN
1044: SELECT SUM(amount)
1045: INTO l_total_prorated
1046: FROM ap_allocation_rule_lines_gt
1047: WHERE invoice_id = X_invoice_id
1048: AND chrg_invoice_line_number = X_chrg_line_number;
1049:
1050: IF (l_amount_to_prorate <> l_total_prorated) THEN

Line 1051: UPDATE ap_allocation_rule_lines_gt

1047: WHERE invoice_id = X_invoice_id
1048: AND chrg_invoice_line_number = X_chrg_line_number;
1049:
1050: IF (l_amount_to_prorate <> l_total_prorated) THEN
1051: UPDATE ap_allocation_rule_lines_gt
1052: SET amount = amount + (l_amount_to_prorate - l_total_prorated)
1053: WHERE invoice_id = X_invoice_id
1054: AND chrg_invoice_line_number = X_chrg_line_number
1055: AND to_invoice_line_number =

Line 1087: FROM ap_allocation_rule_lines

1083: ELSE
1084: BEGIN
1085: SELECT SUM(amount)
1086: INTO l_total_prorated
1087: FROM ap_allocation_rule_lines
1088: WHERE invoice_id = X_invoice_id
1089: AND chrg_invoice_line_number = X_chrg_line_number;
1090:
1091: IF (l_amount_to_prorate <> l_total_prorated) THEN

Line 1092: UPDATE ap_allocation_rule_lines

1088: WHERE invoice_id = X_invoice_id
1089: AND chrg_invoice_line_number = X_chrg_line_number;
1090:
1091: IF (l_amount_to_prorate <> l_total_prorated) THEN
1092: UPDATE ap_allocation_rule_lines
1093: SET amount = amount + (l_amount_to_prorate - l_total_prorated)
1094: WHERE invoice_id = X_invoice_id
1095: AND chrg_invoice_line_number = X_chrg_line_number
1096: AND to_invoice_line_number =

Line 1140: -- Global Temporary Table(AP_ALLOCATION_RULE_LINES_GT).

1136: -- This procedure sums up the Allocations lines from the Standpoint of a
1137: -- Item Line. This procedures sums up the Allocations lines from the
1138: -- Allocation_rule_lines table(AMOUNT, PERCENTAGE and Executed PRORATION)
1139: -- UNIONED with the PENDING Proration allocation rule lines from the
1140: -- Global Temporary Table(AP_ALLOCATION_RULE_LINES_GT).
1141: -----------------------------------------------------------------------
1142: PROCEDURE Select_Item_Summary(
1143: X_Invoice_id IN NUMBER,
1144: X_to_invoice_line_number IN NUMBER,

Line 1168: FROM ap_allocation_rule_lines

1164: ----------------------------------------------------------
1165:
1166: SELECT nvl(sum(amount), 0), nvl(sum(amount), 0)
1167: INTO l_allocated_total, l_allocated_total_rtot_db
1168: FROM ap_allocation_rule_lines
1169: WHERE invoice_id = X_invoice_id
1170: AND to_invoice_line_number = X_to_invoice_line_number;
1171:
1172:

Line 1178: FROM ap_allocation_rule_lines_gt

1174: debug_info := 'Get allocated total from the GT Table';
1175: ----------------------------------------------------------
1176: SELECT nvl(sum(amount), 0), nvl(sum(amount), 0)
1177: INTO l_allocated_total_gt, l_allocated_total_gt_rtot_db
1178: FROM ap_allocation_rule_lines_gt
1179: WHERE invoice_id = X_invoice_id
1180: AND to_invoice_line_number = X_to_invoice_line_number;
1181:
1182: X_allocated_total := l_allocated_total + l_allocated_total_gt;

Line 1206: -- in the Ap_allocation_Rule_lines based on the allocation_flag

1202:
1203:
1204: -----------------------------------------------------------------------
1205: -- This function Inserts/Updates/Deletes records
1206: -- in the Ap_allocation_Rule_lines based on the allocation_flag
1207: -- passed to this function via manual allocation for AMOUNT and
1208: -- PERCENTAGE type Rules in the Allocation Rule Window.
1209: ------------------------------------------------------------------------
1210: FUNCTION Allocation_Rule_Lines(

Line 1241: FROM ap_allocation_rule_lines

1237: BEGIN
1238: l_alloc_rule_line := 0;
1239: SELECT COUNT(*)
1240: INTO l_alloc_rule_line
1241: FROM ap_allocation_rule_lines
1242: WHERE invoice_id = X_invoice_id
1243: AND chrg_invoice_line_number = X_chrg_invoice_line_number
1244: AND to_invoice_line_number = X_to_invoice_line_number;
1245:

Line 1260: INSERT INTO ap_allocation_rule_Lines(

1256: IF l_alloc_rule_line = 0 then
1257:
1258: IF X_allocation_flag = 'Y' then
1259: BEGIN
1260: INSERT INTO ap_allocation_rule_Lines(
1261: invoice_id,
1262: chrg_invoice_line_number,
1263: to_invoice_line_number,
1264: percentage,

Line 1319: DELETE FROM ap_allocation_rule_lines

1315: IF l_alloc_rule_line <> 0 THEN
1316:
1317: IF X_allocation_flag = 'N' then
1318: BEGIN
1319: DELETE FROM ap_allocation_rule_lines
1320: WHERE invoice_id = X_invoice_id
1321: AND chrg_invoice_line_number = X_chrg_invoice_line_number
1322: AND to_invoice_line_number = X_to_invoice_line_number;
1323:

Line 1351: UPDATE ap_allocation_rule_lines

1347: IF l_alloc_rule_line <> 0 THEN
1348:
1349: IF X_allocation_flag = 'Y' then
1350: BEGIN
1351: UPDATE ap_allocation_rule_lines
1352: SET Amount = X_allocated_AMount,
1353: percentage = X_allocated_percentage,
1354: last_update_date = SYSDATE,
1355: last_updated_by = FND_GLOBAL.user_id,

Line 1762: FROM ap_allocation_rule_lines

1758:
1759: BEGIN
1760: SELECT NVL(SUM(amount) ,0)
1761: INTO l_prorating_total
1762: FROM ap_allocation_rule_lines
1763: WHERE invoice_id = X_invoice_id
1764: AND chrg_invoice_line_number = X_chrg_line_number;
1765:
1766: IF (l_prorating_total = 0) THEN

Line 1783: debug_info := 'Step 5 - Update ap_allocation_rule_lines ';

1779: END;
1780: END IF;
1781:
1782: ---------------------------------------------------------
1783: debug_info := 'Step 5 - Update ap_allocation_rule_lines ';
1784: ---------------------------------------------------------
1785: IF (l_rule_type <> 'PRORATION' AND
1786: X_new_chrg_line_amt <> 0 ) THEN
1787:

Line 1790: UPDATE ap_allocation_rule_lines

1786: X_new_chrg_line_amt <> 0 ) THEN
1787:
1788: BEGIN
1789:
1790: UPDATE ap_allocation_rule_lines
1791: SET amount = ap_utilities_pkg.ap_round_currency(
1792: l_amount_to_prorate*amount/
1793: l_prorating_total, l_inv_curr_code),
1794: last_updated_by = FND_GLOBAL.USER_ID,

Line 1827: FROM ap_allocation_rule_lines

1823: X_new_chrg_line_amt <> 0 ) THEN
1824: BEGIN
1825: SELECT SUM(amount)
1826: INTO l_total_prorated
1827: FROM ap_allocation_rule_lines
1828: WHERE invoice_id = X_invoice_id
1829: AND chrg_invoice_line_number = X_chrg_line_number;
1830:
1831: IF (l_amount_to_prorate <> l_total_prorated) THEN

Line 1832: UPDATE ap_allocation_rule_lines

1828: WHERE invoice_id = X_invoice_id
1829: AND chrg_invoice_line_number = X_chrg_line_number;
1830:
1831: IF (l_amount_to_prorate <> l_total_prorated) THEN
1832: UPDATE ap_allocation_rule_lines
1833: SET amount = amount + (l_amount_to_prorate - l_total_prorated)
1834: WHERE invoice_id = X_invoice_id
1835: AND chrg_invoice_line_number = X_chrg_line_number
1836: AND to_invoice_line_number =

Line 1838: FROM ap_allocation_rule_lines arl1

1834: WHERE invoice_id = X_invoice_id
1835: AND chrg_invoice_line_number = X_chrg_line_number
1836: AND to_invoice_line_number =
1837: (SELECT (MAX(arl1.to_invoice_line_number))
1838: FROM ap_allocation_rule_lines arl1
1839: WHERE arl1.invoice_id = X_invoice_id
1840: AND arl1.chrg_invoice_line_number = X_chrg_line_number
1841: AND arl1.amount <> 0
1842: AND ABS(arl1.amount) >=

Line 1844: FROM ap_allocation_rule_lines arl2

1840: AND arl1.chrg_invoice_line_number = X_chrg_line_number
1841: AND arl1.amount <> 0
1842: AND ABS(arl1.amount) >=
1843: ( SELECT MAX(ABS(arl2.amount))
1844: FROM ap_allocation_rule_lines arl2
1845: WHERE arl2.invoice_id = X_invoice_id
1846: AND arl2.chrg_invoice_line_number = X_chrg_line_number
1847: AND arl2.to_invoice_line_number <>
1848: arl2.to_invoice_line_number

Line 2054: DELETE FROM ap_allocation_rule_lines

2050: 'Ap_Allocation_Rules_Pkg.Delete_allocations_lines<-'||X_Calling_Sequence;
2051: -----------------------------------------------------------
2052: debug_info := 'Deleting any existing allocation rows ';
2053: ----------------------------------------------------------
2054: DELETE FROM ap_allocation_rule_lines
2055: WHERE invoice_id = X_invoice_id
2056: AND chrg_invoice_line_number = X_chrg_line_number;
2057:
2058: EXCEPTION

Line 2153: FROM ap_allocation_rule_lines

2149: AND chrg_invoice_line_number = X_chrg_line_number;
2150:
2151: SELECT COUNT(*)
2152: INTO l_other_alloc_rule_line
2153: FROM ap_allocation_rule_lines
2154: WHERE invoice_id = X_invoice_id
2155: AND chrg_invoice_line_number = X_chrg_line_number;
2156:
2157:

Line 2168: DELETE FROM ap_allocation_rule_lines

2164: END IF;
2165:
2166: IF (l_other_alloc_rule_line <> 0) THEN
2167:
2168: DELETE FROM ap_allocation_rule_lines
2169: WHERE invoice_id = X_invoice_id
2170: AND chrg_invoice_line_number = X_chrg_line_number;
2171:
2172: END IF;

Line 2232: INSERT INTO ap_allocation_rule_lines (

2228: --------------------------------------------------------------
2229: -- Step 6 - Insert Allocation Rule Lines
2230: --------------------------------------------------------------
2231: BEGIN
2232: INSERT INTO ap_allocation_rule_lines (
2233: invoice_id,
2234: chrg_invoice_line_number,
2235: to_invoice_line_number,
2236: amount,