eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_API_PUB dependencies on FND_GLOBAL

Line 548: l_userid := fnd_global.user_id;

544: AND organization_id = p_organization_id
545: AND lot_number = p_lot_number;
546:
547: IF ( l_lotcount = 0 ) THEN
548: l_userid := fnd_global.user_id;
549: l_loginid := fnd_global.login_id;
550:
551: IF ( p_expiration_date IS NULL ) THEN
552: SELECT shelf_life_code,

Line 549: l_loginid := fnd_global.login_id;

545: AND lot_number = p_lot_number;
546:
547: IF ( l_lotcount = 0 ) THEN
548: l_userid := fnd_global.user_id;
549: l_loginid := fnd_global.login_id;
550:
551: IF ( p_expiration_date IS NULL ) THEN
552: SELECT shelf_life_code,
553: shelf_life_days

Line 1521: l_userid := fnd_global.user_id;

1517: END IF;
1518:
1519: IF (l_lotcount > 0 AND p_expiration_date IS NOT NULL) THEN
1520:
1521: l_userid := fnd_global.user_id;
1522:
1523: --Lot exists, but now the user has entered the lot expiration date
1524: IF (l_debug = 1) THEN
1525: inv_pick_wave_pick_confirm_pub.tracelog ('Update the expiration date', 'INV_LOT_API_PUB');

Line 1721: l_userid := fnd_global.user_id;

1717: end if;
1718: end if;
1719:
1720: populateattributescolumn ( );
1721: l_userid := fnd_global.user_id;
1722: l_loginid := fnd_global.login_id;
1723: l_mmtt_pri_quantity := 0;
1724:
1725: IF ( p_primary_quantity IS NOT NULL )

Line 1722: l_loginid := fnd_global.login_id;

1718: end if;
1719:
1720: populateattributescolumn ( );
1721: l_userid := fnd_global.user_id;
1722: l_loginid := fnd_global.login_id;
1723: l_mmtt_pri_quantity := 0;
1724:
1725: IF ( p_primary_quantity IS NOT NULL )
1726: THEN

Line 2648: l_userid := fnd_global.user_id;

