[Home] [Help]
17: G_IPL_ERRORS_TBL OE_GLOBALS.Number_Tbl_Type;
18: G_BINARY_LIMIT CONSTANT NUMBER:=2147483647;
19:
20: --rc
21: G_CHARGE_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
22:
23: --
24: G_ADDED_PARENT_TBL OE_GLOBALS.Number_Tbl_Type;
25:
48: g_lineid_tbl g_lineid_tbl_type ;
49: --3021992 ends
50:
51: -- AG change
52: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
53: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
49: --3021992 ends
50:
51: -- AG change
52: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
53: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
50:
51: -- AG change
52: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
53: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
51: -- AG change
52: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
53: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
52: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
53: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
53: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
54: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
55: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
56: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
57: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
58: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
59: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
60: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
61: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
62: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
63: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
64: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
65: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
67: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
70: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
78: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
79: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
80: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
81: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
83: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
85: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
86: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
87: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
88: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
89: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
90: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
91: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
92: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
93: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
94: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
95: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
96: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
97: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
98: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
99: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
100: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
101: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
102: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
105: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
110: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
118: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
118: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
118: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
113: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
118: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
121: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
114: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
118: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
121: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
122:
115: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
118: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
121: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
122:
123: --RT{
116: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
118: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
119: G_LIST_PRICE_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LINE_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
121: G_IS_THERE_FREEZE_OVERRIDE Boolean:=TRUE;
122:
123: --RT{
124: G_PRICING_EVENT VARCHAR2(80);
823: ,Override_Flag
824: from oe_order_price_attribs a
825: where (p_line_id is not null and a.line_id = p_line_id);
826:
827: --l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
828: px_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
829: k NUMBER := px_line_attr_index;
830: l_attribute_type varchar2(30);
831: --
824: from oe_order_price_attribs a
825: where (p_line_id is not null and a.line_id = p_line_id);
826:
827: --l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
828: px_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
829: k NUMBER := px_line_attr_index;
830: l_attribute_type varchar2(30);
831: --
832: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1688: k:=k+1;
1689: IF l_debug_level > 0 THEN
1690: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
1691: END IF;
1692: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
1693: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1694: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1695: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1696: ELSE
1689: IF l_debug_level > 0 THEN
1690: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
1691: END IF;
1692: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
1693: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1694: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1695: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1696: ELSE
1697: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
1691: END IF;
1692: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
1693: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1694: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1695: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1696: ELSE
1697: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
1698: END IF;
1699: G_ATTR_LINE_INDEX_tbl(k) := p_line_index; --p_header_id + nvl(p_line_id,0);
1693: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;
1694: ELSIF (px_req_line_attr_tbl(I).PRICING_CONTEXT = 'MODLIST') THEN
1695: l_attribute_type := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1696: ELSE
1697: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
1698: END IF;
1699: G_ATTR_LINE_INDEX_tbl(k) := p_line_index; --p_header_id + nvl(p_line_id,0);
1700: IF l_debug_level > 0 THEN
1701: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
1700: IF l_debug_level > 0 THEN
1701: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
1702: END IF;
1703: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
1704: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
1705: G_ATTR_VALIDATED_FLAG_tbl(k) := px_Req_line_attr_Tbl(i).Validated_Flag; --'N';
1706: G_ATTR_ATTRIBUTE_TYPE_tbl(k) := l_attribute_type;
1707: G_ATTR_PRICING_CONTEXT_tbl(k)
1708: := px_req_line_attr_tbl(i).pricing_context;
1707: G_ATTR_PRICING_CONTEXT_tbl(k)
1708: := px_req_line_attr_tbl(i).pricing_context;
1709: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
1710: := px_req_line_attr_tbl(i).pricing_attribute;
1711: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;
1712: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1713: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;
1714: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
1715: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
1708: := px_req_line_attr_tbl(i).pricing_context;
1709: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
1710: := px_req_line_attr_tbl(i).pricing_attribute;
1711: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;
1712: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1713: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;
1714: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
1715: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
1716: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
1709: G_ATTR_PRICING_ATTRIBUTE_tbl(k)
1710: := px_req_line_attr_tbl(i).pricing_attribute;
1711: G_ATTR_APPLIED_FLAG_tbl(k) := QP_PREQ_GRP.G_LIST_NOT_APPLIED;
1712: G_ATTR_PRICING_STATUS_CODE_tbl(k) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1713: G_ATTR_PRICING_ATTR_FLAG_tbl (k) := QP_PREQ_GRP.G_YES;
1714: G_ATTR_LIST_HEADER_ID_tbl(k) := NULL;
1715: G_ATTR_LIST_LINE_ID_tbl(k) := NULL;
1716: G_ATTR_VALUE_FROM_tbl(k) :=px_req_line_attr_tbl(i).pricing_attr_value_from;
1717: G_ATTR_SETUP_VALUE_FROM_tbl(k):=NULL;
1747: )
1748: is
1749: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1750: line_Tbl_Index pls_integer;
1751: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1752: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1754: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1755: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1748: is
1749: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1750: line_Tbl_Index pls_integer;
1751: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1752: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1754: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1755: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_status_code varchar2(1);
1749: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
1750: line_Tbl_Index pls_integer;
1751: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1752: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1754: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1755: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_status_code varchar2(1);
1757: l_status_text varchar2(240);
1750: line_Tbl_Index pls_integer;
1751: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1752: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1754: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1755: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_status_code varchar2(1);
1757: l_status_text varchar2(240);
1758: --bug 3968023 start
1751: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1752: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1753: l_relationship_type_code QP_PREQ_GRP.VARCHAR_TYPE;
1754: l_related_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1755: l_related_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
1756: l_status_code varchar2(1);
1757: l_status_text varchar2(240);
1758: --bug 3968023 start
1759: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1908:
1909: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
1910: l_line_index(1) := line_Tbl_Index; --px_line_tbl(line_tbl_index).header_id + px_line_tbl(line_tbl_index).line_id;
1911: l_line_detail_index(1) := NULL;
1912: l_relationship_type_code(1) := QP_PREQ_GRP.G_SERVICE_LINE;
1913: 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;
1914: l_related_line_detail_index(1) := NULL;
1915:
1916: QP_PREQ_GRP.INSERT_RLTD_LINES2(
1912: l_relationship_type_code(1) := QP_PREQ_GRP.G_SERVICE_LINE;
1913: 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;
1914: l_related_line_detail_index(1) := NULL;
1915:
1916: QP_PREQ_GRP.INSERT_RLTD_LINES2(
1917: p_LINE_INDEX => l_line_index
1918: ,p_LINE_DETAIL_INDEX => l_line_detail_index
1919: ,p_RELATIONSHIP_TYPE_CODE => l_relationship_type_code
1920: ,p_RELATED_LINE_INDEX => l_related_line_index
1923: ,x_status_text => l_status_text
1924: );
1925:
1926: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1927: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1930: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1931: RAISE FND_API.G_EXC_ERROR;
1926: IF l_status_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
1927: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: ELSIF l_status_code = FND_API.G_RET_STS_ERROR THEN
1930: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1931: RAISE FND_API.G_EXC_ERROR;
1932: END IF;
1933: ELSE --lower than 110510
1934: INSERT INTO QP_PREQ_RLTD_LINES_TMP
1942:
1943: VALUES ( line_Tbl_Index /*px_line_tbl(line_tbl_index).header_id
1944: + px_line_tbl(line_tbl_index).line_id*/,
1945: NULL,
1946: QP_PREQ_GRP.G_SERVICE_LINE,
1947: p_line_tbl_index /*px_line_tbl(p_line_tbl_index).header_id
1948: + px_line_tbl(p_line_tbl_index).line_id*/,
1949: NULL,
1950: 'NULL',
2119: +--------------------------------------------------------------------
2120: */
2121: PROCEDURE Reset_All_Tbls
2122: AS
2123: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
2124: --
2125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2126: --
2127: BEGIN
2333: where lines.line_id=l_line_rec.line_id
2334: and lines.line_type_code='LINE'
2335: and lines.process_status <> 'NOT_VALID'
2336: and lines.pricing_status_code in
2337: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2338: QP_PREQ_GRP.G_STATUS_UPDATED);
2339:
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'UNIT_SELLING_PRICE:'||L_LINE_REC.UNIT_SELLING_PRICE||' FOR LINE:'||L_LINE_REC.LINE_ID , 3 ) ;
2334: and lines.line_type_code='LINE'
2335: and lines.process_status <> 'NOT_VALID'
2336: and lines.pricing_status_code in
2337: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2338: QP_PREQ_GRP.G_STATUS_UPDATED);
2339:
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'UNIT_SELLING_PRICE:'||L_LINE_REC.UNIT_SELLING_PRICE||' FOR LINE:'||L_LINE_REC.LINE_ID , 3 ) ;
2342: oe_debug_pub.add(' QTY:'||l_line_rec.ordered_quantity,3);
2480: and lines.line_type_code='LINE'
2481: and l_line_rec.ordered_quantity <> 0
2482: and lines.process_status <> 'NOT_VALID'
2483: and l_line_rec.open_flag <> 'N'
2484: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2485: QP_PREQ_GRP.G_STATUS_UPDATED);
2486:
2487: IF (l_line_rec.operation IS NULL
2488: OR l_line_rec.operation= FND_API.G_MISS_CHAR) THEN
2481: and l_line_rec.ordered_quantity <> 0
2482: and lines.process_status <> 'NOT_VALID'
2483: and l_line_rec.open_flag <> 'N'
2484: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2485: QP_PREQ_GRP.G_STATUS_UPDATED);
2486:
2487: IF (l_line_rec.operation IS NULL
2488: OR l_line_rec.operation= FND_API.G_MISS_CHAR) THEN
2489: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
2622: WHERE ql.line_id=l.line_id
2623: AND ql.LINE_TYPE_CODE='LINE'
2624: AND ql.PROCESS_STATUS <> 'NOT_VALID'
2625: AND ql.PRICING_STATUS_CODE =
2626: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
2627: AND l.ITEM_TYPE_CODE NOT IN ('INCLUDED','CONFIG')
2628: AND l.TRANSACTION_PHASE_CODE ='F'; -- Bug 6617462;
2629: CURSOR updated_lines IS
2630: SELECT LINE_ID FROM QP_PREQ_LINES_TMP
2629: CURSOR updated_lines IS
2630: SELECT LINE_ID FROM QP_PREQ_LINES_TMP
2631: WHERE LINE_TYPE_CODE='LINE'
2632: AND PROCESS_STATUS <> 'NOT_VALID'
2633: AND PRICING_STATUS_CODE = (QP_PREQ_GRP.G_STATUS_UPDATED);
2634: --
2635: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2636: --
2637: --these variables are introduced for bug 3021992
2916: , l.order_source_id
2917: FROM QP_PREQ_LINES_TMP lines
2918: , OE_ORDER_LINES l
2919: WHERE lines.pricing_status_code IN
2920: ( QP_PREQ_GRP.G_STATUS_UPDATED
2921: , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2922: AND lines.process_status <> 'NOT_VALID'
2923: AND lines.line_type_code='LINE'
2924: AND (lines.adjusted_unit_price <> nvl(l.unit_selling_price_per_pqty,0)
2917: FROM QP_PREQ_LINES_TMP lines
2918: , OE_ORDER_LINES l
2919: WHERE lines.pricing_status_code IN
2920: ( QP_PREQ_GRP.G_STATUS_UPDATED
2921: , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2922: AND lines.process_status <> 'NOT_VALID'
2923: AND lines.line_type_code='LINE'
2924: AND (lines.adjusted_unit_price <> nvl(l.unit_selling_price_per_pqty,0)
2925: or nvl(lines.order_uom_Selling_price,0) <> nvl(l.unit_selling_price,0))
3399: from qp_preq_lines_tmp lines
3400: where lines.line_id=l.line_id
3401: and l.open_flag <> 'N'
3402: and lines.line_type_code='LINE'
3403: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3404: and lines.process_status <> 'NOT_VALID'
3405: )
3406: where
3407: --l.header_id=oe_order_pub.g_hdr.header_id
3410: and l.open_flag <> 'N'
3411: and l.line_id in (select line_id from qp_preq_lines_tmp lines
3412: where
3413: lines.pricing_status_code in
3414: (QP_PREQ_GRP.G_STATUS_UPDATED,
3415: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3416: and lines.process_status <> 'NOT_VALID'
3417: and
3418: lines.line_type_code='LINE');
3411: and l.line_id in (select line_id from qp_preq_lines_tmp lines
3412: where
3413: lines.pricing_status_code in
3414: (QP_PREQ_GRP.G_STATUS_UPDATED,
3415: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3416: and lines.process_status <> 'NOT_VALID'
3417: and
3418: lines.line_type_code='LINE');
3419: IF l_debug_level > 0 THEN
3585: and nvl(b.user_freeze_override_flag,freeze_override_flag)
3586: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3587: AND HEADER_ID = p_hdr_line_id
3588: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3589: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3590: QP_PREQ_GRP.G_STATUS_UPDATED,
3591: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3592: and ld.line_index = p_hdr_line_index
3593: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3586: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))
3587: AND HEADER_ID = p_hdr_line_id
3588: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3589: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3590: QP_PREQ_GRP.G_STATUS_UPDATED,
3591: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3592: and ld.line_index = p_hdr_line_index
3593: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3594: returning price_adjustment_id,
3587: AND HEADER_ID = p_hdr_line_id
3588: AND list_line_id not in (select list_line_id from qp_ldets_v ld
3589: where ld.process_code in (QP_PREQ_GRP.G_STATUS_NEW, --bug 4190357
3590: QP_PREQ_GRP.G_STATUS_UPDATED,
3591: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3592: and ld.line_index = p_hdr_line_index
3593: and p_hdr_line_id = oe_order_pub.g_hdr.header_id)
3594: returning price_adjustment_id,
3595: header_id,
3743: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712
3744: AND list_line_id not in (select list_line_id
3745: from qp_ldets_v ld
3746: where ld.process_code in
3747: (QP_PREQ_GRP.G_STATUS_UPDATED,
3748: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3749: QP_PREQ_PUB.G_STATUS_NEW)
3750: and (ld.applied_flag = 'Y'
3751: OR
3744: AND list_line_id not in (select list_line_id
3745: from qp_ldets_v ld
3746: where ld.process_code in
3747: (QP_PREQ_GRP.G_STATUS_UPDATED,
3748: QP_PREQ_GRP.G_STATUS_UNCHANGED,
3749: QP_PREQ_PUB.G_STATUS_NEW)
3750: and (ld.applied_flag = 'Y'
3751: OR
3752: (nvl(ld.applied_flag,'N') = 'N'
3968: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
3969: -- where pricing_event_code = p_pricing_events)
3970: --changes to enable multiple events passed as a string
3971: where instr(l_pricing_events, pricing_event_code||',') > 0)
3972: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
3973: QP_PREQ_GRP.G_STATUS_UPDATED)
3974: AND nvl(ADJ.updated_flag,'N') = 'N'
3975: AND QPLINES.LINE_ID = ADJ.LINE_ID
3976: AND QPLINES.PROCESS_STATUS <> 'NOT_VALID'
3969: -- where pricing_event_code = p_pricing_events)
3970: --changes to enable multiple events passed as a string
3971: where instr(l_pricing_events, pricing_event_code||',') > 0)
3972: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
3973: QP_PREQ_GRP.G_STATUS_UPDATED)
3974: AND nvl(ADJ.updated_flag,'N') = 'N'
3975: AND QPLINES.LINE_ID = ADJ.LINE_ID
3976: AND QPLINES.PROCESS_STATUS <> 'NOT_VALID'
3977: AND QPLINES.LINE_TYPE_CODE = 'LINE';
3986: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
3987: -- where pricing_event_code = p_pricing_events)
3988: --changes to enable multiple events passed as a string
3989: where instr(l_pricing_events, pricing_event_code||',') > 0)
3990: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
3991: QP_PREQ_GRP.G_STATUS_UPDATED)
3992: AND nvl(ADJ.updated_flag,'N') = 'N'
3993: AND ADJ.HEADER_ID = p_hdr_line_id;
3994:
3987: -- where pricing_event_code = p_pricing_events)
3988: --changes to enable multiple events passed as a string
3989: where instr(l_pricing_events, pricing_event_code||',') > 0)
3990: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,
3991: QP_PREQ_GRP.G_STATUS_UPDATED)
3992: AND nvl(ADJ.updated_flag,'N') = 'N'
3993: AND ADJ.HEADER_ID = p_hdr_line_id;
3994:
3995: --pviprana: cursors retrieving the needed values from qp temp tables for debugging purpose *start*
4036: and lines.line_index = ldets.line_index
4037: and lines.process_status <> 'NOT_VALID'
4038: and ldets.list_line_id = adj.list_line_id
4039: and lines.line_type_code='ORDER' and lines.line_id=adj.header_id
4040: and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED;
4041:
4042: cursor debug_updatable_line_adj is
4043: select ldets.list_line_id,
4044: ldets.adjustment_amount,
4082: and lines.line_index = ldets.line_index
4083: and lines.process_status <> 'NOT_VALID'
4084: and ldets.list_line_id = adj.list_line_id
4085: and lines.line_type_code='LINE' and lines.line_id=adj.line_id
4086: and ldets.process_code = QP_PREQ_GRP.G_STATUS_UPDATED;
4087:
4088: --pviprana: cursors retrieving the needed values from qp temp tables for debugging purpose *end*
4089:
4090: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
4092: --bug 3836854
4093: Cursor upd_adj(l_line_type IN Varchar2) Is
4094: select ldets2.price_adjustment_id, ldets2.line_detail_index
4095: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4096: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4097: 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)
4098: and lines2.process_status <> 'NOT_VALID'
4099: and lines2.line_index = ldets2.line_index
4100: and lines2.line_type_code = l_line_type
4093: Cursor upd_adj(l_line_type IN Varchar2) Is
4094: select ldets2.price_adjustment_id, ldets2.line_detail_index
4095: from qp_ldets_v ldets2, QP_PREQ_LINES_TMP lines2
4096: where ldets2.process_code=QP_PREQ_GRP.G_STATUS_UPDATED
4097: 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)
4098: and lines2.process_status <> 'NOT_VALID'
4099: and lines2.line_index = ldets2.line_index
4100: and lines2.line_type_code = l_line_type
4101: AND (l_booked_flag = 'N' or ldets2.list_line_type_code<>'IUE');
4140:
4141: --bug3654144
4142: IF nvl(G_PRICING_EVENT,'x-c1') <> 'RETROBILL' THEN
4143:
4144: IF (p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
4145: IF (p_LINE_id IS NULL) THEN
4146: ---bug 3740009
4147: delete_hdr_adjs(l_pricing_events,l_hdr_line_id,l_hdr_line_index,l_hdr_price_flag,l_hdr_pricing_status_code);
4148: delete_lines_adjs(l_pricing_events);
4249: END IF;
4250: oe_debug_pub.add( '************************************************************************');
4251: END IF;
4252:
4253: IF (p_Calculate_Flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
4254: l_stmt:=7;
4255: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4256: OE_ADV_PRICE_PVT.Insert_Adj(p_header_id);
4257: ELSE
4466: , QP_PREQ_LINES_TMP lines
4467: , QP_LIST_HEADERS_B QH
4468: WHERE
4469: ldets.list_header_id=qh.list_header_id
4470: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
4471: 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)
4472: AND lines.process_status <> 'NOT_VALID'
4473: AND ldets.line_index=lines.line_index
4474: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
4467: , QP_LIST_HEADERS_B QH
4468: WHERE
4469: ldets.list_header_id=qh.list_header_id
4470: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
4471: 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)
4472: AND lines.process_status <> 'NOT_VALID'
4473: AND ldets.line_index=lines.line_index
4474: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
4475: AND nvl(ldets.automatic_flag,'N') = 'Y'
4470: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
4471: 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)
4472: AND lines.process_status <> 'NOT_VALID'
4473: AND ldets.line_index=lines.line_index
4474: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
4475: AND nvl(ldets.automatic_flag,'N') = 'Y'
4476: -- or
4477: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
4478: AND ldets.created_from_list_type_code not in ('PRL','AGR')
4971:
4972: -- AG change --
4973: procedure copy_Header_to_request(
4974: p_header_rec OE_Order_PUB.Header_Rec_Type
4975: ,px_req_line_tbl in out NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE
4976: --,p_pricing_event varchar2
4977: ,p_Request_Type_Code varchar2
4978: ,p_calculate_price_flag varchar2
4979: ,px_line_index in out NOCOPY NUMBER
4978: ,p_calculate_price_flag varchar2
4979: ,px_line_index in out NOCOPY NUMBER
4980: )
4981: is
4982: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
4983: --l_line_index pls_integer := px_req_line_tbl.count;
4984: --
4985: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4986: --
5008: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
5009: Else
5010: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5011: End If;
5012: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5013: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5014: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5015: ELSE
5016: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5009: Else
5010: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5011: End If;
5012: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5013: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5014: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5015: ELSE
5016: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5017: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5010: l_req_line_rec.PRICING_EFFECTIVE_DATE := p_header_rec.pricing_date;
5011: End If;
5012: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5013: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5014: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5015: ELSE
5016: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5017: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5018: THEN
5013: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5014: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5015: ELSE
5016: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5017: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5018: THEN
5019: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5020: END IF;
5021:
5015: ELSE
5016: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5017: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5018: THEN
5019: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5020: END IF;
5021:
5022: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5023: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5019: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5020: END IF;
5021:
5022: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5023: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5024: THEN
5025: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5026: END IF;
5027:
5021:
5022: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5023: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5024: THEN
5025: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5026: END IF;
5027:
5028: END IF;
5029: l_req_line_rec.CURRENCY_CODE := p_Header_rec.transactional_curr_code;
5026: END IF;
5027:
5028: END IF;
5029: l_req_line_rec.CURRENCY_CODE := p_Header_rec.transactional_curr_code;
5030: QP_PREQ_GRP.G_CURRENCY_CODE := l_req_line_rec.currency_code;
5031: l_req_line_rec.PRICE_FLAG := p_calculate_price_flag;
5032: l_req_line_rec.Active_date_first_type := 'ORD';
5033: l_req_line_rec.Active_date_first := p_Header_rec.Ordered_date;
5034: If G_ROUNDING_FLAG = 'Y' Then
5059: G_CURRENCY_CODE_TBL(px_line_index) := l_req_line_rec.CURRENCY_CODE;
5060: G_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.unit_price; -- AG
5061: G_PERCENT_PRICE_TBL(px_line_index) := l_req_line_rec.PERCENT_PRICE;
5062: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.ADJUSTED_UNIT_PRICE;
5063: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
5064: G_PRICE_FLAG_TBL(px_line_index) := l_req_line_rec.PRICE_FLAG;
5065: G_LINE_ID_TBL(px_line_index) := l_req_line_rec.LINE_ID;
5066: G_ROUNDING_FLAG_TBL(px_line_index)
5067: := G_ROUNDING_FLAG; -- AG
5066: G_ROUNDING_FLAG_TBL(px_line_index)
5067: := G_ROUNDING_FLAG; -- AG
5068: G_ROUNDING_FACTOR_TBL(px_line_index) := l_req_line_rec.ROUNDING_FACTOR;
5069: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
5070: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
5071: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
5072:
5073: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
5074: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
5091: end copy_Header_to_request;
5092:
5093: procedure copy_Line_to_request(
5094: p_Line_rec OE_Order_PUB.Line_Rec_Type
5095: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
5096: ,p_pricing_events varchar2
5097: ,p_request_type_code varchar2
5098: ,p_honor_price_flag varchar2
5099: ,px_line_index in out NOCOPY NUMBER
5099: ,px_line_index in out NOCOPY NUMBER
5100: )
5101: is
5102: --l_line_index pls_integer := nvl(px_req_line_tbl.count,0);
5103: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5104: l_uom_rate NUMBER;
5105: v_discounting_privilege VARCHAR2(30);
5106: l_item_type_code VARCHAR2(30);
5107: l_item_rec OE_ORDER_CACHE.item_rec_type; --OPM 2434270
5158:
5159: --rc
5160: l_req_line_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code;
5161:
5162: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5163: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5164: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5165: ELSE
5166: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5159: --rc
5160: l_req_line_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code;
5161:
5162: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5163: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5164: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5165: ELSE
5166: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5167: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5160: l_req_line_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code;
5161:
5162: IF (QP_PREQ_GRP.G_MIN_PRICING_DATE IS NULL) THEN
5163: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5164: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5165: ELSE
5166: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5167: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5168: THEN
5163: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5164: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5165: ELSE
5166: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5167: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5168: THEN
5169: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5170: END IF;
5171:
5165: ELSE
5166: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5167: < TRUNC(QP_PREQ_GRP.G_MIN_PRICING_DATE))
5168: THEN
5169: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5170: END IF;
5171:
5172: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5173: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5169: QP_PREQ_GRP.G_MIN_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5170: END IF;
5171:
5172: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5173: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5174: THEN
5175: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5176:
5177: END IF;
5171:
5172: IF (TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE)
5173: > TRUNC(QP_PREQ_GRP.G_MAX_PRICING_DATE))
5174: THEN
5175: QP_PREQ_GRP.G_MAX_PRICING_DATE := TRUNC(l_req_line_rec.PRICING_EFFECTIVE_DATE);
5176:
5177: END IF;
5178: END IF;
5179: l_req_line_rec.LINE_QUANTITY := p_Line_rec.Ordered_quantity ;
5617: END IF;
5618: G_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.unit_price; -- AG
5619: G_PERCENT_PRICE_TBL(px_line_index) := l_req_line_rec.PERCENT_PRICE;
5620: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := l_req_line_rec.ADJUSTED_UNIT_PRICE;
5621: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
5622: G_PRICE_FLAG_TBL(px_line_index) := l_req_line_rec.PRICE_FLAG;
5623: G_LINE_ID_TBL(px_line_index) := l_req_line_rec.LINE_ID;
5624: IF l_debug_level > 0 THEN
5625: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( PX_LINE_INDEX ) ) ;
5626: END IF;
5627: G_ROUNDING_FLAG_TBL(px_line_index) := G_ROUNDING_FLAG; -- AG
5628: G_ROUNDING_FACTOR_TBL(px_line_index) := l_req_line_rec.ROUNDING_FACTOR;
5629: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
5630: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
5631: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
5632: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
5633: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
5634: G_PRICE_LIST_ID_TBL(px_line_index) :=p_line_rec.price_list_id;
5646: p_pricing_events = 'PRICE' THEN
5647: IF l_debug_level > 0 THEN
5648: oe_debug_pub.add( 'setting process code as UPDATED for override list price');
5649: END IF;
5650: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UPDATED;
5651: END IF;
5652:
5653:
5654: IF l_debug_level > 0 THEN
5668: IF l_debug_level > 0 THEN
5669: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
5670: oe_debug_pub.add('G_CHARGE_PERIODICITY_CODE_TBL.Count:'||G_CHARGE_PERIODICITY_CODE_TBL.COUNT);
5671: END IF;
5672: QP_PREQ_GRP.INSERT_LINES2
5673: (p_LINE_INDEX => G_LINE_INDEX_TBL,
5674: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
5675: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
5676: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,
5723: RAISE FND_API.G_EXC_ERROR;
5724: END IF;
5725:
5726: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
5727: QP_PREQ_GRP.INSERT_LINE_ATTRS2
5728: ( G_ATTR_LINE_INDEX_tbl,
5729: G_ATTR_LINE_DETAIL_INDEX_tbl ,
5730: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
5731: G_ATTR_ATTRIBUTE_TYPE_tbl ,
5942: l_any_frozen_line BOOLEAN:=FALSE;
5943: l_calculate_price_flag varchar2(1);
5944: l_message_displayed Boolean:=FALSE;
5945: --btea begin
5946: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5947: --btea end
5948: l_order_line_id NUMBER;
5949: l_service_reference_line_id NUMBER;
5950: l_completely_frozen BOOLEAN := TRUE;
5959: --2740845 begin
5960: l_agreement_name varchar2(240);
5961: l_revision varchar2(50);
5962: --2740845 end
5963: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5964: --bug 3968023
5965: l_event_in_phase1 VARCHAR2(1);
5966:
5967: begin
6660:
6661: )
6662: IS
6663: l_return_status_text varchar(2000);
6664: l_control_rec QP_PREQ_GRP.control_record_type;
6665: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6666: /*
6667: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6663: l_return_status_text varchar(2000);
6664: l_control_rec QP_PREQ_GRP.control_record_type;
6665: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6666: /*
6667: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6670: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6671: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6664: l_control_rec QP_PREQ_GRP.control_record_type;
6665: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6666: /*
6667: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6670: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6671: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6672: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6665: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
6666: /*
6667: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6670: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6671: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6672: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6673: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6666: /*
6667: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6670: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6671: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6672: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6673: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6674: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6667: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6670: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6671: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6672: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6673: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6674: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6675: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6668: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6670: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6671: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6672: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6673: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6674: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6675: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6676: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6669: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6670: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6671: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6672: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6673: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6674: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6675: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6676: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6677: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6672: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6673: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6674: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6675: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6676: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6677: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6678: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6679: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6680: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6673: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6674: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6675: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6676: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6677: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6678: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6679: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6680: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6681: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6674: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6675: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6676: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6677: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6678: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6679: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6680: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6681: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6682: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6675: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
6676: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6677: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6678: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6679: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6680: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6681: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6682: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6683: */
6676: x_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
6677: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6678: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6679: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6680: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6681: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6682: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6683: */
6684: --
6677: x_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6678: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6679: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6680: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6681: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6682: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6683: */
6684: --
6685: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6678: x_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6679: x_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
6680: x_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
6681: x_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
6682: x_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
6683: */
6684: --
6685: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6686: --
6877: --bug 3696768
6878: cursor reset_ipl_tbl is
6879: select line_id
6880: from qp_preq_lines_tmp
6881: where pricing_status_code <> QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST;
6882: --bug 3696768
6883: cursor wrong_lines is
6884: select line_id
6885: , line_index
6894: , priced_uom_code
6895: from qp_preq_lines_tmp
6896: where process_status <> 'NOT_VALID' and
6897: (pricing_status_code not in
6898: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
6899: QP_PREQ_GRP.G_STATUS_UPDATED,
6900: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
6901: 'NOT_VALID')
6902: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
6895: from qp_preq_lines_tmp
6896: where process_status <> 'NOT_VALID' and
6897: (pricing_status_code not in
6898: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
6899: QP_PREQ_GRP.G_STATUS_UPDATED,
6900: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
6901: 'NOT_VALID')
6902: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
6903: cursor wrong_book_lines is
6896: where process_status <> 'NOT_VALID' and
6897: (pricing_status_code not in
6898: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
6899: QP_PREQ_GRP.G_STATUS_UPDATED,
6900: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
6901: 'NOT_VALID')
6902: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
6903: cursor wrong_book_lines is
6904: select lines.line_id
6923: --bug 3968023
6924: and lines.pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED
6925: ;
6926: -- Bug 2079138: booked lines should always have price
6927: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
6928: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
6929: -- );
6930: --
6931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6924: and lines.pricing_status_code <> QP_PREQ_PUB.G_STATUS_UNCHANGED
6925: ;
6926: -- Bug 2079138: booked lines should always have price
6927: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
6928: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
6929: -- );
6930: --
6931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6932: --
7000: END IF;
7001: l_invalid_line := 'N';
7002: -- add message when the price list is found to be inactive
7003: /*IF wrong_line.line_Type_code ='LINE' and
7004: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
7005: IF not G_IPL_ERRORS_TBL.exists(MOD(l_line_rec.line_id,G_BINARY_LIMIT))
7006: or (G_IPL_ERRORS_TBL.exists(MOD(l_line_rec.line_id,G_BINARY_LIMIT))
7007: and
7008: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT))<>l_line_rec.price_list_id)
7029: l_invalid_line := 'Y';
7030: END IF; */
7031:
7032: if wrong_line.line_Type_code ='LINE' and
7033: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7034: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7035: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7030: END IF; */
7031:
7032: if wrong_line.line_Type_code ='LINE' and
7033: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7034: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7035: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7031:
7032: if wrong_line.line_Type_code ='LINE' and
7033: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7034: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7035: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7032: if wrong_line.line_Type_code ='LINE' and
7033: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
7034: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
7035: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7035: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7043: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7036: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7043: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7044: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7037: FND_API.G_RET_STS_UNEXP_ERROR,
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7043: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7044: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7045: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7038: FND_API.G_RET_STS_ERROR,
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7043: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7044: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7045: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7046: then
7039: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7043: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7044: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7045: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7046: then
7047:
7040: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7043: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7044: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7045: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7046: then
7047:
7048: l_invalid_line := 'Y';
7041: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
7042: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
7043: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
7044: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
7045: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
7046: then
7047:
7048: l_invalid_line := 'Y';
7049: Begin
7053: Exception When No_data_found then
7054: l_price_list := l_line_rec.price_list_id;
7055: End;
7056:
7057: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
7058: IF l_debug_level > 0 THEN
7059: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
7060: END IF;
7061:
7117:
7118: IF l_debug_level > 0 THEN
7119: oe_debug_pub.add('invalid price done');
7120: END IF;
7121: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
7122: IF l_debug_level > 0 THEN
7123: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
7124: END IF;
7125: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7133: end if;
7134: else
7135: OE_MSG_PUB.Add;
7136: end if;
7137: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7138: IF l_debug_level > 0 THEN
7139: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
7140: END IF;
7141: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7149: else
7150: OE_MSG_PUB.Add;
7151: end if;
7152: Elsif wrong_line.pricing_status_code in
7153: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7154: FND_API.G_RET_STS_ERROR)
7155: then
7156: IF l_debug_level > 0 THEN
7157: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7166: end if;
7167: else
7168: OE_MSG_PUB.Add;
7169: end if;
7170: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
7171: IF l_debug_level > 0 THEN
7172: oe_debug_pub.add( 'INVALID UOM' ) ;
7173: END IF;
7174: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
7182: end if;
7183: else
7184: OE_MSG_PUB.Add;
7185: end if;
7186: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
7187: IF l_debug_level > 0 THEN
7188: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;
7189: END IF;
7190: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
7230: end if;
7231: else
7232: OE_MSG_PUB.Add;
7233: end if;
7234: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
7235: IF l_debug_level > 0 THEN
7236: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
7237: END IF;
7238: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
7246: end if;
7247: else
7248: OE_MSG_PUB.Add;
7249: end if;
7250: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
7251: IF l_debug_level > 0 THEN
7252: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
7253: END IF;
7254: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
7262: end if;
7263: else
7264: OE_MSG_PUB.Add;
7265: end if;
7266: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
7267: IF l_debug_level > 0 THEN
7268: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
7269: END IF;
7270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
7316: --btea end
7317:
7318: elsif
7319: wrong_line.line_Type_code ='LINE' and
7320: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
7321: Then
7322:
7323: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7324: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
7372:
7373: end if;
7374:
7375: IF wrong_line.line_type_code='ORDER' THEN
7376: if wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7377: oe_debug_pub.add( 'ERROR IN ORDER LEVEL FORMULA PROCESSING' ) ;
7378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7379: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7380: OE_MSG_PUB.Add;
7603: END IF;
7604: End if;
7605:
7606: -- calculate may change adjustments: adjusted_amount
7607: --IF (p_control_rec.p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
7608: IF (p_header_id IS NOT NULL) THEN
7609: REFRESH_ADJS(p_line_id=>NULL
7610: , p_pricing_events=>p_pricing_events
7611: , p_calculate_flag => p_control_rec.p_calculate_flag);
7800:
7801: qp_price_request_context.set_request_id;
7802:
7803: IF l_debug_level > 0 THEN
7804: oe_debug_pub.add( ' REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
7805: END IF;
7806:
7807: G_IS_THERE_FREEZE_OVERRIDE:=TRUE;
7808: G_IS_THERE_FREEZE_OVERRIDE:=Check_Freeze_Override(p_pricing_events);