APPS.IBC_LABELS_PKG dependencies on FND_API

Line 42: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

38: LAST_UPDATE_LOGIN
39: ) VALUES (
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,

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 46: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

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),
50: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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 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 68: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),

64: SOURCE_LANG
65: ) SELECT
66: p_LABEL_CODE,
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),

Line 69: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

65: ) SELECT
66: p_LABEL_CODE,
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,

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 73: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

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),
77: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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 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 165: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

161: ) IS
162: BEGIN
163: UPDATE IBC_LABELS_B SET
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),

Line 167: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

163: UPDATE IBC_LABELS_B SET
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,

Line 170: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,

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)
173: WHERE LABEL_CODE = p_LABEL_CODE
174: AND object_version_number = DECODE(p_object_version_number,

Line 175: FND_API.G_MISS_NUM,object_version_number,

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,
176: NULL,object_version_number,
177: p_object_version_number);
178:
179: IF (SQL%NOTFOUND) THEN

Line 184: LABEL_NAME = DECODE(p_LABEL_NAME,FND_API.G_MISS_CHAR,NULL,NULL,LABEL_NAME,p_LABEL_NAME),

180: RAISE NO_DATA_FOUND;
181: END IF;
182:
183: UPDATE IBC_LABELS_TL SET
184: LABEL_NAME = DECODE(p_LABEL_NAME,FND_API.G_MISS_CHAR,NULL,NULL,LABEL_NAME,p_LABEL_NAME),
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,

Line 185: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,NULL,DESCRIPTION,p_DESCRIPTION),

181: END IF;
182:
183: UPDATE IBC_LABELS_TL SET
184: LABEL_NAME = DECODE(p_LABEL_NAME,FND_API.G_MISS_CHAR,NULL,NULL,LABEL_NAME,p_LABEL_NAME),
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,

Line 186: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

182:
183: UPDATE IBC_LABELS_TL SET
184: LABEL_NAME = DECODE(p_LABEL_NAME,FND_API.G_MISS_CHAR,NULL,NULL,LABEL_NAME,p_LABEL_NAME),
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),

Line 188: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

184: LABEL_NAME = DECODE(p_LABEL_NAME,FND_API.G_MISS_CHAR,NULL,NULL,LABEL_NAME,p_LABEL_NAME),
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,

Line 191: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,

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),
194: SOURCE_LANG = USERENV('LANG')
195: WHERE LABEL_CODE = p_LABEL_CODE

Line 311: p_Label_NAME => nvl(p_Label_NAME,FND_API.G_MISS_CHAR),

307: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
308:
309: Ibc_Labels_Pkg.Update_row (
310: p_Label_CODE => p_Label_CODE,
311: p_Label_NAME => nvl(p_Label_NAME,FND_API.G_MISS_CHAR),
312: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),
313: p_LAST_UPDATED_BY => l_user_id,
314: p_LAST_UPDATE_DATE => sysdate,
315: p_LAST_UPDATE_LOGIN => 0,

Line 312: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),

308:
309: Ibc_Labels_Pkg.Update_row (
310: p_Label_CODE => p_Label_CODE,
311: p_Label_NAME => nvl(p_Label_NAME,FND_API.G_MISS_CHAR),
312: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),
313: p_LAST_UPDATED_BY => l_user_id,
314: p_LAST_UPDATE_DATE => sysdate,
315: p_LAST_UPDATE_LOGIN => 0,
316: p_OBJECT_VERSION_NUMBER => NULL);