[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;
1901:
1902: procedure copy_Header_to_request(
1903: p_request_type_code in varchar2
1904: ,p_calculate_price_flag in varchar2
1905: -- ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1906: ,px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
1907: ) is
1908:
1909: l_line_index pls_integer := 0;
1971: G_CURRENCY_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).CURRENCY_CODE;
1972: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
1973: G_PERCENT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).PERCENT_PRICE;
1974: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
1975: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1976: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1977: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1978: if l_debug_level >0 then
1979: oe_debug_pub.add('the order line id'||G_LINE_ID_TBL(l_line_index));
1980: end if;
1981: G_ROUNDING_FLAG_TBL(l_line_index) := NULL;
1982: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1983: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
1984: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1985: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
1986:
1987: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
1988: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
2004: END copy_Header_to_request;
2005:
2006:
2007: PROCEDURE copy_Line_to_request(
2008: -- px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
2009: px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
2010: ,p_pricing_event in varchar2
2011: ,p_Request_Type_Code in varchar2
2012: ,p_honor_price_flag in VARCHAR2 Default 'Y'
2136: END IF;
2137: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
2138: G_PERCENT_PRICE_TBL(l_line_index) := NULL;
2139: G_ADJUSTED_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).ADJUSTED_UNIT_PRICE;
2140: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
2141: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
2142: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( L_LINE_INDEX ) ) ;
2145: END IF;
2146: G_ROUNDING_FLAG_TBL(l_line_index) := NULL; -- AG
2147: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
2148: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;
2149: G_PRICING_STATUS_CODE_tbl(l_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
2150: G_PRICING_STATUS_TEXT_tbl(l_line_index) := NULL;
2151: G_QUALIFIERS_EXIST_FLAG_TBL(l_line_index) :='N';
2152: G_PRICING_ATTRS_EXIST_FLAG_TBL(l_line_index) :='N';
2153:
2185: l_control_rec.pricing_event := 'PRICE';
2186: else
2187: l_control_rec.pricing_event := in_pricing_event;
2188: end if;
2189: l_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
2190: l_control_rec.simulation_flag := 'Y';
2191:
2192: l_control_rec.gsa_check_flag := 'Y';
2193: l_control_rec.gsa_dup_check_flag := 'Y';
2201:
2202: END set_pricing_control_record;
2203:
2204: Procedure copy_control_rec(in_Control_Rec in oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE,
2205: x_Control_Rec out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE) IS
2206:
2207: Begin
2208: x_control_rec.pricing_event := in_control_rec.pricing_event;
2209: x_Control_Rec.calculate_flag := in_control_Rec.calculate_flag;
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
3496: END IF;
3497:
3498: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
3499: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3500: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3501: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3502: ELSE
3495: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
3496: END IF;
3497:
3498: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
3499: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3500: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3501: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3502: ELSE
3503: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
3497:
3498: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
3499: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3500: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3501: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3502: ELSE
3503: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
3504: END IF;
3505: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
3499: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
3500: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
3501: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
3502: ELSE
3503: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
3504: END IF;
3505: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
3506: IF l_debug_level > 0 THEN
3507: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
3506: IF l_debug_level > 0 THEN
3507: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
3508: END IF;
3509: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
3510: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
3511: G_ATTR_VALIDATED_FLAG_tbl(k) := 'N';
3512: G_ATTR_ATTRIBUTE_TYPE_tbl(k) := l_attribute_type;
3513: G_ATTR_PRICING_CONTEXT_tbl(k)
3514: := px_req_line_attr_tbl(i).pricing_context;
3513: G_ATTR_PRICING_CONTEXT_tbl(k)
3514: := px_req_line_attr_tbl(i).pricing_context;
3515: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
3516: := px_req_line_attr_tbl(i).pricing_attribute;
3517: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
3518: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3519: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
3520: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
3521: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
3514: := px_req_line_attr_tbl(i).pricing_context;
3515: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
3516: := px_req_line_attr_tbl(i).pricing_attribute;
3517: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
3518: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3519: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
3520: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
3521: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
3522: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
3515: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
3516: := px_req_line_attr_tbl(i).pricing_attribute;
3517: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;--NULL;
3518: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3519: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;--NULL;
3520: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
3521: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
3522: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
3523: G_ATTR_SETUP_VALUE_FROM_tbl(k):=NULL;
3541: END LOOP;
3542:
3543:
3544: --G_ATTR_LINE_INDEX_tbl(G_ATTR_LINE_INDEX_tbl.count+1):=2;
3545: --G_ATTR_ATTRIBUTE_LEVEL_tbl(G_ATTR_LINE_INDEX_tbl.count):=QP_PREQ_GRP.G_LINE_LEVEL;
3546:
3547: --Temp_tables population ends
3548:
3549: end append_attr_to_TTables;
3549: end append_attr_to_TTables;
3550:
3551: PROCEDURE Reset_All_Tbls
3552: AS
3553: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
3554: --
3555: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3556: --
3557: BEGIN
3631: BEGIN
3632: IF l_debug_level > 0 THEN
3633: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
3634: END IF;
3635: QP_PREQ_GRP.INSERT_LINES2
3636: (p_LINE_INDEX => G_LINE_INDEX_TBL,
3637: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
3638: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
3639: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683:
3684: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
3685: QP_PREQ_GRP.INSERT_LINE_ATTRS2
3686: ( G_ATTR_LINE_INDEX_tbl,
3687: G_ATTR_LINE_DETAIL_INDEX_tbl ,
3688: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
3689: G_ATTR_ATTRIBUTE_TYPE_tbl ,
3795: QPLAT.PRICING_STATUS_TEXT
3796: FROM QP_PREQ_LDETS_TMP QPLD ,
3797: QP_PREQ_LINE_ATTRS_TMP QPLAT
3798: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3799: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3800: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3801: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;
3802:
3803:
3812: QPLAT_PRICING.VALIDATED_FLAG
3813: FROM QP_PREQ_LDETS_TMP QPLD ,
3814: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3815: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3816: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3817: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3818: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;
3819:
3820:
3846: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3847: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3848: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3849: AND qpt.created_from_list_line_id = b.list_line_id
3850: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
3851: UNION ALL
3852: SELECT qpt.line_detail_index, qpt.line_detail_type_code, qpt.line_index,
3853: qpt.created_from_list_header_id list_header_id, qpt.created_from_list_line_id list_line_id,
3854: qpt.created_from_list_line_type list_line_type_code, qpt.price_break_type_code,
3873: FROM qp_int_ldets_t qpt, qp_list_lines b
3874: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3875: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), -9999)
3876: AND qpt.created_from_list_line_id = b.list_line_id
3877: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
3878:
3879:
3880: CURSOR l_rltd_lines_cur IS
3881: SELECT LINE_INDEX,
3885: RELATED_LINE_DETAIL_INDEX,
3886: PRICING_STATUS_CODE,
3887: PRICING_STATUS_TEXT
3888: FROM QP_PREQ_RLTD_LINES_TMP
3889: WHERE PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3890: ORDER BY SETUP_VALUE_FROM;
3891:
3892:
3893: I PLS_INTEGER :=1;
3895: l_expiration_period_end_date Date;
3896: l_status_code VARCHAR2(30);
3897: l_status_text VARCHAR2(30);
3898: E_ROUTINE_ERROR EXCEPTION;
3899: l_routine VARCHAR2(240):='QP_PREQ_GRP.POPULATE_OUTPUT';
3900: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3901:
3902: BEGIN
3903:
4032: IF l_debug_level > 0 then
4033: oe_debug_pub.add('----Before populate x_qual_tbl-----');
4034: END IF;
4035: --END IF;
4036: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
4037: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;
4038: x_line_detail_qual_tbl(I).QUALIFIER_CONTEXT := l_qual.CONTEXT;
4039: x_line_detail_qual_tbl(I).QUALIFIER_ATTRIBUTE := l_qual.ATTRIBUTE;
4040: x_line_detail_qual_tbl(I).QUALIFIER_ATTR_VALUE_FROM := l_qual.SETUP_VALUE_FROM;
4107: ) IS
4108:
4109: l_return_status varchar2(10);
4110: l_return_status_Text varchar2(240) ;
4111: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4112: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4123: --
4124: BEGIN
4125:
4126: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
4127: reset_all_tbls;
4128:
4129: IF l_debug_level > 0 THEN
4130: oe_debug_pub.add( 'SETTING REQUEST ID' , 1 ) ;
4132:
4133: qp_price_request_context.set_request_id;
4134:
4135: IF l_debug_level > 0 THEN
4136: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
4137: END IF;
4138:
4139:
4140: OE_ORDER_PUB.G_HDR:=NULL;
5213: END IF;
5214:
5215:
5216: IF in_line_Type_code ='LINE' and
5217: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5218: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5219: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5214:
5215:
5216: IF in_line_Type_code ='LINE' and
5217: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5218: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5219: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5215:
5216: IF in_line_Type_code ='LINE' and
5217: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5218: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5219: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5216: IF in_line_Type_code ='LINE' and
5217: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5218: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5219: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5219: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5227: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5227: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5228: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5227: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5228: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5229: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5227: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5228: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5229: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5230: then
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5227: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5228: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5229: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5230: then
5231:
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5227: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5228: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5229: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5230: then
5231:
5232: l_return_status := 'E';
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5227: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5228: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5229: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
5230: then
5231:
5232: l_return_status := 'E';
5233:
5240: l_price_list := in_price_list_id;
5241: End;
5242: END IF;
5243:
5244: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
5245:
5246: IF l_debug_level > 0 THEN
5247: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
5248: END IF;
5266: OE_MSG_PUB.Add;
5267:
5268: END IF;
5269:
5270: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5271:
5272: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5273: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5274: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5273: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5274: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5275: OE_MSG_PUB.Add;
5276:
5277: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
5279: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text); --3730467
5280: OE_MSG_PUB.Add;
5281:
5280: OE_MSG_PUB.Add;
5281:
5282:
5283: ELSIF in_status_code in
5284: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5285: FND_API.G_RET_STS_ERROR) then
5286: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5288: OE_MSG_PUB.Add;
5286: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5288: OE_MSG_PUB.Add;
5289:
5290: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5291: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5292: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5293: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5294: OE_MSG_PUB.Add;
5292: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5293: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5294: OE_MSG_PUB.Add;
5295:
5296: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
5297: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
5298:
5299: IF l_debug_level > 0 THEN
5300: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5336:
5337: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
5338: OE_MSG_PUB.Add;
5339:
5340: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5341: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
5342: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5343: in_status_text);
5344: OE_MSG_PUB.Add;
5342: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5343: in_status_text);
5344: OE_MSG_PUB.Add;
5345:
5346: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
5347: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
5348: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5349: in_status_text);
5350: OE_MSG_PUB.Add;
5348: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5349: in_status_text);
5350: OE_MSG_PUB.Add;
5351:
5352: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5353: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5354: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5355: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5356: OE_MSG_PUB.Add;
5358:
5359:
5360:
5361: ELSIF in_line_Type_code ='LINE' and
5362: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
5363:
5364: IF l_debug_level > 0 THEN
5365: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
5366: END IF;
5368: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
5369: OE_MSG_PUB.Add;
5370:
5371: ELSIF in_line_Type_code ='LINE' and in_status_code in
5372: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5373: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5374: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5375: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5376: and in_price_flag IN ('Y','P')
5369: OE_MSG_PUB.Add;
5370:
5371: ELSIF in_line_Type_code ='LINE' and in_status_code in
5372: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5373: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5374: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5375: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5376: and in_price_flag IN ('Y','P')
5377: --we do not want to go in this loop if price_flag is set up 'N' because
5370:
5371: ELSIF in_line_Type_code ='LINE' and in_status_code in
5372: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5373: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5374: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5375: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5376: and in_price_flag IN ('Y','P')
5377: --we do not want to go in this loop if price_flag is set up 'N' because
5378: --engine doesn't look at the line and will not return adjustments. In this
5371: ELSIF in_line_Type_code ='LINE' and in_status_code in
5372: --( QP_PREQ_GRP.G_STATUS_UPDATED,
5373: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
5374: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5375: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
5376: and in_price_flag IN ('Y','P')
5377: --we do not want to go in this loop if price_flag is set up 'N' because
5378: --engine doesn't look at the line and will not return adjustments. In this
5379: --case we DON't want to remove the adjustments that engine doesn't return.
5436:
5437:
5438: ELSIF -- Process header level adjustments
5439: in_line_type_code ='ORDER' and
5440: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
5441: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
5442: --In this case even engine doesn't update the order (status = UNCHANGED)
5443: --because of one of the lined is frozen,
5444: --there can be some order level adjustments in database which
5437:
5438: ELSIF -- Process header level adjustments
5439: in_line_type_code ='ORDER' and
5440: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
5441: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
5442: --In this case even engine doesn't update the order (status = UNCHANGED)
5443: --because of one of the lined is frozen,
5444: --there can be some order level adjustments in database which
5445: --need to be pulled out by append_adjustment_lines routine
5442: --In this case even engine doesn't update the order (status = UNCHANGED)
5443: --because of one of the lined is frozen,
5444: --there can be some order level adjustments in database which
5445: --need to be pulled out by append_adjustment_lines routine
5446: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
5447: Then
5448: IF l_debug_level > 0 THEN
5449: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
5450: END IF;