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 437: l_userid := fnd_global.user_id;

433: AND organization_id = p_organization_id
434: AND lot_number = p_lot_number;
435:
436: IF ( l_lotcount = 0 ) THEN
437: l_userid := fnd_global.user_id;
438: l_loginid := fnd_global.login_id;
439:
440: IF ( p_expiration_date IS NULL ) THEN
441: SELECT shelf_life_code,

Line 438: l_loginid := fnd_global.login_id;

434: AND lot_number = p_lot_number;
435:
436: IF ( l_lotcount = 0 ) THEN
437: l_userid := fnd_global.user_id;
438: l_loginid := fnd_global.login_id;
439:
440: IF ( p_expiration_date IS NULL ) THEN
441: SELECT shelf_life_code,
442: shelf_life_days

Line 1402: l_userid := fnd_global.user_id;

1398: END IF;
1399:
1400: IF (l_lotcount > 0 AND p_expiration_date IS NOT NULL) THEN
1401:
1402: l_userid := fnd_global.user_id;
1403:
1404: --Lot exists, but now the user has entered the lot expiration date
1405: IF (l_debug = 1) THEN
1406: inv_pick_wave_pick_confirm_pub.tracelog ('Update the expiration date', 'INV_LOT_API_PUB');

Line 1602: l_userid := fnd_global.user_id;

1598: end if;
1599: end if;
1600:
1601: populateattributescolumn ( );
1602: l_userid := fnd_global.user_id;
1603: l_loginid := fnd_global.login_id;
1604: l_mmtt_pri_quantity := 0;
1605:
1606: IF ( p_primary_quantity IS NOT NULL )

Line 1603: l_loginid := fnd_global.login_id;

1599: end if;
1600:
1601: populateattributescolumn ( );
1602: l_userid := fnd_global.user_id;
1603: l_loginid := fnd_global.login_id;
1604: l_mmtt_pri_quantity := 0;
1605:
1606: IF ( p_primary_quantity IS NOT NULL )
1607: THEN

Line 2506: l_userid := fnd_global.user_id;

