DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_GLOBAL

Line 212: WHERE USER_ID=FND_GLOBAL.USER_ID;

208: CURSOR DEFAULT_USER_CUR
209: IS
210: SELECT A.employee_id
211: FROM FND_USER A
212: WHERE USER_ID=FND_GLOBAL.USER_ID;
213:
214: -- Query for Disposition..
215:
216: CURSOR DISPOSITION_CUR(C_WORKORDER_ID NUMBER,C_DISP_ID NUMBER)

Line 1341: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID

1337:
1338: END IF;
1339:
1340: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then
1341: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1342: --Call Service request API to create service request.
1343: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1344: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1345: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type

Line 1565: X_CREATED_BY => FND_GLOBAL.USER_ID,

1561: X_ATTRIBUTE13 => NULL ,
1562: X_ATTRIBUTE14 => NULL ,
1563: X_ATTRIBUTE15 => NULL ,
1564: X_CREATION_DATE => SYSDATE,
1565: X_CREATED_BY => FND_GLOBAL.USER_ID,
1566: X_LAST_UPDATE_DATE => SYSDATE,
1567: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1568: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1569:

Line 1567: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1563: X_ATTRIBUTE15 => NULL ,
1564: X_CREATION_DATE => SYSDATE,
1565: X_CREATED_BY => FND_GLOBAL.USER_ID,
1566: X_LAST_UPDATE_DATE => SYSDATE,
1567: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1568: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1569:
1570: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1571: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;

Line 1568: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1564: X_CREATION_DATE => SYSDATE,
1565: X_CREATED_BY => FND_GLOBAL.USER_ID,
1566: X_LAST_UPDATE_DATE => SYSDATE,
1567: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1568: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1569:
1570: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1571: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;
1572:

Line 2966: l_mmtt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

2962: END IF;
2963:
2964: l_mmtt_rec.LOCK_FLAG := '';
2965: l_mmtt_rec.LAST_UPDATE_DATE := SYSDATE;
2966: l_mmtt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
2967: l_mmtt_rec.CREATION_DATE := SYSDATE;
2968: l_mmtt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
2969: l_mmtt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
2970: --l_mmtt_rec.PROGRAM_APPLICATION_ID :=

Line 2968: l_mmtt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

2964: l_mmtt_rec.LOCK_FLAG := '';
2965: l_mmtt_rec.LAST_UPDATE_DATE := SYSDATE;
2966: l_mmtt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
2967: l_mmtt_rec.CREATION_DATE := SYSDATE;
2968: l_mmtt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
2969: l_mmtt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
2970: --l_mmtt_rec.PROGRAM_APPLICATION_ID :=
2971: --l_mmtt_rec.PROGRAM_ID :=
2972: --l_mmtt_rec.PROGRAM_UPDATE_DATE :=

Line 2969: l_mmtt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;

2965: l_mmtt_rec.LAST_UPDATE_DATE := SYSDATE;
2966: l_mmtt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
2967: l_mmtt_rec.CREATION_DATE := SYSDATE;
2968: l_mmtt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
2969: l_mmtt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
2970: --l_mmtt_rec.PROGRAM_APPLICATION_ID :=
2971: --l_mmtt_rec.PROGRAM_ID :=
2972: --l_mmtt_rec.PROGRAM_UPDATE_DATE :=
2973: l_mmtt_rec.INVENTORY_ITEM_ID := p_x_ahl_mtltxn_rec.Inventory_Item_Id;

Line 3125: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3121: l_mtlt_rec.Transaction_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3122: l_mtlt_rec.Primary_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3123:
3124: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3125: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3126: l_mtlt_rec.CREATION_DATE := SYSDATE;
3127: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3128: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3129:

Line 3127: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3123:
3124: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3125: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3126: l_mtlt_rec.CREATION_DATE := SYSDATE;
3127: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3128: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3129:
3130: l_msnt_rec.Transaction_Temp_Id := l_Srl_Txn_Tmp_Id;
3131: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;

Line 3128: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;

3124: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3125: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3126: l_mtlt_rec.CREATION_DATE := SYSDATE;
3127: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3128: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3129:
3130: l_msnt_rec.Transaction_Temp_Id := l_Srl_Txn_Tmp_Id;
3131: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3132: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;

Line 3134: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3130: l_msnt_rec.Transaction_Temp_Id := l_Srl_Txn_Tmp_Id;
3131: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3132: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3133: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3134: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3135: l_msnt_rec.CREATION_DATE := SYSDATE;
3136: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3137: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3138:

Line 3136: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3132: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3133: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3134: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3135: l_msnt_rec.CREATION_DATE := SYSDATE;
3136: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3137: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3138:
3139: IF G_DEBUG='Y' THEN
3140: AHL_DEBUG_PUB.debug('inserting in mtlt..');

Line 3137: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;

3133: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3134: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3135: l_msnt_rec.CREATION_DATE := SYSDATE;
3136: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3137: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3138:
3139: IF G_DEBUG='Y' THEN
3140: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3141: END IF;

Line 3188: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3184: --l_mtlt_rec.Lot_Expiration_Date := p_x_ahl_mtltxn_rec.Lot_Expiration_Date;
3185: l_mtlt_rec.Transaction_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3186: l_mtlt_rec.Primary_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3187: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3188: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3189: l_mtlt_rec.CREATION_DATE := SYSDATE;
3190: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3191: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3192:

Line 3190: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3186: l_mtlt_rec.Primary_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3187: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3188: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3189: l_mtlt_rec.CREATION_DATE := SYSDATE;
3190: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3191: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3192:
3193: IF G_DEBUG='Y' THEN
3194: AHL_DEBUG_PUB.debug('inserting in mtlt..');

Line 3191: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;

