DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_GLOBAL

Line 223: WHERE USER_ID=FND_GLOBAL.USER_ID;

219: CURSOR DEFAULT_USER_CUR
220: IS
221: SELECT A.employee_id
222: FROM FND_USER A
223: WHERE USER_ID=FND_GLOBAL.USER_ID;
224:
225: -- Query for Disposition..
226:
227: CURSOR DISPOSITION_CUR(C_WORKORDER_ID NUMBER,C_DISP_ID NUMBER)

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

1626:
1627: END IF;
1628:
1629: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then
1630: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1631: --Call Service request API to create service request.
1632: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1633: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1634: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type

Line 1854: X_CREATED_BY => FND_GLOBAL.USER_ID,

1850: X_ATTRIBUTE13 => NULL ,
1851: X_ATTRIBUTE14 => NULL ,
1852: X_ATTRIBUTE15 => NULL ,
1853: X_CREATION_DATE => SYSDATE,
1854: X_CREATED_BY => FND_GLOBAL.USER_ID,
1855: X_LAST_UPDATE_DATE => SYSDATE,
1856: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1857: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1858:

Line 1856: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1852: X_ATTRIBUTE15 => NULL ,
1853: X_CREATION_DATE => SYSDATE,
1854: X_CREATED_BY => FND_GLOBAL.USER_ID,
1855: X_LAST_UPDATE_DATE => SYSDATE,
1856: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1857: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1858:
1859: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1860: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;

Line 1857: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1853: X_CREATION_DATE => SYSDATE,
1854: X_CREATED_BY => FND_GLOBAL.USER_ID,
1855: X_LAST_UPDATE_DATE => SYSDATE,
1856: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1857: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1858:
1859: select AHL_WORKORDER_MTL_TXNS_S.currval into p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id from dual;
1860: -- p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id:=x_ahl_mtl_txn_id;
1861:

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

3529: END IF;
3530:
3531: l_mmtt_rec.LOCK_FLAG := '';
3532: l_mmtt_rec.LAST_UPDATE_DATE := SYSDATE;
3533: l_mmtt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3534: l_mmtt_rec.CREATION_DATE := SYSDATE;
3535: l_mmtt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3536: l_mmtt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3537: --l_mmtt_rec.PROGRAM_APPLICATION_ID :=

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

3531: l_mmtt_rec.LOCK_FLAG := '';
3532: l_mmtt_rec.LAST_UPDATE_DATE := SYSDATE;
3533: l_mmtt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3534: l_mmtt_rec.CREATION_DATE := SYSDATE;
3535: l_mmtt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3536: l_mmtt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3537: --l_mmtt_rec.PROGRAM_APPLICATION_ID :=
3538: --l_mmtt_rec.PROGRAM_ID :=
3539: --l_mmtt_rec.PROGRAM_UPDATE_DATE :=

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

3532: l_mmtt_rec.LAST_UPDATE_DATE := SYSDATE;
3533: l_mmtt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3534: l_mmtt_rec.CREATION_DATE := SYSDATE;
3535: l_mmtt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3536: l_mmtt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3537: --l_mmtt_rec.PROGRAM_APPLICATION_ID :=
3538: --l_mmtt_rec.PROGRAM_ID :=
3539: --l_mmtt_rec.PROGRAM_UPDATE_DATE :=
3540: l_mmtt_rec.INVENTORY_ITEM_ID := p_x_ahl_mtltxn_rec.Inventory_Item_Id;

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

3688: l_mtlt_rec.Transaction_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3689: l_mtlt_rec.Primary_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3690:
3691: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3692: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3693: l_mtlt_rec.CREATION_DATE := SYSDATE;
3694: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3695: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3696:

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

3690:
3691: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3692: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3693: l_mtlt_rec.CREATION_DATE := SYSDATE;
3694: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3695: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3696:
3697: l_msnt_rec.Transaction_Temp_Id := l_Srl_Txn_Tmp_Id;
3698: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;

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

3691: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3692: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3693: l_mtlt_rec.CREATION_DATE := SYSDATE;
3694: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3695: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3696:
3697: l_msnt_rec.Transaction_Temp_Id := l_Srl_Txn_Tmp_Id;
3698: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3699: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;

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

