[Home] [Help]
59: item_desc VARCHAR2(240),
60: project_id number default null,
61: task_id number default null,
62: lot_number mtl_lot_numbers.lot_number%TYPE DEFAULT NULL,
63: serial_number mtl_serial_numbers.serial_number%TYPE DEFAULT NULL, --9651496,9764650
64: req_header_id NUMBER --12546176
65: );
66:
67: TYPE cascaded_trans_tab_type IS TABLE OF cascaded_trans_rec_type
680: PROCEDURE insert_mtlt
681: (p_mtlt_rec mtl_transaction_lots_temp%ROWTYPE);
682:
683: PROCEDURE insert_msnt
684: (p_msnt_rec mtl_serial_numbers_temp%ROWTYPE);
685:
686: PROCEDURE GET_SERIAL_CTRL
687: (x_return_status OUT NOCOPY VARCHAR2,
688: x_serial_control OUT NOCOPY NUMBER,