3187: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3188: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3189: l_mtlt_rec.CREATION_DATE := SYSDATE;
3190: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3191: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3192:
3193: IF G_DEBUG='Y' THEN
3194: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3195:

Line 3220: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3216: l_msnt_rec.Transaction_Temp_Id := x_Txn_Tmp_Id;
3217: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3218: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3219: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3220: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3221: l_msnt_rec.CREATION_DATE := SYSDATE;
3222: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3223: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3224:

Line 3222: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;

3218: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3219: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3220: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3221: l_msnt_rec.CREATION_DATE := SYSDATE;
3222: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3223: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3224:
3225: IF G_DEBUG='Y' THEN
3226: AHL_DEBUG_PUB.debug('inserting in msnt..');

Line 3223: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;

3219: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3220: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3221: l_msnt_rec.CREATION_DATE := SYSDATE;
3222: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3223: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3224:
3225: IF G_DEBUG='Y' THEN
3226: AHL_DEBUG_PUB.debug('inserting in msnt..');
3227:

Line 3742: FND_GLOBAL.USER_ID,

3738: VALUES(p_x_txn_intf_id,
3739: l_Source_Code,
3740: l_Source_Line_Id,
3741: sysdate,
3742: FND_GLOBAL.USER_ID,
3743: sysdate,
3744: FND_GLOBAL.USER_ID,
3745: FND_GLOBAL.LOGIN_ID,
3746: p_x_ahl_mtl_txn_rec.Lot_Number,

Line 3744: FND_GLOBAL.USER_ID,

3740: l_Source_Line_Id,
3741: sysdate,
3742: FND_GLOBAL.USER_ID,
3743: sysdate,
3744: FND_GLOBAL.USER_ID,
3745: FND_GLOBAL.LOGIN_ID,
3746: p_x_ahl_mtl_txn_rec.Lot_Number,
3747: l_lot_expiration_Date,
3748: l_qty,

Line 3745: FND_GLOBAL.LOGIN_ID,

3741: sysdate,
3742: FND_GLOBAL.USER_ID,
3743: sysdate,
3744: FND_GLOBAL.USER_ID,
3745: FND_GLOBAL.LOGIN_ID,
3746: p_x_ahl_mtl_txn_rec.Lot_Number,
3747: l_lot_expiration_Date,
3748: l_qty,
3749: l_qty,

Line 3774: FND_GLOBAL.USER_ID,

3770: VALUES ( l_txn_tmp_id,
3771: l_source_code,
3772: l_source_line_id,
3773: SYSDATE,
3774: FND_GLOBAL.USER_ID,
3775: SYSDATE,
3776: FND_GLOBAL.USER_ID,
3777: FND_GLOBAL.LOGIN_ID,
3778: p_x_ahl_mtl_txn_rec.Serial_Number,

Line 3776: FND_GLOBAL.USER_ID,

3772: l_source_line_id,
3773: SYSDATE,
3774: FND_GLOBAL.USER_ID,
3775: SYSDATE,
3776: FND_GLOBAL.USER_ID,
3777: FND_GLOBAL.LOGIN_ID,
3778: p_x_ahl_mtl_txn_rec.Serial_Number,
3779: p_x_ahl_mtl_txn_rec.Serial_Number,
3780: l_Process_Flag );

Line 3777: FND_GLOBAL.LOGIN_ID,

3773: SYSDATE,
3774: FND_GLOBAL.USER_ID,
3775: SYSDATE,
3776: FND_GLOBAL.USER_ID,
3777: FND_GLOBAL.LOGIN_ID,
3778: p_x_ahl_mtl_txn_rec.Serial_Number,
3779: p_x_ahl_mtl_txn_rec.Serial_Number,
3780: l_Process_Flag );
3781: END IF;

Line 3832: sysdate, FND_GLOBAL.USER_ID,

3828: values (p_x_txn_intf_id, p_x_txn_hdr_id,
3829: l_Source_Code, l_Source_Line_Id,
3830: l_Source_Header_Id, l_Process_Flag,
3831: l_Validation_required , l_transaction_Mode,
3832: sysdate, FND_GLOBAL.USER_ID,
3833: sysdate, FND_GLOBAL.USER_ID,
3834: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,
3835: p_x_ahl_mtl_txn_rec.Organization_Id, l_qty,
3836: l_qty, p_x_ahl_mtl_txn_rec.Uom,

Line 3833: sysdate, FND_GLOBAL.USER_ID,

3829: l_Source_Code, l_Source_Line_Id,
3830: l_Source_Header_Id, l_Process_Flag,
3831: l_Validation_required , l_transaction_Mode,
3832: sysdate, FND_GLOBAL.USER_ID,
3833: sysdate, FND_GLOBAL.USER_ID,
3834: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,
3835: p_x_ahl_mtl_txn_rec.Organization_Id, l_qty,
3836: l_qty, p_x_ahl_mtl_txn_rec.Uom,
3837: p_x_ahl_mtl_txn_rec.Transaction_Date, p_x_ahl_mtl_txn_rec.Subinventory_Name,

Line 3834: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,

3830: l_Source_Header_Id, l_Process_Flag,
3831: l_Validation_required , l_transaction_Mode,
3832: sysdate, FND_GLOBAL.USER_ID,
3833: sysdate, FND_GLOBAL.USER_ID,
3834: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,
3835: p_x_ahl_mtl_txn_rec.Organization_Id, l_qty,
3836: l_qty, p_x_ahl_mtl_txn_rec.Uom,
3837: p_x_ahl_mtl_txn_rec.Transaction_Date, p_x_ahl_mtl_txn_rec.Subinventory_Name,
3838: p_x_ahl_mtl_txn_rec.Locator_Id, p_x_ahl_mtl_txn_rec.Transaction_Type_Id,