2644: l_loginid NUMBER;
2645:
2646: BEGIN
2647:
2648: l_userid := fnd_global.user_id;
2649: l_loginid := fnd_global.login_id;
2650:
2651: INSERT into mtl_child_lot_numbers
2652: (organization_id, inventory_item_id,

Line 2649: l_loginid := fnd_global.login_id;

2645:
2646: BEGIN
2647:
2648: l_userid := fnd_global.user_id;
2649: l_loginid := fnd_global.login_id;
2650:
2651: INSERT into mtl_child_lot_numbers
2652: (organization_id, inventory_item_id,
2653: parent_lot_number, last_child_lot_number_seq,

Line 2686: l_userid := fnd_global.user_id;

2682: l_loginid NUMBER;
2683:
2684: BEGIN
2685:
2686: l_userid := fnd_global.user_id;
2687: l_loginid := fnd_global.login_id;
2688: UPDATE mtl_child_lot_numbers
2689: SET last_child_lot_number_seq = p_last_child_lot_seq,
2690: last_updated_by = l_userid,

Line 2687: l_loginid := fnd_global.login_id;

2683:
2684: BEGIN
2685:
2686: l_userid := fnd_global.user_id;
2687: l_loginid := fnd_global.login_id;
2688: UPDATE mtl_child_lot_numbers
2689: SET last_child_lot_number_seq = p_last_child_lot_seq,
2690: last_updated_by = l_userid,
2691: last_update_date = SYSDATE,

Line 6433: ,LAST_UPDATED_BY = fnd_global.user_id

6429: , 2, DECODE(l_d_attributes_tbl(10), g_miss_date, NULL, NULL, d_attribute10, l_d_attributes_tbl(10))
6430: , DECODE(l_d_attributes_tbl(10), g_miss_date, d_attribute10, NULL, NULL, l_d_attributes_tbl(10))
6431: )
6432: ,LAST_UPDATE_DATE = sysdate
6433: ,LAST_UPDATED_BY = fnd_global.user_id
6434: WHERE inventory_item_id = p_lot_rec.inventory_item_id
6435: AND organization_id = p_lot_rec.organization_id
6436: AND lot_number = p_lot_rec.lot_number;
6437: ELSE

Line 6869: ,LAST_UPDATED_BY = fnd_global.user_id

6865: , d_attribute10 = decode(p_source, 2,
6866: DECODE(l_d_attributes_tbl(10), g_miss_date, NULL, NULL, d_attribute10, l_d_attributes_tbl(10))
6867: ,DECODE(l_d_attributes_tbl(10), g_miss_date, d_attribute10, NULL, null, l_d_attributes_tbl(10)))*/
6868: ,LAST_UPDATE_DATE = sysdate
6869: ,LAST_UPDATED_BY = fnd_global.user_id
6870: WHERE inventory_item_id = p_lot_rec.inventory_item_id
6871: AND organization_id = p_lot_rec.organization_id
6872: AND lot_number = p_lot_rec.lot_number;
6873: END IF;

Line 7059: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;

7055: l_in_lot_rec.territory_code := p_territory_code;
7056: l_in_lot_rec.supplier_lot_number := p_supplier_lot_number;
7057: l_in_lot_rec.vendor_name := p_vendor_name;
7058: l_in_lot_rec.last_update_date := SYSDATE ;
7059: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
7060: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
7061: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
7062: --exception would be thrown if accessed. So add clause to check for this
7063:

Line 7060: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

7056: l_in_lot_rec.supplier_lot_number := p_supplier_lot_number;
7057: l_in_lot_rec.vendor_name := p_vendor_name;
7058: l_in_lot_rec.last_update_date := SYSDATE ;
7059: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
7060: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
7061: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
7062: --exception would be thrown if accessed. So add clause to check for this
7063:
7064: /*bug 14546399 added else for passing g_miss_char for all attributes values*/

Line 9327: l_in_lot_rec.created_by := FND_GLOBAL.USER_ID;

9323: l_in_lot_rec.supplier_lot_number := p_supplier_lot_number;
9324: l_in_lot_rec.vendor_name := p_vendor_name;
9325: l_in_lot_rec.creation_date := SYSDATE;
9326: l_in_lot_rec.last_update_date := SYSDATE ;
9327: l_in_lot_rec.created_by := FND_GLOBAL.USER_ID;
9328: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
9329: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
9330: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
9331: --exception would be thrown if accessed. So add clause to check for this

Line 9328: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;

9324: l_in_lot_rec.vendor_name := p_vendor_name;
9325: l_in_lot_rec.creation_date := SYSDATE;
9326: l_in_lot_rec.last_update_date := SYSDATE ;
9327: l_in_lot_rec.created_by := FND_GLOBAL.USER_ID;
9328: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
9329: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
9330: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
9331: --exception would be thrown if accessed. So add clause to check for this
9332: IF (p_attributes_tbl.exists(1)) THEN

Line 9329: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

9325: l_in_lot_rec.creation_date := SYSDATE;
9326: l_in_lot_rec.last_update_date := SYSDATE ;
9327: l_in_lot_rec.created_by := FND_GLOBAL.USER_ID;
9328: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
9329: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
9330: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
9331: --exception would be thrown if accessed. So add clause to check for this
9332: IF (p_attributes_tbl.exists(1)) THEN
9333: l_in_lot_rec.attribute1 := p_attributes_tbl(1);

Line 9954: , x_last_updated_by => FND_GLOBAL.USER_ID

9950: , x_expiration_action_date => l_child_lot_rec.expiration_action_date
9951: , x_expiration_action_code => l_child_lot_rec.expiration_action_code
9952: , x_hold_date => l_child_lot_rec.hold_date
9953: , x_last_update_date => SYSDATE
9954: , x_last_updated_by => FND_GLOBAL.USER_ID
9955: , x_creation_date => SYSDATE
9956: , x_created_by => FND_GLOBAL.USER_ID
9957: , x_last_update_login => FND_GLOBAL.LOGIN_ID
9958: , x_attribute1 => l_child_lot_rec.attribute1

Line 9956: , x_created_by => FND_GLOBAL.USER_ID

9952: , x_hold_date => l_child_lot_rec.hold_date
9953: , x_last_update_date => SYSDATE
9954: , x_last_updated_by => FND_GLOBAL.USER_ID
9955: , x_creation_date => SYSDATE
9956: , x_created_by => FND_GLOBAL.USER_ID
9957: , x_last_update_login => FND_GLOBAL.LOGIN_ID
9958: , x_attribute1 => l_child_lot_rec.attribute1
9959: , x_attribute2 => l_child_lot_rec.attribute2
9960: , x_attribute3 => l_child_lot_rec.attribute3

Line 9957: , x_last_update_login => FND_GLOBAL.LOGIN_ID

9953: , x_last_update_date => SYSDATE
9954: , x_last_updated_by => FND_GLOBAL.USER_ID
9955: , x_creation_date => SYSDATE
9956: , x_created_by => FND_GLOBAL.USER_ID
9957: , x_last_update_login => FND_GLOBAL.LOGIN_ID
9958: , x_attribute1 => l_child_lot_rec.attribute1
9959: , x_attribute2 => l_child_lot_rec.attribute2
9960: , x_attribute3 => l_child_lot_rec.attribute3
9961: , x_attribute4 => l_child_lot_rec.attribute4

Line 10056: , p_user_id => fnd_global.user_id

10052: , p_to_organization_id => p_lot_rec.organization_id
10053: , p_inventory_item_id => p_lot_rec.inventory_item_id
10054: , p_from_lot_number => p_lot_rec.parent_lot_number
10055: , p_to_lot_number => p_lot_rec.lot_number
10056: , p_user_id => fnd_global.user_id
10057: , p_creation_date => SYSDATE
10058: , p_commit => p_commit
10059: , x_return_status => l_return_status
10060: , x_msg_count => l_msg_count