18: -- G_BINARY_LIMIT CONSTANT NUMBER:=2147483647; -- Bug 8631297
19: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8631297
20:
21: --rc
22: G_CHARGE_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
23:
24: --
25: G_ADDED_PARENT_TBL OE_GLOBALS.Number_Tbl_Type;
26:
49: g_lineid_tbl g_lineid_tbl_type ;
50: --3021992 ends
51:
52: -- AG change
53: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
54: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
50: --3021992 ends
51:
52: -- AG change
53: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
54: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
51:
52: -- AG change
53: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
54: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
52: -- AG change
53: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
54: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
53: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
54: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
55: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
56: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
57: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
58: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
59: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
60: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
62: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
68: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
70: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
71: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
81: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
82: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
83: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
84: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
89: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
91: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
92: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
97: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
98: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
99: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
101: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
106: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
112: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
120: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
120: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
114: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
120: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
122: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
115: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
120: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
122: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
123:
116: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
120: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
122: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
123:
124: --RT{
117: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
120: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
122: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
123:
124: --RT{
125: G_PRICING_EVENT VARCHAR2(80);
824: ,Override_Flag
825: from oe_order_price_attribs a
826: where (p_line_id is not null and a.line_id = p_line_id);
827:
828: --l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
829: px_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
830: k NUMBER := px_line_attr_index;
831: l_attribute_type varchar2(30);
832: --
825: from oe_order_price_attribs a
826: where (p_line_id is not null and a.line_id = p_line_id);
827:
828: --l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
829: px_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
830: k NUMBER := px_line_attr_index;
831: l_attribute_type varchar2(30);
832: --
833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1689: k:=k+1;
1690: IF l_debug_level > 0 THEN
1691: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
1692: END IF;
1693: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
1694: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1695: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1696: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1697: ELSE
1690: IF l_debug_level > 0 THEN
1691: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
1692: END IF;
1693: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
1694: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1695: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1696: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1697: ELSE
1698: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
1692: END IF;
1693: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
1694: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1695: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1696: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1697: ELSE
1698: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
1699: END IF;
1700: G_ATTR_LINE_INDEX_tbl(k) := p_line_index; --p_header_id + nvl(p_line_id,0);
1694: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1695: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1696: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1697: ELSE
1698: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
1699: END IF;
1700: G_ATTR_LINE_INDEX_tbl(k) := p_line_index; --p_header_id + nvl(p_line_id,0);
1701: IF l_debug_level > 0 THEN
1702: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
1701: IF l_debug_level > 0 THEN
1702: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
1703: END IF;
1704: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
1705: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
1706: G_ATTR_VALIDATED_FLAG_tbl(k) := px_Req_line_attr_Tbl(i).Validated_Flag; --'N';
1707: G_ATTR_ATTRIBUTE_TYPE_tbl(k) := l_attribute_type;
1708: G_ATTR_PRICING_CONTEXT_tbl(k)
1709: := px_req_line_attr_tbl(i).pricing_context;
1708: G_ATTR_PRICING_CONTEXT_tbl(k)
1709: := px_req_line_attr_tbl(i).pricing_context;
1710: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
1711: := px_req_line_attr_tbl(i).pricing_attribute;
1712: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;
1713: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1714: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;
1715: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
1716: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
1709: := px_req_line_attr_tbl(i).pricing_context;
1710: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
1711: := px_req_line_attr_tbl(i).pricing_attribute;
1712: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;
1713: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1714: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;
1715: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
1716: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
1717: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
1710: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
1711: := px_req_line_attr_tbl(i).pricing_attribute;
1712: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;
1713: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1714: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;
1715: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
1716: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
1717: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
1718: G_ATTR_SETUP_VALUE_FROM_tbl(k):=NULL;
1748: )
1749: is
1750: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1751: line_Tbl_Index pls_integer;
1752: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1754: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1755: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1749: is
1750: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1751: line_Tbl_Index pls_integer;
1752: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1754: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1755: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1757: l_status_code varchar2(1);
1750: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1751: line_Tbl_Index pls_integer;
1752: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1754: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1755: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1757: l_status_code varchar2(1);
1758: l_status_text varchar2(240);
1751: line_Tbl_Index pls_integer;
1752: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1754: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1755: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1757: l_status_code varchar2(1);
1758: l_status_text varchar2(240);
1759: --bug 3968023 start
1752: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1754: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1755: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1757: l_status_code varchar2(1);
1758: l_status_text varchar2(240);
1759: --bug 3968023 start
1760: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1909:
1910: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
1911: l_line_index(1) := line_Tbl_Index; --px_line_tbl(line_tbl_index).header_id + px_line_tbl(line_tbl_index).line_id;
1912: l_line_detail_index(1) := NULL;
1913: l_relationship_type_code(1) := QP_PREQ_GRP.G_SERVICE_LINE;
1914: l_related_line_index(1) := p_line_Tbl_index; --px_line_tbl(p_line_tbl_index).header_id + px_line_tbl(p_line_tbl_index).line_id;
1915: l_related_line_detail_index(1) := NULL;
1916:
1917: QP_PREQ_GRP.INSERT_RLTD_LINES2(
1913: l_relationship_type_code(1) := QP_PREQ_GRP.G_SERVICE_LINE;
1914: l_related_line_index(1) := p_line_Tbl_index; --px_line_tbl(p_line_tbl_index).header_id + px_line_tbl(p_line_tbl_index).line_id;
1915: l_related_line_detail_index(1) := NULL;
1916:
1917: QP_PREQ_GRP.INSERT_RLTD_LINES2(
1918: p_LINE_INDEX => l_line_index
1919: ,p_LINE_DETAIL_INDEX => l_line_detail_index
1920: ,p_RELATIONSHIP_TYPE_CODE => l_relationship_type_code
1921: ,p_RELATED_LINE_INDEX => l_related_line_index
1924: ,x_status_text => l_status_text
1925: );
1926:
1927: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1931: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1932: RAISE FND_API.G_EXC_ERROR;
1927: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1931: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: ELSE --lower than 110510
1935: INSERT INTO QP_PREQ_RLTD_LINES_TMP
1943:
1944: VALUES ( line_Tbl_Index /*px_line_tbl(line_tbl_index).header_id
1945: + px_line_tbl(line_tbl_index).line_id*/,
1946: NULL,
1947: QP_PREQ_GRP.G_SERVICE_LINE,
1948: p_line_tbl_index /*px_line_tbl(p_line_tbl_index).header_id
1949: + px_line_tbl(p_line_tbl_index).line_id*/,
1950: NULL,
1951: 'NULL',
2120: +--------------------------------------------------------------------
2121: */
2122: PROCEDURE Reset_All_Tbls
2123: AS
2124: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
2125: --
2126: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2127: --
2128: BEGIN
2334: where lines.line_id=l_line_rec.line_id
2335: and lines.line_type_code='LINE'
2336: and lines.process_status <> 'NOT_VALID'
2337: and lines.pricing_status_code in
2338: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2339: QP_PREQ_GRP.G_STATUS_UPDATED);
2340:
2341: IF l_debug_level > 0 THEN
2342: oe_debug_pub.add( 'UNIT_SELLING_PRICE:'||L_LINE_REC.UNIT_SELLING_PRICE||' FOR LINE:'||L_LINE_REC.LINE_ID , 3 ) ;
2335: and lines.line_type_code='LINE'
2336: and lines.process_status <> 'NOT_VALID'
2337: and lines.pricing_status_code in
2338: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2339: QP_PREQ_GRP.G_STATUS_UPDATED);
2340:
2341: IF l_debug_level > 0 THEN
2342: oe_debug_pub.add( 'UNIT_SELLING_PRICE:'||L_LINE_REC.UNIT_SELLING_PRICE||' FOR LINE:'||L_LINE_REC.LINE_ID , 3 ) ;
2343: oe_debug_pub.add(' QTY:'||l_line_rec.ordered_quantity,3);
2487: and lines.line_type_code='LINE'
2488: and l_line_rec.ordered_quantity <> 0
2489: and lines.process_status <> 'NOT_VALID'
2490: and l_line_rec.open_flag <> 'N'
2491: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2492: QP_PREQ_GRP.G_STATUS_UPDATED);
2493:
2494: IF (l_line_rec.operation IS NULL
2495: OR l_line_rec.operation= FND_API.G_MISS_CHAR) THEN
2488: and l_line_rec.ordered_quantity <> 0
2489: and lines.process_status <> 'NOT_VALID'
2490: and l_line_rec.open_flag <> 'N'
2491: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2492: QP_PREQ_GRP.G_STATUS_UPDATED);
2493:
2494: IF (l_line_rec.operation IS NULL
2495: OR l_line_rec.operation= FND_API.G_MISS_CHAR) THEN
2496: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2629: WHERE ql.line_id=l.line_id
2630: AND ql.LINE_TYPE_CODE='LINE'
2631: AND ql.PROCESS_STATUS <> 'NOT_VALID'
2632: AND ql.PRICING_STATUS_CODE =
2633: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
2634: AND l.ITEM_TYPE_CODE NOT IN ('INCLUDED','CONFIG')
2635: AND l.TRANSACTION_PHASE_CODE ='F'; -- Bug 6617462;
2636: CURSOR updated_lines IS
2637: SELECT LINE_ID FROM QP_PREQ_LINES_TMP
2636: CURSOR updated_lines IS
2637: SELECT LINE_ID FROM QP_PREQ_LINES_TMP
2638: WHERE LINE_TYPE_CODE='LINE'
2639: AND PROCESS_STATUS <> 'NOT_VALID'
2640: AND PRICING_STATUS_CODE = (QP_PREQ_GRP.G_STATUS_UPDATED);
2641: --
2642: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2643: --
2644: --these variables are introduced for bug 3021992
2937: , l.order_source_id
2938: FROM QP_PREQ_LINES_TMP lines
2939: , OE_ORDER_LINES l
2940: WHERE lines.pricing_status_code IN
2941: ( QP_PREQ_GRP.G_STATUS_UPDATED
2942: , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2943: AND lines.process_status <> 'NOT_VALID'
2944: AND lines.line_type_code='LINE'
2945: AND (lines.adjusted_unit_price <> nvl(l.unit_selling_price_per_pqty,0)
2938: FROM QP_PREQ_LINES_TMP lines
2939: , OE_ORDER_LINES l
2940: WHERE lines.pricing_status_code IN
2941: ( QP_PREQ_GRP.G_STATUS_UPDATED
2942: , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2943: AND lines.process_status <> 'NOT_VALID'
2944: AND lines.line_type_code='LINE'
2945: AND (lines.adjusted_unit_price <> nvl(l.unit_selling_price_per_pqty,0)
2946: or nvl(lines.order_uom_Selling_price,0) <> nvl(l.unit_selling_price,0))
3398: AND open_flag <> 'N'
3399: AND line_id in (select line_id
3400: from qp_preq_lines_tmp lines
3401: where lines.pricing_status_code in
3402: (QP_PREQ_GRP.G_STATUS_UPDATED,
3403: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
3404: )
3405: and lines.process_status <> 'NOT_VALID'
3406: and lines.line_type_code='LINE'
3399: AND line_id in (select line_id
3400: from qp_preq_lines_tmp lines
3401: where lines.pricing_status_code in
3402: (QP_PREQ_GRP.G_STATUS_UPDATED,
3403: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
3404: )
3405: and lines.process_status <> 'NOT_VALID'
3406: and lines.line_type_code='LINE'
3407: )
3469: from qp_preq_lines_tmp lines
3470: where lines.line_id=l.line_id
3471: and l.open_flag <> 'N'
3472: and lines.line_type_code='LINE'
3473: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3474: and lines.process_status <> 'NOT_VALID'
3475: )
3476: where
3477: --l.header_id=oe_order_pub.g_hdr.header_id
3480: and l.open_flag <> 'N'
3481: and l.line_id in (select line_id from qp_preq_lines_tmp lines
3482: where
3483: lines.pricing_status_code in
3484: (QP_PREQ_GRP.G_STATUS_UPDATED,
3485: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3486: and lines.process_status <> 'NOT_VALID'
3487: and
3488: lines.line_type_code='LINE');
3481: and l.line_id in (select line_id from qp_preq_lines_tmp lines
3482: where
3483: lines.pricing_status_code in
3484: (QP_PREQ_GRP.G_STATUS_UPDATED,
3485: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3486: and lines.process_status <> 'NOT_VALID'
3487: and
3488: lines.line_type_code='LINE');
3489: IF l_debug_level > 0 THEN
3699: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3700: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3701: AND HEADER_ID = p_hdr_line_id
3702: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3703: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3704: QP_PREQ_GRP.G_STATUS_UPDATED,
3705: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3706: and ld.line_index = p_hdr_line_index
3707: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3700: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3701: AND HEADER_ID = p_hdr_line_id
3702: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3703: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3704: QP_PREQ_GRP.G_STATUS_UPDATED,
3705: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3706: and ld.line_index = p_hdr_line_index
3707: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3708: returning price_adjustment_id,
3701: AND HEADER_ID = p_hdr_line_id
3702: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3703: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3704: QP_PREQ_GRP.G_STATUS_UPDATED,
3705: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3706: and ld.line_index = p_hdr_line_index
3707: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3708: returning price_adjustment_id,
3709: header_id,
3859: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE','TSN') --Bug 13573144
3860: AND list_line_id not in (select list_line_id
3861: from qp_ldets_v ld
3862: where ld.process_code in
3863: (QP_PREQ_GRP.G_STATUS_UPDATED,
3864: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3865: QP_PREQ_PUB.G_STATUS_NEW)
3866: and (ld.applied_flag = 'Y'
3867: OR
3860: AND list_line_id not in (select list_line_id
3861: from qp_ldets_v ld
3862: where ld.process_code in
3863: (QP_PREQ_GRP.G_STATUS_UPDATED,
3864: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3865: QP_PREQ_PUB.G_STATUS_NEW)
3866: and (ld.applied_flag = 'Y'
3867: OR
3868: (nvl(ld.applied_flag,'N') = 'N'
4083: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
4084: -- where pricing_event_code = p_pricing_events)
4085: --changes to enable multiple events passed as a string
4086: where instr(l_pricing_events, pricing_event_code||',') > 0)
4087: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
4088: QP_PREQ_GRP.G_STATUS_UPDATED)
4089: AND nvl(ADJ.updated_flag,'N') = 'N'
4090: AND QPLINES.LINE_ID = ADJ.LINE_ID
4091: AND QPLINES.PROCESS_STATUS <> 'NOT_VALID'
4084: -- where pricing_event_code = p_pricing_events)
4085: --changes to enable multiple events passed as a string
4086: where instr(l_pricing_events, pricing_event_code||',') > 0)
4087: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
4088: QP_PREQ_GRP.G_STATUS_UPDATED)
4089: AND nvl(ADJ.updated_flag,'N') = 'N'
4090: AND QPLINES.LINE_ID = ADJ.LINE_ID
4091: AND QPLINES.PROCESS_STATUS <> 'NOT_VALID'
4092: AND QPLINES.LINE_TYPE_CODE = 'LINE';
4101: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
4102: -- where pricing_event_code = p_pricing_events)
4103: --changes to enable multiple events passed as a string
4104: where instr(l_pricing_events, pricing_event_code||',') > 0)
4105: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
4106: QP_PREQ_GRP.G_STATUS_UPDATED)
4107: AND nvl(ADJ.updated_flag,'N') = 'N'
4108: AND ADJ.HEADER_ID = p_hdr_line_id;
4109:
4102: -- where pricing_event_code = p_pricing_events)
4103: --changes to enable multiple events passed as a string
4104: where instr(l_pricing_events, pricing_event_code||',') > 0)
4105: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
4106: QP_PREQ_GRP.G_STATUS_UPDATED)
4107: AND nvl(ADJ.updated_flag,'N') = 'N'
4108: AND ADJ.HEADER_ID = p_hdr_line_id;
4109:
4110: --pviprana: cursors retrieving the needed values from qp temp tables for debugging purpose *start*
4151: and lines.line_index = ldets.line_index
4152: and lines.process_status <> 'NOT_VALID'
4153: and ldets.list_line_id = adj.list_line_id
4154: and lines.line_type_code='ORDER' and lines.line_id=adj.header_id
4155: and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED;
4156:
4157: cursor debug_updatable_line_adj is
4158: select ldets.list_line_id,
4159: ldets.adjustment_amount,
4197: and lines.line_index = ldets.line_index
4198: and lines.process_status <> 'NOT_VALID'
4199: and ldets.list_line_id = adj.list_line_id
4200: and lines.line_type_code='LINE' and lines.line_id=adj.line_id
4201: and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED;
4202:
4203: --pviprana: cursors retrieving the needed values from qp temp tables for debugging purpose *end*
4204:
4205: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
4207: --bug 3836854
4208: Cursor upd_adj(l_line_type IN Varchar2) Is
4209: select ldets2.price_adjustment_id, ldets2.line_detail_index
4210: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4211: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4212: AND lines2.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4213: and lines2.process_status <> 'NOT_VALID'
4214: and lines2.line_index = ldets2.line_index
4215: and lines2.line_type_code = l_line_type
4208: Cursor upd_adj(l_line_type IN Varchar2) Is
4209: select ldets2.price_adjustment_id, ldets2.line_detail_index
4210: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4211: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4212: AND lines2.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4213: and lines2.process_status <> 'NOT_VALID'
4214: and lines2.line_index = ldets2.line_index
4215: and lines2.line_type_code = l_line_type
4216: AND (l_booked_flag = 'N' or ldets2.list_line_type_code<>'IUE');
4255:
4256: --bug3654144
4257: IF nvl(G_PRICING_EVENT,'x-c1') <> 'RETROBILL' THEN
4258:
4259: IF (p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
4260: IF (p_LINE_id IS NULL) THEN
4261: ---bug 3740009
4262: delete_hdr_adjs(l_pricing_events,l_hdr_line_id,l_hdr_line_index,l_hdr_price_flag,l_hdr_pricing_status_code);
4263: delete_lines_adjs(l_pricing_events);
4364: END IF;
4365: oe_debug_pub.add( '************************************************************************');
4366: END IF;
4367:
4368: IF (p_Calculate_Flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
4369: l_stmt:=7;
4370: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4371: OE_ADV_PRICE_PVT.Insert_Adj(p_header_id);
4372: ELSE
4581: , QP_PREQ_LINES_TMP lines
4582: , QP_LIST_HEADERS_B QH
4583: WHERE
4584: ldets.list_header_id=qh.list_header_id
4585: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
4586: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4587: AND lines.process_status <> 'NOT_VALID'
4588: AND ldets.line_index=lines.line_index
4589: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
4582: , QP_LIST_HEADERS_B QH
4583: WHERE
4584: ldets.list_header_id=qh.list_header_id
4585: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
4586: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4587: AND lines.process_status <> 'NOT_VALID'
4588: AND ldets.line_index=lines.line_index
4589: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
4590: AND nvl(ldets.automatic_flag,'N') = 'Y'
4585: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
4586: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
4587: AND lines.process_status <> 'NOT_VALID'
4588: AND ldets.line_index=lines.line_index
4589: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
4590: AND nvl(ldets.automatic_flag,'N') = 'Y'
4591: -- or
4592: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
4593: AND ldets.created_from_list_type_code not in ('PRL','AGR')
5149:
5150: -- AG change --
5151: procedure copy_Header_to_request(
5152: p_header_rec OE_Order_PUB.Header_Rec_Type
5153: ,px_req_line_tbl in out NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE
5154: --,p_pricing_event varchar2
5155: ,p_Request_Type_Code varchar2
5156: ,p_calculate_price_flag varchar2
5157: ,px_line_index in out NOCOPY NUMBER
5156: ,p_calculate_price_flag varchar2
5157: ,px_line_index in out NOCOPY NUMBER
5158: )
5159: is
5160: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5161: --l_line_index pls_integer := px_req_line_tbl.count;
5162: --
5163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5164: --
5186: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
5187: Else
5188: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5189: End If;
5190: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5191: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5192: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5193: ELSE
5194: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5187: Else
5188: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5189: End If;
5190: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5191: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5192: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5193: ELSE
5194: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5195: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5188: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5189: End If;
5190: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5191: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5192: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5193: ELSE
5194: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5195: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5196: THEN
5191: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5192: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5193: ELSE
5194: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5195: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5196: THEN
5197: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5198: END IF;
5199:
5193: ELSE
5194: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5195: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5196: THEN
5197: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5198: END IF;
5199:
5200: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5201: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5197: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5198: END IF;
5199:
5200: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5201: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5202: THEN
5203: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5204: END IF;
5205:
5199:
5200: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5201: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5202: THEN
5203: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5204: END IF;
5205:
5206: END IF;
5207: l_req_line_rec.CURRENCY_CODE := p_Header_rec.transactional_curr_code;
5204: END IF;
5205:
5206: END IF;
5207: l_req_line_rec.CURRENCY_CODE := p_Header_rec.transactional_curr_code;
5208: QP_PREQ_GRP.G_CURRENCY_CODE := l_req_line_rec.currency_code;
5209: l_req_line_rec.PRICE_FLAG := p_calculate_price_flag;
5210: l_req_line_rec.Active_date_first_type := 'ORD';
5211: l_req_line_rec.Active_date_first := p_Header_rec.Ordered_date;
5212: If G_ROUNDING_FLAG = 'Y' Then
5237: G_CURRENCY_CODE_TBL(px_line_index) := l_req_line_rec.CURRENCY_CODE;
5238: G_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.unit_price; -- AG
5239: G_PERCENT_PRICE_TBL(px_line_index) := l_req_line_rec.PERCENT_PRICE;
5240: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.ADJUSTED_UNIT_PRICE;
5241: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
5242: G_PRICE_FLAG_TBL(px_line_index) := l_req_line_rec.PRICE_FLAG;
5243: G_LINE_ID_TBL(px_line_index) := l_req_line_rec.LINE_ID;
5244: G_ROUNDING_FLAG_TBL(px_line_index)
5245: := G_ROUNDING_FLAG; -- AG
5244: G_ROUNDING_FLAG_TBL(px_line_index)
5245: := G_ROUNDING_FLAG; -- AG
5246: G_ROUNDING_FACTOR_TBL(px_line_index) := l_req_line_rec.ROUNDING_FACTOR;
5247: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
5248: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
5249: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
5250:
5251: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
5252: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
5269: end copy_Header_to_request;
5270:
5271: procedure copy_Line_to_request(
5272: p_Line_rec OE_Order_PUB.Line_Rec_Type
5273: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
5274: ,p_pricing_events varchar2
5275: ,p_request_type_code varchar2
5276: ,p_honor_price_flag varchar2
5277: ,px_line_index in out NOCOPY NUMBER
5277: ,px_line_index in out NOCOPY NUMBER
5278: )
5279: is
5280: --l_line_index pls_integer := nvl(px_req_line_tbl.count,0);
5281: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5282: l_uom_rate NUMBER;
5283: v_discounting_privilege VARCHAR2(30);
5284: l_item_type_code VARCHAR2(30);
5285: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2434270
5341:
5342: --rc
5343: l_req_line_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code;
5344:
5345: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5346: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5347: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5348: ELSE
5349: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5342: --rc
5343: l_req_line_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code;
5344:
5345: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5346: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5347: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5348: ELSE
5349: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5350: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5343: l_req_line_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code;
5344:
5345: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5346: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5347: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5348: ELSE
5349: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5350: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5351: THEN
5346: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5347: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5348: ELSE
5349: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5350: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5351: THEN
5352: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5353: END IF;
5354:
5348: ELSE
5349: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5350: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5351: THEN
5352: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5353: END IF;
5354:
5355: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5356: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5352: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5353: END IF;
5354:
5355: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5356: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5357: THEN
5358: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5359:
5360: END IF;
5354:
5355: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5356: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5357: THEN
5358: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5359:
5360: END IF;
5361: END IF;
5362: l_req_line_rec.LINE_QUANTITY := p_Line_rec.Ordered_quantity ;
5896: END IF;
5897: G_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.unit_price; -- AG
5898: G_PERCENT_PRICE_TBL(px_line_index) := l_req_line_rec.PERCENT_PRICE;
5899: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.ADJUSTED_UNIT_PRICE;
5900: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
5901: G_PRICE_FLAG_TBL(px_line_index) := l_req_line_rec.PRICE_FLAG;
5902: G_LINE_ID_TBL(px_line_index) := l_req_line_rec.LINE_ID;
5903: IF l_debug_level > 0 THEN
5904: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( PX_LINE_INDEX ) ) ;
5905: END IF;
5906: G_ROUNDING_FLAG_TBL(px_line_index) := G_ROUNDING_FLAG; -- AG
5907: G_ROUNDING_FACTOR_TBL(px_line_index) := l_req_line_rec.ROUNDING_FACTOR;
5908: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
5909: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
5910: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
5911: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
5912: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
5913: G_PRICE_LIST_ID_TBL(px_line_index) :=p_line_rec.price_list_id;
5925: p_pricing_events = 'PRICE' THEN
5926: IF l_debug_level > 0 THEN
5927: oe_debug_pub.add( 'setting process code as UPDATED for override list price');
5928: END IF;
5929: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UPDATED;
5930: END IF;
5931:
5932:
5933: IF l_debug_level > 0 THEN
5947: IF l_debug_level > 0 THEN
5948: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
5949: oe_debug_pub.add('G_CHARGE_PERIODICITY_CODE_TBL.Count:'||G_CHARGE_PERIODICITY_CODE_TBL.COUNT);
5950: END IF;
5951: QP_PREQ_GRP.INSERT_LINES2
5952: (p_LINE_INDEX => G_LINE_INDEX_TBL,
5953: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
5954: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
5955: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,
6002: RAISE FND_API.G_EXC_ERROR;
6003: END IF;
6004:
6005: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
6006: QP_PREQ_GRP.INSERT_LINE_ATTRS2
6007: ( G_ATTR_LINE_INDEX_tbl,
6008: G_ATTR_LINE_DETAIL_INDEX_tbl ,
6009: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
6010: G_ATTR_ATTRIBUTE_TYPE_tbl ,
6221: l_any_frozen_line BOOLEAN:=FALSE;
6222: l_calculate_price_flag varchar2(1);
6223: l_message_displayed Boolean:=FALSE;
6224: --btea begin
6225: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
6226: --btea end
6227: l_order_line_id NUMBER;
6228: l_service_reference_line_id NUMBER;
6229: l_completely_frozen BOOLEAN := TRUE;
6238: --2740845 begin
6239: l_agreement_name varchar2(240);
6240: l_revision varchar2(50);
6241: --2740845 end
6242: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6243: --bug 3968023
6244: l_event_in_phase1 VARCHAR2(1);
6245: l_sql varchar2(4000); --bug 9436193
6246:
6939:
6940: )
6941: IS
6942: l_return_status_text varchar(2000);
6943: l_control_rec QP_PREQ_GRP.control_record_type;
6944: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6945: /*
6946: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6942: l_return_status_text varchar(2000);
6943: l_control_rec QP_PREQ_GRP.control_record_type;
6944: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6945: /*
6946: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6949: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6950: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6943: l_control_rec QP_PREQ_GRP.control_record_type;
6944: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6945: /*
6946: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6949: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6950: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6951: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6944: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6945: /*
6946: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6949: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6950: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6951: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6952: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6945: /*
6946: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6949: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6950: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6951: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6952: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6953: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6946: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6949: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6950: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6951: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6952: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6953: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6954: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6947: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6949: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6950: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6951: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6952: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6953: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6954: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6955: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6948: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6949: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6950: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6951: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6952: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6953: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6954: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6955: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6956: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6951: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6952: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6953: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6954: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6955: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6956: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6957: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6958: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6959: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6952: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6953: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6954: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6955: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6956: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6957: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6958: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6959: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6960: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6953: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6954: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6955: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6956: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6957: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6958: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6959: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6960: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6961: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6954: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6955: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6956: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6957: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6958: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6959: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6960: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6961: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6962: */
6955: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6956: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6957: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6958: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6959: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6960: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6961: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6962: */
6963: --
6956: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6957: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6958: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6959: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6960: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6961: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6962: */
6963: --
6964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6957: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6958: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6959: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6960: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6961: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6962: */
6963: --
6964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6965: --
7156: --bug 3696768
7157: cursor reset_ipl_tbl is
7158: select line_id
7159: from qp_preq_lines_tmp
7160: where pricing_status_code <> QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST;
7161: --bug 3696768
7162: cursor wrong_lines is
7163: select line_id
7164: , line_index
7173: , priced_uom_code
7174: from qp_preq_lines_tmp
7175: where process_status <> 'NOT_VALID' and
7176: (pricing_status_code not in
7177: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
7178: QP_PREQ_GRP.G_STATUS_UPDATED,
7179: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
7180: 'NOT_VALID')
7181: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
7174: from qp_preq_lines_tmp
7175: where process_status <> 'NOT_VALID' and
7176: (pricing_status_code not in
7177: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
7178: QP_PREQ_GRP.G_STATUS_UPDATED,
7179: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
7180: 'NOT_VALID')
7181: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
7182: cursor wrong_book_lines is
7175: where process_status <> 'NOT_VALID' and
7176: (pricing_status_code not in
7177: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
7178: QP_PREQ_GRP.G_STATUS_UPDATED,
7179: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
7180: 'NOT_VALID')
7181: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
7182: cursor wrong_book_lines is
7183: select lines.line_id
7203: --bug 3968023
7204: and lines.pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED
7205: ;
7206: -- Bug 2079138: booked lines should always have price
7207: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
7208: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
7209: -- );
7210: --
7211: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7204: and lines.pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED
7205: ;
7206: -- Bug 2079138: booked lines should always have price
7207: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
7208: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
7209: -- );
7210: --
7211: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7212: --
7282: END IF;
7283: l_invalid_line := 'N';
7284: -- add message when the price list is found to be inactive
7285: /*IF wrong_line.line_Type_code ='LINE' and
7286: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
7287: IF not G_IPL_ERRORS_TBL.exists(MOD(l_line_rec.line_id,G_BINARY_LIMIT))
7288: or (G_IPL_ERRORS_TBL.exists(MOD(l_line_rec.line_id,G_BINARY_LIMIT))
7289: and
7290: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT))<>l_line_rec.price_list_id)
7311: l_invalid_line := 'Y';
7312: END IF; */
7313:
7314: if wrong_line.line_Type_code ='LINE' and
7315: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7316: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7317: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7312: END IF; */
7313:
7314: if wrong_line.line_Type_code ='LINE' and
7315: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7316: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7317: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7313:
7314: if wrong_line.line_Type_code ='LINE' and
7315: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7316: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7317: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7314: if wrong_line.line_Type_code ='LINE' and
7315: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7316: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7317: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7317: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7325: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7318: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7325: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7326: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7319: FND_API.G_RET_STS_UNEXP_ERROR,
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7325: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7326: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7327: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7320: FND_API.G_RET_STS_ERROR,
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7325: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7326: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7327: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7328: then
7321: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7325: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7326: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7327: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7328: then
7329:
7322: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7325: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7326: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7327: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7328: then
7329:
7330: l_invalid_line := 'Y';
7323: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7324: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7325: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7326: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7327: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7328: then
7329:
7330: l_invalid_line := 'Y';
7331: Begin
7335: Exception When No_data_found then
7336: l_price_list := l_line_rec.price_list_id;
7337: End;
7338:
7339: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
7340: IF l_debug_level > 0 THEN
7341: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
7342: END IF;
7343:
7404:
7405: IF l_debug_level > 0 THEN
7406: oe_debug_pub.add('invalid price done');
7407: END IF;
7408: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
7409: IF l_debug_level > 0 THEN
7410: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
7411: END IF;
7412: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7420: end if;
7421: else
7422: OE_MSG_PUB.Add;
7423: end if;
7424: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7425: IF l_debug_level > 0 THEN
7426: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
7427: END IF;
7428: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7436: else
7437: OE_MSG_PUB.Add;
7438: end if;
7439: Elsif wrong_line.pricing_status_code in
7440: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7441: FND_API.G_RET_STS_ERROR)
7442: then
7443: IF l_debug_level > 0 THEN
7444: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7453: end if;
7454: else
7455: OE_MSG_PUB.Add;
7456: end if;
7457: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
7458: IF l_debug_level > 0 THEN
7459: oe_debug_pub.add( 'INVALID UOM' ) ;
7460: END IF;
7461: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
7469: end if;
7470: else
7471: OE_MSG_PUB.Add;
7472: end if;
7473: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
7474: IF l_debug_level > 0 THEN
7475: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;
7476: END IF;
7477: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
7517: end if;
7518: else
7519: OE_MSG_PUB.Add;
7520: end if;
7521: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
7522: IF l_debug_level > 0 THEN
7523: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
7524: END IF;
7525: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
7533: end if;
7534: else
7535: OE_MSG_PUB.Add;
7536: end if;
7537: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
7538: IF l_debug_level > 0 THEN
7539: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
7540: END IF;
7541: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
7549: end if;
7550: else
7551: OE_MSG_PUB.Add;
7552: end if;
7553: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
7554: IF l_debug_level > 0 THEN
7555: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
7556: END IF;
7557: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
7603: --btea end
7604:
7605: elsif
7606: wrong_line.line_Type_code ='LINE' and
7607: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
7608: Then
7609:
7610: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7611: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
7659:
7660: end if;
7661:
7662: IF wrong_line.line_type_code='ORDER' THEN
7663: if wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7664: oe_debug_pub.add( 'ERROR IN ORDER LEVEL FORMULA PROCESSING' ) ;
7665: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7666: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7667: OE_MSG_PUB.Add;
7906: END IF;
7907: End if;
7908:
7909: -- calculate may change adjustments: adjusted_amount
7910: --IF (p_control_rec.p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
7911: IF (p_header_id IS NOT NULL) THEN
7912: REFRESH_ADJS(p_line_id=>NULL
7913: , p_pricing_events=>p_pricing_events
7914: , p_calculate_flag => p_control_rec.p_calculate_flag);
8110:
8111: qp_price_request_context.set_request_id;
8112:
8113: IF l_debug_level > 0 THEN
8114: oe_debug_pub.add( ' REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
8115: END IF;
8116:
8117: G_IS_THERE_FREEZE_OVERRIDE:=TRUE;
8118: G_IS_THERE_FREEZE_OVERRIDE:=Check_Freeze_Override(p_pricing_events);