APPS.AP_ALLOCATION_RULES_PKG dependencies on AP_ALLOCATION_RULE_LINES_GT

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 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 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 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;