APPS.GMD_SAMPLES_GRP dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');

4363: CLOSE Cur_get_seq;
4364:
4365: IF (l_debug = 'Y') THEN
4366: gmd_debug.put_line('In Procedure create_inv_txn');
4367: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
4368: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
4369: gmd_debug.put_line(' header ID: ' || p_header_id);
4370: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
4371: gmd_debug.put_line(' user name : ' || p_user_name);

Line 4382: -- create entry in mtl_transaction_lots_interface table (MTLI)

4378:
4379: l_position := '040' ;
4380:
4381: --gml_sf_log('b4 insert');
4382: -- create entry in mtl_transaction_lots_interface table (MTLI)
4383:
4384: --RLNAGARA Bug4753039 Insert into this table only for lot controlled item ie when the lot number is not null
4385: --because from the form we are passing lot number as NULL for Non-lot controlled items.
4386:

Line 4388: INSERT INTO mtl_transaction_lots_interface

4384: --RLNAGARA Bug4753039 Insert into this table only for lot controlled item ie when the lot number is not null
4385: --because from the form we are passing lot number as NULL for Non-lot controlled items.
4386:
4387: IF p_sample.lot_number IS NOT NULL THEN
4388: INSERT INTO mtl_transaction_lots_interface
4389: ( transaction_interface_id
4390: , source_code
4391: , source_line_id
4392: , last_updated_by