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.QP_LIST_UPGRADE_UTIL_PVT dependencies on QP_LIST_HEADERS_B

Line 290: TYPE PRICE_LIST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

286: end_price_list_id number := 0;
287: new_price_list_id number := 0;
288:
289:
290: TYPE PRICE_LIST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
291:
292: TYPE COMMENTSTAB IS TABLE OF QP_LIST_HEADERS_B.COMMENTS%TYPE INDEX BY BINARY_INTEGER;
293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;
294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

Line 292: TYPE COMMENTSTAB IS TABLE OF QP_LIST_HEADERS_B.COMMENTS%TYPE INDEX BY BINARY_INTEGER;

288:
289:
290: TYPE PRICE_LIST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
291:
292: TYPE COMMENTSTAB IS TABLE OF QP_LIST_HEADERS_B.COMMENTS%TYPE INDEX BY BINARY_INTEGER;
293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;
294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

Line 293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;

289:
290: TYPE PRICE_LIST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
291:
292: TYPE COMMENTSTAB IS TABLE OF QP_LIST_HEADERS_B.COMMENTS%TYPE INDEX BY BINARY_INTEGER;
293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;
294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

Line 294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

290: TYPE PRICE_LIST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
291:
292: TYPE COMMENTSTAB IS TABLE OF QP_LIST_HEADERS_B.COMMENTS%TYPE INDEX BY BINARY_INTEGER;
293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;
294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

Line 295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;

291:
292: TYPE COMMENTSTAB IS TABLE OF QP_LIST_HEADERS_B.COMMENTS%TYPE INDEX BY BINARY_INTEGER;
293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;
294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

Line 296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

292: TYPE COMMENTSTAB IS TABLE OF QP_LIST_HEADERS_B.COMMENTS%TYPE INDEX BY BINARY_INTEGER;
293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;
294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

Line 297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

293: TYPE CONTEXTTAB IS TABLE OF QP_LIST_HEADERS_B.CONTEXT%TYPE INDEX BY BINARY_INTEGER;
294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

Line 298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

294: TYPE ATTRIBUTE1TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;

Line 299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

295: TYPE ATTRIBUTE2TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;

Line 300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

296: TYPE ATTRIBUTE3TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;

Line 301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

297: TYPE ATTRIBUTE4TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;

Line 302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;

298: TYPE ATTRIBUTE5TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;

Line 303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;

299: TYPE ATTRIBUTE6TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;

Line 304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;

300: TYPE ATTRIBUTE7TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;

Line 305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;

301: TYPE ATTRIBUTE8TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;

302: TYPE ATTRIBUTE9TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;

303: TYPE ATTRIBUTE10TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;

304: TYPE ATTRIBUTE11TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

305: TYPE ATTRIBUTE12TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

Line 310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;

306: TYPE ATTRIBUTE13TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

Line 311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;

307: TYPE ATTRIBUTE14TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

308: TYPE ATTRIBUTE15TAB IS TABLE OF QP_LIST_HEADERS_B.ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

309: TYPE CURRENCYTAB IS TABLE OF QP_LIST_HEADERS_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;

Line 314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

310: TYPE SHIP_METHOD_TAB IS TABLE OF QP_LIST_HEADERS_B.SHIP_METHOD_CODE%TYPE INDEX BY BINARY_INTEGER;
311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;

Line 315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;

311: TYPE FREIGHT_TERMS_TAB IS TABLE OF QP_LIST_HEADERS_B.FREIGHT_TERMS_CODE%TYPE INDEX BY BINARY_INTEGER;
312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

312: TYPE LIST_HEADER_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;

313: TYPE START_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;

Line 318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;

314: TYPE END_DATE_ACTIVE_TAB IS TABLE OF QP_LIST_HEADERS_B.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;

315: TYPE AUTOMATIC_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.AUTOMATIC_FLAG%TYPE INDEX BY BINARY_INTEGER;
316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;

Line 320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;

316: TYPE LIST_TYPE_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;

Line 321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;

317: TYPE TERMS_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

318: TYPE ROUNDING_FACTOR_TAB IS TABLE OF QP_LIST_HEADERS_B.ROUNDING_FACTOR%TYPE INDEX BY BINARY_INTEGER;
319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;

319: TYPE REQUEST_ID_TAB IS TABLE OF QP_LIST_HEADERS_B.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;
327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;

320: TYPE CREATION_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;
327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;
328: TYPE NAME_TAB IS TABLE OF QP_LIST_HEADERS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

Line 325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;

321: TYPE CREATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;
327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;
328: TYPE NAME_TAB IS TABLE OF QP_LIST_HEADERS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
329: TYPE DESCRIPTION_TAB IS TABLE OF QP_LIST_HEADERS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;

322: TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;
327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;
328: TYPE NAME_TAB IS TABLE OF QP_LIST_HEADERS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
329: TYPE DESCRIPTION_TAB IS TABLE OF QP_LIST_HEADERS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
330:

