[Home] [Help]
2: /* $Header: QPXVCLNB.pls 120.9.12010000.2 2008/08/12 06:28:41 smuhamme 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:
695: FROM qp_int_line_attrs
696: WHERE line_detail_index is not null;
697: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
698: */
699: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
700: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
701: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
696: WHERE line_detail_index is not null;
697: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
698: */
699: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
700: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
701: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
697: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
698: */
699: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
700: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
701: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
698: */
699: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
700: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
701: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
699: l_cur_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
700: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
701: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
700: l_cur_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
701: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
701: l_cur_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
702: l_cur_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
703: l_cur_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
704: l_cur_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
705: l_cur_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
706: l_cur_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
707: l_cur_adj_amt_tbl QP_PREQ_GRP.NUMBER_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
708: l_cur_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
709: l_cur_substn_val_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
710: l_cur_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
711: l_cur_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
712: l_cur_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
713: l_cur_override_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
714: l_cur_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
715: l_cur_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
716: l_cur_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
717: l_cur_accr_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
718: l_cur_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
719: l_cur_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
720: l_cur_line_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
721: l_adj_automatic_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
722: l_adj_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
723: --l_adj_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
724: --l_adj_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
725: l_adj_modified_from_tbl QP_PREQ_GRP.VARCHAR_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
726: l_adj_modified_to_tbl QP_PREQ_GRP.VARCHAR_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
727: l_adj_update_allowed_tbl QP_PREQ_GRP.FLAG_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
728: l_adj_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
729: l_adj_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
730: l_adj_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
731: l_adj_charge_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
732: l_adj_charge_subtype_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
733: l_adj_range_break_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
734: l_adj_accrual_conv_rate_tbl QP_PREQ_GRP.NUMBER_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
735: l_adj_pricing_grp_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
736: l_adj_accrual_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
737: l_adj_benefit_qty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
738: l_adj_benefit_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
739: l_adj_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
740: l_adj_rebate_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
741: l_adj_price_brk_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
742: l_adj_substn_attr_tbl QP_PREQ_GRP.VARCHAR_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
743: l_adj_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
744: l_adj_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
745: l_adj_operand_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
746: l_adj_adj_amt_pqty_tbl QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
747: l_adj_operator_tbl QP_PREQ_GRP.VARCHAR_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
755: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
748: l_cur_exp_date_tbl QP_PREQ_GRP.DATE_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
755: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
756: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
749: l_cur_prorat_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
755: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
756: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
757: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
750: l_cur_include_ret_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
755: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
756: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
757: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
758:
751: l_cur_reb_txn_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
755: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
756: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
757: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
758:
759:
752: l_cur_prc_sts_txt_tbl QP_PREQ_GRP.VARCHAR_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
755: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
756: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
757: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
758:
759:
760: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
753: l_cur_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
754: l_cur_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
755: l_adj_ord_qty_adjamt QP_PREQ_GRP.NUMBER_TYPE;
756: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
757: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
758:
759:
760: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
761: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
756: l_cur_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
757: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
758:
759:
760: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
761: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
762: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
763: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
764: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
757: l_adj_ord_qty_operand QP_PREQ_GRP.NUMBER_TYPE;
758:
759:
760: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
761: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
762: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
763: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
764: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
765:
758:
759:
760: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
761: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
762: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
763: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
764: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
765:
766:
759:
760: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
761: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
762: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
763: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
764: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
765:
766:
767:
760: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
761: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
762: l_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
763: l_process_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
764: l_pricing_sts_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
765:
766:
767:
768:
770: X PLS_INTEGER;
771: nrows NUMBER := 500;
772: BEGIN
773:
774: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
775: x:=0;
776: IF l_debug = FND_API.G_TRUE THEN
777: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
778: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
773:
774: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
775: x:=0;
776: IF l_debug = FND_API.G_TRUE THEN
777: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
778: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
779: qp_preq_grp.engine_debug('begin update check viewcode '||p_view_code);
780: END IF; --Bug No 4033618
781: --IF p_request_type_code in ('ONT','ASO')
774: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
775: x:=0;
776: IF l_debug = FND_API.G_TRUE THEN
777: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
778: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
779: qp_preq_grp.engine_debug('begin update check viewcode '||p_view_code);
780: END IF; --Bug No 4033618
781: --IF p_request_type_code in ('ONT','ASO')
782: IF p_cleanup_flag = 'Y'
775: x:=0;
776: IF l_debug = FND_API.G_TRUE THEN
777: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
778: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
779: qp_preq_grp.engine_debug('begin update check viewcode '||p_view_code);
780: END IF; --Bug No 4033618
781: --IF p_request_type_code in ('ONT','ASO')
782: IF p_cleanup_flag = 'Y'
783: --and p_request_type_code = 'ONT'
785: -- they pass reqtype ONT and insert adj into ldets
786: and QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
787: THEN
788: IF l_debug = FND_API.G_TRUE THEN
789: qp_preq_grp.engine_debug('in update cleanup '||p_cleanup_flag);
790: END IF; -- Bug No 4033618
791: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
792: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
793: IF l_debug = FND_API.G_TRUE THEN
790: END IF; -- Bug No 4033618
791: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
792: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
793: IF l_debug = FND_API.G_TRUE THEN
794: QP_PREQ_GRP.ENGINE_DEBUG('cleanup_adjustments Java Engine not Installed ----------');
795: END IF;
796: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
797:
798: OPEN l_update_cur;
926:
927: FOR i IN l_cur_dtl_index_tbl.FIRST..l_cur_dtl_index_tbl.LAST
928: LOOP
929:
930: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
931: THEN
932: qp_preq_grp.engine_debug('loop update cur line ind '
933: ||l_cur_line_index_tbl(i)||' line_dtl_index '
934: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
928: LOOP
929:
930: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
931: THEN
932: qp_preq_grp.engine_debug('loop update cur line ind '
933: ||l_cur_line_index_tbl(i)||' line_dtl_index '
934: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
935: ||l_cur_price_adj_id_tbl(i));
936: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
932: qp_preq_grp.engine_debug('loop update cur line ind '
933: ||l_cur_line_index_tbl(i)||' line_dtl_index '
934: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
935: ||l_cur_price_adj_id_tbl(i));
936: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
937: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
938: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
939: ||' adj '||l_adj_operand_pqty_tbl(i));
940: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
934: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
935: ||l_cur_price_adj_id_tbl(i));
936: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
937: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
938: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
939: ||' adj '||l_adj_operand_pqty_tbl(i));
940: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
941: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
942: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
936: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
937: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
938: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
939: ||' adj '||l_adj_operand_pqty_tbl(i));
940: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
941: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
942: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
943: ||' adj '||l_adj_charge_type_tbl(i));
944: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
938: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
939: ||' adj '||l_adj_operand_pqty_tbl(i));
940: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
941: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
942: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
943: ||' adj '||l_adj_charge_type_tbl(i));
944: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
945: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
946: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
940: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
941: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
942: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
943: ||' adj '||l_adj_charge_type_tbl(i));
944: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
945: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
946: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
947: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
948: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
942: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
943: ||' adj '||l_adj_charge_type_tbl(i));
944: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
945: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
946: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
947: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
948: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
949: ||' adj operator '||l_adj_operator_tbl(i));
950: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
944: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
945: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
946: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
947: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
948: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
949: ||' adj operator '||l_adj_operator_tbl(i));
950: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
951: ||' adj phase id '||l_adj_phase_id_tbl(i));
952: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
946: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
947: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
948: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
949: ||' adj operator '||l_adj_operator_tbl(i));
950: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
951: ||' adj phase id '||l_adj_phase_id_tbl(i));
952: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
953: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
954: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
948: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
949: ||' adj operator '||l_adj_operator_tbl(i));
950: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
951: ||' adj phase id '||l_adj_phase_id_tbl(i));
952: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
953: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
954: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
955: ||' adj override '||l_adj_update_allowed_tbl(i));
956: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
950: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
951: ||' adj phase id '||l_adj_phase_id_tbl(i));
952: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
953: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
954: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
955: ||' adj override '||l_adj_update_allowed_tbl(i));
956: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
957: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
958: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
952: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
953: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
954: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
955: ||' adj override '||l_adj_update_allowed_tbl(i));
956: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
957: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
958: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
959: ||' adj substn val '||l_adj_modified_to_tbl(i));
960: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
954: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
955: ||' adj override '||l_adj_update_allowed_tbl(i));
956: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
957: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
958: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
959: ||' adj substn val '||l_adj_modified_to_tbl(i));
960: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
961: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
962: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
956: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
957: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
958: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
959: ||' adj substn val '||l_adj_modified_to_tbl(i));
960: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
961: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
962: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
963: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
964: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
958: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
959: ||' adj substn val '||l_adj_modified_to_tbl(i));
960: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
961: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
962: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
963: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
964: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
965: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
966: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
960: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
961: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
962: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
963: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
964: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
965: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
966: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
967: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
968: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
962: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
963: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
964: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
965: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
966: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
967: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
968: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
969: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
970: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
964: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
965: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
966: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
967: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
968: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
969: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
970: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
971: ||' adj proration type '||l_adj_prorat_type_tbl(i));
972: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
966: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
967: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
968: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
969: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
970: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
971: ||' adj proration type '||l_adj_prorat_type_tbl(i));
972: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
973: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
974: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
968: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
969: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
970: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
971: ||' adj proration type '||l_adj_prorat_type_tbl(i));
972: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
973: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
974: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
975: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
976: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
970: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
971: ||' adj proration type '||l_adj_prorat_type_tbl(i));
972: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
973: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
974: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
975: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
976: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
977: ||' adj exp date '||l_adj_exp_date_tbl(i)
978: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
972: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
973: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
974: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
975: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
976: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
977: ||' adj exp date '||l_adj_exp_date_tbl(i)
978: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
979: qp_preq_grp.engine_debug('ord_qty_adjamt '
980: ||l_cur_ord_qty_adjamt(i)
975: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
976: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
977: ||' adj exp date '||l_adj_exp_date_tbl(i)
978: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
979: qp_preq_grp.engine_debug('ord_qty_adjamt '
980: ||l_cur_ord_qty_adjamt(i)
981: ||' adj ord_qty_adjamt '||l_adj_ord_qty_adjamt(i)
982: ||' ord_qty_operand '||l_cur_ord_qty_operand(i)
983: ||' adj ord_qty_operand '||l_adj_ord_qty_operand(i));
1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1034: THEN
1035: x:=x+1;
1036: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1037: qp_preq_grp.engine_debug('if update check '||x);
1038: qp_preq_grp.engine_debug('update check dtls '
1039: ||l_cur_dtl_index_tbl(i)||' adj_id '
1040: ||l_cur_price_adj_id_tbl(i)||' id '
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1034: THEN
1035: x:=x+1;
1036: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1037: qp_preq_grp.engine_debug('if update check '||x);
1038: qp_preq_grp.engine_debug('update check dtls '
1039: ||l_cur_dtl_index_tbl(i)||' adj_id '
1040: ||l_cur_price_adj_id_tbl(i)||' id '
1041: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1034: THEN
1035: x:=x+1;
1036: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1037: qp_preq_grp.engine_debug('if update check '||x);
1038: qp_preq_grp.engine_debug('update check dtls '
1039: ||l_cur_dtl_index_tbl(i)||' adj_id '
1040: ||l_cur_price_adj_id_tbl(i)||' id '
1041: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1042: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1048: l_process_code_tbl(x) := QP_PREQ_PUB.G_STATUS_UNCHANGED;
1049: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1050: ELSE
1051: x:=x+1;
1052: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1053: qp_preq_grp.engine_debug('else update check '||x);
1054: qp_preq_grp.engine_debug('update check dtls '
1055: ||l_cur_dtl_index_tbl(i)||' adj_id '
1056: ||l_cur_price_adj_id_tbl(i)||' id '
1049: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1050: ELSE
1051: x:=x+1;
1052: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1053: qp_preq_grp.engine_debug('else update check '||x);
1054: qp_preq_grp.engine_debug('update check dtls '
1055: ||l_cur_dtl_index_tbl(i)||' adj_id '
1056: ||l_cur_price_adj_id_tbl(i)||' id '
1057: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1050: ELSE
1051: x:=x+1;
1052: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1053: qp_preq_grp.engine_debug('else update check '||x);
1054: qp_preq_grp.engine_debug('update check dtls '
1055: ||l_cur_dtl_index_tbl(i)||' adj_id '
1056: ||l_cur_price_adj_id_tbl(i)||' id '
1057: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1058: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1071: CLOSE l_update_cur;
1072: ELSE
1073: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1074: IF l_debug = FND_API.G_TRUE THEN
1075: QP_PREQ_GRP.ENGINE_DEBUG('cleanup_adjustments() Java Engine is Installed ----------');
1076: END IF;
1077: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1078:
1079: OPEN l_update_int_cur;
1207:
1208: FOR i IN l_cur_dtl_index_tbl.FIRST..l_cur_dtl_index_tbl.LAST
1209: LOOP
1210:
1211: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1212: THEN
1213: qp_preq_grp.engine_debug('loop update cur line ind '
1214: ||l_cur_line_index_tbl(i)||' line_dtl_index '
1215: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1209: LOOP
1210:
1211: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1212: THEN
1213: qp_preq_grp.engine_debug('loop update cur line ind '
1214: ||l_cur_line_index_tbl(i)||' line_dtl_index '
1215: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1216: ||l_cur_price_adj_id_tbl(i));
1217: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1213: qp_preq_grp.engine_debug('loop update cur line ind '
1214: ||l_cur_line_index_tbl(i)||' line_dtl_index '
1215: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1216: ||l_cur_price_adj_id_tbl(i));
1217: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1218: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
1219: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1220: ||' adj '||l_adj_operand_pqty_tbl(i));
1221: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1215: ||l_cur_dtl_index_tbl(i)||' price_adj_id '
1216: ||l_cur_price_adj_id_tbl(i));
1217: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1218: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
1219: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1220: ||' adj '||l_adj_operand_pqty_tbl(i));
1221: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1222: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1223: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1217: qp_preq_grp.engine_debug('adj amt '||l_cur_adj_amt_tbl(i)
1218: ||' adj '||l_adj_adj_amt_pqty_tbl(i));
1219: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1220: ||' adj '||l_adj_operand_pqty_tbl(i));
1221: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1222: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1223: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1224: ||' adj '||l_adj_charge_type_tbl(i));
1225: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1219: qp_preq_grp.engine_debug('operand '||l_cur_operand_tbl(i)
1220: ||' adj '||l_adj_operand_pqty_tbl(i));
1221: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1222: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1223: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1224: ||' adj '||l_adj_charge_type_tbl(i));
1225: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1226: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1227: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1221: qp_preq_grp.engine_debug('bucket '||l_cur_pricing_grp_seq_tbl(i)
1222: ||' adj '||l_adj_pricing_grp_seq_tbl(i));
1223: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1224: ||' adj '||l_adj_charge_type_tbl(i));
1225: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1226: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1227: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1228: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1229: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1223: qp_preq_grp.engine_debug('charg type '||l_cur_charge_type_tbl(i)
1224: ||' adj '||l_adj_charge_type_tbl(i));
1225: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1226: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1227: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1228: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1229: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1230: ||' adj operator '||l_adj_operator_tbl(i));
1231: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1225: qp_preq_grp.engine_debug('chstype '||l_cur_charge_subtype_tbl(i)
1226: ||' adj charge subtype '||l_adj_charge_subtype_tbl(i));
1227: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1228: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1229: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1230: ||' adj operator '||l_adj_operator_tbl(i));
1231: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1232: ||' adj phase id '||l_adj_phase_id_tbl(i));
1233: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1227: qp_preq_grp.engine_debug('pbrk '||l_cur_price_brk_type_tbl(i)
1228: ||' adj price brk type '||l_adj_price_brk_type_tbl(i));
1229: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1230: ||' adj operator '||l_adj_operator_tbl(i));
1231: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1232: ||' adj phase id '||l_adj_phase_id_tbl(i));
1233: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1234: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1235: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1229: qp_preq_grp.engine_debug('operator '||l_cur_operator_tbl(i)
1230: ||' adj operator '||l_adj_operator_tbl(i));
1231: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1232: ||' adj phase id '||l_adj_phase_id_tbl(i));
1233: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1234: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1235: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1236: ||' adj override '||l_adj_update_allowed_tbl(i));
1237: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1231: qp_preq_grp.engine_debug('phase id '||l_cur_phase_id_tbl(i)
1232: ||' adj phase id '||l_adj_phase_id_tbl(i));
1233: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1234: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1235: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1236: ||' adj override '||l_adj_update_allowed_tbl(i));
1237: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1238: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1239: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1233: qp_preq_grp.engine_debug('autoflg '||l_cur_automatic_flag_tbl(i)
1234: ||' adj autom flag '||l_adj_automatic_flag_tbl(i));
1235: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1236: ||' adj override '||l_adj_update_allowed_tbl(i));
1237: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1238: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1239: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1240: ||' adj substn val '||l_adj_modified_to_tbl(i));
1241: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1235: qp_preq_grp.engine_debug('override '||l_cur_override_flag_tbl(i)
1236: ||' adj override '||l_adj_update_allowed_tbl(i));
1237: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1238: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1239: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1240: ||' adj substn val '||l_adj_modified_to_tbl(i));
1241: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1242: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1243: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1237: qp_preq_grp.engine_debug('sub attr '||l_cur_substn_attr_tbl(i)
1238: ||' adj sub attr '||l_adj_substn_attr_tbl(i));
1239: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1240: ||' adj substn val '||l_adj_modified_to_tbl(i));
1241: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1242: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1243: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1244: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1245: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1239: qp_preq_grp.engine_debug('subval '||l_cur_substn_val_to_tbl(i)
1240: ||' adj substn val '||l_adj_modified_to_tbl(i));
1241: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1242: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1243: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1244: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1245: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1246: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1247: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1241: qp_preq_grp.engine_debug('benf qty '||l_cur_benefit_qty_tbl(i)
1242: ||' adj benefit qty '||l_adj_benefit_qty_tbl(i));
1243: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1244: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1245: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1246: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1247: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1248: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1249: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1243: qp_preq_grp.engine_debug('bnuom '||l_cur_benefit_uom_code_tbl(i)
1244: ||' adj benefit uom '||l_adj_benefit_uom_code_tbl(i));
1245: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1246: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1247: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1248: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1249: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1250: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1251: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1245: qp_preq_grp.engine_debug('accrual '||l_cur_accrual_flag_tbl(i)
1246: ||' adj accrual flag '||l_adj_accrual_flag_tbl(i));
1247: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1248: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1249: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1250: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1251: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1252: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1253: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1247: qp_preq_grp.engine_debug('conv '||l_cur_accr_conv_rate_tbl(i)
1248: ||' adj accr conv rate '||l_adj_accrual_conv_rate_tbl(i));
1249: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1250: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1251: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1252: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1253: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1254: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1255: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1249: qp_preq_grp.engine_debug('rebtxn '||l_cur_reb_txn_type_tbl(i)
1250: ||' adj rebate txn type '||l_adj_rebate_txn_type_tbl(i));
1251: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1252: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1253: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1254: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1255: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1256: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1257: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1251: qp_preq_grp.engine_debug('prorat typ '||l_cur_prorat_type_tbl(i)
1252: ||' adj proration type '||l_adj_prorat_type_tbl(i));
1253: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1254: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1255: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1256: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1257: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1258: ||' adj exp date '||l_adj_exp_date_tbl(i)
1259: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
1253: qp_preq_grp.engine_debug('incl '||l_cur_include_ret_flag_tbl(i)
1254: ||' adj include on ret '||l_adj_include_ret_flag_tbl(i));
1255: qp_preq_grp.engine_debug('line_qty '||l_cur_line_qty_tbl(i)
1256: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1257: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1258: ||' adj exp date '||l_adj_exp_date_tbl(i)
1259: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
1260: qp_preq_grp.engine_debug('ord_qty_adjamt '
1261: ||l_cur_ord_qty_adjamt(i)
1256: ||' adj range_brk_qty '||l_adj_range_break_qty_tbl(i));
1257: qp_preq_grp.engine_debug('exp date '||l_cur_exp_date_tbl(i)
1258: ||' adj exp date '||l_adj_exp_date_tbl(i)
1259: ||' pricing sts text '||l_cur_prc_sts_txt_tbl(i));
1260: qp_preq_grp.engine_debug('ord_qty_adjamt '
1261: ||l_cur_ord_qty_adjamt(i)
1262: ||' adj ord_qty_adjamt '||l_adj_ord_qty_adjamt(i)
1263: ||' ord_qty_operand '||l_cur_ord_qty_operand(i)
1264: ||' adj ord_qty_operand '||l_adj_ord_qty_operand(i));
1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1315: THEN
1316: x:=x+1;
1317: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1318: qp_preq_grp.engine_debug('if update check '||x);
1319: qp_preq_grp.engine_debug('update check dtls '
1320: ||l_cur_dtl_index_tbl(i)||' adj_id '
1321: ||l_cur_price_adj_id_tbl(i)||' id '
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1315: THEN
1316: x:=x+1;
1317: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1318: qp_preq_grp.engine_debug('if update check '||x);
1319: qp_preq_grp.engine_debug('update check dtls '
1320: ||l_cur_dtl_index_tbl(i)||' adj_id '
1321: ||l_cur_price_adj_id_tbl(i)||' id '
1322: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1315: THEN
1316: x:=x+1;
1317: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1318: qp_preq_grp.engine_debug('if update check '||x);
1319: qp_preq_grp.engine_debug('update check dtls '
1320: ||l_cur_dtl_index_tbl(i)||' adj_id '
1321: ||l_cur_price_adj_id_tbl(i)||' id '
1322: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1323: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1329: l_process_code_tbl(x) := QP_PREQ_PUB.G_STATUS_UNCHANGED;
1330: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1331: ELSE
1332: x:=x+1;
1333: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1334: qp_preq_grp.engine_debug('else update check '||x);
1335: qp_preq_grp.engine_debug('update check dtls '
1336: ||l_cur_dtl_index_tbl(i)||' adj_id '
1337: ||l_cur_price_adj_id_tbl(i)||' id '
1330: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1331: ELSE
1332: x:=x+1;
1333: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1334: qp_preq_grp.engine_debug('else update check '||x);
1335: qp_preq_grp.engine_debug('update check dtls '
1336: ||l_cur_dtl_index_tbl(i)||' adj_id '
1337: ||l_cur_price_adj_id_tbl(i)||' id '
1338: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1331: ELSE
1332: x:=x+1;
1333: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1334: qp_preq_grp.engine_debug('else update check '||x);
1335: qp_preq_grp.engine_debug('update check dtls '
1336: ||l_cur_dtl_index_tbl(i)||' adj_id '
1337: ||l_cur_price_adj_id_tbl(i)||' id '
1338: ||l_cur_list_line_id_tbl(i)||' adj adj amt '
1339: ||l_adj_adj_amt_pqty_tbl(i)||' adj amt '
1355:
1356: IF l_line_dtl_index_tbl.COUNT > 0
1357: THEN
1358:
1359: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1360: THEN
1361: FOR x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1362: LOOP
1363: IF l_debug = FND_API.G_TRUE THEN
1360: THEN
1361: FOR x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1362: LOOP
1363: IF l_debug = FND_API.G_TRUE THEN
1364: QP_PREQ_GRP.engine_debug('Cleanup debug '
1365: ||' line index '||l_line_index_tbl(x)
1366: ||' line dtl index '||l_line_dtl_index_tbl(x)
1367: ||' price_adj_id '||l_price_adj_id_tbl(x)
1368: ||' process code '||l_process_code_tbl(x)
1372: END IF;
1373: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1374: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
1375: IF l_debug = FND_API.G_TRUE THEN
1376: QP_PREQ_GRP.ENGINE_DEBUG('Java Engine not Installed ----------');
1377: END IF;
1378: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1379:
1380: FORALL x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1386: and line_detail_index = l_line_dtl_index_tbl(x);
1387: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1388: ELSE
1389: IF l_debug = FND_API.G_TRUE THEN
1390: QP_PREQ_GRP.ENGINE_DEBUG('Java Engine is Installed ----------');
1391: END IF;
1392: FORALL x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1393: UPDATE qp_int_ldets
1394: SET process_code = l_process_code_tbl(x)
1444: and attr.pricing_attribute = lattr.attribute
1445: and attr.pricing_attr_value_from = lattr.value_from);
1446:
1447:
1448: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1449: THEN
1450: for cl in l_attr_cur
1451: loop
1452: qp_preq_grp.engine_debug('attr details '
1448: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1449: THEN
1450: for cl in l_attr_cur
1451: loop
1452: qp_preq_grp.engine_debug('attr details '
1453: ||cl.line_index||' dtl index '||cl.line_detail_index
1454: ||' sts code '||cl.pricing_status_code||' context '
1455: ||cl.context||' attr '||cl.attribute
1456: ||' val from '||cl.value_from);
1461:
1462:
1463: END IF;
1464: IF l_debug = FND_API.G_TRUE THEN
1465: QP_PREQ_GRP.engine_debug('Completed QP_CLEANUP.cleanup_adjustments');
1466: END IF;
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: EXCEPTION
1468:
1469: EXCEPTION
1470: When OTHERS Then
1471: IF l_debug = FND_API.G_TRUE THEN
1472: QP_PREQ_GRP.engine_debug('error in QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM);
1473: END IF;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: --x_return_status_text := 'error QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM';
1476:
1479: FUNCTION Get_line_detail_index(p_line_index IN NUMBER,
1480: p_price_adj_id IN NUMBER)
1481: RETURN NUMBER IS
1482: BEGIN
1483: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1484: IF G_PBH_PLSQL_IND.EXISTS(p_price_adj_id) THEN
1485: IF l_debug = FND_API.G_TRUE THEN
1486: QP_PREQ_GRP.engine_debug('begin get loop ');
1487: END IF;--l_debug
1482: BEGIN
1483: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1484: IF G_PBH_PLSQL_IND.EXISTS(p_price_adj_id) THEN
1485: IF l_debug = FND_API.G_TRUE THEN
1486: QP_PREQ_GRP.engine_debug('begin get loop ');
1487: END IF;--l_debug
1488: FOR i IN G_PBH_LINE_DTL_INDEX.FIRST..G_PBH_LINE_DTL_INDEX.LAST
1489: LOOP
1490: IF l_debug = FND_API.G_TRUE THEN
1487: END IF;--l_debug
1488: FOR i IN G_PBH_LINE_DTL_INDEX.FIRST..G_PBH_LINE_DTL_INDEX.LAST
1489: LOOP
1490: IF l_debug = FND_API.G_TRUE THEN
1491: QP_PREQ_GRP.engine_debug('in get loop '||G_PBH_LINE_INDEX(i)||' '
1492: ||G_PBH_PRICE_ADJ_ID(i));
1493: END IF;--l_debug
1494: IF G_PBH_LINE_INDEX(i) = p_line_index
1495: and G_PBH_PRICE_ADJ_ID(i) = p_price_adj_id THEN
1725: 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
1726: 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
1727: and nvl(ph.user_freeze_override_flag,ph.freeze_override_flag) = QP_PREQ_PUB.G_YES))));
1728:
1729: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1730: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1731: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1726: 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
1727: and nvl(ph.user_freeze_override_flag,ph.freeze_override_flag) = QP_PREQ_PUB.G_YES))));
1728:
1729: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1730: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1731: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1727: and nvl(ph.user_freeze_override_flag,ph.freeze_override_flag) = QP_PREQ_PUB.G_YES))));
1728:
1729: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1730: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1731: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1728:
1729: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1730: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1731: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1729: l_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1730: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1731: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1730: l_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1731: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1731: l_rltd_line_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1732: l_rltd_line_dtl_index_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1733: l_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1734: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1735: l_list_line_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1736: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1737: l_operand_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1738: l_pricing_group_seq_tbl QP_PREQ_GRP.NUMBER_TYPE;
1739: l_price_brk_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1740: l_setup_value_from_tbl QP_PREQ_GRP.NUMBER_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1748: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1741: l_setup_value_to_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1748: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1749: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1742: l_qualifier_value_tbl QP_PREQ_GRP.NUMBER_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1748: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1749: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1750: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1743: --added these columns to insert child break lines for bug 3314259
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1748: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1749: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1750: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751:
1744: l_mod_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1748: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1749: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1750: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751:
1752: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1745: l_pricing_phase_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1748: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1749: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1750: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751:
1752: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1753: N pls_integer;
1746: l_auto_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1747: l_applied_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1748: l_updated_flag_tbl QP_PREQ_GRP.FLAG_TYPE;
1749: l_list_hdr_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1750: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
1751:
1752: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1753: N pls_integer;
1754: BEGIN
1751:
1752: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1753: N pls_integer;
1754: BEGIN
1755: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1756: IF l_debug = FND_API.G_TRUE THEN
1757: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1758: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1759: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1753: N pls_integer;
1754: BEGIN
1755: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1756: IF l_debug = FND_API.G_TRUE THEN
1757: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1758: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1759: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1760:
1761: END IF;
1754: BEGIN
1755: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1756: IF l_debug = FND_API.G_TRUE THEN
1757: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1758: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1759: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1760:
1761: END IF;
1762: OPEN l_pbh_adj_exists_cur;
1755: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1756: IF l_debug = FND_API.G_TRUE THEN
1757: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1758: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1759: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1760:
1761: END IF;
1762: OPEN l_pbh_adj_exists_cur;
1763: FETCH l_pbh_adj_exists_cur INTO l_pbh_adj_exists;
1763: FETCH l_pbh_adj_exists_cur INTO l_pbh_adj_exists;
1764: CLOSE l_pbh_adj_exists_cur;
1765:
1766: IF l_debug = FND_API.G_TRUE THEN
1767: QP_PREQ_GRP.engine_debug('Check l_pbh_adj_exists '||l_pbh_adj_exists);
1768:
1769: END IF;
1770: N := 0;
1771:
1796:
1797: FOR I IN l_rltd_line_info_cur
1798: LOOP
1799: IF l_debug = FND_API.G_TRUE THEN
1800: QP_PREQ_GRP.engine_debug('In l_rltd_line_info_cur');
1801: END IF;
1802: N := N+1;
1803: l_line_index_tbl(N):=I.line_index;
1804: l_line_dtl_index_tbl(N) :=
1807:
1808: l_rltd_line_dtl_index_tbl(N):=
1809: Get_line_detail_index(I.related_line_index, I.related_line_detail_index);
1810: IF l_debug = FND_API.G_TRUE THEN
1811: QP_PREQ_GRP.engine_debug('Pbh dtl_index '
1812: ||l_line_dtl_index_tbl(N)
1813: ||' rltd_dtl_index '
1814: ||l_rltd_line_dtl_index_tbl(N));
1815: END IF;--l_debug
1834: l_list_hdr_id_tbl(N) := I.list_header_id;
1835: l_list_line_no_tbl(N) := I.list_line_no;
1836:
1837: IF l_debug = FND_API.G_TRUE THEN
1838: QP_PREQ_GRP.engine_debug('price brk child details '
1839: ||l_line_dtl_index_tbl(N)||' rltd_dtl '
1840: ||l_rltd_line_dtl_index_tbl(N)||' bucket '
1841: ||l_pricing_group_seq_tbl(N)||' '
1842: ||' parent id '||l_list_line_id_tbl(N)
1850: END IF;
1851: END LOOP;
1852:
1853: IF l_debug = FND_API.G_TRUE THEN
1854: QP_PREQ_GRP.engine_debug('price brk after loop ');
1855: END IF;
1856: IF l_line_dtl_index_tbl.COUNT > 0
1857: THEN
1858: IF l_debug = FND_API.G_TRUE THEN
1855: END IF;
1856: IF l_line_dtl_index_tbl.COUNT > 0
1857: THEN
1858: IF l_debug = FND_API.G_TRUE THEN
1859: QP_PREQ_GRP.engine_debug('price brk before insert ');
1860: END IF;
1861: FORALL I IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1862: INSERT INTO qp_npreq_rltd_lines_tmp
1863: (
1932: ,pricing_phase_id)
1933: values
1934: (l_rltd_line_dtl_index_tbl(I)
1935: ,l_rltd_line_index_tbl(I)
1936: ,QP_PREQ_GRP.G_CHILD_DETAIL_TYPE -- bug 3487840, pass QP_PREQ_GRP.G_CHILD_DETAIL_TYPE instead of null
1937: ,QP_PREQ_PUB.G_STATUS_NEW
1938: ,''
1939: ,QP_PREQ_PUB.G_STATUS_NEW
1940: ,l_list_hdr_id_tbl(I) --put list_header_id
1952: ,l_auto_flag_tbl(I) --QP_PREQ_PUB.G_NO
1953: ,l_pricing_phase_id_tbl(I));
1954:
1955: IF l_debug = FND_API.G_TRUE THEN
1956: QP_PREQ_GRP.engine_debug('price brk after insert ');
1957:
1958: END IF;
1959: END IF;
1960: END IF;
1958: END IF;
1959: END IF;
1960: END IF;
1961: IF l_debug = FND_API.G_TRUE THEN
1962: QP_PREQ_GRP.engine_debug('End Insert_rltd_lines');
1963: END IF;
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965: EXCEPTION
1966: When OTHERS Then
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965: EXCEPTION
1966: When OTHERS Then
1967: IF l_debug = FND_API.G_TRUE THEN
1968: QP_PREQ_GRP.engine_debug('Error Insert_rltd_lines'||SQLERRM);
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: x_return_status_text := 'Error in QP_CLEANUP_ADJUSTMENTS.Insert_Rltd_Lines '||SQLERRM;
1972: END Insert_Rltd_Lines;
2092: and not exists (select 'x'
2093: from oe_price_adj_assocs a, oe_price_adjustments b
2094: where a.RLTD_PRICE_ADJ_ID = adj.price_adjustment_id
2095: and b.price_adjustment_id = a.price_adjustment_id
2096: and b.list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE)
2097: UNION
2098: select /*+ ORDERED USE_NL(adj line qplh) index(adj OE_PRICE_ADJUSTMENTS_N1) dynamic_sampling(1) */ -- Bug No: 6753550
2099: adj.list_line_id created_from_list_line_id
2100: , line.line_index line_ind
2619: g Pls_Integer;
2620: n Pls_Integer;
2621:
2622: l_curr_line_index number := -1;--fnd_api.g_miss_num;
2623: l_auto_line_dtl_index_tbl qp_preq_grp.number_type;
2624: l_auto_override_dtl_id_tbl qp_preq_grp.number_type;
2625:
2626: l_adj_tbl QP_PREQ_PUB.adj_tbl_type;
2627: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2620: n Pls_Integer;
2621:
2622: l_curr_line_index number := -1;--fnd_api.g_miss_num;
2623: l_auto_line_dtl_index_tbl qp_preq_grp.number_type;
2624: l_auto_override_dtl_id_tbl qp_preq_grp.number_type;
2625:
2626: l_adj_tbl QP_PREQ_PUB.adj_tbl_type;
2627: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2628: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2626: l_adj_tbl QP_PREQ_PUB.adj_tbl_type;
2627: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2628: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2629:
2630: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2631: l_line_index_tbl QP_PREQ_GRP.number_type;
2632: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2627: l_adj_overflow_tbl QP_PREQ_PUB.adj_tbl_type;
2628: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2629:
2630: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2631: l_line_index_tbl QP_PREQ_GRP.number_type;
2632: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2628: l_frt_tbl QP_PREQ_PUB.frt_charge_tbl;
2629:
2630: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2631: l_line_index_tbl QP_PREQ_GRP.number_type;
2632: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2629:
2630: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2631: l_line_index_tbl QP_PREQ_GRP.number_type;
2632: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2630: l_list_line_id_tbl QP_PREQ_GRP.number_type;
2631: l_line_index_tbl QP_PREQ_GRP.number_type;
2632: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2631: l_line_index_tbl QP_PREQ_GRP.number_type;
2632: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2632: l_curr_line_index_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2633: l_line_id_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2634: l_line_dtl_index_tbl QP_PREQ_GRP.number_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2635: l_list_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2636: l_list_header_id_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2637: l_applied_flag_tbl QP_PREQ_GRP.flag_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2638: l_amount_changed_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2639: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2640: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2641: l_upd_adj_unit_price_tbl QP_PREQ_GRP.number_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2642: l_automatic_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2643: l_override_flag_tbl QP_PREQ_GRP.flag_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2644: l_pricing_group_sequence_tbl QP_PREQ_GRP.number_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2645: l_operand_calc_code_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2646: l_operand_value_tbl QP_PREQ_GRP.number_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2647: l_adjustment_amount_tbl QP_PREQ_GRP.number_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2648: l_unit_price_tbl QP_PREQ_GRP.number_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2649: l_accrual_flag_tbl QP_PREQ_GRP.flag_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2650: l_updated_flag_tbl QP_PREQ_GRP.flag_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2651: l_process_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2652: l_status_code_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2653: l_status_text_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2654: l_price_break_type_code_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2655: l_charge_type_code_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2656: l_charge_subtype_code_tbl QP_PREQ_GRP.varchar_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2657: l_rounding_factor_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2658: l_pricing_phase_id_tbl QP_PREQ_GRP.number_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2659: l_list_type_code_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2660: l_list_line_no_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2668: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2661: l_limit_code_tbl QP_PREQ_GRP.varchar_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2668: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2669: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2662: l_limit_text_tbl QP_PREQ_GRP.varchar_type;
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2668: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2669: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2670: --2388011
2663: l_modifier_level_tbl QP_PREQ_GRP.varchar_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2668: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2669: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2670: --2388011
2671: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2664: l_group_qty_tbl QP_PREQ_GRP.number_type;
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2668: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2669: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2670: --2388011
2671: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2672: --2388011
2665: l_group_amt_tbl QP_PREQ_GRP.number_type;
2666: l_line_sts_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2668: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2669: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2670: --2388011
2671: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2672: --2388011
2673: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2667: l_is_ldet_rec_tbl QP_PREQ_GRP.varchar_type;
2668: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
2669: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2670: --2388011
2671: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2672: --2388011
2673: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2674: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2669: l_line_priced_qty_tbl QP_PREQ_GRP.number_type;
2670: --2388011
2671: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2672: --2388011
2673: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2674: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2670: --2388011
2671: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2672: --2388011
2673: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2674: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2678: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2671: l_net_amount_flag_tbl QP_PREQ_GRP.flag_type;
2672: --2388011
2673: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2674: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2678: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2679: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2672: --2388011
2673: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2674: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2678: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2679: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2680: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2673: l_calculation_code_tbl QP_PREQ_GRP.varchar_type;
2674: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2678: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2679: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2680: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2681:
2674: l_catchweight_qty_tbl QP_PREQ_GRP.number_type;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2678: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2679: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2680: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2681:
2682: l_prev_line_start_index number :=0;
2675: l_actual_order_qty_tbl QP_PREQ_GRP.number_type;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2678: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2679: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2680: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2681:
2682: l_prev_line_start_index number :=0;
2683: l_cleanup_flag VARCHAR2(1) := QP_PREQ_PUB.G_YES;
2676: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
2677: l_ord_qty_tbl QP_PREQ_GRP.number_type;
2678: l_line_detail_type_code_tbl QP_PREQ_GRP.varchar_type;
2679: l_line_category_tbl QP_PREQ_GRP.varchar_type;
2680: l_price_flag_tbl QP_PREQ_GRP.flag_type;
2681:
2682: l_prev_line_start_index number :=0;
2683: l_cleanup_flag VARCHAR2(1) := QP_PREQ_PUB.G_YES;
2684: nrows CONSTANT number := 2;
2684: nrows CONSTANT number := 2;
2685:
2686: --added to check for duplicate list_line_ids
2687: l_dup_ind NUMBER;
2688: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2689: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2690: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2691: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2692: --added to check for duplicate list_line_ids
2685:
2686: --added to check for duplicate list_line_ids
2687: l_dup_ind NUMBER;
2688: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2689: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2690: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2691: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2692: --added to check for duplicate list_line_ids
2693:
2686: --added to check for duplicate list_line_ids
2687: l_dup_ind NUMBER;
2688: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2689: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2690: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2691: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2692: --added to check for duplicate list_line_ids
2693:
2694: BEGIN
2687: l_dup_ind NUMBER;
2688: l_dup_updated_flag QP_PREQ_GRP.FLAG_TYPE;
2689: l_dup_is_ldet_rec QP_PREQ_GRP.VARCHAR_TYPE;
2690: l_dup_uniq_ind QP_PREQ_GRP.VARCHAR_TYPE;
2691: l_dup_plsql_ind QP_PREQ_GRP.NUMBER_TYPE;
2692: --added to check for duplicate list_line_ids
2693:
2694: BEGIN
2695:
2692: --added to check for duplicate list_line_ids
2693:
2694: BEGIN
2695:
2696: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2697:
2698: IF l_debug = FND_API.G_TRUE THEN
2699: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2700: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2695:
2696: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2697:
2698: IF l_debug = FND_API.G_TRUE THEN
2699: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2700: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2701: --bug 3085453 handle pricing availability UI
2702: -- they pass reqtype ONT and insert adj into ldets
2703: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2696: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2697:
2698: IF l_debug = FND_API.G_TRUE THEN
2699: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2700: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2701: --bug 3085453 handle pricing availability UI
2702: -- they pass reqtype ONT and insert adj into ldets
2703: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2704: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2699: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2700: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2701: --bug 3085453 handle pricing availability UI
2702: -- they pass reqtype ONT and insert adj into ldets
2703: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2704: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2705: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2706: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2707: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2700: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2701: --bug 3085453 handle pricing availability UI
2702: -- they pass reqtype ONT and insert adj into ldets
2703: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2704: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2705: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2706: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2707: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2708: END IF;
2701: --bug 3085453 handle pricing availability UI
2702: -- they pass reqtype ONT and insert adj into ldets
2703: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2704: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2705: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2706: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2707: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2708: END IF;
2709:
2702: -- they pass reqtype ONT and insert adj into ldets
2703: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2704: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2705: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2706: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2707: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2708: END IF;
2709:
2710: --cleanup needs to be done only for OM as OC/OKC delete and insert adjustments
2703: QP_PREQ_GRP.engine_debug('begin fetch adj chk_cust '||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2704: QP_PREQ_GRP.engine_debug('begin fetch adj calc_flag '||p_calculate_flag);
2705: QP_PREQ_GRP.engine_debug('begin fetch adj round_flag '||p_rounding_flag);
2706: QP_PREQ_GRP.engine_debug('begin fetch adj view_code '||p_view_code);
2707: QP_PREQ_GRP.engine_debug('SL, with net_amt change, ordered by bucket, line_index.');
2708: END IF;
2709:
2710: --cleanup needs to be done only for OM as OC/OKC delete and insert adjustments
2711: --setting up cleanup_flag accordingly to not peform cleanup for adj if
2742: G_PBH_PLSQL_IND.delete;
2743: G_ORD_LVL_LDET_INDEX.delete; -- 3031108
2744:
2745: IF l_debug = FND_API.G_TRUE THEN
2746: QP_PREQ_GRP.engine_debug('G_MAX_DTL_INDEX '||G_MAX_DTL_INDEX);
2747:
2748: END IF;
2749:
2750: --to eliminate the duplicate manual adjustments in the temp table to prevent cleanup for them bug 2191169
2761: and ldet.created_from_list_line_id =
2762: ldet2.created_from_list_line_id);
2763:
2764: IF (l_debug = FND_API.G_TRUE) THEN
2765: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2766: END IF;
2767:
2768: -- bug 3359924 - AFTER APPLYING MANUAL PBH ENGINE RETURNS DUPLICATE RELATIONSHIP RECORDS
2769: UPDATE qp_npreq_rltd_lines_tmp rltd
2775: where ldet.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
2776: and ldet.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_PUB.G_BY_PBH);
2777:
2778: IF (l_debug = FND_API.G_TRUE) THEN
2779: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2780: END IF;
2781:
2782: -- IF p_event_code IS NULL
2783: -- and p_calculate_flag = QP_PREQ_GRP.G_CALCULATE_ONLY
2779: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2780: END IF;
2781:
2782: -- IF p_event_code IS NULL
2783: -- and p_calculate_flag = QP_PREQ_GRP.G_CALCULATE_ONLY
2784: -- THEN
2785:
2786: -- IF p_request_type_code = 'ONT'
2787: -- and p_view_code = 'ONTVIEW'
2786: -- IF p_request_type_code = 'ONT'
2787: -- and p_view_code = 'ONTVIEW'
2788: -- THEN
2789: IF l_debug = FND_API.G_TRUE THEN
2790: -- QP_PREQ_GRP.engine_debug('open ONT cur'||p_request_type_code);
2791: QP_PREQ_GRP.engine_debug('open ONT cur'||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2792: END IF;
2793:
2794: --bug 4900095 get service qty for lumpsum
2787: -- and p_view_code = 'ONTVIEW'
2788: -- THEN
2789: IF l_debug = FND_API.G_TRUE THEN
2790: -- QP_PREQ_GRP.engine_debug('open ONT cur'||p_request_type_code);
2791: QP_PREQ_GRP.engine_debug('open ONT cur'||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2792: END IF;
2793:
2794: --bug 4900095 get service qty for lumpsum
2795: IF QP_PREQ_GRP.G_Service_line_qty_tbl.COUNT = 0 THEN
2791: QP_PREQ_GRP.engine_debug('open ONT cur'||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2792: END IF;
2793:
2794: --bug 4900095 get service qty for lumpsum
2795: IF QP_PREQ_GRP.G_Service_line_qty_tbl.COUNT = 0 THEN
2796: QP_PREQ_PUB.Determine_svc_item_quantity;
2797: END IF;
2798:
2799: OPEN l_calculate_cur;
2866: l_prev_line_start_index := 0;
2867:
2868:
2869: IF l_debug = FND_API.G_TRUE THEN
2870: QP_PREQ_GRP.engine_debug('fetch cur');
2871: END IF;
2872:
2873:
2874: FETCH l_calculate_cur
2927: -- LIMIT nrows;
2928: EXIT WHEN l_list_line_id_tbl.COUNT = 0;
2929:
2930: IF l_list_line_id_tbl.COUNT > 0
2931: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
2932: and l_debug = FND_API.G_TRUE
2933: THEN
2934: for i in l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2935: LOOP
2933: THEN
2934: for i in l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2935: LOOP
2936: IF l_debug = FND_API.G_TRUE THEN
2937: QP_PREQ_GRP.engine_debug('list_line_id '||l_list_line_id_tbl(i)||
2938: 'line index '||l_line_index_tbl(i)||' is ldet '||
2939: l_is_ldet_rec_tbl(i)||' linetype '||l_line_type_code_tbl(i) ||
2940: 'line detail type code ' || l_line_detail_type_code_tbl(i)||
2941: ' line_category '||l_line_category_tbl(i)||' priceflag '||
2950: FOR i IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2951: LOOP
2952: d := d + 1;
2953: IF l_debug = FND_API.G_TRUE THEN
2954: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
2955: QP_PREQ_GRP.engine_debug('loop cur '||i);
2956:
2957: END IF;
2958: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
2951: LOOP
2952: d := d + 1;
2953: IF l_debug = FND_API.G_TRUE THEN
2954: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
2955: QP_PREQ_GRP.engine_debug('loop cur '||i);
2956:
2957: END IF;
2958: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
2959: qp_preq_grp.engine_debug('display details '
2954: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
2955: QP_PREQ_GRP.engine_debug('loop cur '||i);
2956:
2957: END IF;
2958: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
2959: qp_preq_grp.engine_debug('display details '
2960: ||l_list_line_id_tbl(i)||' line index '||l_line_index_tbl(i)
2961: ||' line detail index '||l_line_dtl_index_tbl(i)
2962: ||' auto '||l_automatic_flag_tbl(i)
2955: QP_PREQ_GRP.engine_debug('loop cur '||i);
2956:
2957: END IF;
2958: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
2959: qp_preq_grp.engine_debug('display details '
2960: ||l_list_line_id_tbl(i)||' line index '||l_line_index_tbl(i)
2961: ||' line detail index '||l_line_dtl_index_tbl(i)
2962: ||' auto '||l_automatic_flag_tbl(i)
2963: ||' overr '||l_override_flag_tbl(i)
2965: ||' applied '||l_applied_flag_tbl(i)
2966: ||' hdr id '||l_list_header_id_tbl(i)||' is ldet '
2967: ||l_is_ldet_rec_tbl(i)||' linetype '||l_line_type_code_tbl(i));
2968:
2969: qp_preq_grp.engine_debug('list_line_type ' || l_list_line_type_code_tbl(i)
2970: || 'modifier_level ' || l_modifier_level_tbl(i)
2971: || 'net_amount_flag ' || l_net_amount_flag_tbl(i)
2972: || 'is_ldet_rec ' || l_is_ldet_rec_tbl(i));
2973: END IF;
2998: /*
2999: l_dup_ind := l_line_index_tbl(i) + l_list_line_id_tbl(i);
3000:
3001: IF l_debug = FND_API.G_TRUE THEN
3002: QP_PREQ_GRP.engine_debug('Duplicate list line check '
3003: ||' line_index+list_line_id val: '||l_dup_ind);
3004: END IF;--l_debug
3005:
3006: IF l_dup_updated_flag.exists(l_dup_ind) THEN
3004: END IF;--l_debug
3005:
3006: IF l_dup_updated_flag.exists(l_dup_ind) THEN
3007: IF l_debug = FND_API.G_TRUE THEN
3008: QP_PREQ_GRP.engine_debug('Duplicate list line exists ');
3009: END IF;--l_debug
3010:
3011: IF l_dup_updated_flag(l_dup_ind) = QP_PREQ_PUB.G_YES
3012: and l_updated_flag_tbl(i) = QP_PREQ_PUB.G_NO THEN
3012: and l_updated_flag_tbl(i) = QP_PREQ_PUB.G_NO THEN
3013: --in this case the oe_price_adj record must be applied
3014: --so engine selected needs to be marked as deleted
3015: IF l_debug = FND_API.G_TRUE THEN
3016: QP_PREQ_GRP.engine_debug('Duplicate adj overridden ');
3017: END IF;--l_debug
3018: IF l_is_ldet_rec_tbl(i) in (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3019: QP_PREQ_PUB.G_LDET_LINE_TYPE) THEN
3020: IF l_debug = FND_API.G_TRUE THEN
3017: END IF;--l_debug
3018: IF l_is_ldet_rec_tbl(i) in (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3019: QP_PREQ_PUB.G_LDET_LINE_TYPE) THEN
3020: IF l_debug = FND_API.G_TRUE THEN
3021: QP_PREQ_GRP.engine_debug('Marking non-overrdn adj '
3022: ||'as deleted ');
3023: END IF;--l_debug
3024: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3025: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3031: := QP_PREQ_PUB.G_STATUS_DELETED;
3032: l_adj_tbl(l_dup_plsql_ind(l_dup_ind)).pricing_status_text
3033: := 'DUPLICATE MODIFIER PICKED UP';
3034: IF l_debug = FND_API.G_TRUE THEN
3035: QP_PREQ_GRP.engine_debug('Marking prev overdn deltd ');
3036: END IF;--l_debug
3037: --replace l_dup values w/current values
3038: l_dup_updated_flag(l_dup_ind) := l_updated_flag_tbl(i);
3039: l_dup_is_ldet_rec(l_dup_ind) := l_is_ldet_rec_tbl(i);
3041: ELSE --updated_flag is 'N'
3042: --in this case the engine selected record must be applied
3043: --so adj from oe_price_adj needs to be marked as deleted
3044: IF l_debug = FND_API.G_TRUE THEN
3045: QP_PREQ_GRP.engine_debug('Duplicate adj not overridden ');
3046: QP_PREQ_GRP.engine_debug('Prev adj is_ldet: '
3047: ||l_dup_is_ldet_rec(l_dup_ind));
3048: QP_PREQ_GRP.engine_debug('Current adj is_ldet: '
3049: ||l_is_ldet_rec_tbl(i));
3042: --in this case the engine selected record must be applied
3043: --so adj from oe_price_adj needs to be marked as deleted
3044: IF l_debug = FND_API.G_TRUE THEN
3045: QP_PREQ_GRP.engine_debug('Duplicate adj not overridden ');
3046: QP_PREQ_GRP.engine_debug('Prev adj is_ldet: '
3047: ||l_dup_is_ldet_rec(l_dup_ind));
3048: QP_PREQ_GRP.engine_debug('Current adj is_ldet: '
3049: ||l_is_ldet_rec_tbl(i));
3050: END IF;--l_debug
3044: IF l_debug = FND_API.G_TRUE THEN
3045: QP_PREQ_GRP.engine_debug('Duplicate adj not overridden ');
3046: QP_PREQ_GRP.engine_debug('Prev adj is_ldet: '
3047: ||l_dup_is_ldet_rec(l_dup_ind));
3048: QP_PREQ_GRP.engine_debug('Current adj is_ldet: '
3049: ||l_is_ldet_rec_tbl(i));
3050: END IF;--l_debug
3051: IF l_dup_is_ldet_rec(l_dup_ind) in
3052: (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3058: --it is from oe_price_adj
3059: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3060: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3061: IF l_debug = FND_API.G_TRUE THEN
3062: QP_PREQ_GRP.engine_debug('Marking curr adj deleted ');
3063: END IF;--l_debug
3064: ELSIF l_is_ldet_rec_tbl(i) in
3065: (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3066: QP_PREQ_PUB.G_LDET_LINE_TYPE)
3075: l_dup_updated_flag(l_dup_ind) := l_updated_flag_tbl(i);
3076: l_dup_is_ldet_rec(l_dup_ind) := l_is_ldet_rec_tbl(i);
3077: l_dup_plsql_ind(l_dup_ind) := d;
3078: IF l_debug = FND_API.G_TRUE THEN
3079: QP_PREQ_GRP.engine_debug('Marking prev adj deleted ');
3080: END IF;--l_debug
3081: ELSE--both the records have same is_ldet so delete one
3082: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3083: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3081: ELSE--both the records have same is_ldet so delete one
3082: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3083: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3084: IF l_debug = FND_API.G_TRUE THEN
3085: QP_PREQ_GRP.engine_debug('Marking else curr adj deltd');
3086: END IF;--l_debug
3087: END IF;--l_is_ldet_rec_tbl(i)
3088: END IF;--l_dup_updated_flag
3089: ELSE
3113: IF (l_adj_tbl(d).priced_quantity = 0
3114: and l_adj_tbl(d).unit_price <> 0)
3115: THEN
3116: IF l_debug = FND_API.G_TRUE THEN
3117: QP_PREQ_GRP.engine_debug('ldet.line_qty is zero');
3118: END IF;
3119: l_adj_tbl(d).priced_quantity := null;
3120: ELSE
3121: IF l_debug = FND_API.G_TRUE THEN
3118: END IF;
3119: l_adj_tbl(d).priced_quantity := null;
3120: ELSE
3121: IF l_debug = FND_API.G_TRUE THEN
3122: QP_PREQ_GRP.engine_debug('ldet.line_qty not zero');
3123: END IF;
3124: END IF;
3125: l_adj_tbl(d).line_priced_quantity := l_line_priced_qty_tbl(i);
3126: l_adj_tbl(d).updated_adjusted_unit_price :=
3172: IF l_curr_line_index <> l_line_index_tbl(i)
3173: THEN
3174: l_prev_line_start_index := i;
3175: IF l_debug = FND_API.G_TRUE THEN
3176: qp_preq_grp.engine_debug('auto_overr: new line');
3177: END IF; --Bug No 4033618
3178: l_curr_line_index := l_line_index_tbl(i);
3179: x := 0;
3180: l_auto_line_dtl_index_tbl.delete;
3212: l_auto_override_dtl_id_tbl(x) := l_list_line_id_tbl(i);
3213: -- l_adj_tbl(d).pricing_status_code :=
3214: -- QP_PREQ_PUB.G_STATUS_UPDATED;
3215: IF l_debug = FND_API.G_TRUE THEN
3216: qp_preq_grp.engine_debug('auto_overr: from adj tbl '
3217: ||l_line_dtl_index_tbl(i)||' adj id '
3218: ||l_list_line_id_tbl(i));
3219: END IF; --Bug No 4033618
3220: ELSIF l_curr_line_index = l_line_index_tbl(i)
3235: QP_PREQ_PUB.G_NO))
3236: */
3237: THEN
3238: IF l_debug = FND_API.G_TRUE THEN
3239: qp_preq_grp.engine_debug('auto_overr: from ldet tbl '
3240: ||l_adj_tbl(d).created_from_list_line_id
3241: ||' adj index '||l_adj_tbl(d).line_detail_index);
3242: END IF; --Bug No 4033618
3243: m := l_auto_line_dtl_index_tbl.FIRST;
3244: WHILE (m IS NOT NULL
3245: and l_auto_line_dtl_index_tbl.COUNT > 0)
3246: LOOP
3247: IF l_debug = FND_API.G_TRUE THEN
3248: qp_preq_grp.engine_debug('auto_overr: from auto_ov tbl '
3249: ||m||' adj id '||l_auto_override_dtl_id_tbl(m)
3250: ||' dtl index '||l_auto_line_dtl_index_tbl(m));
3251: END IF; --Bug No 4033618
3252: IF l_list_line_id_tbl(i) =
3252: IF l_list_line_id_tbl(i) =
3253: l_auto_override_dtl_id_tbl(m)
3254: THEN
3255: IF l_debug = FND_API.G_TRUE THEN
3256: QP_PREQ_GRP.engine_debug('duplicate hit'
3257: ||' '||l_list_line_id_tbl(i));
3258: END IF;
3259: l_adj_tbl(d).pricing_status_code :=
3260: QP_PREQ_GRP.G_STATUS_DELETED;
3256: QP_PREQ_GRP.engine_debug('duplicate hit'
3257: ||' '||l_list_line_id_tbl(i));
3258: END IF;
3259: l_adj_tbl(d).pricing_status_code :=
3260: QP_PREQ_GRP.G_STATUS_DELETED;
3261: l_adj_tbl(d).pricing_status_text :=
3262: 'DUPLICATE AUTO-OVERRIDEABLE';
3263: l_auto_override_dtl_id_tbl.delete(m);
3264: l_auto_line_dtl_index_tbl.delete(m);
3283: QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id) := null;
3284: END;
3285:
3286: IF l_debug = FND_API.G_TRUE THEN
3287: QP_PREQ_GRP.engine_debug(' PBH vol attr for list_line_id '
3288: ||l_adj_tbl(d).created_from_list_line_id||' attr '
3289: ||QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id));
3290: END IF;--l_debug
3291: END IF;--l_adj_tbl(d).created_from_list_line_type
3334: G_PBH_PLSQL_IND(l_line_dtl_index_tbl(i)) :=
3335: G_PBH_LINE_INDEX.COUNT;
3336: END IF;--l_adj_tbl(d).created_from_list_line_type
3337: IF l_debug = FND_API.G_TRUE THEN
3338: QP_PREQ_GRP.engine_debug('figuring out line_dtl_index '
3339: ||l_adj_tbl(d).line_detail_index);
3340: END IF;--l_debug
3341: END IF;--nvl(l_adj_tbl(d).is_ldet_rec
3342:
3342:
3343:
3344:
3345: IF l_debug = FND_API.G_TRUE THEN
3346: QP_PREQ_GRP.engine_debug('load tbl'||l_adj_tbl(d).line_detail_index
3347: ||' list_line_id '||l_adj_tbl(d).created_from_list_line_id
3348: ||' list_hdr_id '||l_adj_tbl(d).created_from_list_header_id
3349: ||' line dtl index '||l_adj_tbl(d).line_detail_index
3350: ||' operand '||l_adj_tbl(d).operand_value
3358: /*
3359: i := l_adj_tbl.NEXT(l_prev_line_start_index-1);
3360: g := 0;
3361: IF l_debug = FND_API.G_TRUE THEN
3362: QP_PREQ_GRP.engine_debug('last line starts at '||l_prev_line_start_index);
3363: END IF;
3364: WHILE i IS NOT NULL
3365: LOOP
3366: g := g + 1;
3370:
3371: l_adj_tbl.delete(l_prev_line_start_index,l_adj_tbl.COUNT);
3372:
3373: IF l_adj_tbl.COUNT > 0
3374: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
3375: THEN
3376: i := l_adj_tbl.first;
3377: WHILE i IS NOT NULL
3378: LOOP
3376: i := l_adj_tbl.first;
3377: WHILE i IS NOT NULL
3378: LOOP
3379: IF l_debug = FND_API.G_TRUE THEN
3380: QP_PREQ_GRP.engine_debug('list_line_id '||l_adj_tbl(i).line_detail_index);--||
3381: END IF;
3382: i := l_adj_tbl.next(i);
3383: END LOOP;
3384: END IF;
3386: n:=G_PBH_LINE_DTL_INDEX.FIRST;
3387: WHILE n IS NOT NULL
3388: LOOP
3389: IF l_debug = FND_API.G_TRUE THEN
3390: QP_PREQ_GRP.engine_debug('G_PBH_LINE_DTL_INDEX loop '
3391: ||' lineindex '||G_PBH_LINE_INDEX(n)
3392: ||' price_adj_id '||G_PBH_PRICE_ADJ_ID(n)
3393: ||' linedtlind '||G_PBH_LINE_DTL_INDEX(n));
3394: END IF;
3440: -- and p_view_name = 'ONTVIEW'
3441: -- THEN
3442: CLOSE l_calculate_cur;
3443: IF l_debug = FND_API.G_TRUE THEN
3444: QP_PREQ_GRP.engine_debug('close cur');
3445: END IF;
3446: -- END IF;
3447:
3448: --commenting to do the delete at all times
3449: -- IF p_event_code = ','
3450: -- and p_calculate_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
3451: -- THEN
3452: IF l_debug = FND_API.G_TRUE THEN
3453: QP_PREQ_GRP.engine_debug('deleting related lines');
3454: END IF;
3455: delete from qp_npreq_rltd_lines_tmp
3456: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3457: and relationship_type_code = QP_PREQ_PUB.G_PBH_LINE
3456: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3457: and relationship_type_code = QP_PREQ_PUB.G_PBH_LINE
3458: and pricing_status_text = G_CALC_INSERT;
3459: IF l_debug = FND_API.G_TRUE THEN
3460: QP_PREQ_GRP.engine_debug('deleted related lines '||SQL%ROWCOUNT);
3461: END IF;
3462: -- END IF;
3463:
3464: --This is to update the status code on the child lines on PBH for
3480: and ldet.created_from_list_line_id =
3481: ldet2.created_from_list_line_id);
3482:
3483: IF (l_debug = FND_API.G_TRUE) THEN
3484: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
3485: END IF;
3486:
3487: -- 4528043, mark any newly picked-up manual modifiers as 'deleted'
3488: -- to prevent OM from incorrectly displaying them in View Adjs
3488: -- to prevent OM from incorrectly displaying them in View Adjs
3489: -- 5413797, but don't delete any manual modifiers that appear new
3490: -- because they were repriced with a different quantity
3491: IF (QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES and
3492: QP_PREQ_GRP.G_MANUAL_ADJUSTMENTS_CALL_FLAG = QP_PREQ_PUB.G_NO)
3493: THEN
3494: UPDATE qp_npreq_ldets_tmp
3495: SET pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
3496: WHERE pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3498: AND applied_flag = QP_PREQ_PUB.G_NO
3499: and updated_flag = QP_PREQ_PUB.G_NO; -- 5413797
3500:
3501: IF (l_debug = FND_API.G_TRUE) THEN
3502: QP_PREQ_GRP.engine_debug(SQL%ROWCOUNT||' new manual modifier(s) marked as DELETED');
3503: END IF;
3504: END IF;
3505:
3506: --Fix for bug 2247167 Status on lines is unchanged although
3521: --update needs to be done
3522: -- IF p_calculate_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
3523: -- THEN
3524: IF l_debug = FND_API.G_TRUE THEN
3525: QP_PREQ_GRP.engine_debug('calculate_only call check to see'
3526: ||' if there are adjustments');
3527: END IF;
3528: QP_PREQ_PUB.update_unit_price(x_return_status,
3529: x_return_status_text);
3575:
3576:
3577:
3578: IF l_debug = FND_API.G_TRUE THEN
3579: QP_PREQ_GRP.engine_debug('end fetch adjustments');
3580:
3581:
3582: END IF;
3583: EXCEPTION
3583: EXCEPTION
3584: When PRICING_EXCEPTION Then
3585: x_return_status := FND_API.G_RET_STS_ERROR;
3586: IF l_debug = FND_API.G_TRUE THEN
3587: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3588: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||x_return_status_text);
3589: END IF;
3590: When OTHERS Then
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3584: When PRICING_EXCEPTION Then
3585: x_return_status := FND_API.G_RET_STS_ERROR;
3586: IF l_debug = FND_API.G_TRUE THEN
3587: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3588: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||x_return_status_text);
3589: END IF;
3590: When OTHERS Then
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: x_return_status_text := 'Error in fetch_adjustments: '||SQLERRM;
3590: When OTHERS Then
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: x_return_status_text := 'Error in fetch_adjustments: '||SQLERRM;
3593: IF l_debug = FND_API.G_TRUE THEN
3594: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3595: END IF;
3596: END fetch_adjustments;
3597:
3598: