DBA Data[Home] [Help]

APPS.IEU_UWQM_PRIORITIES_PKG dependencies on FND_GLOBAL

Line 31: FND_GLOBAL.USER_ID,

27: P_PRIORITY_ID,
28: 1,
29: P_PRIORITY_LEVEL,
30: SYSDATE,
31: FND_GLOBAL.USER_ID,
32: SYSDATE,
33: FND_GLOBAL.USER_ID,
34: FND_GLOBAL.LOGIN_ID
35: );

Line 33: FND_GLOBAL.USER_ID,

29: P_PRIORITY_LEVEL,
30: SYSDATE,
31: FND_GLOBAL.USER_ID,
32: SYSDATE,
33: FND_GLOBAL.USER_ID,
34: FND_GLOBAL.LOGIN_ID
35: );
36:
37: insert into IEU_UWQM_PRIORITIES_TL (

Line 34: FND_GLOBAL.LOGIN_ID

30: SYSDATE,
31: FND_GLOBAL.USER_ID,
32: SYSDATE,
33: FND_GLOBAL.USER_ID,
34: FND_GLOBAL.LOGIN_ID
35: );
36:
37: insert into IEU_UWQM_PRIORITIES_TL (
38: LAST_UPDATE_LOGIN,

Line 50: FND_GLOBAL.LOGIN_ID,

46: PRIORITY_ID,
47: LANGUAGE,
48: SOURCE_LANG
49: ) select
50: FND_GLOBAL.LOGIN_ID,
51: P_NAME,
52: P_DESCRIPTION,
53: SYSDATE,
54: SYSDATE,

Line 55: FND_GLOBAL.USER_ID,

51: P_NAME,
52: P_DESCRIPTION,
53: SYSDATE,
54: SYSDATE,
55: FND_GLOBAL.USER_ID,
56: 1,
57: FND_GLOBAL.USER_ID,
58: P_PRIORITY_ID,
59: L.LANGUAGE_CODE,

Line 57: FND_GLOBAL.USER_ID,

53: SYSDATE,
54: SYSDATE,
55: FND_GLOBAL.USER_ID,
56: 1,
57: FND_GLOBAL.USER_ID,
58: P_PRIORITY_ID,
59: L.LANGUAGE_CODE,
60: userenv('LANG')
61: from FND_LANGUAGES L

Line 151: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

147: PRIORITY_CODE = P_PRIORITY_CODE,
148: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
149: PRIORITY_LEVEL = P_PRIORITY_LEVEL,
150: LAST_UPDATE_DATE = SYSDATE,
151: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
152: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
153: where PRIORITY_ID = P_PRIORITY_ID;
154:
155: if (sql%notfound) then

Line 152: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

148: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
149: PRIORITY_LEVEL = P_PRIORITY_LEVEL,
150: LAST_UPDATE_DATE = SYSDATE,
151: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
152: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
153: where PRIORITY_ID = P_PRIORITY_ID;
154:
155: if (sql%notfound) then
156: raise no_data_found;

Line 163: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

159: update IEU_UWQM_PRIORITIES_TL set
160: NAME = P_NAME,
161: DESCRIPTION = P_DESCRIPTION,
162: LAST_UPDATE_DATE = SYSDATE,
163: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
164: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
165: SOURCE_LANG = userenv('LANG')
166: where PRIORITY_ID = P_PRIORITY_ID
167: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 164: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

160: NAME = P_NAME,
161: DESCRIPTION = P_DESCRIPTION,
162: LAST_UPDATE_DATE = SYSDATE,
163: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
164: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
165: SOURCE_LANG = userenv('LANG')
166: where PRIORITY_ID = P_PRIORITY_ID
167: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
168: