[Home] [Help]
20: g_upgrade_ship_from_org_id number;
21:
22: --Global Tables required for temp_table population.
23:
24: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
25: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
21:
22: --Global Tables required for temp_table population.
23:
24: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
25: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
22: --Global Tables required for temp_table population.
23:
24: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
25: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
23:
24: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
25: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
24: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
25: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
25: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
32: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
33: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
34: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
38: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
39: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
40: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
43: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
44: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
45: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
50: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
51: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
59: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
61: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
67: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
70: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
87: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
80: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
87: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
87: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
82: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
87: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
90:
83: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
87: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
90:
91:
84: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
87: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
90:
91:
92: --g_panda_rec_table panda_rec_table;
1911:
1912: procedure copy_Header_to_request(
1913: p_request_type_code in varchar2
1914: ,p_calculate_price_flag in varchar2
1915: -- ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1916: ,px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
1917: ) is
1918:
1919: l_line_index pls_integer := 0;
1981: G_CURRENCY_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).CURRENCY_CODE;
1982: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
1983: G_PERCENT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).PERCENT_PRICE;
1984: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
1985: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1986: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1987: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1988: if l_debug_level >0 then
1989: oe_debug_pub.add('the order line id'||G_LINE_ID_TBL(l_line_index));
1990: end if;
1991: G_ROUNDING_FLAG_TBL(l_line_index) := NULL;
1992: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1993: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
1994: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1995: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
1996:
1997: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
1998: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
2014: END copy_Header_to_request;
2015:
2016:
2017: PROCEDURE copy_Line_to_request(
2018: -- px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
2019: px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
2020: ,p_pricing_event in varchar2
2021: ,p_Request_Type_Code in varchar2
2022: ,p_honor_price_flag in VARCHAR2 Default 'Y'
2146: END IF;
2147: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
2148: G_PERCENT_PRICE_TBL(l_line_index) := NULL;
2149: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
2150: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
2151: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
2152: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( L_LINE_INDEX ) ) ;
2155: END IF;
2156: G_ROUNDING_FLAG_TBL(l_line_index) := NULL; -- AG
2157: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
2158: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
2159: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
2160: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
2161: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
2162: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
2163:
2195: l_control_rec.pricing_event := 'PRICE';
2196: else
2197: l_control_rec.pricing_event := in_pricing_event;
2198: end if;
2199: l_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
2200: l_control_rec.simulation_flag := 'Y';
2201:
2202: l_control_rec.gsa_check_flag := 'Y';
2203: l_control_rec.gsa_dup_check_flag := 'Y';
2211:
2212: END set_pricing_control_record;
2213:
2214: Procedure copy_control_rec(in_Control_Rec in oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE,
2215: x_Control_Rec out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE) IS
2216:
2217: Begin
2218: x_control_rec.pricing_event := in_control_rec.pricing_event;
2219: x_Control_Rec.calculate_flag := in_control_Rec.calculate_flag;
3519: IF l_debug_level > 0 THEN
3520: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
3521: END IF;
3522:
3523: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
3524: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3525: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3526: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3527: ELSE
3520: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
3521: END IF;
3522:
3523: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
3524: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3525: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3526: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3527: ELSE
3528: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
3522:
3523: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
3524: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3525: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3526: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3527: ELSE
3528: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
3529: END IF;
3530: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
3524: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3525: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3526: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3527: ELSE
3528: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
3529: END IF;
3530: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
3531: IF l_debug_level > 0 THEN
3532: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
3531: IF l_debug_level > 0 THEN
3532: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
3533: END IF;
3534: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
3535: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
3536: G_ATTR_VALIDATED_FLAG_tbl(k) := 'N';
3537: G_ATTR_ATTRIBUTE_TYPE_tbl(k) := l_attribute_type;
3538: G_ATTR_PRICING_CONTEXT_tbl(k)
3539: := px_req_line_attr_tbl(i).pricing_context;
3538: G_ATTR_PRICING_CONTEXT_tbl(k)
3539: := px_req_line_attr_tbl(i).pricing_context;
3540: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
3541: := px_req_line_attr_tbl(i).pricing_attribute;
3542: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
3543: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3544: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
3545: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
3546: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
3539: := px_req_line_attr_tbl(i).pricing_context;
3540: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
3541: := px_req_line_attr_tbl(i).pricing_attribute;
3542: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
3543: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3544: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
3545: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
3546: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
3547: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
3540: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
3541: := px_req_line_attr_tbl(i).pricing_attribute;
3542: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
3543: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3544: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
3545: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
3546: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
3547: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
3548: G_ATTR_SETUP_VALUE_FROM_tbl(k):=NULL;
3566: END LOOP;
3567:
3568:
3569: --G_ATTR_LINE_INDEX_tbl(G_ATTR_LINE_INDEX_tbl.count+1):=2;
3570: --G_ATTR_ATTRIBUTE_LEVEL_tbl(G_ATTR_LINE_INDEX_tbl.count):=QP_PREQ_GRP.G_LINE_LEVEL;
3571:
3572: --Temp_tables population ends
3573:
3574: end append_attr_to_TTables;
3574: end append_attr_to_TTables;
3575:
3576: PROCEDURE Reset_All_Tbls
3577: AS
3578: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
3579: --
3580: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3581: --
3582: BEGIN
3656: BEGIN
3657: IF l_debug_level > 0 THEN
3658: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
3659: END IF;
3660: QP_PREQ_GRP.INSERT_LINES2
3661: (p_LINE_INDEX => G_LINE_INDEX_TBL,
3662: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
3663: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
3664: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,
3706: RAISE FND_API.G_EXC_ERROR;
3707: END IF;
3708:
3709: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
3710: QP_PREQ_GRP.INSERT_LINE_ATTRS2
3711: ( G_ATTR_LINE_INDEX_tbl,
3712: G_ATTR_LINE_DETAIL_INDEX_tbl ,
3713: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
3714: G_ATTR_ATTRIBUTE_TYPE_tbl ,
3820: QPLAT.PRICING_STATUS_TEXT
3821: FROM QP_PREQ_LDETS_TMP QPLD ,
3822: QP_PREQ_LINE_ATTRS_TMP QPLAT
3823: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3824: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3825: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3826: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;
3827:
3828:
3837: QPLAT_PRICING.VALIDATED_FLAG
3838: FROM QP_PREQ_LDETS_TMP QPLD ,
3839: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3840: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3841: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3842: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3843: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;
3844:
3845:
3871: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3872: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3873: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3874: AND qpt.created_from_list_line_id = b.list_line_id
3875: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
3876: UNION ALL
3877: SELECT qpt.line_detail_index, qpt.line_detail_type_code, qpt.line_index,
3878: qpt.created_from_list_header_id list_header_id, qpt.created_from_list_line_id list_line_id,
3879: qpt.created_from_list_line_type list_line_type_code, qpt.price_break_type_code,
3898: FROM qp_int_ldets_t qpt, qp_list_lines b
3899: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3900: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), -9999)
3901: AND qpt.created_from_list_line_id = b.list_line_id
3902: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
3903:
3904:
3905: CURSOR l_rltd_lines_cur IS
3906: SELECT LINE_INDEX,
3910: RELATED_LINE_DETAIL_INDEX,
3911: PRICING_STATUS_CODE,
3912: PRICING_STATUS_TEXT
3913: FROM QP_PREQ_RLTD_LINES_TMP
3914: WHERE PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3915: ORDER BY SETUP_VALUE_FROM;
3916:
3917:
3918: I PLS_INTEGER :=1;
3920: l_expiration_period_end_date Date;
3921: l_status_code VARCHAR2(30);
3922: l_status_text VARCHAR2(30);
3923: E_ROUTINE_ERROR EXCEPTION;
3924: l_routine VARCHAR2(240):='QP_PREQ_GRP.POPULATE_OUTPUT';
3925: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3926:
3927: BEGIN
3928:
4057: IF l_debug_level > 0 then
4058: oe_debug_pub.add('----Before populate x_qual_tbl-----');
4059: END IF;
4060: --END IF;
4061: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
4062: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;
4063: x_line_detail_qual_tbl(I).QUALIFIER_CONTEXT := l_qual.CONTEXT;
4064: x_line_detail_qual_tbl(I).QUALIFIER_ATTRIBUTE := l_qual.ATTRIBUTE;
4065: x_line_detail_qual_tbl(I).QUALIFIER_ATTR_VALUE_FROM := l_qual.SETUP_VALUE_FROM;
4132: ) IS
4133:
4134: l_return_status varchar2(10);
4135: l_return_status_Text varchar2(240) ;
4136: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4137: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4147: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4148: --
4149: BEGIN
4150:
4151: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
4152: reset_all_tbls;
4153:
4154: IF l_debug_level > 0 THEN
4155: oe_debug_pub.add( 'SETTING REQUEST ID' , 1 ) ;
4157:
4158: qp_price_request_context.set_request_id;
4159:
4160: IF l_debug_level > 0 THEN
4161: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
4162: END IF;
4163:
4164:
4165: OE_ORDER_PUB.G_HDR:=NULL;
5238: END IF;
5239:
5240:
5241: IF in_line_Type_code ='LINE' and
5242: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5243: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5244: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5239:
5240:
5241: IF in_line_Type_code ='LINE' and
5242: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5243: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5244: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5240:
5241: IF in_line_Type_code ='LINE' and
5242: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5243: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5244: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5241: IF in_line_Type_code ='LINE' and
5242: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5243: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5244: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5244: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5252: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5252: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5253: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5252: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5253: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5254: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5252: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5253: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5254: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5255: then
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5252: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5253: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5254: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5255: then
5256:
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5252: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5253: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5254: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5255: then
5256:
5257: l_return_status := 'E';
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5252: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5253: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5254: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5255: then
5256:
5257: l_return_status := 'E';
5258:
5265: l_price_list := in_price_list_id;
5266: End;
5267: END IF;
5268:
5269: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
5270:
5271: IF l_debug_level > 0 THEN
5272: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
5273: END IF;
5291: OE_MSG_PUB.Add;
5292:
5293: END IF;
5294:
5295: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5296:
5297: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5298: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5299: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5298: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5299: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5300: OE_MSG_PUB.Add;
5301:
5302: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5303: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
5304: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text); --3730467
5305: OE_MSG_PUB.Add;
5306:
5305: OE_MSG_PUB.Add;
5306:
5307:
5308: ELSIF in_status_code in
5309: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5310: FND_API.G_RET_STS_ERROR) then
5311: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5312: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5313: OE_MSG_PUB.Add;
5311: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5312: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5313: OE_MSG_PUB.Add;
5314:
5315: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5316: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5317: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5318: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5319: OE_MSG_PUB.Add;
5317: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5318: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5319: OE_MSG_PUB.Add;
5320:
5321: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
5322: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
5323:
5324: IF l_debug_level > 0 THEN
5325: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5361:
5362: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
5363: OE_MSG_PUB.Add;
5364:
5365: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5366: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
5367: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5368: in_status_text);
5369: OE_MSG_PUB.Add;
5367: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5368: in_status_text);
5369: OE_MSG_PUB.Add;
5370:
5371: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
5372: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
5373: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5374: in_status_text);
5375: OE_MSG_PUB.Add;
5373: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5374: in_status_text);
5375: OE_MSG_PUB.Add;
5376:
5377: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5379: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5380: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5381: OE_MSG_PUB.Add;
5383:
5384:
5385:
5386: ELSIF in_line_Type_code ='LINE' and
5387: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
5388:
5389: IF l_debug_level > 0 THEN
5390: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
5391: END IF;
5393: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
5394: OE_MSG_PUB.Add;
5395:
5396: ELSIF in_line_Type_code ='LINE' and in_status_code in
5397: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5398: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5399: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5400: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5401: and in_price_flag IN ('Y','P')
5394: OE_MSG_PUB.Add;
5395:
5396: ELSIF in_line_Type_code ='LINE' and in_status_code in
5397: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5398: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5399: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5400: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5401: and in_price_flag IN ('Y','P')
5402: --we do not want to go in this loop if price_flag is set up 'N' because
5395:
5396: ELSIF in_line_Type_code ='LINE' and in_status_code in
5397: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5398: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5399: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5400: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5401: and in_price_flag IN ('Y','P')
5402: --we do not want to go in this loop if price_flag is set up 'N' because
5403: --engine doesn't look at the line and will not return adjustments. In this
5396: ELSIF in_line_Type_code ='LINE' and in_status_code in
5397: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5398: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5399: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5400: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5401: and in_price_flag IN ('Y','P')
5402: --we do not want to go in this loop if price_flag is set up 'N' because
5403: --engine doesn't look at the line and will not return adjustments. In this
5404: --case we DON't want to remove the adjustments that engine doesn't return.
5461:
5462:
5463: ELSIF -- Process header level adjustments
5464: in_line_type_code ='ORDER' and
5465: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
5466: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
5467: --In this case even engine doesn't update the order (status = UNCHANGED)
5468: --because of one of the lined is frozen,
5469: --there can be some order level adjustments in database which
5462:
5463: ELSIF -- Process header level adjustments
5464: in_line_type_code ='ORDER' and
5465: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
5466: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
5467: --In this case even engine doesn't update the order (status = UNCHANGED)
5468: --because of one of the lined is frozen,
5469: --there can be some order level adjustments in database which
5470: --need to be pulled out by append_adjustment_lines routine
5467: --In this case even engine doesn't update the order (status = UNCHANGED)
5468: --because of one of the lined is frozen,
5469: --there can be some order level adjustments in database which
5470: --need to be pulled out by append_adjustment_lines routine
5471: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
5472: Then
5473: IF l_debug_level > 0 THEN
5474: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
5475: END IF;