3697: l_msnt_rec.Transaction_Temp_Id := l_Srl_Txn_Tmp_Id;
3698: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3699: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3700: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3701: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3702: l_msnt_rec.CREATION_DATE := SYSDATE;
3703: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3704: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3705:

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

3699: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3700: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3701: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3702: l_msnt_rec.CREATION_DATE := SYSDATE;
3703: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3704: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3705:
3706: IF G_DEBUG='Y' THEN
3707: AHL_DEBUG_PUB.debug('inserting in mtlt..');

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

3700: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3701: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3702: l_msnt_rec.CREATION_DATE := SYSDATE;
3703: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3704: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3705:
3706: IF G_DEBUG='Y' THEN
3707: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3708: END IF;

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

3751: --l_mtlt_rec.Lot_Expiration_Date := p_x_ahl_mtltxn_rec.Lot_Expiration_Date;
3752: l_mtlt_rec.Transaction_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3753: l_mtlt_rec.Primary_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3754: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3755: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3756: l_mtlt_rec.CREATION_DATE := SYSDATE;
3757: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3758: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3759:

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

3753: l_mtlt_rec.Primary_Quantity := p_x_ahl_mtltxn_rec.Quantity;
3754: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3755: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3756: l_mtlt_rec.CREATION_DATE := SYSDATE;
3757: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3758: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3759:
3760: IF G_DEBUG='Y' THEN
3761: AHL_DEBUG_PUB.debug('inserting in mtlt..');

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

3754: l_mtlt_rec.LAST_UPDATE_DATE := SYSDATE;
3755: l_mtlt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3756: l_mtlt_rec.CREATION_DATE := SYSDATE;
3757: l_mtlt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3758: l_mtlt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3759:
3760: IF G_DEBUG='Y' THEN
3761: AHL_DEBUG_PUB.debug('inserting in mtlt..');
3762:

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

3783: l_msnt_rec.Transaction_Temp_Id := x_Txn_Tmp_Id;
3784: l_msnt_rec.Fm_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3785: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3786: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3787: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3788: l_msnt_rec.CREATION_DATE := SYSDATE;
3789: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3790: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3791:

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

3785: l_msnt_rec.To_Serial_Number := p_x_ahl_mtltxn_rec.Serial_Number;
3786: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3787: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3788: l_msnt_rec.CREATION_DATE := SYSDATE;
3789: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3790: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3791:
3792: IF G_DEBUG='Y' THEN
3793: AHL_DEBUG_PUB.debug('inserting in msnt..');

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

3786: l_msnt_rec.LAST_UPDATE_DATE := SYSDATE;
3787: l_msnt_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3788: l_msnt_rec.CREATION_DATE := SYSDATE;
3789: l_msnt_rec.CREATED_BY := FND_GLOBAL.USER_ID; --p_x_ahl_mtltxn_rec.Last_Updated_By;
3790: l_msnt_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID; --p_x_ahl_mtltxn_rec.Last_Update_Login;
3791:
3792: IF G_DEBUG='Y' THEN
3793: AHL_DEBUG_PUB.debug('inserting in msnt..');
3794:

Line 4388: FND_GLOBAL.USER_ID,

4384: VALUES(p_x_txn_intf_id,
4385: l_Source_Code,
4386: l_Source_Line_Id,
4387: sysdate,
4388: FND_GLOBAL.USER_ID,
4389: sysdate,
4390: FND_GLOBAL.USER_ID,
4391: FND_GLOBAL.LOGIN_ID,
4392: p_x_ahl_mtl_txn_rec.Lot_Number,

Line 4390: FND_GLOBAL.USER_ID,

4386: l_Source_Line_Id,
4387: sysdate,
4388: FND_GLOBAL.USER_ID,
4389: sysdate,
4390: FND_GLOBAL.USER_ID,
4391: FND_GLOBAL.LOGIN_ID,
4392: p_x_ahl_mtl_txn_rec.Lot_Number,
4393: l_lot_expiration_Date,
4394: l_qty,

Line 4391: FND_GLOBAL.LOGIN_ID,

4387: sysdate,
4388: FND_GLOBAL.USER_ID,
4389: sysdate,
4390: FND_GLOBAL.USER_ID,
4391: FND_GLOBAL.LOGIN_ID,
4392: p_x_ahl_mtl_txn_rec.Lot_Number,
4393: l_lot_expiration_Date,
4394: l_qty,
4395: l_qty,

Line 4463: FND_GLOBAL.USER_ID,

4459: VALUES ( l_txn_tmp_id,
4460: l_source_code,
4461: l_source_line_id,
4462: SYSDATE,
4463: FND_GLOBAL.USER_ID,
4464: SYSDATE,
4465: FND_GLOBAL.USER_ID,
4466: FND_GLOBAL.LOGIN_ID,
4467: p_x_ahl_mtl_txn_rec.Serial_Number,

Line 4465: FND_GLOBAL.USER_ID,

4461: l_source_line_id,
4462: SYSDATE,
4463: FND_GLOBAL.USER_ID,
4464: SYSDATE,
4465: FND_GLOBAL.USER_ID,
4466: FND_GLOBAL.LOGIN_ID,
4467: p_x_ahl_mtl_txn_rec.Serial_Number,
4468: p_x_ahl_mtl_txn_rec.Serial_Number,
4469: l_Process_Flag,

Line 4466: FND_GLOBAL.LOGIN_ID,

4462: SYSDATE,
4463: FND_GLOBAL.USER_ID,
4464: SYSDATE,
4465: FND_GLOBAL.USER_ID,
4466: FND_GLOBAL.LOGIN_ID,
4467: p_x_ahl_mtl_txn_rec.Serial_Number,
4468: p_x_ahl_mtl_txn_rec.Serial_Number,
4469: l_Process_Flag,
4470: l_serial_dff_rec.ATTRIBUTE_CATEGORY,

Line 4548: sysdate, FND_GLOBAL.USER_ID,

4544: values (p_x_txn_intf_id, p_x_txn_hdr_id,
4545: l_Source_Code, l_Source_Line_Id,
4546: l_Source_Header_Id, l_Process_Flag,
4547: l_Validation_required , l_transaction_Mode,
4548: sysdate, FND_GLOBAL.USER_ID,
4549: sysdate, FND_GLOBAL.USER_ID,
4550: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,
4551: p_x_ahl_mtl_txn_rec.Organization_Id, l_qty,
4552: l_qty, p_x_ahl_mtl_txn_rec.Uom,

Line 4549: sysdate, FND_GLOBAL.USER_ID,

4545: l_Source_Code, l_Source_Line_Id,
4546: l_Source_Header_Id, l_Process_Flag,
4547: l_Validation_required , l_transaction_Mode,
4548: sysdate, FND_GLOBAL.USER_ID,
4549: sysdate, FND_GLOBAL.USER_ID,
4550: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,
4551: p_x_ahl_mtl_txn_rec.Organization_Id, l_qty,
4552: l_qty, p_x_ahl_mtl_txn_rec.Uom,
4553: p_x_ahl_mtl_txn_rec.Transaction_Date, p_x_ahl_mtl_txn_rec.Subinventory_Name,

Line 4550: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,

4546: l_Source_Header_Id, l_Process_Flag,
4547: l_Validation_required , l_transaction_Mode,
4548: sysdate, FND_GLOBAL.USER_ID,
4549: sysdate, FND_GLOBAL.USER_ID,
4550: FND_GLOBAL.LOGIN_ID, p_x_ahl_mtl_txn_rec.Inventory_Item_Id,
4551: p_x_ahl_mtl_txn_rec.Organization_Id, l_qty,
4552: l_qty, p_x_ahl_mtl_txn_rec.Uom,
4553: p_x_ahl_mtl_txn_rec.Transaction_Date, p_x_ahl_mtl_txn_rec.Subinventory_Name,
4554: p_x_ahl_mtl_txn_rec.Locator_Id, p_x_ahl_mtl_txn_rec.Transaction_Type_Id,