APPS.GMD_SAMPLES_GRP dependencies on MTL_TRANSACTION_LOTS_INTERFACE

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

3726: CLOSE Cur_get_seq;
3727:
3728: IF (l_debug = 'Y') THEN
3729: gmd_debug.put_line('In Procedure create_inv_txn');
3730: gmd_debug.put_line('Input to mtl_transaction_lots_interface table=');
3731: gmd_debug.put_line(' transaction interface ID: ' || p_transaction_interface_id);
3732: gmd_debug.put_line(' header ID: ' || p_header_id);
3733: gmd_debug.put_line(' Sample ID: ' || p_sample.sample_id);
3734: gmd_debug.put_line(' user name : ' || p_user_name);

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

3740:
3741: l_position := '040' ;
3742:
3743: --gml_sf_log('b4 insert');
3744: -- create entry in mtl_transaction_lots_interface table (MTLI)
3745:
3746: --RLNAGARA Bug4753039 Insert into this table only for lot controlled item ie when the lot number is not null
3747: --because from the form we are passing lot number as NULL for Non-lot controlled items.
3748:

Line 3750: INSERT INTO mtl_transaction_lots_interface

3746: --RLNAGARA Bug4753039 Insert into this table only for lot controlled item ie when the lot number is not null
3747: --because from the form we are passing lot number as NULL for Non-lot controlled items.
3748:
3749: IF p_sample.lot_number IS NOT NULL THEN
3750: INSERT INTO mtl_transaction_lots_interface
3751: ( transaction_interface_id
3752: , source_code
3753: , source_line_id
3754: , last_updated_by