APPS.AP_GENERATE_DISTRIBUTIONS_PKG dependencies on AP_ALLOCATION_RULES

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

236: l_invoice_num VARCHAR2(50);
237: l_line_number NUMBER;
238: l_api_name CONSTANT VARCHAR2(200) := 'Generate_Dists_For_Invoice';
239:
240: l_allocation_rule_type ap_allocation_rules.rule_type%TYPE; --10052153
241: l_allocation_status ap_allocation_rules.status%TYPE; --10052153
242:
243: BEGIN
244:

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

237: l_line_number NUMBER;
238: l_api_name CONSTANT VARCHAR2(200) := 'Generate_Dists_For_Invoice';
239:
240: l_allocation_rule_type ap_allocation_rules.rule_type%TYPE; --10052153
241: l_allocation_status ap_allocation_rules.status%TYPE; --10052153
242:
243: BEGIN
244:
245: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||

Line 332: FROM ap_allocation_rules

328: -- is Y or Fully Prorate rule is defined from Allocations window
329: BEGIN
330: SELECT rule_type, status
331: INTO l_allocation_rule_type, l_allocation_status
332: FROM ap_allocation_rules
333: WHERE invoice_id = p_invoice_id
334: AND chrg_invoice_line_number = t_inv_lines_table(i).line_number;
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN

Line 352: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(

348: --Bug10052153: Added OR condition
349: IF(t_inv_lines_table(i).prorate_across_all_items='Y'
350: OR (l_allocation_rule_type = 'PRORATION' AND l_allocation_status = 'PENDING')) then
351:
352: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(
353: t_inv_lines_table(i).invoice_id,
354: t_inv_lines_table(i).line_number,
355: NULL,
356: 'APAIDUTB',

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

629: l_debug_info VARCHAR2(2000);
630: l_debug_context VARCHAR2(2000);
631: l_curr_calling_sequence VARCHAR2(2000);
632:
633: l_allocation_status ap_allocation_rules.status%TYPE; --10052153
634: l_allocation_rule_type ap_allocation_rules.rule_type%TYPE; --10052153
635:
636: BEGIN
637:

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

630: l_debug_context VARCHAR2(2000);
631: l_curr_calling_sequence VARCHAR2(2000);
632:
633: l_allocation_status ap_allocation_rules.status%TYPE; --10052153
634: l_allocation_rule_type ap_allocation_rules.rule_type%TYPE; --10052153
635:
636: BEGIN
637:
638: l_curr_calling_sequence := 'AP_GENERATE_DISTRIBUTIONS_PKG.'||

Line 713: FROM ap_allocation_rules

709: -- is Y or Fully Prorate rule is defined from Allocations window
710: BEGIN
711: SELECT rule_type, status
712: INTO l_allocation_rule_type, l_allocation_status
713: FROM ap_allocation_rules
714: WHERE invoice_id = p_invoice_id
715: AND chrg_invoice_line_number = t_inv_lines_table(i).line_number;
716: EXCEPTION
717: WHEN NO_DATA_FOUND THEN

Line 734: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(

730: --Bug10052153 : Added OR condition
731: IF (t_inv_lines_table(i).prorate_across_all_items='Y'
732: OR (l_allocation_rule_type = 'PRORATION' AND l_allocation_status='PENDING')) then
733:
734: l_success := AP_ALLOCATION_RULES_PKG.Create_Proration_Rule(
735: t_inv_lines_table(i).invoice_id,
736: t_inv_lines_table(i).line_number,
737: NULL,
738: 'APAIDUTB',