Line 327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;

323: TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
324: TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
325: TYPE ASK_FOR_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ASK_FOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
326: TYPE SOURCE_SYSTEM_CODE_TAB IS TABLE OF QP_LIST_HEADERS_B.SOURCE_SYSTEM_CODE%TYPE INDEX BY BINARY_INTEGER;
327: TYPE ACTIVE_FLAG_TAB IS TABLE OF QP_LIST_HEADERS_B.ACTIVE_FLAG%TYPE INDEX BY BINARY_INTEGER;
328: TYPE NAME_TAB IS TABLE OF QP_LIST_HEADERS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
329: TYPE DESCRIPTION_TAB IS TABLE OF QP_LIST_HEADERS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
330:
331: type agr_type_tab is table of VARCHAR2(3) index by binary_integer;

Line 420: from qp_list_headers_b lh

416: where dm.old_discount_id = prl.price_list_id
417: and dm.new_type in ('P','Z'))
418:
419: AND not exists ( select 'x'
420: from qp_list_headers_b lh
421: where lh.list_header_id = prl.price_list_id );
422: /* vivek
423: UNION
424: SELECT COMMENTS,

Line 473: from qp_LIST_headers_b

469: SELECT price_list_id, secondary_price_list_id
470: FROM so_price_lists_b spl
471: WHERE secondary_price_list_id is not null
472: and exists ( select list_header_id
473: from qp_LIST_headers_b
474: where list_header_id = spl.secondary_price_list_id )
475: and exists ( select list_header_id
476: from qp_LIST_headers_b
477: where list_header_id = spl.price_list_id );

Line 476: from qp_LIST_headers_b

472: and exists ( select list_header_id
473: from qp_LIST_headers_b
474: where list_header_id = spl.secondary_price_list_id )
475: and exists ( select list_header_id
476: from qp_LIST_headers_b
477: where list_header_id = spl.price_list_id );
478:
479: cursor invalid_sec is
480: select price_list_id, secondary_price_list_id

Line 484: from qp_LIST_headers_b );

480: select price_list_id, secondary_price_list_id
481: from so_price_lists_b spl
482: where secondary_price_list_id is not null
483: and secondary_price_list_id not in ( select list_header_id
484: from qp_LIST_headers_b );
485:
486: cursor invalid_prc is
487: select price_list_id
488: from so_price_lists_b

Line 490: from qp_LIST_headers_b );

486: cursor invalid_prc is
487: select price_list_id
488: from so_price_lists_b
489: where price_list_id not in ( select list_header_id
490: from qp_LIST_headers_b );
491:
492:
493: BEGIN
494:

Line 559: select qp_list_headers_b_s.nextval

555: AND ( AGR_TYPE_T(K) = 'AGR' ) ) then
556:
557: --dbms_output.put_line('pr2.1'||K);
558:
559: select qp_list_headers_b_s.nextval
560: into new_price_list_id
561: from dual;
562:
563: --dbms_output.put_line('pr2.2'||K);

Line 620: INTO qp_LIST_headers_b

616: BEGIN /* forall k in 1_min_price_list..l_max_price_list */
617:
618: FORALL K IN l_min_price_list..l_max_price_list
619: INSERT
620: INTO qp_LIST_headers_b
621: (COMMENTS,
622: CONTEXT,
623: ATTRIBUTE1,
624: ATTRIBUTE2,

Line 965: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_secondary_price_list_id)

961: NULL
962: --ENH Upgrade BOAPI for orig_sys...ref RAVI
963: ,to_char(QP_QUALIFIERS_S.currval)
964: ,null
965: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_secondary_price_list_id)
966: from dual
967: WHERE NOT EXISTS ( select null
968: from qp_qualifiers
969: where qualifier_context = 'MODLIST'

Line 1438: from qp_LIST_headers_b

1434: NULL,
1435: 3
1436: from so_price_list_lines_115 prl
1437: where prl.price_list_id in ( select list_header_id
1438: from qp_LIST_headers_b
1439: where list_type_code = 'PRL')
1440: and not exists ( select null
1441: from qp_LIST_lines
1442: where list_line_id = prl.price_list_line_id )

Line 1503: from qp_list_headers_b qph,

1499: prl.attribute15,
1500: prl.price_list_line_id,
1501: 'AGR',
1502: 3
1503: from qp_list_headers_b qph,
1504: so_price_list_lines_115 prl
1505: where prl.price_list_id = qph.list_header_id
1506: and prl.price_list_id in ( select price_list_id
1507: from so_agreements_b)

Line 1959: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=price_list_ids(K))

1955: 'EXCL',
1956: qualification_ind(k)
1957: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1958: ,to_char(price_list_line_ids(K))
1959: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=price_list_ids(K))
1960: );
1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN