APPS.AP_APPROVAL_PKG dependencies on AP_ALLOCATION_RULES

Line 2245: ap_allocation_rules ALOC

2241:
2242: CURSOR Alloc_Rule_Cur IS
2243: SELECT ALOC.rule_type
2244: FROM ap_invoice_lines AIL,
2245: ap_allocation_rules ALOC
2246: WHERE AIL.invoice_id = p_inv_line_rec.invoice_id
2247: AND AIL.line_number = p_inv_line_rec.line_number
2248: AND AIL.invoice_id = ALOC.invoice_id
2249: AND AIL.line_number = ALOC.chrg_invoice_line_number(+);

Line 2256: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;

2252: l_curr_calling_sequence VARCHAR2(2000);
2253: l_debug_info VARCHAR2(1000);
2254: l_ret_val BOOLEAN;
2255: l_should_have_hold VARCHAR2(1) := 'N';
2256: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;
2257: l_product_registered BOOLEAN;
2258: l_dummy VARCHAR2(100);
2259:
2260: BEGIN

Line 2396: ap_allocation_rules ALOC

2392:
2393: CURSOR Alloc_Rule_Cur IS
2394: SELECT ALOC.rule_type
2395: FROM ap_invoice_lines AIL,
2396: ap_allocation_rules ALOC
2397: WHERE AIL.invoice_id = p_inv_line_rec.invoice_id
2398: AND AIL.line_number = p_inv_line_rec.line_number
2399: AND AIL.invoice_id = ALOC.invoice_id
2400: AND AIL.line_number = ALOC.chrg_invoice_line_number(+);

Line 2405: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;

2401:
2402: l_debug_loc VARCHAR2(30) := 'Execute_Dist_Generation_Check';
2403: l_curr_calling_sequence VARCHAR2(2000);
2404: l_debug_info VARCHAR2(2000);
2405: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;
2406:
2407: l_debug_context VARCHAR2(2000);
2408: l_msg_application VARCHAR2(25);
2409: l_error_code VARCHAR2(4000);

Line 8598: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(

8594: AND line_number = t_inv_lines_table(i).line_number;
8595:
8596: IF (l_prorate_across_all_items='Y') then
8597:
8598: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(
8599: t_inv_lines_table(i).invoice_id,
8600: t_inv_lines_table(i).line_number,
8601: NULL,
8602: 'APAPRVLB',