eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_QP_ENGINE dependencies on QP_PREQ_GRP

Line 107: G_I_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;

103: G_EXTRAS_OFFSET NUMBER := 100000; -- offset that is used to lookup into the extras tbl
104:
105:
106: -- input to QP
107: G_I_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_I_LINE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;
110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

Line 108: G_I_LINE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

104:
105:
106: -- input to QP
107: G_I_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_I_LINE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;
110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;

Line 109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;

105:
106: -- input to QP
107: G_I_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_I_LINE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;
110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;

Line 110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;

106: -- input to QP
107: G_I_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_I_LINE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;
110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;

Line 111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

107: G_I_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
108: G_I_LINE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;
110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;

108: G_I_LINE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;
110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;

109: G_I_PRICING_EFFECTIVE_DATE QP_PREQ_GRP.DATE_TYPE ;
110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;

Line 114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;

110: G_I_ACTIVE_DATE_FIRST QP_PREQ_GRP.DATE_TYPE ;
111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;

111: G_I_ACTIVE_DATE_FIRST_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

112: G_I_ACTIVE_DATE_SECOND QP_PREQ_GRP.DATE_TYPE ;
113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

Line 117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;

113: G_I_ACTIVE_DATE_SECOND_TYPE QP_PREQ_GRP.VARCHAR_TYPE ;
114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

Line 118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;

114: G_I_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE ;
115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;

Line 119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;

115: G_I_LINE_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

Line 120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

116: G_I_REQUEST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

Line 121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

117: G_I_PRICED_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;

118: G_I_PRICED_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

119: G_I_CURRENCY_CODE QP_PREQ_GRP.VARCHAR_TYPE;
120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;

Line 124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;

120: G_I_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

121: G_I_PERCENT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

122: G_I_UOM_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;

Line 127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;

123: G_I_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;

Line 128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;

124: G_I_UPD_ADJUSTED_UNIT_PRICE QP_PREQ_GRP.NUMBER_TYPE;
125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;

125: G_I_PROCESSED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;

126: G_I_PRICE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;

127: G_I_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;

Line 132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;

128: G_I_PROCESSING_ORDER QP_PREQ_GRP.PLS_INTEGER_TYPE;
129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

129: G_I_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

130: G_I_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;
138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

Line 135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;

131: G_I_ROUNDING_FLAG QP_PREQ_GRP.FLAG_TYPE;
132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;
138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;

Line 136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

132: G_I_ROUNDING_FACTOR QP_PREQ_GRP.PLS_INTEGER_TYPE;
133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;
138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;
140:

Line 137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;

133: G_I_QUALIFIERS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;
138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;
140:
141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

134: G_I_PRICING_ATTRS_EXIST_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;
138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;
140:
141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;

135: G_I_PRICE_LIST_ID QP_PREQ_GRP.NUMBER_TYPE;
136: G_I_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;
138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;
140:
141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;

Line 141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;

137: G_I_PRICE_REQUEST_CODE QP_PREQ_GRP.VARCHAR_TYPE;
138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;
140:
141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;
144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;

Line 142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;

138: G_I_USAGE_PRICING_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;
140:
141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;
144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;

Line 143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;

139: G_I_LINE_CATEGORY QP_PREQ_GRP.VARCHAR_TYPE;
140:
141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;
144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;

Line 144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

140:
141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;
144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;

Line 145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;

141: G_I_A_LINE_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;
144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;

Line 146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;

142: G_I_A_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;
144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;

Line 147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;

143: G_I_A_ATTRIBUTE_LEVEL QP_PREQ_GRP.VARCHAR_TYPE;
144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;

Line 148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;

144: G_I_A_ATTRIBUTE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;

Line 149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;

145: G_I_A_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;

146: G_I_A_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;

147: G_I_A_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE;
148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

Line 152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;

148: G_I_A_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;

149: G_I_A_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;

150: G_I_A_SETUP_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

151: G_I_A_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;

Line 156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

152: G_I_A_SETUP_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

153: G_I_A_GROUPING_NUMBER QP_PREQ_GRP.PLS_INTEGER_TYPE;
154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;

Line 158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;

154: G_I_A_NO_QUALIFIERS_IN_GRP QP_PREQ_GRP.PLS_INTEGER_TYPE;
155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;

