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

Line 10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX

6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- Sri Rangarajan 01/06/2002 Created Package
10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11: -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
12: -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
13:
14: PROCEDURE INSERT_ROW (

Line 44: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)

40: ) VALUES (
41: p_content_item_id
42: ,p_label_code
43: ,p_citem_version_id
44: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
45: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
46: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
47: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
48: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 45: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

41: p_content_item_id
42: ,p_label_code
43: ,p_citem_version_id
44: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
45: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
46: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
47: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
48: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
49: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

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

42: ,p_label_code
43: ,p_citem_version_id
44: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
45: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
46: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
47: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
48: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
49: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
50: );

Line 47: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

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

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

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

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

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

Line 109: citem_version_id = DECODE(p_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)

105: ,p_object_version_number IN NUMBER --DEFAULT NULL
106: ) IS
107: BEGIN
108: UPDATE IBC_CITEM_VERSION_LABELS SET
109: citem_version_id = DECODE(p_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
110: ,object_version_number = NVL(object_version_number,0) + 1
111: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
112: ,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)
113: ,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)

Line 111: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

107: BEGIN
108: UPDATE IBC_CITEM_VERSION_LABELS SET
109: citem_version_id = DECODE(p_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
110: ,object_version_number = NVL(object_version_number,0) + 1
111: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
112: ,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)
113: ,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)
114: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
115: AND LABEL_CODE = p_LABEL_CODE

Line 112: ,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)

108: UPDATE IBC_CITEM_VERSION_LABELS SET
109: citem_version_id = DECODE(p_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
110: ,object_version_number = NVL(object_version_number,0) + 1
111: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
112: ,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)
113: ,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)
114: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
115: AND LABEL_CODE = p_LABEL_CODE
116: AND object_version_number = DECODE(p_object_version_number,

Line 113: ,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)

109: citem_version_id = DECODE(p_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
110: ,object_version_number = NVL(object_version_number,0) + 1
111: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
112: ,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)
113: ,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)
114: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
115: AND LABEL_CODE = p_LABEL_CODE
116: AND object_version_number = DECODE(p_object_version_number,
117: FND_API.G_MISS_NUM,

Line 117: FND_API.G_MISS_NUM,

113: ,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)
114: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
115: AND LABEL_CODE = p_LABEL_CODE
116: AND object_version_number = DECODE(p_object_version_number,
117: FND_API.G_MISS_NUM,
118: object_version_number,
119: NULL,
120: object_version_number,
121: p_object_version_number);

Line 192: l_object_version_number NUMBER := FND_API.G_MISS_NUM;

188: p_LAST_UPDATE_DATE IN VARCHAR2) IS
189:
190: l_user_id NUMBER := 0;
191: l_row_id VARCHAR2(64);
192: l_object_version_number NUMBER := FND_API.G_MISS_NUM;
193: l_last_update_date DATE;
194:
195: db_user_id NUMBER := 0;
196: db_last_update_date DATE;

Line 216: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)

212: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
213: db_user_id, db_last_update_date, p_upload_mode )) THEN
214: BEGIN
215: Ibc_Citem_Version_Labels_Pkg.UPDATE_ROW (
216: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
217: ,p_label_code => NVL(p_label_code,FND_API.G_MISS_CHAR)
218: ,p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
219: ,p_last_updated_by => l_user_id
220: ,p_last_update_date => SYSDATE

Line 217: ,p_label_code => NVL(p_label_code,FND_API.G_MISS_CHAR)

213: db_user_id, db_last_update_date, p_upload_mode )) THEN
214: BEGIN
215: Ibc_Citem_Version_Labels_Pkg.UPDATE_ROW (
216: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
217: ,p_label_code => NVL(p_label_code,FND_API.G_MISS_CHAR)
218: ,p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
219: ,p_last_updated_by => l_user_id
220: ,p_last_update_date => SYSDATE
221: ,p_last_update_login => 0

Line 218: ,p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)

214: BEGIN
215: Ibc_Citem_Version_Labels_Pkg.UPDATE_ROW (
216: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
217: ,p_label_code => NVL(p_label_code,FND_API.G_MISS_CHAR)
218: ,p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
219: ,p_last_updated_by => l_user_id
220: ,p_last_update_date => SYSDATE
221: ,p_last_update_login => 0
222: ,p_object_version_number => l_object_version_number);