APPS.IBC_LABELS_PKG dependencies on FND_GLOBAL

Line 44: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

40: p_LABEL_CODE,
41: p_OBJECT_VERSION_NUMBER,
42: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
43: p_creation_date),
44: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
45: NULL, FND_GLOBAL.user_id, p_created_by),
46: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
47: p_last_update_date),
48: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 45: NULL, FND_GLOBAL.user_id, p_created_by),

41: p_OBJECT_VERSION_NUMBER,
42: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
43: p_creation_date),
44: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
45: NULL, FND_GLOBAL.user_id, p_created_by),
46: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
47: p_last_update_date),
48: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
49: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 48: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

44: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
45: NULL, FND_GLOBAL.user_id, p_created_by),
46: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
47: p_last_update_date),
48: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
49: NULL, FND_GLOBAL.user_id, p_last_updated_by),
50: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
51: NULL, FND_GLOBAL.login_id, p_last_update_login)
52: );

Line 49: NULL, FND_GLOBAL.user_id, p_last_updated_by),

45: NULL, FND_GLOBAL.user_id, p_created_by),
46: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
47: p_last_update_date),
48: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
49: NULL, FND_GLOBAL.user_id, p_last_updated_by),
50: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
51: NULL, FND_GLOBAL.login_id, p_last_update_login)
52: );
53:

Line 50: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

46: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
47: p_last_update_date),
48: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
49: NULL, FND_GLOBAL.user_id, p_last_updated_by),
50: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
51: NULL, FND_GLOBAL.login_id, p_last_update_login)
52: );
53:
54: INSERT INTO IBC_LABELS_TL (

Line 51: NULL, FND_GLOBAL.login_id, p_last_update_login)

47: p_last_update_date),
48: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
49: NULL, FND_GLOBAL.user_id, p_last_updated_by),
50: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
51: NULL, FND_GLOBAL.login_id, p_last_update_login)
52: );
53:
54: INSERT INTO IBC_LABELS_TL (
55: LABEL_CODE,

Line 71: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

67: p_LABEL_NAME,
68: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
69: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
70: p_creation_date) ,
71: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
72: NULL, FND_GLOBAL.user_id, p_created_by),
73: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
74: p_last_update_date),
75: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 72: NULL, FND_GLOBAL.user_id, p_created_by),

68: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
69: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
70: p_creation_date) ,
71: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
72: NULL, FND_GLOBAL.user_id, p_created_by),
73: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
74: p_last_update_date),
75: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 75: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

71: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
72: NULL, FND_GLOBAL.user_id, p_created_by),
73: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
74: p_last_update_date),
75: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_last_updated_by),
77: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
78: NULL, FND_GLOBAL.login_id, p_last_update_login),
79: L.LANGUAGE_CODE,

Line 76: NULL, FND_GLOBAL.user_id, p_last_updated_by),

72: NULL, FND_GLOBAL.user_id, p_created_by),
73: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
74: p_last_update_date),
75: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_last_updated_by),
77: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
78: NULL, FND_GLOBAL.login_id, p_last_update_login),
79: L.LANGUAGE_CODE,
80: USERENV('LANG')

Line 77: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

73: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
74: p_last_update_date),
75: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_last_updated_by),
77: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
78: NULL, FND_GLOBAL.login_id, p_last_update_login),
79: L.LANGUAGE_CODE,
80: USERENV('LANG')
81: FROM FND_LANGUAGES L

Line 78: NULL, FND_GLOBAL.login_id, p_last_update_login),

74: p_last_update_date),
75: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_last_updated_by),
77: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
78: NULL, FND_GLOBAL.login_id, p_last_update_login),
79: L.LANGUAGE_CODE,
80: USERENV('LANG')
81: FROM FND_LANGUAGES L
82: WHERE L.INSTALLED_FLAG IN ('I', 'B')

Line 168: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

164: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
166: NULL, SYSDATE, p_last_update_date),
167: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
168: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
169: p_last_updated_by),
170: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
171: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
172: p_last_update_login)

Line 171: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

167: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
168: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
169: p_last_updated_by),
170: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
171: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
172: p_last_update_login)
173: WHERE LABEL_CODE = p_LABEL_CODE
174: AND object_version_number = DECODE(p_object_version_number,
175: FND_API.G_MISS_NUM,object_version_number,

Line 189: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

185: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,NULL,DESCRIPTION,p_DESCRIPTION),
186: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
187: NULL, SYSDATE, p_last_update_date),
188: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
189: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
190: p_last_updated_by),
191: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
192: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
193: p_last_update_login),

Line 192: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

188: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
189: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
190: p_last_updated_by),
191: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
192: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
193: p_last_update_login),
194: SOURCE_LANG = USERENV('LANG')
195: WHERE LABEL_CODE = p_LABEL_CODE
196: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);