2: /* $Header: QPXVCLNB.pls 120.19 2011/08/29 08:09:10 jputta ship $ */
3:
4: G_CALC_INSERT VARCHAR2(30) := 'INSERTED FOR CALCULATION';
5: --to store the line_detail_index with which the relationships were inserted
6: G_PBH_LINE_DTL_INDEX QP_PREQ_GRP.NUMBER_TYPE;
7: G_PBH_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
8: G_PBH_PRICE_ADJ_ID QP_PREQ_GRP.NUMBER_TYPE;
9: G_PBH_PLSQL_IND QP_PREQ_GRP.NUMBER_TYPE;
10: G_MAX_DTL_INDEX NUMBER := 0;
3:
4: G_CALC_INSERT VARCHAR2(30) := 'INSERTED FOR CALCULATION';
5: --to store the line_detail_index with which the relationships were inserted
6: G_PBH_LINE_DTL_INDEX QP_PREQ_GRP.NUMBER_TYPE;
7: G_PBH_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
8: G_PBH_PRICE_ADJ_ID QP_PREQ_GRP.NUMBER_TYPE;
9: G_PBH_PLSQL_IND QP_PREQ_GRP.NUMBER_TYPE;
10: G_MAX_DTL_INDEX NUMBER := 0;
11: G_ORD_LVL_LDET_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE; -- 3031108
4: G_CALC_INSERT VARCHAR2(30) := 'INSERTED FOR CALCULATION';
5: --to store the line_detail_index with which the relationships were inserted
6: G_PBH_LINE_DTL_INDEX QP_PREQ_GRP.NUMBER_TYPE;
7: G_PBH_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
8: G_PBH_PRICE_ADJ_ID QP_PREQ_GRP.NUMBER_TYPE;
9: G_PBH_PLSQL_IND QP_PREQ_GRP.NUMBER_TYPE;
10: G_MAX_DTL_INDEX NUMBER := 0;
11: G_ORD_LVL_LDET_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE; -- 3031108
12:
5: --to store the line_detail_index with which the relationships were inserted
6: G_PBH_LINE_DTL_INDEX QP_PREQ_GRP.NUMBER_TYPE;
7: G_PBH_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
8: G_PBH_PRICE_ADJ_ID QP_PREQ_GRP.NUMBER_TYPE;
9: G_PBH_PLSQL_IND QP_PREQ_GRP.NUMBER_TYPE;
10: G_MAX_DTL_INDEX NUMBER := 0;
11: G_ORD_LVL_LDET_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE; -- 3031108
12:
13: l_debug VARCHAR2(3);
7: G_PBH_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
8: G_PBH_PRICE_ADJ_ID QP_PREQ_GRP.NUMBER_TYPE;
9: G_PBH_PLSQL_IND QP_PREQ_GRP.NUMBER_TYPE;
10: G_MAX_DTL_INDEX NUMBER := 0;
11: G_ORD_LVL_LDET_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE; -- 3031108
12:
13: l_debug VARCHAR2(3);
14: --to populate the price_adjustment_id for modifiers applied by the
15: --pricing engine. The price_adjustment_id is queried from the
20: BEGIN
21: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
22: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
23: IF l_debug = FND_API.G_TRUE THEN
24: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine not Installed ----------');
25: END IF;
26: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
27: Update qp_npreq_ldets_tmp set price_adjustment_id =
28: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
34: (QP_PREQ_PUB.G_PRICE_LIST_HEADER, QP_PREQ_PUB.G_AGR_LIST_HEADER);
35: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
36: ELSE
37: IF l_debug = FND_API.G_TRUE THEN
38: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine is Installed ----------');
39: END IF;
40: IF (QP_UTIL_PUB.HVOP_Pricing_ON = 'Y') THEN
41: Update qp_int_ldets set price_adjustment_id =
42: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
75: FUNCTION get_sum_operand(p_header_id IN NUMBER) RETURN NUMBER IS
76: l_adj_sum_operand number;
77: BEGIN
78:
79: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
80: select sum(operand) into l_adj_sum_operand
81: from oe_price_adjustments adj
82: where adj.header_id = p_header_id
83: and adj.line_id is null
89: THEN
90: l_adj_sum_operand := 0;
91: END IF;
92: IF l_debug = FND_API.G_TRUE THEN
93: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
94: END IF;
95: RETURN l_adj_sum_operand;
96:
97: EXCEPTION
97: EXCEPTION
98: When NO_DATA_FOUND Then
99: l_adj_sum_operand := 0;
100: IF l_debug = FND_API.G_TRUE THEN
101: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
102: END IF;
103: RETURN l_adj_sum_operand;
104: When OTHERS Then
105: l_adj_sum_operand := FND_API.G_MISS_NUM;
103: RETURN l_adj_sum_operand;
104: When OTHERS Then
105: l_adj_sum_operand := FND_API.G_MISS_NUM;
106: IF l_debug = FND_API.G_TRUE THEN
107: QP_PREQ_GRP.engine_debug(' Exception adj operand '||SQLERRM);
108: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
109: END IF;
110: RETURN l_adj_sum_operand;
111: END get_sum_operand;
104: When OTHERS Then
105: l_adj_sum_operand := FND_API.G_MISS_NUM;
106: IF l_debug = FND_API.G_TRUE THEN
107: QP_PREQ_GRP.engine_debug(' Exception adj operand '||SQLERRM);
108: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
109: END IF;
110: RETURN l_adj_sum_operand;
111: END get_sum_operand;
112:
699: FROM qp_int_line_attrs
700: WHERE line_detail_index is not null;
701: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
702: */
703: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
704: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
700: WHERE line_detail_index is not null;
701: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
702: */
703: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
704: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
701: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
702: */
703: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
704: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
702: */
703: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
704: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
703: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
704: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
704: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
705: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
708: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
709: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
710: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
712: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
714: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
715: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
717: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
718: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
719: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
720: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
722: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
723: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
724: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
725: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
726: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
728: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
729: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
730: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
732: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
733: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
735: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
736: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
737: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
738: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
740: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
741: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
742: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
743: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
745: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
746: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
747: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
749: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
750: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
751: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
759: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
752: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
759: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
760: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
753: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
759: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
760: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
761: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
759: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
760: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
761: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
762:
755: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
759: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
760: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
761: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
762:
763:
756: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
759: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
760: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
761: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
762:
763:
764: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
757: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
758: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
759: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
760: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
761: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
762:
763:
764: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
765: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
760: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
761: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
762:
763:
764: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
765: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
766: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
767: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
768: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
761: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
762:
763:
764: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
765: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
766: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
767: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
768: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
769:
762:
763:
764: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
765: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
766: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
767: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
768: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
769:
770:
763:
764: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
765: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
766: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
767: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
768: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
769:
770:
771:
764: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
765: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
766: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
767: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
768: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
769:
770:
771:
772:
774: X PLS_INTEGER;
775: nrows NUMBER := 500;
776: BEGIN
777:
778: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
779: x:=0;
780: IF l_debug = FND_API.G_TRUE THEN
781: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
782: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
777:
778: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
779: x:=0;
780: IF l_debug = FND_API.G_TRUE THEN
781: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
782: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
783: qp_preq_grp.engine_debug('begin update check viewcode '||p_view_code);
784: END IF; --Bug No 4033618
785: --IF p_request_type_code in ('ONT','ASO')
778: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
779: x:=0;
780: IF l_debug = FND_API.G_TRUE THEN
781: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
782: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
783: qp_preq_grp.engine_debug('begin update check viewcode '||p_view_code);
784: END IF; --Bug No 4033618
785: --IF p_request_type_code in ('ONT','ASO')
786: IF p_cleanup_flag = 'Y'
779: x:=0;
780: IF l_debug = FND_API.G_TRUE THEN
781: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
782: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
783: qp_preq_grp.engine_debug('begin update check viewcode '||p_view_code);
784: END IF; --Bug No 4033618
785: --IF p_request_type_code in ('ONT','ASO')
786: IF p_cleanup_flag = 'Y'
787: --and p_request_type_code = 'ONT'
789: -- they pass reqtype ONT and insert adj into ldets
790: and QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
791: THEN
792: IF l_debug = FND_API.G_TRUE THEN
793: qp_preq_grp.engine_debug('in update cleanup '||p_cleanup_flag);
794: END IF; -- Bug No 4033618
795: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
796: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
797: IF l_debug = FND_API.G_TRUE THEN
794: END IF; -- Bug No 4033618
795: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
796: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
797: IF l_debug = FND_API.G_TRUE THEN
798: QP_PREQ_GRP.ENGINE_DEBUG('cleanup_adjustments Java Engine not Installed ----------');
799: END IF;
800: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
801:
802: OPEN l_update_cur;
930:
931: FOR i IN l_cur_dtl_index_tbl.FIRST..l_cur_dtl_index_tbl.LAST
932: LOOP
933:
934: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
935: THEN
936: qp_preq_grp.engine_debug('loop update cur line ind '
937: ||l_cur_line_index_tbl(i)||' line_dtl_index '
938: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
932: LOOP
933:
934: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
935: THEN
936: qp_preq_grp.engine_debug('loop update cur line ind '
937: ||l_cur_line_index_tbl(i)||' line_dtl_index '
938: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
939: ||l_cur_price_adj_id_tbl(i));
940: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
936: qp_preq_grp.engine_debug('loop update cur line ind '
937: ||l_cur_line_index_tbl(i)||' line_dtl_index '
938: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
939: ||l_cur_price_adj_id_tbl(i));
940: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
941: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
942: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
943: ||' adj '||l_adj_operand_pqty_tbl(i));
944: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
938: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
939: ||l_cur_price_adj_id_tbl(i));
940: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
941: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
942: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
943: ||' adj '||l_adj_operand_pqty_tbl(i));
944: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
945: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
946: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
940: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
941: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
942: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
943: ||' adj '||l_adj_operand_pqty_tbl(i));
944: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
945: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
946: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
947: ||' adj '||l_adj_charge_type_tbl(i));
948: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
942: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
943: ||' adj '||l_adj_operand_pqty_tbl(i));
944: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
945: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
946: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
947: ||' adj '||l_adj_charge_type_tbl(i));
948: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
949: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
950: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
944: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
945: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
946: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
947: ||' adj '||l_adj_charge_type_tbl(i));
948: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
949: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
950: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
951: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
952: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
946: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
947: ||' adj '||l_adj_charge_type_tbl(i));
948: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
949: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
950: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
951: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
952: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
953: ||' adj operator '||l_adj_operator_tbl(i));
954: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
948: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
949: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
950: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
951: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
952: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
953: ||' adj operator '||l_adj_operator_tbl(i));
954: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
955: ||' adj phase id '||l_adj_phase_id_tbl(i));
956: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
950: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
951: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
952: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
953: ||' adj operator '||l_adj_operator_tbl(i));
954: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
955: ||' adj phase id '||l_adj_phase_id_tbl(i));
956: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
957: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
958: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
952: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
953: ||' adj operator '||l_adj_operator_tbl(i));
954: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
955: ||' adj phase id '||l_adj_phase_id_tbl(i));
956: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
957: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
958: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
959: ||' adj override '||l_adj_update_allowed_tbl(i));
960: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
954: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
955: ||' adj phase id '||l_adj_phase_id_tbl(i));
956: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
957: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
958: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
959: ||' adj override '||l_adj_update_allowed_tbl(i));
960: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
961: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
962: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
956: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
957: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
958: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
959: ||' adj override '||l_adj_update_allowed_tbl(i));
960: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
961: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
962: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
963: ||' adj substn val '||l_adj_modified_to_tbl(i));
964: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
958: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
959: ||' adj override '||l_adj_update_allowed_tbl(i));
960: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
961: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
962: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
963: ||' adj substn val '||l_adj_modified_to_tbl(i));
964: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
965: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
966: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
960: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
961: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
962: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
963: ||' adj substn val '||l_adj_modified_to_tbl(i));
964: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
965: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
966: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
967: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
968: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
962: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
963: ||' adj substn val '||l_adj_modified_to_tbl(i));
964: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
965: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
966: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
967: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
968: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
969: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
970: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
964: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
965: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
966: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
967: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
968: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
969: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
970: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
971: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
972: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
966: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
967: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
968: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
969: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
970: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
971: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
972: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
973: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
974: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
968: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
969: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
970: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
971: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
972: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
973: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
974: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
975: ||' adj proration type '||l_adj_prorat_type_tbl(i));
976: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
970: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
971: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
972: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
973: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
974: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
975: ||' adj proration type '||l_adj_prorat_type_tbl(i));
976: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
977: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
978: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
972: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
973: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
974: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
975: ||' adj proration type '||l_adj_prorat_type_tbl(i));
976: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
977: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
978: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
979: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
980: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
974: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
975: ||' adj proration type '||l_adj_prorat_type_tbl(i));
976: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
977: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
978: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
979: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
980: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
981: ||' adj exp date '||l_adj_exp_date_tbl(i)
982: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
976: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
977: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
978: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
979: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
980: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
981: ||' adj exp date '||l_adj_exp_date_tbl(i)
982: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
983: qp_preq_grp.engine_debug('ord_qty_adjamt '
984: ||l_cur_ord_qty_adjamt(i)
979: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
980: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
981: ||' adj exp date '||l_adj_exp_date_tbl(i)
982: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
983: qp_preq_grp.engine_debug('ord_qty_adjamt '
984: ||l_cur_ord_qty_adjamt(i)
985: ||' adj ord_qty_adjamt '||l_adj_ord_qty_adjamt(i)
986: ||' ord_qty_operand '||l_cur_ord_qty_operand(i)
987: ||' adj ord_qty_operand '||l_adj_ord_qty_operand(i));
1036: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1037: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1038: THEN
1039: x:=x+1;
1040: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1041: qp_preq_grp.engine_debug('if update check '||x);
1042: qp_preq_grp.engine_debug('update check dtls '
1043: ||l_cur_dtl_index_tbl(i)||' adj_id '
1044: ||l_cur_price_adj_id_tbl(i)||' id '
1037: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1038: THEN
1039: x:=x+1;
1040: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1041: qp_preq_grp.engine_debug('if update check '||x);
1042: qp_preq_grp.engine_debug('update check dtls '
1043: ||l_cur_dtl_index_tbl(i)||' adj_id '
1044: ||l_cur_price_adj_id_tbl(i)||' id '
1045: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1038: THEN
1039: x:=x+1;
1040: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1041: qp_preq_grp.engine_debug('if update check '||x);
1042: qp_preq_grp.engine_debug('update check dtls '
1043: ||l_cur_dtl_index_tbl(i)||' adj_id '
1044: ||l_cur_price_adj_id_tbl(i)||' id '
1045: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1046: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1052: l_process_code_tbl(x) := QP_PREQ_PUB.G_STATUS_UNCHANGED;
1053: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1054: ELSE
1055: x:=x+1;
1056: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1057: qp_preq_grp.engine_debug('else update check '||x);
1058: qp_preq_grp.engine_debug('update check dtls '
1059: ||l_cur_dtl_index_tbl(i)||' adj_id '
1060: ||l_cur_price_adj_id_tbl(i)||' id '
1053: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1054: ELSE
1055: x:=x+1;
1056: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1057: qp_preq_grp.engine_debug('else update check '||x);
1058: qp_preq_grp.engine_debug('update check dtls '
1059: ||l_cur_dtl_index_tbl(i)||' adj_id '
1060: ||l_cur_price_adj_id_tbl(i)||' id '
1061: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1054: ELSE
1055: x:=x+1;
1056: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1057: qp_preq_grp.engine_debug('else update check '||x);
1058: qp_preq_grp.engine_debug('update check dtls '
1059: ||l_cur_dtl_index_tbl(i)||' adj_id '
1060: ||l_cur_price_adj_id_tbl(i)||' id '
1061: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1062: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1075: CLOSE l_update_cur;
1076: ELSE
1077: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1078: IF l_debug = FND_API.G_TRUE THEN
1079: QP_PREQ_GRP.ENGINE_DEBUG('cleanup_adjustments() Java Engine is Installed ----------');
1080: END IF;
1081: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1082:
1083: OPEN l_update_int_cur;
1211:
1212: FOR i IN l_cur_dtl_index_tbl.FIRST..l_cur_dtl_index_tbl.LAST
1213: LOOP
1214:
1215: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1216: THEN
1217: qp_preq_grp.engine_debug('loop update cur line ind '
1218: ||l_cur_line_index_tbl(i)||' line_dtl_index '
1219: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1213: LOOP
1214:
1215: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1216: THEN
1217: qp_preq_grp.engine_debug('loop update cur line ind '
1218: ||l_cur_line_index_tbl(i)||' line_dtl_index '
1219: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1220: ||l_cur_price_adj_id_tbl(i));
1221: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1217: qp_preq_grp.engine_debug('loop update cur line ind '
1218: ||l_cur_line_index_tbl(i)||' line_dtl_index '
1219: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1220: ||l_cur_price_adj_id_tbl(i));
1221: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1222: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
1223: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1224: ||' adj '||l_adj_operand_pqty_tbl(i));
1225: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1219: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1220: ||l_cur_price_adj_id_tbl(i));
1221: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1222: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
1223: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1224: ||' adj '||l_adj_operand_pqty_tbl(i));
1225: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1226: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1227: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1221: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1222: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
1223: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1224: ||' adj '||l_adj_operand_pqty_tbl(i));
1225: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1226: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1227: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1228: ||' adj '||l_adj_charge_type_tbl(i));
1229: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1223: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1224: ||' adj '||l_adj_operand_pqty_tbl(i));
1225: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1226: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1227: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1228: ||' adj '||l_adj_charge_type_tbl(i));
1229: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1230: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1231: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1225: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1226: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1227: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1228: ||' adj '||l_adj_charge_type_tbl(i));
1229: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1230: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1231: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1232: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1233: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1227: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1228: ||' adj '||l_adj_charge_type_tbl(i));
1229: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1230: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1231: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1232: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1233: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1234: ||' adj operator '||l_adj_operator_tbl(i));
1235: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1229: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1230: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1231: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1232: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1233: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1234: ||' adj operator '||l_adj_operator_tbl(i));
1235: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1236: ||' adj phase id '||l_adj_phase_id_tbl(i));
1237: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1231: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1232: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1233: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1234: ||' adj operator '||l_adj_operator_tbl(i));
1235: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1236: ||' adj phase id '||l_adj_phase_id_tbl(i));
1237: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1238: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1239: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1233: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1234: ||' adj operator '||l_adj_operator_tbl(i));
1235: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1236: ||' adj phase id '||l_adj_phase_id_tbl(i));
1237: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1238: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1239: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1240: ||' adj override '||l_adj_update_allowed_tbl(i));
1241: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1235: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1236: ||' adj phase id '||l_adj_phase_id_tbl(i));
1237: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1238: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1239: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1240: ||' adj override '||l_adj_update_allowed_tbl(i));
1241: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1242: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1243: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1237: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1238: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1239: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1240: ||' adj override '||l_adj_update_allowed_tbl(i));
1241: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1242: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1243: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1244: ||' adj substn val '||l_adj_modified_to_tbl(i));
1245: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1239: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1240: ||' adj override '||l_adj_update_allowed_tbl(i));
1241: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1242: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1243: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1244: ||' adj substn val '||l_adj_modified_to_tbl(i));
1245: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1246: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1247: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1241: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1242: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1243: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1244: ||' adj substn val '||l_adj_modified_to_tbl(i));
1245: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1246: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1247: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1248: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1249: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1243: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1244: ||' adj substn val '||l_adj_modified_to_tbl(i));
1245: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1246: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1247: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1248: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1249: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1250: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1251: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1245: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1246: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1247: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1248: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1249: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1250: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1251: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1252: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1253: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1247: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1248: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1249: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1250: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1251: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1252: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1253: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1254: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1255: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1249: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1250: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1251: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1252: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1253: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1254: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1255: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1256: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1257: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1251: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1252: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1253: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1254: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1255: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1256: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1257: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1258: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1259: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1253: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1254: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1255: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1256: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1257: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1258: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1259: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1260: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1261: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1255: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1256: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1257: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1258: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1259: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1260: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1261: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1262: ||' adj exp date '||l_adj_exp_date_tbl(i)
1263: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
1257: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1258: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1259: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1260: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1261: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1262: ||' adj exp date '||l_adj_exp_date_tbl(i)
1263: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
1264: qp_preq_grp.engine_debug('ord_qty_adjamt '
1265: ||l_cur_ord_qty_adjamt(i)
1260: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1261: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1262: ||' adj exp date '||l_adj_exp_date_tbl(i)
1263: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
1264: qp_preq_grp.engine_debug('ord_qty_adjamt '
1265: ||l_cur_ord_qty_adjamt(i)
1266: ||' adj ord_qty_adjamt '||l_adj_ord_qty_adjamt(i)
1267: ||' ord_qty_operand '||l_cur_ord_qty_operand(i)
1268: ||' adj ord_qty_operand '||l_adj_ord_qty_operand(i));
1317: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1318: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1319: THEN
1320: x:=x+1;
1321: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1322: qp_preq_grp.engine_debug('if update check '||x);
1323: qp_preq_grp.engine_debug('update check dtls '
1324: ||l_cur_dtl_index_tbl(i)||' adj_id '
1325: ||l_cur_price_adj_id_tbl(i)||' id '
1318: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1319: THEN
1320: x:=x+1;
1321: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1322: qp_preq_grp.engine_debug('if update check '||x);
1323: qp_preq_grp.engine_debug('update check dtls '
1324: ||l_cur_dtl_index_tbl(i)||' adj_id '
1325: ||l_cur_price_adj_id_tbl(i)||' id '
1326: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1319: THEN
1320: x:=x+1;
1321: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1322: qp_preq_grp.engine_debug('if update check '||x);
1323: qp_preq_grp.engine_debug('update check dtls '
1324: ||l_cur_dtl_index_tbl(i)||' adj_id '
1325: ||l_cur_price_adj_id_tbl(i)||' id '
1326: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1327: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1333: l_process_code_tbl(x) := QP_PREQ_PUB.G_STATUS_UNCHANGED;
1334: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1335: ELSE
1336: x:=x+1;
1337: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1338: qp_preq_grp.engine_debug('else update check '||x);
1339: qp_preq_grp.engine_debug('update check dtls '
1340: ||l_cur_dtl_index_tbl(i)||' adj_id '
1341: ||l_cur_price_adj_id_tbl(i)||' id '
1334: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1335: ELSE
1336: x:=x+1;
1337: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1338: qp_preq_grp.engine_debug('else update check '||x);
1339: qp_preq_grp.engine_debug('update check dtls '
1340: ||l_cur_dtl_index_tbl(i)||' adj_id '
1341: ||l_cur_price_adj_id_tbl(i)||' id '
1342: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1335: ELSE
1336: x:=x+1;
1337: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1338: qp_preq_grp.engine_debug('else update check '||x);
1339: qp_preq_grp.engine_debug('update check dtls '
1340: ||l_cur_dtl_index_tbl(i)||' adj_id '
1341: ||l_cur_price_adj_id_tbl(i)||' id '
1342: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1343: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1359:
1360: IF l_line_dtl_index_tbl.COUNT > 0
1361: THEN
1362:
1363: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1364: THEN
1365: FOR x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1366: LOOP
1367: IF l_debug = FND_API.G_TRUE THEN
1364: THEN
1365: FOR x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1366: LOOP
1367: IF l_debug = FND_API.G_TRUE THEN
1368: QP_PREQ_GRP.engine_debug('Cleanup debug '
1369: ||' line index '||l_line_index_tbl(x)
1370: ||' line dtl index '||l_line_dtl_index_tbl(x)
1371: ||' price_adj_id '||l_price_adj_id_tbl(x)
1372: ||' process code '||l_process_code_tbl(x)
1376: END IF;
1377: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1378: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
1379: IF l_debug = FND_API.G_TRUE THEN
1380: QP_PREQ_GRP.ENGINE_DEBUG('Java Engine not Installed ----------');
1381: END IF;
1382: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1383:
1384: FORALL x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1390: and line_detail_index = l_line_dtl_index_tbl(x);
1391: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1392: ELSE
1393: IF l_debug = FND_API.G_TRUE THEN
1394: QP_PREQ_GRP.ENGINE_DEBUG('Java Engine is Installed ----------');
1395: END IF;
1396: FORALL x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1397: UPDATE qp_int_ldets
1398: SET process_code = l_process_code_tbl(x)
1448: and attr.pricing_attribute = lattr.attribute
1449: and attr.pricing_attr_value_from = lattr.value_from);
1450:
1451:
1452: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1453: THEN
1454: for cl in l_attr_cur
1455: loop
1456: qp_preq_grp.engine_debug('attr details '
1452: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1453: THEN
1454: for cl in l_attr_cur
1455: loop
1456: qp_preq_grp.engine_debug('attr details '
1457: ||cl.line_index||' dtl index '||cl.line_detail_index
1458: ||' sts code '||cl.pricing_status_code||' context '
1459: ||cl.context||' attr '||cl.attribute
1460: ||' val from '||cl.value_from);
1465:
1466:
1467: END IF;
1468: IF l_debug = FND_API.G_TRUE THEN
1469: QP_PREQ_GRP.engine_debug('Completed QP_CLEANUP.cleanup_adjustments');
1470: END IF;
1471: x_return_status := FND_API.G_RET_STS_SUCCESS;
1472:
1473: EXCEPTION
1472:
1473: EXCEPTION
1474: When OTHERS Then
1475: IF l_debug = FND_API.G_TRUE THEN
1476: QP_PREQ_GRP.engine_debug('error in QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM);
1477: END IF;
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: --x_return_status_text := 'error QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM';
1480:
1483: FUNCTION Get_line_detail_index(p_line_index IN NUMBER,
1484: p_price_adj_id IN NUMBER)
1485: RETURN NUMBER IS
1486: BEGIN
1487: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1488: IF G_PBH_PLSQL_IND.EXISTS(mod(p_price_adj_id,G_BINARY_LIMIT)) THEN --8744755
1489: IF l_debug = FND_API.G_TRUE THEN
1490: QP_PREQ_GRP.engine_debug('begin get loop ');
1491: END IF;--l_debug
1486: BEGIN
1487: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1488: IF G_PBH_PLSQL_IND.EXISTS(mod(p_price_adj_id,G_BINARY_LIMIT)) THEN --8744755
1489: IF l_debug = FND_API.G_TRUE THEN
1490: QP_PREQ_GRP.engine_debug('begin get loop ');
1491: END IF;--l_debug
1492: FOR i IN G_PBH_LINE_DTL_INDEX.FIRST..G_PBH_LINE_DTL_INDEX.LAST
1493: LOOP
1494: IF l_debug = FND_API.G_TRUE THEN
1491: END IF;--l_debug
1492: FOR i IN G_PBH_LINE_DTL_INDEX.FIRST..G_PBH_LINE_DTL_INDEX.LAST
1493: LOOP
1494: IF l_debug = FND_API.G_TRUE THEN
1495: QP_PREQ_GRP.engine_debug('in get loop '||G_PBH_LINE_INDEX(i)||' '
1496: ||G_PBH_PRICE_ADJ_ID(i));
1497: END IF;--l_debug
1498: IF G_PBH_LINE_INDEX(i) = p_line_index
1499: and G_PBH_PRICE_ADJ_ID(i) = p_price_adj_id THEN
1731: and (nvl(QP_PREQ_PUB.Get_buy_line_price_flag(adj.created_from_list_line_id, line.line_index),line.price_flag) = QP_PREQ_PUB.G_YES
1732: or (nvl(QP_PREQ_PUB.Get_buy_line_price_flag(adj.created_from_list_line_id, line.line_index),line.price_flag) = QP_PREQ_PUB.G_PHASE
1733: and nvl(ph.user_freeze_override_flag,ph.freeze_override_flag) = QP_PREQ_PUB.G_YES))));
1734:
1735: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1736: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1737: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: or (nvl(QP_PREQ_PUB.Get_buy_line_price_flag(adj.created_from_list_line_id, line.line_index),line.price_flag) = QP_PREQ_PUB.G_PHASE
1733: and nvl(ph.user_freeze_override_flag,ph.freeze_override_flag) = QP_PREQ_PUB.G_YES))));
1734:
1735: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1736: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1737: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: and nvl(ph.user_freeze_override_flag,ph.freeze_override_flag) = QP_PREQ_PUB.G_YES))));
1734:
1735: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1736: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1737: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1734:
1735: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1736: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1737: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1735: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1736: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1737: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1736: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1737: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1737: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1738: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1740: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1742: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1744: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1745: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1746: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1753: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1754: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1753: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1754: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1755: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1748: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1753: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1754: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1755: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1756: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1749: --added these columns to insert child break lines for bug 3314259
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1753: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1754: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1755: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1756: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1757:
1750: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1753: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1754: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1755: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1756: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1757:
1758: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1751: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1753: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1754: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1755: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1756: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1757:
1758: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1759: N pls_integer;
1752: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1753: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1754: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1755: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1756: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1757:
1758: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1759: N pls_integer;
1760: BEGIN
1757:
1758: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1759: N pls_integer;
1760: BEGIN
1761: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1762: IF l_debug = FND_API.G_TRUE THEN
1763: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1764: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1765: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1759: N pls_integer;
1760: BEGIN
1761: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1762: IF l_debug = FND_API.G_TRUE THEN
1763: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1764: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1765: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1766:
1767: END IF;
1760: BEGIN
1761: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1762: IF l_debug = FND_API.G_TRUE THEN
1763: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1764: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1765: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1766:
1767: END IF;
1768: OPEN l_pbh_adj_exists_cur;
1761: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1762: IF l_debug = FND_API.G_TRUE THEN
1763: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1764: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1765: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1766:
1767: END IF;
1768: OPEN l_pbh_adj_exists_cur;
1769: FETCH l_pbh_adj_exists_cur INTO l_pbh_adj_exists;
1769: FETCH l_pbh_adj_exists_cur INTO l_pbh_adj_exists;
1770: CLOSE l_pbh_adj_exists_cur;
1771:
1772: IF l_debug = FND_API.G_TRUE THEN
1773: QP_PREQ_GRP.engine_debug('Check l_pbh_adj_exists '||l_pbh_adj_exists);
1774:
1775: END IF;
1776: N := 0;
1777:
1802:
1803: FOR I IN l_rltd_line_info_cur
1804: LOOP
1805: IF l_debug = FND_API.G_TRUE THEN
1806: QP_PREQ_GRP.engine_debug('In l_rltd_line_info_cur');
1807: END IF;
1808: N := N+1;
1809: l_line_index_tbl(N):=I.line_index;
1810: l_line_dtl_index_tbl(N) :=
1813:
1814: l_rltd_line_dtl_index_tbl(N):=
1815: Get_line_detail_index(I.related_line_index, I.related_line_detail_index);
1816: IF l_debug = FND_API.G_TRUE THEN
1817: QP_PREQ_GRP.engine_debug('Pbh dtl_index '
1818: ||l_line_dtl_index_tbl(N)
1819: ||' rltd_dtl_index '
1820: ||l_rltd_line_dtl_index_tbl(N));
1821: END IF;--l_debug
1840: l_list_hdr_id_tbl(N) := I.list_header_id;
1841: l_list_line_no_tbl(N) := I.list_line_no;
1842:
1843: IF l_debug = FND_API.G_TRUE THEN
1844: QP_PREQ_GRP.engine_debug('price brk child details '
1845: ||l_line_dtl_index_tbl(N)||' rltd_dtl '
1846: ||l_rltd_line_dtl_index_tbl(N)||' bucket '
1847: ||l_pricing_group_seq_tbl(N)||' '
1848: ||' parent id '||l_list_line_id_tbl(N)
1856: END IF;
1857: END LOOP;
1858:
1859: IF l_debug = FND_API.G_TRUE THEN
1860: QP_PREQ_GRP.engine_debug('price brk after loop ');
1861: END IF;
1862: IF l_line_dtl_index_tbl.COUNT > 0
1863: THEN
1864: IF l_debug = FND_API.G_TRUE THEN
1861: END IF;
1862: IF l_line_dtl_index_tbl.COUNT > 0
1863: THEN
1864: IF l_debug = FND_API.G_TRUE THEN
1865: QP_PREQ_GRP.engine_debug('price brk before insert ');
1866: END IF;
1867: FORALL I IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1868: INSERT INTO qp_npreq_rltd_lines_tmp
1869: (
1938: ,pricing_phase_id)
1939: values
1940: (l_rltd_line_dtl_index_tbl(I)
1941: ,l_rltd_line_index_tbl(I)
1942: ,QP_PREQ_GRP.G_CHILD_DETAIL_TYPE -- bug 3487840, pass QP_PREQ_GRP.G_CHILD_DETAIL_TYPE instead of null
1943: ,QP_PREQ_PUB.G_STATUS_NEW
1944: ,''
1945: ,QP_PREQ_PUB.G_STATUS_NEW
1946: ,l_list_hdr_id_tbl(I) --put list_header_id
1958: ,l_auto_flag_tbl(I) --QP_PREQ_PUB.G_NO
1959: ,l_pricing_phase_id_tbl(I));
1960:
1961: IF l_debug = FND_API.G_TRUE THEN
1962: QP_PREQ_GRP.engine_debug('price brk after insert ');
1963:
1964: END IF;
1965: END IF;
1966: END IF;
1964: END IF;
1965: END IF;
1966: END IF;
1967: IF l_debug = FND_API.G_TRUE THEN
1968: QP_PREQ_GRP.engine_debug('End Insert_rltd_lines');
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_SUCCESS;
1971: EXCEPTION
1972: When OTHERS Then
1970: x_return_status := FND_API.G_RET_STS_SUCCESS;
1971: EXCEPTION
1972: When OTHERS Then
1973: IF l_debug = FND_API.G_TRUE THEN
1974: QP_PREQ_GRP.engine_debug('Error Insert_rltd_lines'||SQLERRM);
1975: END IF;
1976: x_return_status := FND_API.G_RET_STS_ERROR;
1977: x_return_status_text := 'Error in QP_CLEANUP_ADJUSTMENTS.Insert_Rltd_Lines '||SQLERRM;
1978: END Insert_Rltd_Lines;
2098: and not exists (select 'x'
2099: from oe_price_adj_assocs a, oe_price_adjustments b
2100: where a.RLTD_PRICE_ADJ_ID = adj.price_adjustment_id
2101: and b.price_adjustment_id = a.price_adjustment_id
2102: and b.list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE)
2103: UNION
2104: select /*+ ORDERED USE_NL(adj line qplh) index(adj OE_PRICE_ADJUSTMENTS_N1) dynamic_sampling(1) */ -- Bug No: 6753550
2105: adj.list_line_id created_from_list_line_id
2106: , line.line_index line_ind
2631: AND ldets1.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2632: AND NVL(ldets1.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO
2633: AND nvl(ldets2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_YES;
2634:
2635: l_manual_line_details_tbl qp_preq_grp.number_type;
2636: y Pls_Integer;
2637:
2638: Pricing_Exception Exception;
2639:
2644: g Pls_Integer;
2645: n Pls_Integer;
2646:
2647: l_curr_line_index number := -1;--fnd_api.g_miss_num;
2648: l_auto_line_dtl_index_tbl qp_preq_grp.number_type;
2649: l_auto_override_dtl_id_tbl qp_preq_grp.number_type;
2650:
2651: l_adj_tbl QP_PREQ_PUB.adj_tbl_type;
2652: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2645: n Pls_Integer;
2646:
2647: l_curr_line_index number := -1;--fnd_api.g_miss_num;
2648: l_auto_line_dtl_index_tbl qp_preq_grp.number_type;
2649: l_auto_override_dtl_id_tbl qp_preq_grp.number_type;
2650:
2651: l_adj_tbl QP_PREQ_PUB.adj_tbl_type;
2652: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2653: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2651: l_adj_tbl QP_PREQ_PUB.adj_tbl_type;
2652: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2653: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2654:
2655: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2656: l_line_index_tbl QP_PREQ_GRP.number_type;
2657: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2652: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2653: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2654:
2655: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2656: l_line_index_tbl QP_PREQ_GRP.number_type;
2657: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2654:
2655: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2656: l_line_index_tbl QP_PREQ_GRP.number_type;
2657: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2654:
2655: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2656: l_line_index_tbl QP_PREQ_GRP.number_type;
2657: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2655: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2656: l_line_index_tbl QP_PREQ_GRP.number_type;
2657: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2656: l_line_index_tbl QP_PREQ_GRP.number_type;
2657: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2657: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2658: l_line_id_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2659: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2660: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2661: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2662: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2663: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2664: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2665: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2666: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2667: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2668: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2669: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2670: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2671: l_operand_value_tbl QP_PREQ_GRP.number_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2672: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2673: l_unit_price_tbl QP_PREQ_GRP.number_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2674: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2675: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2676: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2677: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2678: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2679: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2680: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2681: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2682: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2683: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2684: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2685: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2693: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2686: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2693: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2694: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2687: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2693: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2694: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2695: --2388011
2688: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2693: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2694: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2695: --2388011
2696: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2689: l_group_qty_tbl QP_PREQ_GRP.number_type;
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2693: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2694: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2695: --2388011
2696: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2697: --2388011
2690: l_group_amt_tbl QP_PREQ_GRP.number_type;
2691: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2693: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2694: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2695: --2388011
2696: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2697: --2388011
2698: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2692: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2693: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2694: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2695: --2388011
2696: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2697: --2388011
2698: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2699: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2694: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2695: --2388011
2696: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2697: --2388011
2698: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2699: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2695: --2388011
2696: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2697: --2388011
2698: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2699: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2703: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2696: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2697: --2388011
2698: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2699: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2703: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2704: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2697: --2388011
2698: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2699: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2703: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2704: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2705: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2698: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2699: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2703: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2704: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2705: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2706:
2699: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2703: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2704: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2705: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2706:
2707: l_prev_line_start_index number :=0;
2700: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2703: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2704: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2705: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2706:
2707: l_prev_line_start_index number :=0;
2708: l_cleanup_flag VARCHAR2(1) := QP_PREQ_PUB.G_YES;
2701: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2702: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2703: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2704: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2705: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2706:
2707: l_prev_line_start_index number :=0;
2708: l_cleanup_flag VARCHAR2(1) := QP_PREQ_PUB.G_YES;
2709: nrows CONSTANT number := 2;
2709: nrows CONSTANT number := 2;
2710:
2711: --added to check for duplicate list_line_ids
2712: l_dup_ind NUMBER;
2713: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2714: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2715: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2716: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2717: --added to check for duplicate list_line_ids
2710:
2711: --added to check for duplicate list_line_ids
2712: l_dup_ind NUMBER;
2713: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2714: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2715: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2716: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2717: --added to check for duplicate list_line_ids
2718:
2711: --added to check for duplicate list_line_ids
2712: l_dup_ind NUMBER;
2713: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2714: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2715: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2716: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2717: --added to check for duplicate list_line_ids
2718:
2719: BEGIN
2712: l_dup_ind NUMBER;
2713: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2714: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2715: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2716: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2717: --added to check for duplicate list_line_ids
2718:
2719: BEGIN
2720:
2717: --added to check for duplicate list_line_ids
2718:
2719: BEGIN
2720:
2721: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2722:
2723: IF l_debug = FND_API.G_TRUE THEN
2724: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2725: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2720:
2721: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2722:
2723: IF l_debug = FND_API.G_TRUE THEN
2724: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2725: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2726: --bug 3085453 handle pricing availability UI
2727: -- they pass reqtype ONT and insert adj into ldets
2728: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2721: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2722:
2723: IF l_debug = FND_API.G_TRUE THEN
2724: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2725: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2726: --bug 3085453 handle pricing availability UI
2727: -- they pass reqtype ONT and insert adj into ldets
2728: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2729: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2724: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2725: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2726: --bug 3085453 handle pricing availability UI
2727: -- they pass reqtype ONT and insert adj into ldets
2728: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2729: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2730: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2731: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2732: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2725: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2726: --bug 3085453 handle pricing availability UI
2727: -- they pass reqtype ONT and insert adj into ldets
2728: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2729: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2730: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2731: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2732: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2733: END IF;
2726: --bug 3085453 handle pricing availability UI
2727: -- they pass reqtype ONT and insert adj into ldets
2728: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2729: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2730: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2731: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2732: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2733: END IF;
2734:
2727: -- they pass reqtype ONT and insert adj into ldets
2728: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2729: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2730: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2731: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2732: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2733: END IF;
2734:
2735: --cleanup needs to be done only for OM as OC/OKC delete and insert adjustments
2728: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2729: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2730: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2731: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2732: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2733: END IF;
2734:
2735: --cleanup needs to be done only for OM as OC/OKC delete and insert adjustments
2736: --setting up cleanup_flag accordingly to not peform cleanup for adj if
2767: G_PBH_PLSQL_IND.delete;
2768: G_ORD_LVL_LDET_INDEX.delete; -- 3031108
2769:
2770: IF l_debug = FND_API.G_TRUE THEN
2771: QP_PREQ_GRP.engine_debug('G_MAX_DTL_INDEX '||G_MAX_DTL_INDEX);
2772:
2773: END IF;
2774:
2775: --to eliminate the duplicate manual adjustments in the temp table to prevent cleanup for them bug 2191169
2794: FETCH check_manual_modifiers BULK COLLECT INTO l_manual_line_details_tbl LIMIT 5000;
2795: EXIT WHEN l_manual_line_details_tbl.COUNT = 0;
2796:
2797: IF (l_debug = FND_API.G_TRUE) THEN
2798: QP_PREQ_GRP.engine_debug('Duplicate manual override modifier count: '|| l_manual_line_details_tbl.COUNT);
2799: END IF;
2800:
2801: FORALL y IN l_manual_line_details_tbl.FIRST..l_manual_line_details_tbl.LAST
2802: UPDATE qp_npreq_ldets_tmp
2807:
2808: CLOSE check_manual_modifiers;
2809:
2810: IF (l_debug = FND_API.G_TRUE) THEN
2811: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2812: END IF;
2813:
2814: -- bug 3359924 - AFTER APPLYING MANUAL PBH ENGINE RETURNS DUPLICATE RELATIONSHIP RECORDS
2815: UPDATE qp_npreq_rltd_lines_tmp rltd
2821: where ldet.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
2822: and ldet.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_PUB.G_BY_PBH);
2823:
2824: IF (l_debug = FND_API.G_TRUE) THEN
2825: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2826: END IF;
2827:
2828: -- IF p_event_code IS NULL
2829: -- and p_calculate_flag = QP_PREQ_GRP.G_CALCULATE_ONLY
2825: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2826: END IF;
2827:
2828: -- IF p_event_code IS NULL
2829: -- and p_calculate_flag = QP_PREQ_GRP.G_CALCULATE_ONLY
2830: -- THEN
2831:
2832: -- IF p_request_type_code = 'ONT'
2833: -- and p_view_code = 'ONTVIEW'
2832: -- IF p_request_type_code = 'ONT'
2833: -- and p_view_code = 'ONTVIEW'
2834: -- THEN
2835: IF l_debug = FND_API.G_TRUE THEN
2836: -- QP_PREQ_GRP.engine_debug('open ONT cur'||p_request_type_code);
2837: QP_PREQ_GRP.engine_debug('open ONT cur'||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2838: END IF;
2839:
2840: --bug 4900095 get service qty for lumpsum
2833: -- and p_view_code = 'ONTVIEW'
2834: -- THEN
2835: IF l_debug = FND_API.G_TRUE THEN
2836: -- QP_PREQ_GRP.engine_debug('open ONT cur'||p_request_type_code);
2837: QP_PREQ_GRP.engine_debug('open ONT cur'||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2838: END IF;
2839:
2840: --bug 4900095 get service qty for lumpsum
2841: IF QP_PREQ_GRP.G_Service_line_qty_tbl.COUNT = 0 THEN
2837: QP_PREQ_GRP.engine_debug('open ONT cur'||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2838: END IF;
2839:
2840: --bug 4900095 get service qty for lumpsum
2841: IF QP_PREQ_GRP.G_Service_line_qty_tbl.COUNT = 0 THEN
2842: QP_PREQ_PUB.Determine_svc_item_quantity;
2843: END IF;
2844:
2845: OPEN l_calculate_cur;
2912: l_prev_line_start_index := 0;
2913:
2914:
2915: IF l_debug = FND_API.G_TRUE THEN
2916: QP_PREQ_GRP.engine_debug('fetch cur');
2917: END IF;
2918:
2919:
2920: FETCH l_calculate_cur
2973: -- LIMIT nrows;
2974: EXIT WHEN l_list_line_id_tbl.COUNT = 0;
2975:
2976: IF l_list_line_id_tbl.COUNT > 0
2977: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
2978: and l_debug = FND_API.G_TRUE
2979: THEN
2980: for i in l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2981: LOOP
2979: THEN
2980: for i in l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2981: LOOP
2982: IF l_debug = FND_API.G_TRUE THEN
2983: QP_PREQ_GRP.engine_debug('list_line_id '||l_list_line_id_tbl(i)||
2984: 'line index '||l_line_index_tbl(i)||' is ldet '||
2985: l_is_ldet_rec_tbl(i)||' linetype '||l_line_type_code_tbl(i) ||
2986: 'line detail type code ' || l_line_detail_type_code_tbl(i)||
2987: ' line_category '||l_line_category_tbl(i)||' priceflag '||
2996: FOR i IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2997: LOOP
2998: d := d + 1;
2999: IF l_debug = FND_API.G_TRUE THEN
3000: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
3001: QP_PREQ_GRP.engine_debug('loop cur '||i);
3002:
3003: END IF;
3004: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
2997: LOOP
2998: d := d + 1;
2999: IF l_debug = FND_API.G_TRUE THEN
3000: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
3001: QP_PREQ_GRP.engine_debug('loop cur '||i);
3002:
3003: END IF;
3004: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3005: qp_preq_grp.engine_debug('display details '
3000: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
3001: QP_PREQ_GRP.engine_debug('loop cur '||i);
3002:
3003: END IF;
3004: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3005: qp_preq_grp.engine_debug('display details '
3006: ||l_list_line_id_tbl(i)||' line index '||l_line_index_tbl(i)
3007: ||' line detail index '||l_line_dtl_index_tbl(i)
3008: ||' auto '||l_automatic_flag_tbl(i)
3001: QP_PREQ_GRP.engine_debug('loop cur '||i);
3002:
3003: END IF;
3004: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3005: qp_preq_grp.engine_debug('display details '
3006: ||l_list_line_id_tbl(i)||' line index '||l_line_index_tbl(i)
3007: ||' line detail index '||l_line_dtl_index_tbl(i)
3008: ||' auto '||l_automatic_flag_tbl(i)
3009: ||' overr '||l_override_flag_tbl(i)
3011: ||' applied '||l_applied_flag_tbl(i)
3012: ||' hdr id '||l_list_header_id_tbl(i)||' is ldet '
3013: ||l_is_ldet_rec_tbl(i)||' linetype '||l_line_type_code_tbl(i));
3014:
3015: qp_preq_grp.engine_debug('list_line_type ' || l_list_line_type_code_tbl(i)
3016: || 'modifier_level ' || l_modifier_level_tbl(i)
3017: || 'net_amount_flag ' || l_net_amount_flag_tbl(i)
3018: || 'is_ldet_rec ' || l_is_ldet_rec_tbl(i));
3019: END IF;
3044: /*
3045: l_dup_ind := l_line_index_tbl(i) + l_list_line_id_tbl(i);
3046:
3047: IF l_debug = FND_API.G_TRUE THEN
3048: QP_PREQ_GRP.engine_debug('Duplicate list line check '
3049: ||' line_index+list_line_id val: '||l_dup_ind);
3050: END IF;--l_debug
3051:
3052: IF l_dup_updated_flag.exists(l_dup_ind) THEN
3050: END IF;--l_debug
3051:
3052: IF l_dup_updated_flag.exists(l_dup_ind) THEN
3053: IF l_debug = FND_API.G_TRUE THEN
3054: QP_PREQ_GRP.engine_debug('Duplicate list line exists ');
3055: END IF;--l_debug
3056:
3057: IF l_dup_updated_flag(l_dup_ind) = QP_PREQ_PUB.G_YES
3058: and l_updated_flag_tbl(i) = QP_PREQ_PUB.G_NO THEN
3058: and l_updated_flag_tbl(i) = QP_PREQ_PUB.G_NO THEN
3059: --in this case the oe_price_adj record must be applied
3060: --so engine selected needs to be marked as deleted
3061: IF l_debug = FND_API.G_TRUE THEN
3062: QP_PREQ_GRP.engine_debug('Duplicate adj overridden ');
3063: END IF;--l_debug
3064: IF l_is_ldet_rec_tbl(i) in (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3065: QP_PREQ_PUB.G_LDET_LINE_TYPE) THEN
3066: IF l_debug = FND_API.G_TRUE THEN
3063: END IF;--l_debug
3064: IF l_is_ldet_rec_tbl(i) in (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3065: QP_PREQ_PUB.G_LDET_LINE_TYPE) THEN
3066: IF l_debug = FND_API.G_TRUE THEN
3067: QP_PREQ_GRP.engine_debug('Marking non-overrdn adj '
3068: ||'as deleted ');
3069: END IF;--l_debug
3070: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3071: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3077: := QP_PREQ_PUB.G_STATUS_DELETED;
3078: l_adj_tbl(l_dup_plsql_ind(l_dup_ind)).pricing_status_text
3079: := 'DUPLICATE MODIFIER PICKED UP';
3080: IF l_debug = FND_API.G_TRUE THEN
3081: QP_PREQ_GRP.engine_debug('Marking prev overdn deltd ');
3082: END IF;--l_debug
3083: --replace l_dup values w/current values
3084: l_dup_updated_flag(l_dup_ind) := l_updated_flag_tbl(i);
3085: l_dup_is_ldet_rec(l_dup_ind) := l_is_ldet_rec_tbl(i);
3087: ELSE --updated_flag is 'N'
3088: --in this case the engine selected record must be applied
3089: --so adj from oe_price_adj needs to be marked as deleted
3090: IF l_debug = FND_API.G_TRUE THEN
3091: QP_PREQ_GRP.engine_debug('Duplicate adj not overridden ');
3092: QP_PREQ_GRP.engine_debug('Prev adj is_ldet: '
3093: ||l_dup_is_ldet_rec(l_dup_ind));
3094: QP_PREQ_GRP.engine_debug('Current adj is_ldet: '
3095: ||l_is_ldet_rec_tbl(i));
3088: --in this case the engine selected record must be applied
3089: --so adj from oe_price_adj needs to be marked as deleted
3090: IF l_debug = FND_API.G_TRUE THEN
3091: QP_PREQ_GRP.engine_debug('Duplicate adj not overridden ');
3092: QP_PREQ_GRP.engine_debug('Prev adj is_ldet: '
3093: ||l_dup_is_ldet_rec(l_dup_ind));
3094: QP_PREQ_GRP.engine_debug('Current adj is_ldet: '
3095: ||l_is_ldet_rec_tbl(i));
3096: END IF;--l_debug
3090: IF l_debug = FND_API.G_TRUE THEN
3091: QP_PREQ_GRP.engine_debug('Duplicate adj not overridden ');
3092: QP_PREQ_GRP.engine_debug('Prev adj is_ldet: '
3093: ||l_dup_is_ldet_rec(l_dup_ind));
3094: QP_PREQ_GRP.engine_debug('Current adj is_ldet: '
3095: ||l_is_ldet_rec_tbl(i));
3096: END IF;--l_debug
3097: IF l_dup_is_ldet_rec(l_dup_ind) in
3098: (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3104: --it is from oe_price_adj
3105: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3106: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3107: IF l_debug = FND_API.G_TRUE THEN
3108: QP_PREQ_GRP.engine_debug('Marking curr adj deleted ');
3109: END IF;--l_debug
3110: ELSIF l_is_ldet_rec_tbl(i) in
3111: (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3112: QP_PREQ_PUB.G_LDET_LINE_TYPE)
3121: l_dup_updated_flag(l_dup_ind) := l_updated_flag_tbl(i);
3122: l_dup_is_ldet_rec(l_dup_ind) := l_is_ldet_rec_tbl(i);
3123: l_dup_plsql_ind(l_dup_ind) := d;
3124: IF l_debug = FND_API.G_TRUE THEN
3125: QP_PREQ_GRP.engine_debug('Marking prev adj deleted ');
3126: END IF;--l_debug
3127: ELSE--both the records have same is_ldet so delete one
3128: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3129: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3127: ELSE--both the records have same is_ldet so delete one
3128: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3129: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3130: IF l_debug = FND_API.G_TRUE THEN
3131: QP_PREQ_GRP.engine_debug('Marking else curr adj deltd');
3132: END IF;--l_debug
3133: END IF;--l_is_ldet_rec_tbl(i)
3134: END IF;--l_dup_updated_flag
3135: ELSE
3159: IF (l_adj_tbl(d).priced_quantity = 0
3160: and l_adj_tbl(d).unit_price <> 0)
3161: THEN
3162: IF l_debug = FND_API.G_TRUE THEN
3163: QP_PREQ_GRP.engine_debug('ldet.line_qty is zero');
3164: END IF;
3165: l_adj_tbl(d).priced_quantity := null;
3166: ELSE
3167: IF l_debug = FND_API.G_TRUE THEN
3164: END IF;
3165: l_adj_tbl(d).priced_quantity := null;
3166: ELSE
3167: IF l_debug = FND_API.G_TRUE THEN
3168: QP_PREQ_GRP.engine_debug('ldet.line_qty not zero');
3169: END IF;
3170: END IF;
3171: l_adj_tbl(d).line_priced_quantity := l_line_priced_qty_tbl(i);
3172: l_adj_tbl(d).updated_adjusted_unit_price :=
3226: IF l_curr_line_index <> l_line_index_tbl(i)
3227: THEN
3228: l_prev_line_start_index := i;
3229: IF l_debug = FND_API.G_TRUE THEN
3230: qp_preq_grp.engine_debug('auto_overr: new line');
3231: END IF; --Bug No 4033618
3232: l_curr_line_index := l_line_index_tbl(i);
3233: x := 0;
3234: l_auto_line_dtl_index_tbl.delete;
3266: l_auto_override_dtl_id_tbl(x) := l_list_line_id_tbl(i);
3267: -- l_adj_tbl(d).pricing_status_code :=
3268: -- QP_PREQ_PUB.G_STATUS_UPDATED;
3269: IF l_debug = FND_API.G_TRUE THEN
3270: qp_preq_grp.engine_debug('auto_overr: from adj tbl '
3271: ||l_line_dtl_index_tbl(i)||' adj id '
3272: ||l_list_line_id_tbl(i));
3273: END IF; --Bug No 4033618
3274: ELSIF l_curr_line_index = l_line_index_tbl(i)
3289: QP_PREQ_PUB.G_NO))
3290: */
3291: THEN
3292: IF l_debug = FND_API.G_TRUE THEN
3293: qp_preq_grp.engine_debug('auto_overr: from ldet tbl '
3294: ||l_adj_tbl(d).created_from_list_line_id
3295: ||' adj index '||l_adj_tbl(d).line_detail_index);
3296: END IF; --Bug No 4033618
3297: m := l_auto_line_dtl_index_tbl.FIRST;
3298: WHILE (m IS NOT NULL
3299: and l_auto_line_dtl_index_tbl.COUNT > 0)
3300: LOOP
3301: IF l_debug = FND_API.G_TRUE THEN
3302: qp_preq_grp.engine_debug('auto_overr: from auto_ov tbl '
3303: ||m||' adj id '||l_auto_override_dtl_id_tbl(m)
3304: ||' dtl index '||l_auto_line_dtl_index_tbl(m));
3305: END IF; --Bug No 4033618
3306: IF l_list_line_id_tbl(i) =
3306: IF l_list_line_id_tbl(i) =
3307: l_auto_override_dtl_id_tbl(m)
3308: THEN
3309: IF l_debug = FND_API.G_TRUE THEN
3310: QP_PREQ_GRP.engine_debug('duplicate hit'
3311: ||' '||l_list_line_id_tbl(i));
3312: END IF;
3313: l_adj_tbl(d).pricing_status_code :=
3314: QP_PREQ_GRP.G_STATUS_DELETED;
3310: QP_PREQ_GRP.engine_debug('duplicate hit'
3311: ||' '||l_list_line_id_tbl(i));
3312: END IF;
3313: l_adj_tbl(d).pricing_status_code :=
3314: QP_PREQ_GRP.G_STATUS_DELETED;
3315: l_adj_tbl(d).pricing_status_text :=
3316: 'DUPLICATE AUTO-OVERRIDEABLE';
3317: l_auto_override_dtl_id_tbl.delete(m);
3318: l_auto_line_dtl_index_tbl.delete(m);
3337: QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id) := null;
3338: END;
3339:
3340: IF l_debug = FND_API.G_TRUE THEN
3341: QP_PREQ_GRP.engine_debug(' PBH vol attr for list_line_id '
3342: ||l_adj_tbl(d).created_from_list_line_id||' attr '
3343: ||QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id));
3344: END IF;--l_debug
3345: END IF;--l_adj_tbl(d).created_from_list_line_type
3388: G_PBH_PLSQL_IND(mod(l_line_dtl_index_tbl(i),G_BINARY_LIMIT)) := --8744755
3389: G_PBH_LINE_INDEX.COUNT;
3390: END IF;--l_adj_tbl(d).created_from_list_line_type
3391: IF l_debug = FND_API.G_TRUE THEN
3392: QP_PREQ_GRP.engine_debug('figuring out line_dtl_index '
3393: ||l_adj_tbl(d).line_detail_index);
3394: END IF;--l_debug
3395: END IF;--nvl(l_adj_tbl(d).is_ldet_rec
3396:
3396:
3397:
3398:
3399: IF l_debug = FND_API.G_TRUE THEN
3400: QP_PREQ_GRP.engine_debug('load tbl'||l_adj_tbl(d).line_detail_index
3401: ||' list_line_id '||l_adj_tbl(d).created_from_list_line_id
3402: ||' list_hdr_id '||l_adj_tbl(d).created_from_list_header_id
3403: ||' line dtl index '||l_adj_tbl(d).line_detail_index
3404: ||' operand '||l_adj_tbl(d).operand_value
3412: /*
3413: i := l_adj_tbl.NEXT(l_prev_line_start_index-1);
3414: g := 0;
3415: IF l_debug = FND_API.G_TRUE THEN
3416: QP_PREQ_GRP.engine_debug('last line starts at '||l_prev_line_start_index);
3417: END IF;
3418: WHILE i IS NOT NULL
3419: LOOP
3420: g := g + 1;
3424:
3425: l_adj_tbl.delete(l_prev_line_start_index,l_adj_tbl.COUNT);
3426:
3427: IF l_adj_tbl.COUNT > 0
3428: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
3429: THEN
3430: i := l_adj_tbl.first;
3431: WHILE i IS NOT NULL
3432: LOOP
3430: i := l_adj_tbl.first;
3431: WHILE i IS NOT NULL
3432: LOOP
3433: IF l_debug = FND_API.G_TRUE THEN
3434: QP_PREQ_GRP.engine_debug('list_line_id '||l_adj_tbl(i).line_detail_index);--||
3435: END IF;
3436: i := l_adj_tbl.next(i);
3437: END LOOP;
3438: END IF;
3440: n:=G_PBH_LINE_DTL_INDEX.FIRST;
3441: WHILE n IS NOT NULL
3442: LOOP
3443: IF l_debug = FND_API.G_TRUE THEN
3444: QP_PREQ_GRP.engine_debug('G_PBH_LINE_DTL_INDEX loop '
3445: ||' lineindex '||G_PBH_LINE_INDEX(n)
3446: ||' price_adj_id '||G_PBH_PRICE_ADJ_ID(n)
3447: ||' linedtlind '||G_PBH_LINE_DTL_INDEX(n));
3448: END IF;
3494: -- and p_view_name = 'ONTVIEW'
3495: -- THEN
3496: CLOSE l_calculate_cur;
3497: IF l_debug = FND_API.G_TRUE THEN
3498: QP_PREQ_GRP.engine_debug('close cur');
3499: END IF;
3500: -- END IF;
3501:
3502: --commenting to do the delete at all times
3503: -- IF p_event_code = ','
3504: -- and p_calculate_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
3505: -- THEN
3506: IF l_debug = FND_API.G_TRUE THEN
3507: QP_PREQ_GRP.engine_debug('deleting related lines');
3508: END IF;
3509: delete from qp_npreq_rltd_lines_tmp
3510: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3511: and relationship_type_code = QP_PREQ_PUB.G_PBH_LINE
3510: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3511: and relationship_type_code = QP_PREQ_PUB.G_PBH_LINE
3512: and pricing_status_text = G_CALC_INSERT;
3513: IF l_debug = FND_API.G_TRUE THEN
3514: QP_PREQ_GRP.engine_debug('deleted related lines '||SQL%ROWCOUNT);
3515: END IF;
3516: -- END IF;
3517:
3518: --This is to update the status code on the child lines on PBH for
3542: FETCH check_manual_modifiers BULK COLLECT INTO l_manual_line_details_tbl LIMIT 5000;
3543: EXIT WHEN l_manual_line_details_tbl.COUNT = 0;
3544:
3545: IF (l_debug = FND_API.G_TRUE) THEN
3546: QP_PREQ_GRP.engine_debug('Duplicate manual override modifier count: '|| l_manual_line_details_tbl.COUNT);
3547: END IF;
3548:
3549: FORALL y IN l_manual_line_details_tbl.FIRST..l_manual_line_details_tbl.LAST
3550: UPDATE qp_npreq_ldets_tmp
3555:
3556: CLOSE check_manual_modifiers;
3557:
3558: IF (l_debug = FND_API.G_TRUE) THEN
3559: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
3560: END IF;
3561:
3562: -- 4528043, mark any newly picked-up manual modifiers as 'deleted'
3563: -- to prevent OM from incorrectly displaying them in View Adjs
3563: -- to prevent OM from incorrectly displaying them in View Adjs
3564: -- 5413797, but don't delete any manual modifiers that appear new
3565: -- because they were repriced with a different quantity
3566: IF (QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES and
3567: QP_PREQ_GRP.G_MANUAL_ADJUSTMENTS_CALL_FLAG = QP_PREQ_PUB.G_NO)
3568: THEN
3569: UPDATE qp_npreq_ldets_tmp
3570: SET pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
3571: WHERE pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3573: AND applied_flag = QP_PREQ_PUB.G_NO
3574: and updated_flag = QP_PREQ_PUB.G_NO; -- 5413797
3575:
3576: IF (l_debug = FND_API.G_TRUE) THEN
3577: QP_PREQ_GRP.engine_debug(SQL%ROWCOUNT||' new manual modifier(s) marked as DELETED');
3578: END IF;
3579: END IF;
3580:
3581: --Fix for bug 2247167 Status on lines is unchanged although
3596: --update needs to be done
3597: -- IF p_calculate_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
3598: -- THEN
3599: IF l_debug = FND_API.G_TRUE THEN
3600: QP_PREQ_GRP.engine_debug('calculate_only call check to see'
3601: ||' if there are adjustments');
3602: END IF;
3603: QP_PREQ_PUB.update_unit_price(x_return_status,
3604: x_return_status_text);
3650:
3651:
3652:
3653: IF l_debug = FND_API.G_TRUE THEN
3654: QP_PREQ_GRP.engine_debug('end fetch adjustments');
3655:
3656:
3657: END IF;
3658: EXCEPTION
3658: EXCEPTION
3659: When PRICING_EXCEPTION Then
3660: x_return_status := FND_API.G_RET_STS_ERROR;
3661: IF l_debug = FND_API.G_TRUE THEN
3662: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3663: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||x_return_status_text);
3664: END IF;
3665: When OTHERS Then
3666: x_return_status := FND_API.G_RET_STS_ERROR;
3659: When PRICING_EXCEPTION Then
3660: x_return_status := FND_API.G_RET_STS_ERROR;
3661: IF l_debug = FND_API.G_TRUE THEN
3662: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3663: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||x_return_status_text);
3664: END IF;
3665: When OTHERS Then
3666: x_return_status := FND_API.G_RET_STS_ERROR;
3667: x_return_status_text := 'Error in fetch_adjustments: '||SQLERRM;
3665: When OTHERS Then
3666: x_return_status := FND_API.G_RET_STS_ERROR;
3667: x_return_status_text := 'Error in fetch_adjustments: '||SQLERRM;
3668: IF l_debug = FND_API.G_TRUE THEN
3669: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3670: END IF;
3671: END fetch_adjustments;
3672:
3673: