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.INV_RESERVATION_GLOBAL dependencies on FND_API

Line 244: -- what the hell are those fnd_api.g_miss_xxx ?

240:
241: --
242: -- Topic
243: -- What is use for mtl_reservation_rec_type ? And
244: -- what the hell are those fnd_api.g_miss_xxx ?
245: --
246: -- The server side reservation apis use records of mtl_reservation_rec_type as
247: -- input and/or output parameters. The attributes are initialized to
248: -- fnd_api.g_miss_xxx corresponding to their datatypes. For detail discussion

Line 248: -- fnd_api.g_miss_xxx corresponding to their datatypes. For detail discussion

244: -- what the hell are those fnd_api.g_miss_xxx ?
245: --
246: -- The server side reservation apis use records of mtl_reservation_rec_type as
247: -- input and/or output parameters. The attributes are initialized to
248: -- fnd_api.g_miss_xxx corresponding to their datatypes. For detail discussion
249: -- about fnd_api.g_miss_xxx, please refers to the PLSQL Business Object API
250: -- Coding Standard, available from
251: -- http://www-apps.us.oracle.com/atg/standards/codestan.html
252: -- (link API Standards Draft).

Line 249: -- about fnd_api.g_miss_xxx, please refers to the PLSQL Business Object API

245: --
246: -- The server side reservation apis use records of mtl_reservation_rec_type as
247: -- input and/or output parameters. The attributes are initialized to
248: -- fnd_api.g_miss_xxx corresponding to their datatypes. For detail discussion
249: -- about fnd_api.g_miss_xxx, please refers to the PLSQL Business Object API
250: -- Coding Standard, available from
251: -- http://www-apps.us.oracle.com/atg/standards/codestan.html
252: -- (link API Standards Draft).
253: --

Line 373: reservation_id NUMBER := fnd_api.g_miss_num

369: -- INVCONV
370: -- Add secondary_ columns for DUAL UOM
371: TYPE mtl_reservation_rec_type is RECORD
372: (
373: reservation_id NUMBER := fnd_api.g_miss_num
374: , requirement_date DATE := fnd_api.g_miss_date
375: , organization_id NUMBER := fnd_api.g_miss_num
376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num

Line 374: , requirement_date DATE := fnd_api.g_miss_date

370: -- Add secondary_ columns for DUAL UOM
371: TYPE mtl_reservation_rec_type is RECORD
372: (
373: reservation_id NUMBER := fnd_api.g_miss_num
374: , requirement_date DATE := fnd_api.g_miss_date
375: , organization_id NUMBER := fnd_api.g_miss_num
376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char

Line 375: , organization_id NUMBER := fnd_api.g_miss_num

371: TYPE mtl_reservation_rec_type is RECORD
372: (
373: reservation_id NUMBER := fnd_api.g_miss_num
374: , requirement_date DATE := fnd_api.g_miss_date
375: , organization_id NUMBER := fnd_api.g_miss_num
376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num

Line 376: , inventory_item_id NUMBER := fnd_api.g_miss_num

372: (
373: reservation_id NUMBER := fnd_api.g_miss_num
374: , requirement_date DATE := fnd_api.g_miss_date
375: , organization_id NUMBER := fnd_api.g_miss_num
376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num

Line 377: , demand_source_type_id NUMBER := fnd_api.g_miss_num

373: reservation_id NUMBER := fnd_api.g_miss_num
374: , requirement_date DATE := fnd_api.g_miss_date
375: , organization_id NUMBER := fnd_api.g_miss_num
376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num

Line 378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char

374: , requirement_date DATE := fnd_api.g_miss_date
375: , organization_id NUMBER := fnd_api.g_miss_num
376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

Line 379: , demand_source_header_id NUMBER := fnd_api.g_miss_num

375: , organization_id NUMBER := fnd_api.g_miss_num
376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num

Line 380: , demand_source_line_id NUMBER := fnd_api.g_miss_num

376: , inventory_item_id NUMBER := fnd_api.g_miss_num
377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

Line 381: , demand_source_delivery NUMBER := fnd_api.g_miss_num

377: , demand_source_type_id NUMBER := fnd_api.g_miss_num
378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num

Line 382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

378: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char

Line 383: , primary_uom_id NUMBER := fnd_api.g_miss_num

379: , demand_source_header_id NUMBER := fnd_api.g_miss_num
380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num

Line 384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

380: , demand_source_line_id NUMBER := fnd_api.g_miss_num
381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num

Line 385: , secondary_uom_id NUMBER := fnd_api.g_miss_num

381: , demand_source_delivery NUMBER := fnd_api.g_miss_num
382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num

Line 386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char

382: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num

Line 387: , reservation_uom_id NUMBER := fnd_api.g_miss_num

383: , primary_uom_id NUMBER := fnd_api.g_miss_num
384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num

Line 388: , reservation_quantity NUMBER := fnd_api.g_miss_num

384: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num

Line 389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num

385: , secondary_uom_id NUMBER := fnd_api.g_miss_num
386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num

Line 390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num

386: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char

Line 391: , detailed_quantity NUMBER := fnd_api.g_miss_num

387: , reservation_uom_id NUMBER := fnd_api.g_miss_num
388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num

Line 392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num

388: , reservation_quantity NUMBER := fnd_api.g_miss_num
389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num

Line 393: , autodetail_group_id NUMBER := fnd_api.g_miss_num

389: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num

Line 394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char

390: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num

Line 395: , external_source_line_id NUMBER := fnd_api.g_miss_num

391: , detailed_quantity NUMBER := fnd_api.g_miss_num
392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char

Line 396: , supply_source_type_id NUMBER := fnd_api.g_miss_num

392: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num

Line 397: , supply_source_header_id NUMBER := fnd_api.g_miss_num

393: , autodetail_group_id NUMBER := fnd_api.g_miss_num
394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char

Line 398: , supply_source_line_id NUMBER := fnd_api.g_miss_num

394: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char

Line 399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char

395: , external_source_line_id NUMBER := fnd_api.g_miss_num
396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num

Line 400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num

396: , supply_source_type_id NUMBER := fnd_api.g_miss_num
397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num

Line 401: , revision VARCHAR2(3) := fnd_api.g_miss_char

397: , supply_source_header_id NUMBER := fnd_api.g_miss_num
398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.

Line 402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char

398: , supply_source_line_id NUMBER := fnd_api.g_miss_num
399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num

Line 403: , subinventory_id NUMBER := fnd_api.g_miss_num

399: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num

Line 404: , locator_id NUMBER := fnd_api.g_miss_num

400: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num

Line 405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.

401: , revision VARCHAR2(3) := fnd_api.g_miss_char
402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char

Line 406: , lot_number_id NUMBER := fnd_api.g_miss_num

402: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char

Line 407: , pick_slip_number NUMBER := fnd_api.g_miss_num

403: , subinventory_id NUMBER := fnd_api.g_miss_num
404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char

Line 408: , lpn_id NUMBER := fnd_api.g_miss_num

404: , locator_id NUMBER := fnd_api.g_miss_num
405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char

Line 409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char

405: , lot_number VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV changed to 80 chars.
406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char

Line 410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char

406: , lot_number_id NUMBER := fnd_api.g_miss_num
407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char

Line 411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char

407: , pick_slip_number NUMBER := fnd_api.g_miss_num
408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char

Line 412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char

408: , lpn_id NUMBER := fnd_api.g_miss_num
409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char

Line 413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char

409: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char

Line 414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char

410: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char

Line 415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char

411: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char

Line 416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char

412: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char

Line 417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char

413: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char

Line 418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char

414: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char

Line 419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char

415: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char

Line 420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char

416: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char

Line 421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char

417: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
425: , ship_ready_flag NUMBER := fnd_api.g_miss_num

Line 422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char

418: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
425: , ship_ready_flag NUMBER := fnd_api.g_miss_num
426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char

Line 423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char

419: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
425: , ship_ready_flag NUMBER := fnd_api.g_miss_num
426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
427:

Line 424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char

420: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
425: , ship_ready_flag NUMBER := fnd_api.g_miss_num
426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
427:
428: /**** {{ R12 Enhanced reservations code changes }}****/

Line 425: , ship_ready_flag NUMBER := fnd_api.g_miss_num

421: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
425: , ship_ready_flag NUMBER := fnd_api.g_miss_num
426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
427:
428: /**** {{ R12 Enhanced reservations code changes }}****/
429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char

Line 426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char

422: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
423: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
424: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
425: , ship_ready_flag NUMBER := fnd_api.g_miss_num
426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
427:
428: /**** {{ R12 Enhanced reservations code changes }}****/
429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num

Line 429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char

425: , ship_ready_flag NUMBER := fnd_api.g_miss_num
426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
427:
428: /**** {{ R12 Enhanced reservations code changes }}****/
429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date

Line 430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num

426: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
427:
428: /**** {{ R12 Enhanced reservations code changes }}****/
429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date

Line 431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num

427:
428: /**** {{ R12 Enhanced reservations code changes }}****/
429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num

Line 432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num

428: /**** {{ R12 Enhanced reservations code changes }}****/
429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num

Line 433: , supply_receipt_date DATE := fnd_api.g_miss_date

429: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num

Line 434: , demand_ship_date DATE := fnd_api.g_miss_date

430: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num

Line 435: , project_id NUMBER := fnd_api.g_miss_num

431: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num

Line 436: , task_id NUMBER := fnd_api.g_miss_num

432: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num

Line 437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num

433: , supply_receipt_date DATE := fnd_api.g_miss_date
434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num

Line 438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num

434: , demand_ship_date DATE := fnd_api.g_miss_date
435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num

Line 439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num

435: , project_id NUMBER := fnd_api.g_miss_num
436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num

Line 440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num

436: , task_id NUMBER := fnd_api.g_miss_num
437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
444: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num

Line 441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num

437: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
444: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
445: , serial_number VARCHAR2(30) := fnd_api.g_miss_char

Line 442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num

438: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
444: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
445: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
446: -- Original supply and demand information will just be passed back as part

Line 443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num

439: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
444: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
445: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
446: -- Original supply and demand information will just be passed back as part
447: -- of the reservation record. No processing or query will be based on

Line 444: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num

440: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
444: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
445: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
446: -- Original supply and demand information will just be passed back as part
447: -- of the reservation record. No processing or query will be based on
448: -- these parameters. Before every reservation API, these parameters will

Line 445: , serial_number VARCHAR2(30) := fnd_api.g_miss_char

441: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
442: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
443: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
444: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
445: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
446: -- Original supply and demand information will just be passed back as part
447: -- of the reservation record. No processing or query will be based on
448: -- these parameters. Before every reservation API, these parameters will
449: -- be set to g_miss_num. Only the output will contain these values from

Line 497: demand_source_line_id NUMBER := fnd_api.g_miss_num

493: --Table to return Failed reservations when do_check performed at commit
494: --original procedure is in INV_RESERVATION_PVT
495: TYPE mtl_failed_rsv_rec_type IS RECORD
496: (
497: demand_source_line_id NUMBER := fnd_api.g_miss_num
498: ,demand_source_header_id NUMBER :=fnd_api.g_miss_num
499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char
500: ,reservation_id NUMBER := fnd_api.g_miss_num
501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num

Line 498: ,demand_source_header_id NUMBER :=fnd_api.g_miss_num

494: --original procedure is in INV_RESERVATION_PVT
495: TYPE mtl_failed_rsv_rec_type IS RECORD
496: (
497: demand_source_line_id NUMBER := fnd_api.g_miss_num
498: ,demand_source_header_id NUMBER :=fnd_api.g_miss_num
499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char
500: ,reservation_id NUMBER := fnd_api.g_miss_num
501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num
502: ,Organization_id NUMBER := fnd_api.g_miss_num

Line 499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char

495: TYPE mtl_failed_rsv_rec_type IS RECORD
496: (
497: demand_source_line_id NUMBER := fnd_api.g_miss_num
498: ,demand_source_header_id NUMBER :=fnd_api.g_miss_num
499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char
500: ,reservation_id NUMBER := fnd_api.g_miss_num
501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num
502: ,Organization_id NUMBER := fnd_api.g_miss_num
503: ,Primary_reservation_quantity NUMBER := fnd_api.g_miss_num

Line 500: ,reservation_id NUMBER := fnd_api.g_miss_num

496: (
497: demand_source_line_id NUMBER := fnd_api.g_miss_num
498: ,demand_source_header_id NUMBER :=fnd_api.g_miss_num
499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char
500: ,reservation_id NUMBER := fnd_api.g_miss_num
501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num
502: ,Organization_id NUMBER := fnd_api.g_miss_num
503: ,Primary_reservation_quantity NUMBER := fnd_api.g_miss_num
504: );

Line 501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num

497: demand_source_line_id NUMBER := fnd_api.g_miss_num
498: ,demand_source_header_id NUMBER :=fnd_api.g_miss_num
499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char
500: ,reservation_id NUMBER := fnd_api.g_miss_num
501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num
502: ,Organization_id NUMBER := fnd_api.g_miss_num
503: ,Primary_reservation_quantity NUMBER := fnd_api.g_miss_num
504: );
505: TYPE mtl_failed_rsv_tbl_type is TABLE OF mtl_failed_rsv_rec_type INDEX BY BINARY_INTEGER;

Line 502: ,Organization_id NUMBER := fnd_api.g_miss_num

498: ,demand_source_header_id NUMBER :=fnd_api.g_miss_num
499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char
500: ,reservation_id NUMBER := fnd_api.g_miss_num
501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num
502: ,Organization_id NUMBER := fnd_api.g_miss_num
503: ,Primary_reservation_quantity NUMBER := fnd_api.g_miss_num
504: );
505: TYPE mtl_failed_rsv_tbl_type is TABLE OF mtl_failed_rsv_rec_type INDEX BY BINARY_INTEGER;
506:

Line 503: ,Primary_reservation_quantity NUMBER := fnd_api.g_miss_num

499: ,demand_source_name VARCHAR2(1000) := fnd_api.g_miss_char
500: ,reservation_id NUMBER := fnd_api.g_miss_num
501: ,Inventory_item_id NUMBER := fnd_api.g_miss_num
502: ,Organization_id NUMBER := fnd_api.g_miss_num
503: ,Primary_reservation_quantity NUMBER := fnd_api.g_miss_num
504: );
505: TYPE mtl_failed_rsv_tbl_type is TABLE OF mtl_failed_rsv_rec_type INDEX BY BINARY_INTEGER;
506:
507: --