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_XML_ELEMENT_PVT dependencies on AMS_IMP_XML_ELEMENTS

Line 141: p_xml_element_rec IN AMS_IMP_XML_ELEMENTS%ROWTYPE,

137: PROCEDURE Update_B2C_Xml_Source_lines (
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_xml_element_rec IN AMS_IMP_XML_ELEMENTS%ROWTYPE,
142: p_xml_element_ids IN num_data_set_type_w,
143: p_xml_elements_data IN varchar2_2000_set_type,
144: p_xml_elements_col_name IN varchar2_2000_set_type,
145: p_commit IN VARCHAR2

Line 148: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;

144: p_xml_elements_col_name IN varchar2_2000_set_type,
145: p_commit IN VARCHAR2
146: )
147: IS
148: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;
149: l_source_system_column_name VARCHAR2(2000);
150: l_update_element_id NUMBER;
151: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
152:

Line 151: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

147: IS
148: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;
149: l_source_system_column_name VARCHAR2(2000);
150: l_update_element_id NUMBER;
151: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
152:
153: BEGIN
154: l_column_name := UPPER (p_xml_element_rec.COLUMN_NAME);
155: write_msg(' l_column_name::'||l_column_name );

Line 224: p_xml_element_rec IN AMS_IMP_XML_ELEMENTS%ROWTYPE,

220: PROCEDURE Update_B2B_Xml_Source_lines (
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_xml_element_rec IN AMS_IMP_XML_ELEMENTS%ROWTYPE,
225: p_xml_element_ids IN num_data_set_type_w,
226: p_xml_elements_data IN varchar2_2000_set_type,
227: p_xml_elements_col_name IN varchar2_2000_set_type,
228: p_commit IN VARCHAR2

Line 231: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;

227: p_xml_elements_col_name IN varchar2_2000_set_type,
228: p_commit IN VARCHAR2
229: )
230: IS
231: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;
232: l_source_system_column_name VARCHAR2(2000);
233: l_update_element_id NUMBER;
234: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
235:

Line 234: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

230: IS
231: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;
232: l_source_system_column_name VARCHAR2(2000);
233: l_update_element_id NUMBER;
234: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
235:
236: l_update_statement VARCHAR2(2000) := ' UPDATE ' || G_B2B_VIEW_NAME
237: || ' SET LOAD_STATUS = ''RELOAD'', ';
238:

Line 353: FROM AMS_IMP_XML_ELEMENTS

349: IS
350:
351: CURSOR c_get_xml_element(l_imp_xml_element_id NUMBER) IS
352: SELECT *
353: FROM AMS_IMP_XML_ELEMENTS
354: WHERE imp_xml_element_id = l_imp_xml_element_id;
355: -- Hint: Developer need to provide Where clause
356:
357: CURSOR c_get_import_type (p_header_id NUMBER) IS

Line 384: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

380: l_return_status VARCHAR2(1);
381: l_msg_count NUMBER;
382: l_msg_data VARCHAR2 (2000);
383:
384: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
385:
386: BEGIN
387:
388: -- Standard Start of API savepoint

Line 458: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Update_Row)

