[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;
1264:
1265: procedure copy_Header_to_request(
1266: p_request_type_code in varchar2
1267: ,p_calculate_price_flag in varchar2
1268: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1269: ) is
1270:
1271: l_line_index pls_integer := 0;
1272:
1333: G_CURRENCY_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).CURRENCY_CODE;
1334: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
1335: G_PERCENT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).PERCENT_PRICE;
1336: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
1337: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1338: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1339: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1340: if l_debug_level >0 then
1341: oe_debug_pub.add('the order line id'||G_LINE_ID_TBL(l_line_index));
1342: end if;
1343: G_ROUNDING_FLAG_TBL(l_line_index) := NULL;
1344: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1345: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
1346: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1347: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
1348:
1349: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
1350: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
1366: END copy_Header_to_request;
1367:
1368:
1369: PROCEDURE copy_Line_to_request(
1370: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1371: ,p_pricing_event in varchar2
1372: ,p_Request_Type_Code in varchar2
1373: ,p_honor_price_flag in VARCHAR2 Default 'Y'
1374: ,p_line_index in number
1491: END IF;
1492: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
1493: G_PERCENT_PRICE_TBL(l_line_index) := NULL;
1494: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
1495: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1496: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1497: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1498: IF l_debug_level > 0 THEN
1499: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( L_LINE_INDEX ) ) ;
1500: END IF;
1501: G_ROUNDING_FLAG_TBL(l_line_index) := NULL; -- AG
1502: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1503: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
1504: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
1505: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
1506: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
1507: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
1508: G_PRICE_LIST_ID_TBL(l_line_index) :=g_panda_rec_table(1).p_price_list_id;
1521:
1522:
1523:
1524: PROCEDURE set_pricing_control_record (
1525: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
1526: ,in_pricing_event in varchar2)IS
1527:
1528: --
1529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1530: --
1531: BEGIN
1532:
1533: l_control_rec.pricing_event := in_pricing_event;
1534: l_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1535: --l_control_rec.simulation_flag := 'Y';
1536: l_control_rec.simulation_flag :='Y';
1537: l_control_rec.gsa_check_flag := 'Y';
1538: l_control_rec.gsa_dup_check_flag := 'Y';
1549: PROCEDURE build_context_for_line(
1550: p_req_line_tbl_count in number,
1551: p_price_request_code in varchar2,
1552: p_item_type_code in varchar2,
1553: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1554: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
1555: p_line_index in number
1556: )IS
1557:
1550: p_req_line_tbl_count in number,
1551: p_price_request_code in varchar2,
1552: p_item_type_code in varchar2,
1553: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1554: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
1555: p_line_index in number
1556: )IS
1557:
1558: qp_attr_mapping_error exception;
1663: PROCEDURE build_context_for_header(
1664: p_req_line_tbl_count in number,
1665: p_price_request_code in varchar2,
1666: p_item_type_code in varchar2,
1667: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1668: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1669: )IS
1670:
1671: qp_attr_mapping_error exception;
1664: p_req_line_tbl_count in number,
1665: p_price_request_code in varchar2,
1666: p_item_type_code in varchar2,
1667: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1668: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1669: )IS
1670:
1671: qp_attr_mapping_error exception;
1672: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1772: procedure Append_attributes(
1773: p_header_id number default null
1774: ,p_Line_id number default null
1775: ,p_line_index number
1776: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1777: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1778: ,p_g_line_index in number
1779:
1780: ) is
1773: p_header_id number default null
1774: ,p_Line_id number default null
1775: ,p_line_index number
1776: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1777: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1778: ,p_g_line_index in number
1779:
1780: ) is
1781:
2701: END IF;
2702:
2703: END Append_attributes;
2704:
2705: PROCEDURE Append_attr_to_ttables(px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2706: )
2707: IS
2708: i number;
2709: k number;
2727: IF l_debug_level > 0 THEN
2728: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
2729: END IF;
2730:
2731: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
2732: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2733: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2734: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2735: ELSE
2728: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
2729: END IF;
2730:
2731: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
2732: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2733: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2734: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2735: ELSE
2736: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2730:
2731: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
2732: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2733: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2734: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2735: ELSE
2736: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2737: END IF;
2738: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
2732: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
2733: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
2734: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
2735: ELSE
2736: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2737: END IF;
2738: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
2739: IF l_debug_level > 0 THEN
2740: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
2739: IF l_debug_level > 0 THEN
2740: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
2741: END IF;
2742: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
2743: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
2744: G_ATTR_VALIDATED_FLAG_tbl(k) := 'N';
2745: G_ATTR_ATTRIBUTE_TYPE_tbl(k) := l_attribute_type;
2746: G_ATTR_PRICING_CONTEXT_tbl(k)
2747: := px_req_line_attr_tbl(i).pricing_context;
2746: G_ATTR_PRICING_CONTEXT_tbl(k)
2747: := px_req_line_attr_tbl(i).pricing_context;
2748: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
2749: := px_req_line_attr_tbl(i).pricing_attribute;
2750: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
2751: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2752: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
2753: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
2754: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
2747: := px_req_line_attr_tbl(i).pricing_context;
2748: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
2749: := px_req_line_attr_tbl(i).pricing_attribute;
2750: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
2751: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2752: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
2753: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
2754: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
2755: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
2748: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
2749: := px_req_line_attr_tbl(i).pricing_attribute;
2750: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
2751: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2752: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
2753: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
2754: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
2755: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
2756: G_ATTR_SETUP_VALUE_FROM_tbl(k):=NULL;
2774: END LOOP;
2775:
2776:
2777: --G_ATTR_LINE_INDEX_tbl(G_ATTR_LINE_INDEX_tbl.count+1):=2;
2778: --G_ATTR_ATTRIBUTE_LEVEL_tbl(G_ATTR_LINE_INDEX_tbl.count):=QP_PREQ_GRP.G_LINE_LEVEL;
2779:
2780: --Temp_tables population ends
2781:
2782: end append_attr_to_TTables;
2784: PROCEDURE Reset_All_Tbls
2785: AS
2786:
2787:
2788: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
2789: --
2790: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2791: --
2792: BEGIN
2866: BEGIN
2867: IF l_debug_level > 0 THEN
2868: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
2869: END IF;
2870: QP_PREQ_GRP.INSERT_LINES2
2871: (p_LINE_INDEX => G_LINE_INDEX_TBL,
2872: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
2873: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
2874: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:
2919: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
2920: QP_PREQ_GRP.INSERT_LINE_ATTRS2
2921: ( G_ATTR_LINE_INDEX_tbl,
2922: G_ATTR_LINE_DETAIL_INDEX_tbl ,
2923: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
2924: G_ATTR_ATTRIBUTE_TYPE_tbl ,
2972: END POPULATE_TEMP_TABLE;
2973:
2974:
2975: PROCEDURE Populate_results
2976: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2977: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2978: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2979: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2980: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2973:
2974:
2975: PROCEDURE Populate_results
2976: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2977: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2978: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2979: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2980: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2981: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2974:
2975: PROCEDURE Populate_results
2976: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2977: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2978: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2979: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2980: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2981: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2982: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2975: PROCEDURE Populate_results
2976: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2977: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2978: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2979: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2980: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2981: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2982: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2983: AS
2976: (x_line_tbl OUT nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
2977: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2978: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2979: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2980: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2981: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2982: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2983: AS
2984:
2977: x_line_qual_tbl OUT nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2978: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2979: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2980: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2981: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2982: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2983: AS
2984:
2985: CURSOR l_lines_cur IS
2978: x_line_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2979: x_line_detail_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2980: x_line_detail_qual_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2981: x_line_detail_attr_tbl OUT nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2982: x_related_lines_tbl OUT nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
2983: AS
2984:
2985: CURSOR l_lines_cur IS
2986: SELECT LINE_INDEX,
3029: QPLAT.PRICING_STATUS_TEXT
3030: FROM QP_PREQ_LDETS_TMP QPLD ,
3031: QP_PREQ_LINE_ATTRS_TMP QPLAT
3032: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3033: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3034: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3035: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;
3036:
3037:
3046: QPLAT_PRICING.VALIDATED_FLAG
3047: FROM QP_PREQ_LDETS_TMP QPLD ,
3048: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3049: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3050: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3051: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3052: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;
3053:
3054:
3116: b.COMMENTS
3117: FROM QP_PREQ_LDETS_TMP a,
3118: QP_LIST_LINES b
3119: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
3120: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
3121:
3122:
3123: CURSOR l_rltd_lines_cur IS
3124: SELECT LINE_INDEX,
3128: RELATED_LINE_DETAIL_INDEX,
3129: PRICING_STATUS_CODE,
3130: PRICING_STATUS_TEXT
3131: FROM QP_PREQ_RLTD_LINES_TMP
3132: WHERE PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3133: ORDER BY SETUP_VALUE_FROM;
3134:
3135:
3136: I PLS_INTEGER :=1;
3138: l_expiration_period_end_date Date;
3139: l_status_code VARCHAR2(30);
3140: l_status_text VARCHAR2(30);
3141: E_ROUTINE_ERROR EXCEPTION;
3142: l_routine VARCHAR2(240):='QP_PREQ_GRP.POPULATE_OUTPUT';
3143:
3144: BEGIN
3145:
3146:
3267: --Populate Qualifier detail
3268: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3269: oe_debug_pub.add('----Before populate x_qual_tbl-----');
3270: --END IF;
3271: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
3272: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;
3273: x_line_detail_qual_tbl(I).QUALIFIER_CONTEXT := l_qual.CONTEXT;
3274: x_line_detail_qual_tbl(I).QUALIFIER_ATTRIBUTE := l_qual.ATTRIBUTE;
3275: x_line_detail_qual_tbl(I).QUALIFIER_ATTR_VALUE_FROM := l_qual.SETUP_VALUE_FROM;
3328:
3329:
3330:
3331:
3332: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3333: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3334: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3335: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3336: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3329:
3330:
3331:
3332: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3333: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3334: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3335: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3336: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3337: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3330:
3331:
3332: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3333: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3334: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3335: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3336: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3337: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3338: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3331:
3332: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3333: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3334: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3335: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3336: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3337: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3338: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3339: out_child_detail_type out nocopy varchar2
3332: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
3333: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3334: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3335: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3336: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3337: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3338: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3339: out_child_detail_type out nocopy varchar2
3340:
3333: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3334: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3335: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3336: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3337: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3338: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3339: out_child_detail_type out nocopy varchar2
3340:
3341: ) IS
3334: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3335: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3336: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3337: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
3338: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3339: out_child_detail_type out nocopy varchar2
3340:
3341: ) IS
3342:
3341: ) IS
3342:
3343: l_return_status varchar2(10);
3344: l_return_status_Text varchar2(240) ;
3345: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3346: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3347: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3342:
3343: l_return_status varchar2(10);
3344: l_return_status_Text varchar2(240) ;
3345: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3346: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3347: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3350: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3343: l_return_status varchar2(10);
3344: l_return_status_Text varchar2(240) ;
3345: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3346: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3347: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3350: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3351: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3344: l_return_status_Text varchar2(240) ;
3345: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3346: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3347: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3350: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3351: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3352: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3345: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
3346: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3347: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3350: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3351: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3352: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3353: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type; --added for bug 12541442
3346: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
3347: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3350: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3351: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3352: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3353: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type; --added for bug 12541442
3354: --
3347: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3350: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3351: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3352: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3353: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type; --added for bug 12541442
3354: --
3355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3348: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
3349: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
3350: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
3351: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3352: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3353: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type; --added for bug 12541442
3354: --
3355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3356: --
3355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3356: --
3357: BEGIN
3358:
3359: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
3360: reset_all_tbls;
3361:
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'SETTING REQUEST ID' , 1 ) ;
3365:
3366: qp_price_request_context.set_request_id;
3367:
3368: IF l_debug_level > 0 THEN
3369: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
3370: END IF;
3371:
3372:
3373: OE_ORDER_PUB.G_HDR:=NULL;
3715:
3716:
3717: PROCEDURE copy_attribs_to_Req(
3718: p_line_index number
3719: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3720: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3721: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3722: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3723: ) IS
3716:
3717: PROCEDURE copy_attribs_to_Req(
3718: p_line_index number
3719: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3720: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3721: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3722: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3723: ) IS
3724:
3858: END IF;
3859:
3860:
3861: IF in_line_Type_code ='LINE' and
3862: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3863: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3864: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3859:
3860:
3861: IF in_line_Type_code ='LINE' and
3862: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3863: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3864: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3860:
3861: IF in_line_Type_code ='LINE' and
3862: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3863: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3864: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3861: IF in_line_Type_code ='LINE' and
3862: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3863: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3864: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3864: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3872: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3872: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3873: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3872: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3873: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3874: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3872: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3873: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3874: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3875: then
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3872: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3873: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3874: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3875: then
3876:
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3872: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3873: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3874: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3875: then
3876:
3877: l_return_status := 'E';
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3872: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3873: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3874: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3875: then
3876:
3877: l_return_status := 'E';
3878:
3885: l_price_list := in_price_list_id;
3886: End;
3887: END IF;
3888:
3889: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3890:
3891: IF l_debug_level > 0 THEN
3892: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
3893: END IF;
3911: OE_MSG_PUB.Add;
3912:
3913: END IF;
3914:
3915: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3916:
3917: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
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_FORMULA_ERROR then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3924: OE_MSG_PUB.Add;
3925:
3926: ELSIF in_status_code in
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3924: OE_MSG_PUB.Add;
3925:
3926: ELSIF in_status_code in
3927: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3928: FND_API.G_RET_STS_ERROR) then
3929: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3930: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3931: OE_MSG_PUB.Add;
3929: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3930: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3931: OE_MSG_PUB.Add;
3932:
3933: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3934: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3935: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3936: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3937: OE_MSG_PUB.Add;
3935: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3936: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3937: OE_MSG_PUB.Add;
3938:
3939: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3940: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3941:
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3979:
3980: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3981: OE_MSG_PUB.Add;
3982:
3983: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3984: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3985: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3986: in_status_text);
3987: OE_MSG_PUB.Add;
3985: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3986: in_status_text);
3987: OE_MSG_PUB.Add;
3988:
3989: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3990: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3991: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3992: in_status_text);
3993: OE_MSG_PUB.Add;
3991: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3992: in_status_text);
3993: OE_MSG_PUB.Add;
3994:
3995: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3996: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3997: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3998: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3999: OE_MSG_PUB.Add;
4015: l_return_status := 'E';
4016: --RAISE FND_API.G_EXC_ERROR;*/
4017:
4018: ELSIF in_line_Type_code ='LINE' and
4019: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
4020:
4021: IF l_debug_level > 0 THEN
4022: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4023: END IF;
4025: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4026: OE_MSG_PUB.Add;
4027:
4028: ELSIF in_line_Type_code ='LINE' and in_status_code in
4029: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4030: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4031: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4032: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4033: and in_price_flag IN ('Y','P')
4026: OE_MSG_PUB.Add;
4027:
4028: ELSIF in_line_Type_code ='LINE' and in_status_code in
4029: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4030: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4031: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4032: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4033: and in_price_flag IN ('Y','P')
4034: --we do not want to go in this loop if price_flag is set up 'N' because
4027:
4028: ELSIF in_line_Type_code ='LINE' and in_status_code in
4029: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4030: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4031: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4032: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4033: and in_price_flag IN ('Y','P')
4034: --we do not want to go in this loop if price_flag is set up 'N' because
4035: --engine doesn't look at the line and will not return adjustments. In this
4028: ELSIF in_line_Type_code ='LINE' and in_status_code in
4029: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4030: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
4031: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
4032: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
4033: and in_price_flag IN ('Y','P')
4034: --we do not want to go in this loop if price_flag is set up 'N' because
4035: --engine doesn't look at the line and will not return adjustments. In this
4036: --case we DON't want to remove the adjustments that engine doesn't return.
4085:
4086:
4087: ELSIF -- Process header level adjustments
4088: in_line_type_code ='ORDER' and
4089: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
4090: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4091: --In this case even engine doesn't update the order (status = UNCHANGED)
4092: --because of one of the lined is frozen,
4093: --there can be some order level adjustments in database which
4086:
4087: ELSIF -- Process header level adjustments
4088: in_line_type_code ='ORDER' and
4089: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
4090: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4091: --In this case even engine doesn't update the order (status = UNCHANGED)
4092: --because of one of the lined is frozen,
4093: --there can be some order level adjustments in database which
4094: --need to be pulled out by append_adjustment_lines routine
4091: --In this case even engine doesn't update the order (status = UNCHANGED)
4092: --because of one of the lined is frozen,
4093: --there can be some order level adjustments in database which
4094: --need to be pulled out by append_adjustment_lines routine
4095: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
4096: Then
4097: IF l_debug_level > 0 THEN
4098: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
4099: END IF;