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

Line 95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),

91: --file_size,
92: file_size
93: --last_updated_by
94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

92: file_size
93: --last_updated_by
94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

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

93: --last_updated_by
94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),

94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

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

98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

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

99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),

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

100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),

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

101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),

Line 106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),

Line 107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),

103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),

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

104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),

Line 109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),

105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),

Line 110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),

106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),

Line 111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),

107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),

Line 112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),

108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),

Line 113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),

109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),

Line 114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),

110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));

Line 115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),

111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));

Line 116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),

112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:

Line 117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),

113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:
121: END Insert_Row;

Line 118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));

114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:
121: END Insert_Row;
122:

Line 119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));

115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:
121: END Insert_Row;
122:
123:

Line 156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),

152: IS
153: BEGIN
154: Update ams_imp_documents
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),

Line 157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),

153: BEGIN
154: Update ams_imp_documents
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),

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

154: Update ams_imp_documents
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),

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

155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),

Line 160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),

156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),

157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),

Line 162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),

158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),

159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

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

160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),

Line 165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),

161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),

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

162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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 167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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),
171: 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 168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),

164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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),
171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),

Line 169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),

165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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),
171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),

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

166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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),
171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),

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

167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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),
171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),

Line 172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),

168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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),
171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),

Line 173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),

169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --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),
171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),

Line 174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),

170: --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),
171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),

Line 175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),

171: 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),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),

Line 176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),

172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),

Line 177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),

173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)

Line 178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),

174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)

Line 179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),

175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id

Line 180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),

176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id
184: AND object_version_number = px_object_version_number;

Line 181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)

177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id
184: AND object_version_number = px_object_version_number;
185:

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

178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id
184: AND object_version_number = px_object_version_number;
185:
186:

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: AND object_version_number = px_object_version_number;
185:
186:
187: IF (SQL%NOTFOUND) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190:
191: px_object_version_number := nvl(px_object_version_number,0) + 1;
192:

Line 219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

215: DELETE FROM ams_imp_documents
216: WHERE imp_document_id = p_imp_document_id
217: AND object_version_number = p_object_version_number;
218: If (SQL%NOTFOUND) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: End If;
221: END Delete_Row ;
222:
223: