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_STYLESHEETS_PKG dependencies on FND_API

Line 48: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

44: p_CONTENT_TYPE_CODE,
45: p_CONTENT_ITEM_ID,
46: p_default_stylesheet_flag,
47: p_OBJECT_VERSION_NUMBER,
48: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
49: p_creation_date),
50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

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

46: p_default_stylesheet_flag,
47: p_OBJECT_VERSION_NUMBER,
48: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
49: p_creation_date),
50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

48: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
49: p_creation_date),
50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),
56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

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

50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),
56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
57: NULL, Fnd_Global.login_id, p_last_update_login)
58: );

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

52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),
56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
57: NULL, Fnd_Global.login_id, p_last_update_login)
58: );
59:
60: OPEN c;

Line 113: CONTENT_TYPE_CODE = DECODE(p_CONTENT_TYPE_CODE,Fnd_Api.G_MISS_CHAR,NULL,NULL,CONTENT_TYPE_CODE,p_CONTENT_TYPE_CODE),

109: p_OBJECT_VERSION_NUMBER IN NUMBER
110: ) IS
111: BEGIN
112: UPDATE IBC_STYLESHEETS SET
113: CONTENT_TYPE_CODE = DECODE(p_CONTENT_TYPE_CODE,Fnd_Api.G_MISS_CHAR,NULL,NULL,CONTENT_TYPE_CODE,p_CONTENT_TYPE_CODE),
114: CONTENT_ITEM_ID = DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,NULL,CONTENT_ITEM_ID,p_CONTENT_ITEM_ID),
115: default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),
116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
117: last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,

Line 114: CONTENT_ITEM_ID = DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,NULL,CONTENT_ITEM_ID,p_CONTENT_ITEM_ID),

110: ) IS
111: BEGIN
112: UPDATE IBC_STYLESHEETS SET
113: CONTENT_TYPE_CODE = DECODE(p_CONTENT_TYPE_CODE,Fnd_Api.G_MISS_CHAR,NULL,NULL,CONTENT_TYPE_CODE,p_CONTENT_TYPE_CODE),
114: CONTENT_ITEM_ID = DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,NULL,CONTENT_ITEM_ID,p_CONTENT_ITEM_ID),
115: default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),
116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
117: last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,
118: NULL, SYSDATE, p_last_update_date),

Line 115: default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),

111: BEGIN
112: UPDATE IBC_STYLESHEETS SET
113: CONTENT_TYPE_CODE = DECODE(p_CONTENT_TYPE_CODE,Fnd_Api.G_MISS_CHAR,NULL,NULL,CONTENT_TYPE_CODE,p_CONTENT_TYPE_CODE),
114: CONTENT_ITEM_ID = DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,NULL,CONTENT_ITEM_ID,p_CONTENT_ITEM_ID),
115: default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),
116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
117: last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,
118: NULL, SYSDATE, p_last_update_date),
119: last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,

Line 117: last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,

113: CONTENT_TYPE_CODE = DECODE(p_CONTENT_TYPE_CODE,Fnd_Api.G_MISS_CHAR,NULL,NULL,CONTENT_TYPE_CODE,p_CONTENT_TYPE_CODE),
114: CONTENT_ITEM_ID = DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,NULL,CONTENT_ITEM_ID,p_CONTENT_ITEM_ID),
115: default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),
116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
117: last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,
118: NULL, SYSDATE, p_last_update_date),
119: last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,
120: Fnd_Global.user_id, NULL, Fnd_Global.user_id,
121: p_last_updated_by),

Line 119: last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,

115: default_stylesheet_flag = DECODE(p_default_stylesheet_flag,Fnd_Api.G_MISS_CHAR,'F',NULL,default_stylesheet_flag,p_default_stylesheet_flag),
116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
117: last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,
118: NULL, SYSDATE, p_last_update_date),
119: last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,
120: Fnd_Global.user_id, NULL, Fnd_Global.user_id,
121: p_last_updated_by),
122: last_update_login = DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM,
123: Fnd_Global.login_id, NULL, Fnd_Global.login_id,

Line 122: last_update_login = DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM,

118: NULL, SYSDATE, p_last_update_date),
119: last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,
120: Fnd_Global.user_id, NULL, Fnd_Global.user_id,
121: p_last_updated_by),
122: last_update_login = DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM,
123: Fnd_Global.login_id, NULL, Fnd_Global.login_id,
124: p_last_update_login)
125: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
126: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID

Line 128: Fnd_Api.G_MISS_NUM,object_version_number,

124: p_last_update_login)
125: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
126: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
127: AND object_version_number = DECODE(p_object_version_number,
128: Fnd_Api.G_MISS_NUM,object_version_number,
129: NULL,object_version_number,
130: p_object_version_number);
131:
132: IF (SQL%NOTFOUND) THEN

Line 211: Fnd_Api.G_MISS_NUM,object_version_number,

207: FROM IBC_STYLESHEETS
208: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
209: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
210: AND object_version_number = DECODE(object_version_number,
211: Fnd_Api.G_MISS_NUM,object_version_number,
212: NULL,object_version_number,
213: object_version_number);
214: DECLARE
215: l_temp INTEGER;

Line 248: p_default_stylesheet_flag => nvl(l_default_stylesheet_flag,FND_API.G_MISS_CHAR),

244:
245: UPDATE_ROW (
246: p_CONTENT_ITEM_ID => p_CONTENT_ITEM_ID,
247: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
248: p_default_stylesheet_flag => nvl(l_default_stylesheet_flag,FND_API.G_MISS_CHAR),
249: p_LAST_UPDATED_BY => l_user_id,
250: p_LAST_UPDATE_DATE => SYSDATE,
251: p_LAST_UPDATE_LOGIN => 0,
252: p_OBJECT_VERSION_NUMBER => NULL );