APPS.BSC_SYS_BENCHMARKS_PKG dependencies on FND_GLOBAL

Line 23: , p_Created_by => FND_GLOBAL.USER_ID

19: , p_Source_type => X_SOURCE_TYPE
20: , p_Periodicity_id => X_PERIODICITY_ID
21: , p_No_display_flag => X_NO_DISPLAY_FLAG
22: , p_Name => X_NAME
23: , p_Created_by => FND_GLOBAL.USER_ID
24: , p_Creation_date => SYSDATE
25: , p_Last_updated_by => FND_GLOBAL.USER_ID
26: , p_Last_update_date => SYSDATE
27: , p_Last_update_login => FND_GLOBAL.LOGIN_ID

Line 25: , p_Last_updated_by => FND_GLOBAL.USER_ID

21: , p_No_display_flag => X_NO_DISPLAY_FLAG
22: , p_Name => X_NAME
23: , p_Created_by => FND_GLOBAL.USER_ID
24: , p_Creation_date => SYSDATE
25: , p_Last_updated_by => FND_GLOBAL.USER_ID
26: , p_Last_update_date => SYSDATE
27: , p_Last_update_login => FND_GLOBAL.LOGIN_ID
28: );
29:

Line 27: , p_Last_update_login => FND_GLOBAL.LOGIN_ID

23: , p_Created_by => FND_GLOBAL.USER_ID
24: , p_Creation_date => SYSDATE
25: , p_Last_updated_by => FND_GLOBAL.USER_ID
26: , p_Last_update_date => SYSDATE
27: , p_Last_update_login => FND_GLOBAL.LOGIN_ID
28: );
29:
30: END INSERT_ROW;
31:

Line 73: , NVL(p_Last_update_login,FND_GLOBAL.login_id)

69: , p_Created_by
70: , p_Creation_date
71: , p_Last_updated_by
72: , p_Last_update_date
73: , NVL(p_Last_update_login,FND_GLOBAL.login_id)
74: );
75:
76: INSERT INTO bsc_sys_benchmarks_tl (
77: bm_id

Line 194: SELECT NVL(last_updated_by,FND_GLOBAL.USER_ID)

190: l_prev_last_updated_by BSC_SYS_BENCHMARKS_B.last_updated_by%TYPE;
191: l_prev_last_update_date BSC_SYS_BENCHMARKS_B.last_update_date%TYPE;
192: BEGIN
193:
194: SELECT NVL(last_updated_by,FND_GLOBAL.USER_ID)
195: , NVL(last_update_date,SYSDATE)
196: INTO l_prev_last_updated_by,l_prev_last_update_date
197: FROM bsc_sys_benchmarks_b
198: WHERE bm_id = p_Bm_id;

Line 219: , last_update_login= NVL(p_Last_update_login,FND_GLOBAL.LOGIN_ID)

215: , periodicity_id = p_Periodicity_id
216: , no_display_flag = p_No_display_flag
217: , last_updated_by = p_Last_updated_by
218: , last_update_date = p_Last_update_date
219: , last_update_login= NVL(p_Last_update_login,FND_GLOBAL.LOGIN_ID)
220: WHERE bm_id = p_Bm_id;
221:
222: IF (SQL%NOTFOUND) THEN
223: RAISE NO_DATA_FOUND;