eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CITEM_VERSIONS_PKG dependencies on FND_GLOBAL

Line 145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );

Line 147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );
150:
151: INSERT INTO IBC_CITEM_VERSIONS_TL (

Line 148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );
150:
151: INSERT INTO IBC_CITEM_VERSIONS_TL (
152: CITEM_VERSION_ID,

Line 178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE

Line 180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE
183: ,USERENV('LANG')
184: ,DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,p_citem_translation_status)

Line 181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE
183: ,USERENV('LANG')
184: ,DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,p_citem_translation_status)
185: FROM FND_LANGUAGES L

Line 327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

323: L.description,
324: L.default_rendition_mime_type,
325: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
326: p_creation_date) ,
327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 328: NULL, Fnd_Global.user_id, p_created_by),

324: L.default_rendition_mime_type,
325: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
326: p_creation_date) ,
327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),

Line 331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,

Line 332: NULL, Fnd_Global.user_id, p_last_updated_by),

328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,
336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

Line 333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,
336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
337: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

Line 334: NULL, Fnd_Global.login_id, p_last_update_login),

330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,
336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
337: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
338: FROM ibc_citem_versions_tl L

Line 378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,
378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 379: NULL, Fnd_Global.user_id, p_created_by),

375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,
378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),

Line 382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,

Line 383: NULL, Fnd_Global.user_id, p_last_updated_by),

379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,
387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

Line 384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,
387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
388: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

Line 385: NULL, Fnd_Global.login_id, p_last_update_login),

381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,
387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
388: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
389: FROM FND_LANGUAGES L

Line 512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),
512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 513: NULL, Fnd_Global.user_id, p_created_by),

509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),
512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),

Line 516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),
518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
519: NULL, Fnd_Global.login_id, p_last_update_login)
520: );

Line 517: NULL, Fnd_Global.user_id, p_last_updated_by),

513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),
518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
519: NULL, Fnd_Global.login_id, p_last_update_login)
520: );
521:

Line 518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),
518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
519: NULL, Fnd_Global.login_id, p_last_update_login)
520: );
521:
522: INSERT INTO IBC_CITEM_VERSIONS_TL (

Line 519: NULL, Fnd_Global.login_id, p_last_update_login)

515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),
518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
519: NULL, Fnd_Global.login_id, p_last_update_login)
520: );
521:
522: INSERT INTO IBC_CITEM_VERSIONS_TL (
523: CITEM_VERSION_ID,

Line 549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 550: NULL, Fnd_Global.user_id, p_created_by),

546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),

Line 553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

Line 554: NULL, Fnd_Global.user_id, p_last_updated_by),

550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

Line 555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
559: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

Line 556: NULL, Fnd_Global.login_id, p_last_update_login),

552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
559: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
560: );

Line 746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
748: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
749:
750: /*AND object_version_number = DECODE(p_object_version_number,

Line 747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
748: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
749:
750: /*AND object_version_number = DECODE(p_object_version_number,
751: FND_API.G_MISS_NUM,

Line 771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

767: UPDATE IBC_CITEM_VERSIONS_TL SET
768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)
774: ,TEXTIDX = 'X'
775: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID

Line 772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)
774: ,TEXTIDX = 'X'
775: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
776: AND P_SOURCE_LANG IN (LANGUAGE, SOURCE_LANG);