APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_ALLOCATION_RULES

Line 6763: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;

6759: AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE;
6760: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
6761: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
6762: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
6763: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
6767: l_alloc_rule_line_number

Line 6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;

6760: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
6761: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
6762: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
6763: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
6767: l_alloc_rule_line_number
6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;

Line 7040: FROM ap_allocation_rules

7036:
7037: BEGIN
7038: SELECT rule_type, status
7039: INTO l_rule_type, l_rule_status
7040: FROM ap_allocation_rules
7041: WHERE invoice_id = X_invoice_id
7042: AND chrg_invoice_line_number = X_line_number;
7043:
7044: EXCEPTION

Line 8051: UPDATE AP_ALLOCATION_RULES

8047: -- allocation rule status should be set to 'Executed' when the associated
8048: -- charge line amount equals its distributions total.
8049:
8050: BEGIN
8051: UPDATE AP_ALLOCATION_RULES
8052: SET STATUS = 'EXECUTED'
8053: WHERE invoice_id = X_invoice_id
8054: AND chrg_invoice_line_number = X_line_number
8055: AND exists

Line 9166: UPDATE AP_ALLOCATION_RULES ALR

9162: WHERE aid.invoice_id = ail.invoice_id
9163: AND aid.invoice_line_number = ail.line_number
9164: AND aid.distribution_class = 'PERMANENT'); */
9165:
9166: UPDATE AP_ALLOCATION_RULES ALR
9167: SET STATUS = 'EXECUTED'
9168: WHERE alr.invoice_id = p_invoice_id
9169: AND alr.chrg_invoice_line_number = l_line_number_tab(uniq_values)
9170: AND EXISTS (SELECT 'Valid charge line'