[Home] [Help]
133: */
134: -- Till here it would go
135: --Global Tables required for temp_table population.
136:
137: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
138: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
139: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134: -- Till here it would go
135: --Global Tables required for temp_table population.
136:
137: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
138: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
139: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
135: --Global Tables required for temp_table population.
136:
137: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
138: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
139: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
136:
137: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
138: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
139: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
137: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
138: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
139: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
139: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
139: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
140: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
141: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
142: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
143: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
144: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
145: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
146: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
147: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
148: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
149: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
150: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
151: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
152: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
153: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
154: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
155: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
156: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
157: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
158: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
159: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
160: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
161: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
162: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
163: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
164: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
165: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
166: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
167: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
168: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
169: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
170: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
171: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
172: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
173: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
174: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
175: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
176: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
177: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
178: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
179: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
180: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
181: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
182: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
183: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
184: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
185: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
186: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
187: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
188: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
189: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
190: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
191: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
199: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
192: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
199: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
200: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
193: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
199: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
200: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
201: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
194: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
199: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
200: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
201: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
202: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
195: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
199: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
200: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
201: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
202: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
203:
196: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
199: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
200: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
201: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
202: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
203:
204:
197: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
198: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
199: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
200: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
201: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
202: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
203:
204:
205: --g_panda_rec_table panda_rec_table;
1261:
1262: procedure copy_Header_to_request(
1263: p_request_type_code in varchar2
1264: ,p_calculate_price_flag in varchar2
1265: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1266: ) is
1267:
1268: l_line_index pls_integer := 0;
1269:
1330: G_CURRENCY_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).CURRENCY_CODE;
1331: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
1332: G_PERCENT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).PERCENT_PRICE;
1333: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
1334: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1335: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1336: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1337: if l_debug_level >0 then
1338: oe_debug_pub.add('the order line id'||G_LINE_ID_TBL(l_line_index));
1339: end if;
1340: G_ROUNDING_FLAG_TBL(l_line_index) := NULL;
1341: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1342: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
1343: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1344: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
1345:
1346: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
1347: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
1363: END copy_Header_to_request;
1364:
1365:
1366: PROCEDURE copy_Line_to_request(
1367: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1368: ,p_pricing_event in varchar2
1369: ,p_Request_Type_Code in varchar2
1370: ,p_honor_price_flag in VARCHAR2 Default 'Y'
1371: ,p_line_index in number
1488: END IF;
1489: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
1490: G_PERCENT_PRICE_TBL(l_line_index) := NULL;
1491: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
1492: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1493: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1494: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1495: IF l_debug_level > 0 THEN
1496: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( L_LINE_INDEX ) ) ;
1497: END IF;
1498: G_ROUNDING_FLAG_TBL(l_line_index) := NULL; -- AG
1499: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1500: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
1501: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
1502: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
1503: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
1504: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
1505: G_PRICE_LIST_ID_TBL(l_line_index) :=g_panda_rec_table(1).p_price_list_id;
1518:
1519:
1520:
1521: PROCEDURE set_pricing_control_record (
1522: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
1523: ,in_pricing_event in varchar2)IS
1524:
1525: --
1526: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1527: --
1528: BEGIN
1529:
1530: l_control_rec.pricing_event := in_pricing_event;
1531: l_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1532: --l_control_rec.simulation_flag := 'Y';
1533: l_control_rec.simulation_flag :='Y';
1534: l_control_rec.gsa_check_flag := 'Y';
1535: l_control_rec.gsa_dup_check_flag := 'Y';
1546: PROCEDURE build_context_for_line(
1547: p_req_line_tbl_count in number,
1548: p_price_request_code in varchar2,
1549: p_item_type_code in varchar2,
1550: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1551: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
1552: p_line_index in number
1553: )IS
1554:
1547: p_req_line_tbl_count in number,
1548: p_price_request_code in varchar2,
1549: p_item_type_code in varchar2,
1550: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1551: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
1552: p_line_index in number
1553: )IS
1554:
1555: qp_attr_mapping_error exception;
1660: PROCEDURE build_context_for_header(
1661: p_req_line_tbl_count in number,
1662: p_price_request_code in varchar2,
1663: p_item_type_code in varchar2,
1664: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1665: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1666: )IS
1667:
1668: qp_attr_mapping_error exception;
1661: p_req_line_tbl_count in number,
1662: p_price_request_code in varchar2,
1663: p_item_type_code in varchar2,
1664: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1665: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1666: )IS
1667:
1668: qp_attr_mapping_error exception;
1669: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1767: procedure Append_attributes(
1768: p_header_id number default null
1769: ,p_Line_id number default null
1770: ,p_line_index number
1771: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1772: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1773: ,p_g_line_index in number
1774:
1775: ) is
1768: p_header_id number default null
1769: ,p_Line_id number default null
1770: ,p_line_index number
1771: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1772: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1773: ,p_g_line_index in number
1774:
1775: ) is
1776:
2696: END IF;
2697:
2698: END Append_attributes;
2699:
2700: PROCEDURE Append_attr_to_ttables(px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2701: )
2702: IS
2703: i number;
2704: k number;
2722: IF l_debug_level > 0 THEN
2723: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
2724: END IF;
2725:
2726: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
2727: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2728: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2729: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2730: ELSE
2723: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
2724: END IF;
2725:
2726: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
2727: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2728: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2729: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2730: ELSE
2731: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2725:
2726: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
2727: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2728: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2729: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2730: ELSE
2731: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2732: END IF;
2733: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
2727: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2728: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2729: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2730: ELSE
2731: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2732: END IF;
2733: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
2734: IF l_debug_level > 0 THEN
2735: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
2734: IF l_debug_level > 0 THEN
2735: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
2736: END IF;
2737: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
2738: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
2739: G_ATTR_VALIDATED_FLAG_tbl(k) := 'N';
2740: G_ATTR_ATTRIBUTE_TYPE_tbl(k) := l_attribute_type;
2741: G_ATTR_PRICING_CONTEXT_tbl(k)
2742: := px_req_line_attr_tbl(i).pricing_context;
2741: G_ATTR_PRICING_CONTEXT_tbl(k)
2742: := px_req_line_attr_tbl(i).pricing_context;
2743: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
2744: := px_req_line_attr_tbl(i).pricing_attribute;
2745: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
2746: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2747: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
2748: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
2749: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
2742: := px_req_line_attr_tbl(i).pricing_context;
2743: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
2744: := px_req_line_attr_tbl(i).pricing_attribute;
2745: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
2746: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2747: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
2748: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
2749: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
2750: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
2743: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
2744: := px_req_line_attr_tbl(i).pricing_attribute;
2745: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
2746: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2747: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
2748: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
2749: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
2750: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
2751: G_ATTR_SETUP_VALUE_FROM_tbl(k):=NULL;
2769: END LOOP;
2770:
2771:
2772: --G_ATTR_LINE_INDEX_tbl(G_ATTR_LINE_INDEX_tbl.count+1):=2;
2773: --G_ATTR_ATTRIBUTE_LEVEL_tbl(G_ATTR_LINE_INDEX_tbl.count):=QP_PREQ_GRP.G_LINE_LEVEL;
2774:
2775: --Temp_tables population ends
2776:
2777: end append_attr_to_TTables;
2779: PROCEDURE Reset_All_Tbls
2780: AS
2781:
2782:
2783: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
2784: --
2785: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2786: --
2787: BEGIN
2861: BEGIN
2862: IF l_debug_level > 0 THEN
2863: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
2864: END IF;
2865: QP_PREQ_GRP.INSERT_LINES2
2866: (p_LINE_INDEX => G_LINE_INDEX_TBL,
2867: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
2868: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
2869: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913:
2914: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
2915: QP_PREQ_GRP.INSERT_LINE_ATTRS2
2916: ( G_ATTR_LINE_INDEX_tbl,
2917: G_ATTR_LINE_DETAIL_INDEX_tbl ,
2918: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
2919: G_ATTR_ATTRIBUTE_TYPE_tbl ,
2967: END POPULATE_TEMP_TABLE;
2968:
2969:
2970: PROCEDURE Populate_results
2971: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2972: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2973: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2974: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2975: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2968:
2969:
2970: PROCEDURE Populate_results
2971: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2972: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2973: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2974: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2975: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2976: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2969:
2970: PROCEDURE Populate_results
2971: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2972: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2973: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2974: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2975: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2976: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2977: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2970: PROCEDURE Populate_results
2971: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2972: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2973: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2974: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2975: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2976: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2977: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2978: AS
2971: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2972: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2973: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2974: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2975: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2976: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2977: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2978: AS
2979:
2972: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2973: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2974: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2975: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2976: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2977: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2978: AS
2979:
2980: CURSOR l_lines_cur IS
2973: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2974: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2975: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2976: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2977: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2978: AS
2979:
2980: CURSOR l_lines_cur IS
2981: SELECT LINE_INDEX,
3024: QPLAT.PRICING_STATUS_TEXT
3025: FROM QP_PREQ_LDETS_TMP QPLD ,
3026: QP_PREQ_LINE_ATTRS_TMP QPLAT
3027: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3028: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3029: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3030: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;
3031:
3032:
3041: QPLAT_PRICING.VALIDATED_FLAG
3042: FROM QP_PREQ_LDETS_TMP QPLD ,
3043: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3044: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3045: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3046: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3047: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;
3048:
3049:
3111: b.COMMENTS
3112: FROM QP_PREQ_LDETS_TMP a,
3113: QP_LIST_LINES b
3114: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
3115: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
3116:
3117:
3118: CURSOR l_rltd_lines_cur IS
3119: SELECT LINE_INDEX,
3123: RELATED_LINE_DETAIL_INDEX,
3124: PRICING_STATUS_CODE,
3125: PRICING_STATUS_TEXT
3126: FROM QP_PREQ_RLTD_LINES_TMP
3127: WHERE PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3128: ORDER BY SETUP_VALUE_FROM;
3129:
3130:
3131: I PLS_INTEGER :=1;
3133: l_expiration_period_end_date Date;
3134: l_status_code VARCHAR2(30);
3135: l_status_text VARCHAR2(30);
3136: E_ROUTINE_ERROR EXCEPTION;
3137: l_routine VARCHAR2(240):='QP_PREQ_GRP.POPULATE_OUTPUT';
3138:
3139: BEGIN
3140:
3141:
3262: --Populate Qualifier detail
3263: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3264: oe_debug_pub.add('----Before populate x_qual_tbl-----');
3265: --END IF;
3266: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
3267: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;
3268: x_line_detail_qual_tbl(I).QUALIFIER_CONTEXT := l_qual.CONTEXT;
3269: x_line_detail_qual_tbl(I).QUALIFIER_ATTRIBUTE := l_qual.ATTRIBUTE;
3270: x_line_detail_qual_tbl(I).QUALIFIER_ATTR_VALUE_FROM := l_qual.SETUP_VALUE_FROM;
3323:
3324:
3325:
3326:
3327: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3328: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3329: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3330: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3331: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3324:
3325:
3326:
3327: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3328: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3329: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3330: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3331: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3332: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3325:
3326:
3327: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3328: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3329: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3330: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3331: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3332: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3333: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3326:
3327: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3328: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3329: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3330: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3331: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3332: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3333: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3334: out_child_detail_type out nocopy varchar2
3327: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3328: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3329: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3330: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3331: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3332: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3333: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3334: out_child_detail_type out nocopy varchar2
3335:
3328: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3329: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3330: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3331: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3332: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3333: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3334: out_child_detail_type out nocopy varchar2
3335:
3336: ) IS
3329: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3330: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3331: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3332: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3333: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3334: out_child_detail_type out nocopy varchar2
3335:
3336: ) IS
3337:
3336: ) IS
3337:
3338: l_return_status varchar2(10);
3339: l_return_status_Text varchar2(240) ;
3340: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3341: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3342: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3337:
3338: l_return_status varchar2(10);
3339: l_return_status_Text varchar2(240) ;
3340: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3341: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3342: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3345: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3338: l_return_status varchar2(10);
3339: l_return_status_Text varchar2(240) ;
3340: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3341: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3342: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3345: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3346: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3339: l_return_status_Text varchar2(240) ;
3340: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3341: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3342: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3345: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3346: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3347: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3340: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3341: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3342: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3345: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3346: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3347: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3348:
3341: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3342: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3345: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3346: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3347: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3348:
3349: --
3342: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3345: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3346: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3347: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3348:
3349: --
3350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3343: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3344: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3345: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3346: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3347: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3348:
3349: --
3350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3351: --
3350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3351: --
3352: BEGIN
3353:
3354: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
3355: reset_all_tbls;
3356:
3357: IF l_debug_level > 0 THEN
3358: oe_debug_pub.add( 'SETTING REQUEST ID' , 1 ) ;
3360:
3361: qp_price_request_context.set_request_id;
3362:
3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
3365: END IF;
3366:
3367:
3368: OE_ORDER_PUB.G_HDR:=NULL;
3698:
3699:
3700: PROCEDURE copy_attribs_to_Req(
3701: p_line_index number
3702: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3703: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3704: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3705: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3706: ) IS
3699:
3700: PROCEDURE copy_attribs_to_Req(
3701: p_line_index number
3702: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3703: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3704: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3705: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3706: ) IS
3707:
3841: END IF;
3842:
3843:
3844: IF in_line_Type_code ='LINE' and
3845: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3846: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3847: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3842:
3843:
3844: IF in_line_Type_code ='LINE' and
3845: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3846: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3847: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3843:
3844: IF in_line_Type_code ='LINE' and
3845: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3846: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3847: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3844: IF in_line_Type_code ='LINE' and
3845: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3846: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3847: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3847: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3855: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3855: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3856: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3855: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3856: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3857: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3855: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3856: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3857: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3858: then
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3855: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3856: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3857: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3858: then
3859:
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3855: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3856: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3857: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3858: then
3859:
3860: l_return_status := 'E';
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3855: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3856: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3857: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3858: then
3859:
3860: l_return_status := 'E';
3861:
3868: l_price_list := in_price_list_id;
3869: End;
3870: END IF;
3871:
3872: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3873:
3874: IF l_debug_level > 0 THEN
3875: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
3876: END IF;
3894: OE_MSG_PUB.Add;
3895:
3896: END IF;
3897:
3898: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3899:
3900: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3901: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3901: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3903: OE_MSG_PUB.Add;
3904:
3905: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3906: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3907: OE_MSG_PUB.Add;
3908:
3909: ELSIF in_status_code in
3906: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3907: OE_MSG_PUB.Add;
3908:
3909: ELSIF in_status_code in
3910: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3911: FND_API.G_RET_STS_ERROR) then
3912: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3914: OE_MSG_PUB.Add;
3912: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3914: OE_MSG_PUB.Add;
3915:
3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:
3922: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3962:
3963: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3964: OE_MSG_PUB.Add;
3965:
3966: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3967: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3968: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3969: in_status_text);
3970: OE_MSG_PUB.Add;
3968: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3969: in_status_text);
3970: OE_MSG_PUB.Add;
3971:
3972: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3973: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3974: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3975: in_status_text);
3976: OE_MSG_PUB.Add;
3974: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3975: in_status_text);
3976: OE_MSG_PUB.Add;
3977:
3978: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3979: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3980: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3981: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3982: OE_MSG_PUB.Add;
3998: l_return_status := 'E';
3999: --RAISE FND_API.G_EXC_ERROR;*/
4000:
4001: ELSIF in_line_Type_code ='LINE' and
4002: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
4003:
4004: IF l_debug_level > 0 THEN
4005: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4006: END IF;
4008: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4009: OE_MSG_PUB.Add;
4010:
4011: ELSIF in_line_Type_code ='LINE' and in_status_code in
4012: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4013: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4014: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4015: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4016: and in_price_flag IN ('Y','P')
4009: OE_MSG_PUB.Add;
4010:
4011: ELSIF in_line_Type_code ='LINE' and in_status_code in
4012: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4013: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4014: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4015: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4016: and in_price_flag IN ('Y','P')
4017: --we do not want to go in this loop if price_flag is set up 'N' because
4010:
4011: ELSIF in_line_Type_code ='LINE' and in_status_code in
4012: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4013: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4014: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4015: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4016: and in_price_flag IN ('Y','P')
4017: --we do not want to go in this loop if price_flag is set up 'N' because
4018: --engine doesn't look at the line and will not return adjustments. In this
4011: ELSIF in_line_Type_code ='LINE' and in_status_code in
4012: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4013: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4014: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4015: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4016: and in_price_flag IN ('Y','P')
4017: --we do not want to go in this loop if price_flag is set up 'N' because
4018: --engine doesn't look at the line and will not return adjustments. In this
4019: --case we DON't want to remove the adjustments that engine doesn't return.
4068:
4069:
4070: ELSIF -- Process header level adjustments
4071: in_line_type_code ='ORDER' and
4072: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
4073: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4074: --In this case even engine doesn't update the order (status = UNCHANGED)
4075: --because of one of the lined is frozen,
4076: --there can be some order level adjustments in database which
4069:
4070: ELSIF -- Process header level adjustments
4071: in_line_type_code ='ORDER' and
4072: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
4073: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4074: --In this case even engine doesn't update the order (status = UNCHANGED)
4075: --because of one of the lined is frozen,
4076: --there can be some order level adjustments in database which
4077: --need to be pulled out by append_adjustment_lines routine
4074: --In this case even engine doesn't update the order (status = UNCHANGED)
4075: --because of one of the lined is frozen,
4076: --there can be some order level adjustments in database which
4077: --need to be pulled out by append_adjustment_lines routine
4078: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
4079: Then
4080: IF l_debug_level > 0 THEN
4081: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
4082: END IF;