454:
455: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
456: END IF;
457:
458: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Update_Row)
459: AMS_IMP_XML_ELEMENTS_PKG.Update_Row (
460: p_imp_xml_element_id => p_xml_element_rec.imp_xml_element_id,
461: p_last_updated_by => FND_GLOBAL.user_id,
462: p_object_version_number => p_xml_element_rec.object_version_number,

Line 459: AMS_IMP_XML_ELEMENTS_PKG.Update_Row (

455: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
456: END IF;
457:
458: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Update_Row)
459: AMS_IMP_XML_ELEMENTS_PKG.Update_Row (
460: p_imp_xml_element_id => p_xml_element_rec.imp_xml_element_id,
461: p_last_updated_by => FND_GLOBAL.user_id,
462: p_object_version_number => p_xml_element_rec.object_version_number,
463: -- p_created_by => p_xml_element_rec.created_by,

Line 498: UPDATE ams_imp_xml_elements

494: --IF l_ref_xml_element_rec.data IS NULL THEN
495: -- l_ref_xml_element_rec.data := FND_API.g_miss_char;
496: --END IF;
497:
498: UPDATE ams_imp_xml_elements
499: SET LOAD_STATUS = 'RELOAD'
500: WHERE IMP_XML_ELEMENT_ID = l_element_rec.imp_xml_element_id;
501:
502: OPEN c_get_header_id (l_element_rec.IMP_XML_DOCUMENT_ID);

Line 521: UPDATE ams_imp_xml_elements

517: END IF;
518:
519: write_msg(' a test 02::' );
520: FORALL l_count IN p_xml_element_ids.FIRST .. p_xml_element_ids.LAST
521: UPDATE ams_imp_xml_elements
522: SET DATA = p_xml_elements_data (l_count)
523: WHERE IMP_XML_ELEMENT_ID = p_xml_element_ids (l_count);
524:
525: OPEN c_get_import_type (l_header_id.IMPORT_LIST_HEADER_ID);

Line 648: SELECT AMS_IMP_XML_ELEMENTS_s.NEXTVAL

644: l_IMP_XML_ELEMENT_ID NUMBER;
645: l_dummy NUMBER;
646:
647: CURSOR c_id IS
648: SELECT AMS_IMP_XML_ELEMENTS_s.NEXTVAL
649: FROM dual;
650:
651: CURSOR c_id_exists (l_id IN NUMBER) IS
652: SELECT 1

Line 653: FROM AMS_IMP_XML_ELEMENTS

649: FROM dual;
650:
651: CURSOR c_id_exists (l_id IN NUMBER) IS
652: SELECT 1
653: FROM AMS_IMP_XML_ELEMENTS
654: WHERE IMP_XML_ELEMENT_ID = l_id;
655:
656: BEGIN
657: -- Standard Start of API savepoint

Line 745: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Insert_Row)

741:
742: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
743: END IF;
744:
745: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Insert_Row)
746: AMS_IMP_XML_ELEMENTS_PKG.Insert_Row(
747: px_imp_xml_element_id => l_imp_xml_element_id,
748: p_last_updated_by => FND_GLOBAL.user_id,
749: px_object_version_number => l_object_version_number,

Line 746: AMS_IMP_XML_ELEMENTS_PKG.Insert_Row(

742: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
743: END IF;
744:
745: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Insert_Row)
746: AMS_IMP_XML_ELEMENTS_PKG.Insert_Row(
747: px_imp_xml_element_id => l_imp_xml_element_id,
748: p_last_updated_by => FND_GLOBAL.user_id,
749: px_object_version_number => l_object_version_number,
750: p_created_by => FND_GLOBAL.user_id,

Line 849: FROM AMS_IMP_XML_ELEMENTS

845: IS
846:
847: CURSOR c_get_xml_element(l_imp_xml_element_id NUMBER) IS
848: SELECT *
849: FROM AMS_IMP_XML_ELEMENTS
850: WHERE imp_xml_element_id = l_imp_xml_element_id;
851: -- Hint: Developer need to provide Where clause
852:
853: CURSOR c_get_import_type (p_header_id NUMBER) IS

Line 980: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Update_Row)

976:
977: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
978: END IF;
979:
980: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Update_Row)
981: AMS_IMP_XML_ELEMENTS_PKG.Update_Row (
982: p_imp_xml_element_id => p_xml_element_rec.imp_xml_element_id,
983: p_last_updated_by => FND_GLOBAL.user_id,
984: p_object_version_number => p_xml_element_rec.object_version_number,

Line 981: AMS_IMP_XML_ELEMENTS_PKG.Update_Row (

977: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
978: END IF;
979:
980: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Update_Row)
981: AMS_IMP_XML_ELEMENTS_PKG.Update_Row (
982: p_imp_xml_element_id => p_xml_element_rec.imp_xml_element_id,
983: p_last_updated_by => FND_GLOBAL.user_id,
984: p_object_version_number => p_xml_element_rec.object_version_number,
985: -- p_created_by => p_xml_element_rec.created_by,

Line 1190: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Delete_Row)

1186:
1187: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1188: END IF;
1189:
1190: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Delete_Row)
1191: AMS_IMP_XML_ELEMENTS_PKG.Delete_Row(
1192: p_IMP_XML_ELEMENT_ID => p_IMP_XML_ELEMENT_ID);
1193: --
1194: -- End of API body

Line 1191: AMS_IMP_XML_ELEMENTS_PKG.Delete_Row(

1187: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1188: END IF;
1189:
1190: -- Invoke table handler(AMS_IMP_XML_ELEMENTS_PKG.Delete_Row)
1191: AMS_IMP_XML_ELEMENTS_PKG.Delete_Row(
1192: p_IMP_XML_ELEMENT_ID => p_IMP_XML_ELEMENT_ID);
1193: --
1194: -- End of API body
1195: --

Line 1279: FROM AMS_IMP_XML_ELEMENTS

1275: l_IMP_XML_ELEMENT_ID NUMBER;
1276:
1277: CURSOR c_Xml_Element IS
1278: SELECT IMP_XML_ELEMENT_ID
1279: FROM AMS_IMP_XML_ELEMENTS
1280: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID
1281: AND object_version_number = p_object_version
1282: FOR UPDATE NOWAIT;
1283:

Line 1398: 'AMS_IMP_XML_ELEMENTS',

1394: BEGIN
1395: x_return_status := FND_API.g_ret_sts_success;
1396: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1397: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1398: 'AMS_IMP_XML_ELEMENTS',
1399: 'IMP_XML_ELEMENT_ID = ''' || p_xml_element_rec.IMP_XML_ELEMENT_ID ||''''
1400: );
1401: -- ELSE
1402: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1403: -- 'AMS_IMP_XML_ELEMENTS',

1399: 'IMP_XML_ELEMENT_ID = ''' || p_xml_element_rec.IMP_XML_ELEMENT_ID ||''''
1400: );
1401: -- ELSE
1402: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1403: -- 'AMS_IMP_XML_ELEMENTS',
1404: -- 'IMP_XML_ELEMENT_ID = ''' || p_xml_element_rec.IMP_XML_ELEMENT_ID ||
1405: -- ''' AND IMP_XML_ELEMENT_ID <> ' || p_xml_element_rec.IMP_XML_ELEMENT_ID
1406: -- );
1407: END IF;

Line 1617: FROM ams_imp_xml_elements

1613: l_return_status VARCHAR2(1);
1614:
1615: CURSOR c_complete IS
1616: SELECT *
1617: FROM ams_imp_xml_elements
1618: WHERE imp_xml_element_id = p_xml_element_rec.imp_xml_element_id;
1619: l_xml_element_rec c_complete%ROWTYPE;
1620: BEGIN
1621: x_complete_rec := p_xml_element_rec;