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.AMS_IMP_DOC_CON_PKG dependencies on FND_API

Line 77: DECODE( px_imp_doc_content_id, FND_API.G_MISS_NUM, NULL, px_imp_doc_content_id),

73: import_list_header_id,
74: file_id,
75: file_name
76: ) VALUES (
77: DECODE( px_imp_doc_content_id, FND_API.G_MISS_NUM, NULL, px_imp_doc_content_id),
78: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 78: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

74: file_id,
75: file_name
76: ) VALUES (
77: DECODE( px_imp_doc_content_id, FND_API.G_MISS_NUM, NULL, px_imp_doc_content_id),
78: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

75: file_name
76: ) VALUES (
77: DECODE( px_imp_doc_content_id, FND_API.G_MISS_NUM, NULL, px_imp_doc_content_id),
78: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

76: ) VALUES (
77: DECODE( px_imp_doc_content_id, FND_API.G_MISS_NUM, NULL, px_imp_doc_content_id),
78: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),

Line 81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

77: DECODE( px_imp_doc_content_id, FND_API.G_MISS_NUM, NULL, px_imp_doc_content_id),
78: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
85: DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),

Line 82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

78: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
85: DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),
86: DECODE( p_file_name, FND_API.G_MISS_CHAR, NULL, p_file_name));

Line 83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

79: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
85: DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),
86: DECODE( p_file_name, FND_API.G_MISS_CHAR, NULL, p_file_name));
87:

Line 84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),

80: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
85: DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),
86: DECODE( p_file_name, FND_API.G_MISS_CHAR, NULL, p_file_name));
87:
88: END Insert_Row;

Line 85: DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),

81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
85: DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),
86: DECODE( p_file_name, FND_API.G_MISS_CHAR, NULL, p_file_name));
87:
88: END Insert_Row;
89:

Line 86: DECODE( p_file_name, FND_API.G_MISS_CHAR, NULL, p_file_name));

82: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
85: DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),
86: DECODE( p_file_name, FND_API.G_MISS_CHAR, NULL, p_file_name));
87:
88: END Insert_Row;
89:
90:

Line 120: imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),

116: IS
117: BEGIN
118: Update ams_imp_doc_content
119: SET
120: imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),
121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),

Line 121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

117: BEGIN
118: Update ams_imp_doc_content
119: SET
120: imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),
121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
125: file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),

Line 122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

118: Update ams_imp_doc_content
119: SET
120: imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),
121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
125: file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),
126: file_name = DECODE( p_file_name, null, file_name, FND_API.G_MISS_CHAR, null, p_file_name)

Line 123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

119: SET
120: imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),
121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
125: file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),
126: file_name = DECODE( p_file_name, null, file_name, FND_API.G_MISS_CHAR, null, p_file_name)
127: WHERE imp_doc_content_id = p_imp_doc_content_id

Line 124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),

120: imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),
121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
125: file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),
126: file_name = DECODE( p_file_name, null, file_name, FND_API.G_MISS_CHAR, null, p_file_name)
127: WHERE imp_doc_content_id = p_imp_doc_content_id
128: AND object_version_number = px_object_version_number;

Line 125: file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),

121: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
125: file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),
126: file_name = DECODE( p_file_name, null, file_name, FND_API.G_MISS_CHAR, null, p_file_name)
127: WHERE imp_doc_content_id = p_imp_doc_content_id
128: AND object_version_number = px_object_version_number;
129:

Line 126: file_name = DECODE( p_file_name, null, file_name, FND_API.G_MISS_CHAR, null, p_file_name)

122: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
123: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
124: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
125: file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),
126: file_name = DECODE( p_file_name, null, file_name, FND_API.G_MISS_CHAR, null, p_file_name)
127: WHERE imp_doc_content_id = p_imp_doc_content_id
128: AND object_version_number = px_object_version_number;
129:
130:

Line 132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

128: AND object_version_number = px_object_version_number;
129:
130:
131: IF (SQL%NOTFOUND) THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:
135: px_object_version_number := nvl(px_object_version_number,0) + 1;
136:

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: DELETE FROM ams_imp_doc_content
160: WHERE imp_doc_content_id = p_imp_doc_content_id
161: AND object_version_number = p_object_version_number;
162: If (SQL%NOTFOUND) then
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: End If;
165: END Delete_Row ;
166:
167: