APPS.AP_APPROVAL_PKG dependencies on AP_ALLOCATION_RULES

Line 3076: ap_allocation_rules ALOC

3072:
3073: CURSOR Alloc_Rule_Cur IS
3074: SELECT ALOC.rule_type
3075: FROM ap_invoice_lines AIL,
3076: ap_allocation_rules ALOC
3077: WHERE AIL.invoice_id = p_inv_line_rec.invoice_id
3078: AND AIL.line_number = p_inv_line_rec.line_number
3079: AND AIL.invoice_id = ALOC.invoice_id
3080: AND AIL.line_number = ALOC.chrg_invoice_line_number(+);

Line 3087: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;

3083: l_curr_calling_sequence VARCHAR2(2000);
3084: l_debug_info VARCHAR2(1000);
3085: l_ret_val BOOLEAN;
3086: l_should_have_hold VARCHAR2(1) := 'N';
3087: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;
3088: l_product_registered BOOLEAN;
3089: l_dummy VARCHAR2(100);
3090:
3091: BEGIN

Line 3241: ap_allocation_rules ALOC

3237:
3238: CURSOR Alloc_Rule_Cur IS
3239: SELECT ALOC.rule_type
3240: FROM ap_invoice_lines AIL,
3241: ap_allocation_rules ALOC
3242: WHERE AIL.invoice_id = p_inv_line_rec.invoice_id
3243: AND AIL.line_number = p_inv_line_rec.line_number
3244: AND AIL.invoice_id = ALOC.invoice_id
3245: AND AIL.line_number = ALOC.chrg_invoice_line_number(+);

Line 3250: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;

3246:
3247: l_debug_loc VARCHAR2(30) := 'Execute_Dist_Generation_Check';
3248: l_curr_calling_sequence VARCHAR2(2000);
3249: l_debug_info VARCHAR2(2000);
3250: l_alloc_rule_type ap_allocation_rules.rule_type%TYPE;
3251:
3252: l_debug_context VARCHAR2(2000);
3253: l_msg_application VARCHAR2(25);
3254: l_error_code VARCHAR2(4000);

Line 11467: l_allocation_rule_type ap_allocation_rules.rule_type%TYPE; --10052153

11463:
11464: l_not_exist_nond_line VARCHAR2(1); --bug6783517
11465: l_disc_chrge_line NUMBER := 0; --bug8820542
11466:
11467: l_allocation_rule_type ap_allocation_rules.rule_type%TYPE; --10052153
11468: l_allocation_status ap_allocation_rules.status%TYPE; --10052153
11469:
11470: -- bug6783517 starts
11471: CURSOR dist_gen_holds(p_invoice_id NUMBER)

Line 11468: l_allocation_status ap_allocation_rules.status%TYPE; --10052153

11464: l_not_exist_nond_line VARCHAR2(1); --bug6783517
11465: l_disc_chrge_line NUMBER := 0; --bug8820542
11466:
11467: l_allocation_rule_type ap_allocation_rules.rule_type%TYPE; --10052153
11468: l_allocation_status ap_allocation_rules.status%TYPE; --10052153
11469:
11470: -- bug6783517 starts
11471: CURSOR dist_gen_holds(p_invoice_id NUMBER)
11472: IS

Line 11613: FROM ap_invoice_lines_all ail, ap_allocation_rules ALR

11609: WHERE aha.invoice_id = p_invoice_rec.invoice_id
11610: AND aha.hold_lookup_code = 'CANNOT EXECUTE ALLOCATION'
11611: AND aha.release_lookup_code IS NULL
11612: AND NOT EXISTS ( SELECT 1
11613: FROM ap_invoice_lines_all ail, ap_allocation_rules ALR
11614: WHERE ail.invoice_id = p_invoice_rec.invoice_id
11615: AND ail.line_type_lookup_code in ('FREIGHT','MISCELLANEOUS')
11616: AND nvl(ail.discarded_flag,'N') ='N'
11617: AND ALR.invoice_id = AIL.invoice_id

Line 11704: FROM ap_allocation_rules

11700:
11701: BEGIN
11702: SELECT rule_type, status
11703: INTO l_allocation_rule_type, l_allocation_status
11704: FROM ap_allocation_rules
11705: WHERE invoice_id = t_inv_lines_table(i).invoice_id
11706: AND chrg_invoice_line_number = t_inv_lines_table(i).line_number;
11707: EXCEPTION
11708: WHEN NO_DATA_FOUND THEN

Line 11717: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(

11713: --Bug10052153:Added OR condition
11714: IF (l_prorate_across_all_items='Y'
11715: OR (l_allocation_rule_type = 'PRORATION' AND l_allocation_status='PENDING')) then
11716:
11717: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(
11718: t_inv_lines_table(i).invoice_id,
11719: t_inv_lines_table(i).line_number,
11720: NULL,
11721: 'APAPRVLB',