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.OZF_ORDER_PRICE_PVT dependencies on QP_PREQ_GRP

Line 191: ,p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE

187:
188: ,x_return_status OUT NOCOPY VARCHAR2
189: ,x_msg_data OUT NOCOPY VARCHAR2
190: ,x_msg_count OUT NOCOPY NUMBER
191: ,p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE
192: ,xp_line_tbl IN OUT NOCOPY LINE_REC_TBL_TYPE
193: ,x_ldets_tbl OUT NOCOPY LDETS_TBL_TYPE
194: ,x_related_lines_tbl OUT NOCOPY RLTD_LINE_TBL_TYPE
195: )IS

Line 209: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE := p_control_rec;

205: l_price_return_msg varchar2(240);
206:
207: I Number;
208: l_header_build boolean :=False;
209: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE := p_control_rec;
210:
211: cursor cl_lines_tmp is
212: select *
213: from qp_preq_lines_tmp

Line 219: where pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

215:
216: cursor cl_ldets_tmp is
217: select *
218: from qp_ldets_v
219: where pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
220:
221: CURSOR cl_rltd_tmp IS
222: SELECT *
223: FROM QP_PREQ_RLTD_LINES_TMP

Line 224: WHERE PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW

220:
221: CURSOR cl_rltd_tmp IS
222: SELECT *
223: FROM QP_PREQ_RLTD_LINES_TMP
224: WHERE PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
225: ORDER BY SETUP_VALUE_FROM;
226:
227: cursor cl_line_attrs_tmp is
228: select *

Line 231: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;

227: cursor cl_line_attrs_tmp is
228: select *
229: from qp_preq_line_attrs_tmp_t;
230:
231: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
232: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 232: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

228: select *
229: from qp_preq_line_attrs_tmp_t;
230:
231: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
232: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

Line 233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;

229: from qp_preq_line_attrs_tmp_t;
230:
231: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
232: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

Line 234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;

230:
231: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
232: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

Line 235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

231: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
232: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

232: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

233: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

234: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

235: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

236: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

237: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

238: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

239: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

240: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

241: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

242: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
250: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

243: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
250: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
251:

Line 248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

244: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
250: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
251:
252: --mkothari 13-dec-2006

Line 249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

245: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
250: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
251:
252: --mkothari 13-dec-2006
253: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 250: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

246: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
247: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
248: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
250: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
251:
252: --mkothari 13-dec-2006
253: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
254:

Line 253: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

249: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
250: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
251:
252: --mkothari 13-dec-2006
253: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
254:
255: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 255: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

251:
252: --mkothari 13-dec-2006
253: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
254:
255: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

Line 256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

252: --mkothari 13-dec-2006
253: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
254:
255: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

253: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
254:
255: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

254:
255: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

255: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

256: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

257: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

258: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

259: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
267: /*

Line 264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

260: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
267: /*
268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

261: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
267: /*
268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
269: G_CONTRACT_START_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;

Line 266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

262: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
263: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
267: /*
268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
269: G_CONTRACT_START_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
270: G_CONTRACT_END_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;

Line 268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

264: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
267: /*
268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
269: G_CONTRACT_START_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
270: G_CONTRACT_END_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
271: G_LINE_UNIT_PRICE_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
272: */

Line 269: G_CONTRACT_START_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;

265: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
267: /*
268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
269: G_CONTRACT_START_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
270: G_CONTRACT_END_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
271: G_LINE_UNIT_PRICE_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
272: */
273: BEGIN

Line 270: G_CONTRACT_END_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;

266: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
267: /*
268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
269: G_CONTRACT_START_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
270: G_CONTRACT_END_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
271: G_LINE_UNIT_PRICE_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
272: */
273: BEGIN
274: -- Standard begin of API savepoint

Line 271: G_LINE_UNIT_PRICE_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;

267: /*
268: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
269: G_CONTRACT_START_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
270: G_CONTRACT_END_DATE_DEF_TBL QP_PREQ_GRP.DATE_TYPE;
271: G_LINE_UNIT_PRICE_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
272: */
273: BEGIN
274: -- Standard begin of API savepoint
275: SAVEPOINT Get_Order_Price_pvt;

Line 436: G_PRICING_STATUS_CODE_tbl(I):= QP_PREQ_GRP.G_STATUS_UNCHANGED;

432: G_LINE_ID_TBL(I):= xp_line_tbl(I).line_Id;
433: G_PROCESSING_ORDER_TBL(I):= xp_line_tbl(I).PROCESSING_ORDER;
434:
435: -- Always this value
436: G_PRICING_STATUS_CODE_tbl(I):= QP_PREQ_GRP.G_STATUS_UNCHANGED;
437:
438: G_PRICING_STATUS_TEXT_tbl(I):= xp_line_tbl(I).PRICING_STATUS_TEXT;
439: G_ROUNDING_FLAG_TBL(I):= xp_line_tbl(I).ROUNDING_FLAG;
440: G_ROUNDING_FACTOR_TBL(I):= xp_line_tbl(I).ROUNDING_FACTOR;

Line 515: QP_PREQ_GRP.INSERT_LINES2

511: IF OZF_DEBUG_LOW_ON THEN
512: ozf_utility_PVT.debug_message('Before insert_lines2' );
513: END IF;
514:
515: QP_PREQ_GRP.INSERT_LINES2
516: (p_LINE_INDEX => G_LINE_INDEX_TBL,
517: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
518: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
519: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,