DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_GLOBAL

Line 189: last_update_date = SYSDATE, last_updated_by = fnd_global.user_id, last_update_login = fnd_global.login_id

185: UPDATE iex_metric_ratings
186: SET low_from = p_low_from, low_to = p_low_to,
187: medium_from = p_medium_from, medium_to = p_medium_to,
188: high_from = p_high_from, high_to = p_high_to,
189: last_update_date = SYSDATE, last_updated_by = fnd_global.user_id, last_update_login = fnd_global.login_id
190: WHERE score_comp_type_id = p_score_comp_type_id;
191: ELSE
192: SELECT iex_metric_ratings_s.nextval
193: INTO l_metric_rating_id

Line 201: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id, fnd_global.user_id);

197: medium_from, medium_to, high_from, high_to,
198: creation_date, created_by, last_update_date, last_updated_by, last_update_login)
199: VALUES (l_metric_rating_id, p_score_comp_type_id, p_low_from, p_low_to,
200: p_medium_from, p_medium_to, p_high_from, p_high_to,
201: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id, fnd_global.user_id);
202: END IF;
203: CLOSE c_rating;
204: --EXCEPTION
205: --WHEN OTHERS THEN

Line 1761: l_last_updated_by number := FND_GLOBAL.USER_ID;

1757: l_define_party_running_level varchar2(1);
1758: c_str_upd varchar2(2000);
1759: l_count number;
1760:
1761: l_last_updated_by number := FND_GLOBAL.USER_ID;
1762: l_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),0);
1763:
1764:
1765: Begin

Line 1877: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;

1873: -- End for bug 8708271 multi level strategy
1874:
1875: BEGIN
1876: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1877: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1880: G_USER_ID := FND_GLOBAL.User_Id;
1881: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

Line 1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;

1874:
1875: BEGIN
1876: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1877: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1880: G_USER_ID := FND_GLOBAL.User_Id;
1881: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1882: END IEX_CHECKLIST_UTILITY;

Line 1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;

1875: BEGIN
1876: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1877: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1880: G_USER_ID := FND_GLOBAL.User_Id;
1881: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1882: END IEX_CHECKLIST_UTILITY;

Line 1880: G_USER_ID := FND_GLOBAL.User_Id;

1876: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1877: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1880: G_USER_ID := FND_GLOBAL.User_Id;
1881: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1882: END IEX_CHECKLIST_UTILITY;

Line 1881: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

1877: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1880: G_USER_ID := FND_GLOBAL.User_Id;
1881: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1882: END IEX_CHECKLIST_UTILITY;