APPS.INV_EGO_REVISION_VALIDATE dependencies on FND_USER

Line 40: ,p_fnd_user_id IN NUMBER

36: ,p_organization_id IN NUMBER
37: ,p_item_number IN VARCHAR2
38: ,p_auto_commit IN VARCHAR2
39: ,p_wf_user_id IN NUMBER
40: ,p_fnd_user_id IN NUMBER
41: ,x_return_status OUT NOCOPY VARCHAR2);
42:
43: -- ============================================================================
44: -- API Name : Create_New_Item_Req_Upd

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

1640: WHERE user_id = cp_user_id;
1641:
1642: l_has_privilege VARCHAR2(1) := 'T';
1643: l_party_name fnd_grants.grantee_key%TYPE;
1644: l_user_id fnd_user.user_id%TYPE := P_User_Id;
1645:
1646: BEGIN
1647:
1648: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN

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

2009:
2010:
2011: BEGIN
2012:
2013: -- For Internal Users , Customer_Id may not getting populated in FND_USER
2014: -- Hence checking USER_ID from ego_people_v which always return all registered
2015: -- Users (Customer, Internal and Vendor)
2016: -- Bug Fix : 3048453
2017: -- Calling bulk seeding procedure

Line 3393: ,p_fnd_user_id => p_login_id

3389: ,p_organization_id => p_organization_id
3390: ,p_item_number => p_item_number
3391: ,p_auto_commit => FND_API.G_FALSE
3392: ,p_wf_user_id => p_user_id
3393: ,p_fnd_user_id => p_login_id
3394: ,x_return_status => l_return_status );
3395:
3396: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3397: l_error_occured := TRUE;

Line 3521: p_fnd_user_id IN NUMBER,

3517: p_organization_id IN NUMBER,
3518: p_item_number IN VARCHAR2,
3519: p_auto_commit IN VARCHAR2,
3520: p_wf_user_id IN NUMBER,
3521: p_fnd_user_id IN NUMBER,
3522: x_return_status OUT NOCOPY VARCHAR2 )
3523: IS
3524:
3525: dumm_status NUMBER;

Line 3541: ,p_fnd_user_id => p_fnd_user_id

3537: -- ,p_item_number => p_item_number
3538: ,p_auto_commit => p_auto_commit
3539: -- ,p_mode => 'CANCEL'
3540: ,p_wf_user_id => p_wf_user_id
3541: ,p_fnd_user_id => p_fnd_user_id
3542: ,p_cancel_comments => l_translated_text
3543: ,x_nir_cancel_status => l_nir_cancel_status);
3544:
3545: /* EXECUTE IMMEDIATE

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

3549: ||' ,p_org_id => :p_org_id '
3550: ||' ,p_change_notice => :p_change_notice '
3551: ||' ,p_auto_commit => :p_auto_commit '
3552: ||' ,p_wf_user_id => :p_wf_user_id '
3553: ||' ,p_fnd_user_id => :p_fnd_user_id '
3554: ||' ,p_cancel_comments => :l_translated_text '
3555: ||' ,x_nir_cancel_status => :l_nir_cancel_status); '
3556: ||' EXCEPTION '
3557: ||' WHEN OTHERS THEN '

Line 3565: IN p_fnd_user_id,

3561: IN p_org_id,
3562: IN p_change_notice,
3563: IN p_auto_commit,
3564: IN p_wf_user_id,
3565: IN p_fnd_user_id,
3566: IN l_translated_text,
3567: OUT l_nir_cancel_status; */
3568: EXCEPTION
3569: WHEN others THEN