APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_ALLOCATION_RULES

Line 5401: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;

5397: AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE;
5398: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
5399: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
5400: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
5401: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number

Line 5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;

5398: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
5399: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
5400: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
5401: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number
5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;

Line 5603: FROM ap_allocation_rules

5599:
5600: BEGIN
5601: SELECT rule_type, status
5602: INTO l_rule_type, l_rule_status
5603: FROM ap_allocation_rules
5604: WHERE invoice_id = X_invoice_id
5605: AND chrg_invoice_line_number = X_line_number;
5606:
5607: EXCEPTION

Line 6556: UPDATE AP_ALLOCATION_RULES

6552: -- allocation rule status should be set to 'Executed' when the associated
6553: -- charge line amount equals its distributions total.
6554:
6555: BEGIN
6556: UPDATE AP_ALLOCATION_RULES
6557: SET STATUS = 'EXECUTED'
6558: WHERE invoice_id = X_invoice_id
6559: AND chrg_invoice_line_number = X_line_number
6560: AND exists

Line 7324: UPDATE AP_ALLOCATION_RULES ALR

7320: WHERE aid.invoice_id = ail.invoice_id
7321: AND aid.invoice_line_number = ail.line_number
7322: AND aid.distribution_class = 'PERMANENT'); */
7323:
7324: UPDATE AP_ALLOCATION_RULES ALR
7325: SET STATUS = 'EXECUTED'
7326: WHERE alr.invoice_id = p_invoice_id
7327: AND alr.chrg_invoice_line_number = l_line_number_tab(uniq_values)
7328: AND EXISTS (SELECT 'Valid charge line'