APPS.INV_EGO_REVISION_VALIDATE dependencies on FND_USER

Line 44: ,p_fnd_user_id IN NUMBER

40: ,p_organization_id IN NUMBER
41: ,p_item_number IN VARCHAR2
42: ,p_auto_commit IN VARCHAR2
43: ,p_wf_user_id IN NUMBER
44: ,p_fnd_user_id IN NUMBER
45: ,x_return_status OUT NOCOPY VARCHAR2);
46:
47: -- ============================================================================
48: -- API Name : Create_New_Item_Req_Upd

Line 1742: l_user_id fnd_user.user_id%TYPE := P_User_Id;

1738: WHERE user_id = cp_user_id;
1739:
1740: l_has_privilege VARCHAR2(1) := 'T';
1741: l_party_name fnd_grants.grantee_key%TYPE;
1742: l_user_id fnd_user.user_id%TYPE := P_User_Id;
1743:
1744: BEGIN
1745:
1746: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN

Line 2144: -- For Internal Users , Customer_Id may not getting populated in FND_USER

2140:
2141:
2142: BEGIN
2143:
2144: -- For Internal Users , Customer_Id may not getting populated in FND_USER
2145: -- Hence checking USER_ID from ego_people_v which always return all registered
2146: -- Users (Customer, Internal and Vendor)
2147: -- Bug Fix : 3048453
2148: -- Calling bulk seeding procedure

Line 3614: ,p_fnd_user_id => p_login_id

3610: ,p_organization_id => p_organization_id
3611: ,p_item_number => p_item_number
3612: ,p_auto_commit => FND_API.G_FALSE
3613: ,p_wf_user_id => p_user_id
3614: ,p_fnd_user_id => p_login_id
3615: ,x_return_status => l_return_status );
3616:
3617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3618: l_error_occured := TRUE;

Line 3742: p_fnd_user_id IN NUMBER,

3738: p_organization_id IN NUMBER,
3739: p_item_number IN VARCHAR2,
3740: p_auto_commit IN VARCHAR2,
3741: p_wf_user_id IN NUMBER,
3742: p_fnd_user_id IN NUMBER,
3743: x_return_status OUT NOCOPY VARCHAR2 )
3744: IS
3745:
3746: dumm_status NUMBER;

Line 3762: ,p_fnd_user_id => p_fnd_user_id

3758: -- ,p_item_number => p_item_number
3759: ,p_auto_commit => p_auto_commit
3760: -- ,p_mode => 'CANCEL'
3761: ,p_wf_user_id => p_wf_user_id
3762: ,p_fnd_user_id => p_fnd_user_id
3763: ,p_cancel_comments => l_translated_text
3764: ,x_nir_cancel_status => l_nir_cancel_status);
3765:
3766: /* EXECUTE IMMEDIATE

Line 3774: ||' ,p_fnd_user_id => :p_fnd_user_id '

3770: ||' ,p_org_id => :p_org_id '
3771: ||' ,p_change_notice => :p_change_notice '
3772: ||' ,p_auto_commit => :p_auto_commit '
3773: ||' ,p_wf_user_id => :p_wf_user_id '
3774: ||' ,p_fnd_user_id => :p_fnd_user_id '
3775: ||' ,p_cancel_comments => :l_translated_text '
3776: ||' ,x_nir_cancel_status => :l_nir_cancel_status); '
3777: ||' EXCEPTION '
3778: ||' WHEN OTHERS THEN '

Line 3786: IN p_fnd_user_id,

3782: IN p_org_id,
3783: IN p_change_notice,
3784: IN p_auto_commit,
3785: IN p_wf_user_id,
3786: IN p_fnd_user_id,
3787: IN l_translated_text,
3788: OUT l_nir_cancel_status; */
3789: EXCEPTION
3790: WHEN others THEN