155: G_I_A_COMPARISON_OPERATOR_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

Line 160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;

156: G_I_A_VALIDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;

157: G_I_A_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

158: G_I_A_PRICING_STATUS_CODE QP_PREQ_GRP.VARCHAR_TYPE;
159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

159: G_I_A_PRICING_STATUS_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;

160: G_I_A_QUALIFIER_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

161: G_I_A_DATATYPE QP_PREQ_GRP.VARCHAR_TYPE;
162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;

162: G_I_A_PRICING_ATTR_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
170: G_I_A_PRIMARY_UOM_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

Line 167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;

163: G_I_A_QUALIFIER_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
170: G_I_A_PRIMARY_UOM_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
171:

Line 168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

164: G_I_A_PRODUCT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
170: G_I_A_PRIMARY_UOM_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
171:
172: g_I_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;

165: G_I_A_EXCLUDER_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
170: G_I_A_PRIMARY_UOM_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
171:
172: g_I_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
173: g_I_line_extras_tbl line_extras_tab_type;

Line 170: G_I_A_PRIMARY_UOM_FLAG QP_PREQ_GRP.VARCHAR_TYPE;

166: G_I_A_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
167: G_I_A_INCOMPATABILITY_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
170: G_I_A_PRIMARY_UOM_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
171:
172: g_I_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
173: g_I_line_extras_tbl line_extras_tab_type;
174:

Line 172: g_I_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

168: G_I_A_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
169: G_I_A_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
170: G_I_A_PRIMARY_UOM_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
171:
172: g_I_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
173: g_I_line_extras_tbl line_extras_tab_type;
174:
175: -- output from QP
176: g_O_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 176: g_O_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

172: g_I_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
173: g_I_line_extras_tbl line_extras_tab_type;
174:
175: -- output from QP
176: g_O_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
177: g_O_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
178:
179: -- stores defaults for each pricing event
180: --g_engine_defaults_tab pricing_engine_def_tab_type;

Line 177: g_O_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

173: g_I_line_extras_tbl line_extras_tab_type;
174:
175: -- output from QP
176: g_O_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
177: g_O_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
178:
179: -- stores defaults for each pricing event
180: --g_engine_defaults_tab pricing_engine_def_tab_type;
181:

Line 237: PROCEDURE call_qp_api ( x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

233:
234: --PROCEDURE call_qp_api ( p_event_num IN NUMBER,
235: -- x_return_status OUT VARCHAR2);
236:
237: PROCEDURE call_qp_api ( x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
238: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
239: x_return_status OUT NOCOPY VARCHAR2);
240:
241:

Line 238: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

234: --PROCEDURE call_qp_api ( p_event_num IN NUMBER,
235: -- x_return_status OUT VARCHAR2);
236:
237: PROCEDURE call_qp_api ( x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
238: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
239: x_return_status OUT NOCOPY VARCHAR2);
240:
241:
242: -- return the pointer to the qp outputs

Line 244: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

240:
241:
242: -- return the pointer to the qp outputs
243: PROCEDURE get_qp_output(
244: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
245: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
246: x_return_status OUT NOCOPY VARCHAR2);
247:
248: -- other utility methods ---

Line 245: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

241:
242: -- return the pointer to the qp outputs
243: PROCEDURE get_qp_output(
244: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
245: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
246: x_return_status OUT NOCOPY VARCHAR2);
247:
248: -- other utility methods ---
249:

Line 293: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

289: -- p_line_index IN NUMBER,
290: -- x_return_status OUT VARCHAR2);
291:
292: PROCEDURE delete_lines(p_line_index IN NUMBER,
293: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
294: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
295: x_return_status OUT NOCOPY VARCHAR2);
296:
297: -- clear qp input line table, line extra table, attribute/qualifier tabl

Line 294: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

290: -- x_return_status OUT VARCHAR2);
291:
292: PROCEDURE delete_lines(p_line_index IN NUMBER,
293: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
294: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
295: x_return_status OUT NOCOPY VARCHAR2);
296:
297: -- clear qp input line table, line extra table, attribute/qualifier tabl
298: PROCEDURE clear_qp_input(x_return_status OUT NOCOPY VARCHAR2);