DBA Data[Home] [Help]

APPS.IGW_ORG_MAP_DETAILS_PKG dependencies on FND_GLOBAL

Line 18: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

14: where map_id = p_map_id and
15: stop_id = p_stop_id and
16: user_name = p_user_name;
17:
18: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
19: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
20: l_last_update_date DATE := SYSDATE;
21: begin
22:

Line 19: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

15: stop_id = p_stop_id and
16: user_name = p_user_name;
17:
18: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
19: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
20: l_last_update_date DATE := SYSDATE;
21: begin
22:
23: insert into igw_org_map_details(

Line 100: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

96: ,p_stop_id NUMBER
97: ,p_approver_type VARCHAR2
98: ,p_user_name varchar2) is
99:
100: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
101: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
102: l_last_update_date DATE := SYSDATE;
103: begin
104:

Line 101: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

97: ,p_approver_type VARCHAR2
98: ,p_user_name varchar2) is
99:
100: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;
101: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
102: l_last_update_date DATE := SYSDATE;
103: begin
104:
105: update igw_org_map_details