2502: l_loginid NUMBER;
2503:
2504: BEGIN
2505:
2506: l_userid := fnd_global.user_id;
2507: l_loginid := fnd_global.login_id;
2508:
2509: INSERT into mtl_child_lot_numbers
2510: (organization_id, inventory_item_id,

Line 2507: l_loginid := fnd_global.login_id;

2503:
2504: BEGIN
2505:
2506: l_userid := fnd_global.user_id;
2507: l_loginid := fnd_global.login_id;
2508:
2509: INSERT into mtl_child_lot_numbers
2510: (organization_id, inventory_item_id,
2511: parent_lot_number, last_child_lot_number_seq,

Line 2544: l_userid := fnd_global.user_id;

2540: l_loginid NUMBER;
2541:
2542: BEGIN
2543:
2544: l_userid := fnd_global.user_id;
2545: l_loginid := fnd_global.login_id;
2546: UPDATE mtl_child_lot_numbers
2547: SET last_child_lot_number_seq = p_last_child_lot_seq,
2548: last_updated_by = l_userid,

Line 2545: l_loginid := fnd_global.login_id;

2541:
2542: BEGIN
2543:
2544: l_userid := fnd_global.user_id;
2545: l_loginid := fnd_global.login_id;
2546: UPDATE mtl_child_lot_numbers
2547: SET last_child_lot_number_seq = p_last_child_lot_seq,
2548: last_updated_by = l_userid,
2549: last_update_date = SYSDATE,

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

6834: l_in_lot_rec.territory_code := p_territory_code;
6835: l_in_lot_rec.supplier_lot_number := p_supplier_lot_number;
6836: l_in_lot_rec.vendor_name := p_vendor_name;
6837: l_in_lot_rec.last_update_date := SYSDATE ;
6838: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
6839: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
6840: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
6841: --exception would be thrown if accessed. So add clause to check for this
6842: IF (p_attributes_tbl.exists(1)) THEN

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

6835: l_in_lot_rec.supplier_lot_number := p_supplier_lot_number;
6836: l_in_lot_rec.vendor_name := p_vendor_name;
6837: l_in_lot_rec.last_update_date := SYSDATE ;
6838: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
6839: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
6840: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
6841: --exception would be thrown if accessed. So add clause to check for this
6842: IF (p_attributes_tbl.exists(1)) THEN
6843: l_in_lot_rec.attribute1 := p_attributes_tbl(1);

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

8899: l_in_lot_rec.supplier_lot_number := p_supplier_lot_number;
8900: l_in_lot_rec.vendor_name := p_vendor_name;
8901: l_in_lot_rec.creation_date := SYSDATE;
8902: l_in_lot_rec.last_update_date := SYSDATE ;
8903: l_in_lot_rec.created_by := FND_GLOBAL.USER_ID;
8904: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
8905: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
8906: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
8907: --exception would be thrown if accessed. So add clause to check for this

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

8900: l_in_lot_rec.vendor_name := p_vendor_name;
8901: l_in_lot_rec.creation_date := SYSDATE;
8902: l_in_lot_rec.last_update_date := SYSDATE ;
8903: l_in_lot_rec.created_by := FND_GLOBAL.USER_ID;
8904: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
8905: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
8906: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
8907: --exception would be thrown if accessed. So add clause to check for this
8908: IF (p_attributes_tbl.exists(1)) THEN

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

8901: l_in_lot_rec.creation_date := SYSDATE;
8902: l_in_lot_rec.last_update_date := SYSDATE ;
8903: l_in_lot_rec.created_by := FND_GLOBAL.USER_ID;
8904: l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
8905: l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
8906: --BUG 4748451: if the p%tbl are not initialized, then a no_date_found
8907: --exception would be thrown if accessed. So add clause to check for this
8908: IF (p_attributes_tbl.exists(1)) THEN
8909: l_in_lot_rec.attribute1 := p_attributes_tbl(1);

Line 9484: , x_last_updated_by => FND_GLOBAL.USER_ID

9480: , x_expiration_action_date => l_child_lot_rec.expiration_action_date
9481: , x_expiration_action_code => l_child_lot_rec.expiration_action_code
9482: , x_hold_date => l_child_lot_rec.hold_date
9483: , x_last_update_date => SYSDATE
9484: , x_last_updated_by => FND_GLOBAL.USER_ID
9485: , x_creation_date => SYSDATE
9486: , x_created_by => FND_GLOBAL.USER_ID
9487: , x_last_update_login => FND_GLOBAL.LOGIN_ID
9488: , x_attribute1 => l_child_lot_rec.attribute1

Line 9486: , x_created_by => FND_GLOBAL.USER_ID

9482: , x_hold_date => l_child_lot_rec.hold_date
9483: , x_last_update_date => SYSDATE
9484: , x_last_updated_by => FND_GLOBAL.USER_ID
9485: , x_creation_date => SYSDATE
9486: , x_created_by => FND_GLOBAL.USER_ID
9487: , x_last_update_login => FND_GLOBAL.LOGIN_ID
9488: , x_attribute1 => l_child_lot_rec.attribute1
9489: , x_attribute2 => l_child_lot_rec.attribute2
9490: , x_attribute3 => l_child_lot_rec.attribute3

Line 9487: , x_last_update_login => FND_GLOBAL.LOGIN_ID

9483: , x_last_update_date => SYSDATE
9484: , x_last_updated_by => FND_GLOBAL.USER_ID
9485: , x_creation_date => SYSDATE
9486: , x_created_by => FND_GLOBAL.USER_ID
9487: , x_last_update_login => FND_GLOBAL.LOGIN_ID
9488: , x_attribute1 => l_child_lot_rec.attribute1
9489: , x_attribute2 => l_child_lot_rec.attribute2
9490: , x_attribute3 => l_child_lot_rec.attribute3
9491: , x_attribute4 => l_child_lot_rec.attribute4

Line 9586: , p_user_id => fnd_global.user_id

9582: , p_to_organization_id => p_lot_rec.organization_id
9583: , p_inventory_item_id => p_lot_rec.inventory_item_id
9584: , p_from_lot_number => p_lot_rec.parent_lot_number
9585: , p_to_lot_number => p_lot_rec.lot_number
9586: , p_user_id => fnd_global.user_id
9587: , p_creation_date => SYSDATE
9588: , p_commit => p_commit
9589: , x_return_status => l_return_status
9590: , x_msg_count => l_msg_count