DBA Data[Home] [Help]

APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on FND_GLOBAL

Line 191: l_user_id := FND_GLOBAL.User_Id;

187: END IF;
188: CLOSE c_get_default_phase_id;
189: END IF; -- p_lifecycle_id
190:
191: l_user_id := FND_GLOBAL.User_Id;
192: l_login_id := FND_GLOBAL.Login_Id;
193: l_sysdate := SYSDATE;
194:
195: FOR Item_Rev_Record IN c_get_item_rev_details (cp_item_id => p_inventory_item_id

Line 192: l_login_id := FND_GLOBAL.Login_Id;

188: CLOSE c_get_default_phase_id;
189: END IF; -- p_lifecycle_id
190:
191: l_user_id := FND_GLOBAL.User_Id;
192: l_login_id := FND_GLOBAL.Login_Id;
193: l_sysdate := SYSDATE;
194:
195: FOR Item_Rev_Record IN c_get_item_rev_details (cp_item_id => p_inventory_item_id
196: ,cp_org_id => p_organization_id)

Line 351: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;

347: --Return Status Variables
348: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
349: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
350: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
351: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
352: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
353:
354: l_status_rec BOOLEAN := FALSE;
355: l_phase_rec BOOLEAN := FALSE;

Line 352: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;

348: l_ret_success CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
349: l_ret_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
350: l_ret_unexp_error CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
351: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
352: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;
353:
354: l_status_rec BOOLEAN := FALSE;
355: l_phase_rec BOOLEAN := FALSE;
356: l_pending_flag VARCHAR2(1) := 'Y';

Line 1600: l_user_id := FND_GLOBAL.User_Id;

1596: IF FND_API.To_Boolean( p_commit ) THEN
1597: SAVEPOINT Create_Phase_History_SP;
1598: END IF;
1599:
1600: l_user_id := FND_GLOBAL.User_Id;
1601: l_sysdate := SYSDATE;
1602: INSERT INTO mtl_pending_item_status(
1603: inventory_item_id,
1604: organization_id,