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

Line 7960: update AMS_IMP_XML_ELEMENTS

7956: and batch_id = p_batch_id;
7957: end if;
7958: if l_file_type = 'XML' then
7959: if (l_imp_type in ('B2B','B2C') and (l_col1 = 'Y' or l_col2 = 'Y'))then
7960: update AMS_IMP_XML_ELEMENTS
7961: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col1,'Y',l_col11||l_invalid_date)||','||
7962: decode(l_col2,'Y',l_col22||l_invalid_date),
7963: LOAD_STATUS = 'ERROR'
7964: where imp_xml_element_id = l_add_imp_xml_element_id;

Line 7968: update AMS_IMP_XML_ELEMENTS

7964: where imp_xml_element_id = l_add_imp_xml_element_id;
7965: end if;
7966: if (l_imp_type in ('B2B') and (l_col3 = 'Y' or l_col4 = 'Y' or l_col5 = 'Y' or l_col6 = 'Y'))then
7967: if l_col3 = 'Y' then
7968: update AMS_IMP_XML_ELEMENTS
7969: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col3,'Y',l_col33||l_invalid_date),
7970: LOAD_STATUS = 'ERROR'
7971: where imp_xml_element_id = l_ocont_imp_xml_element_id;
7972: end if;

Line 7974: update AMS_IMP_XML_ELEMENTS

7970: LOAD_STATUS = 'ERROR'
7971: where imp_xml_element_id = l_ocont_imp_xml_element_id;
7972: end if;
7973: if l_col4 = 'Y' then
7974: update AMS_IMP_XML_ELEMENTS
7975: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col4,'Y',l_col44||l_invalid_date),
7976: LOAD_STATUS = 'ERROR'
7977: where imp_xml_element_id = l_ocont_imp_xml_element_id;
7978: end if;

Line 7980: update AMS_IMP_XML_ELEMENTS

7976: LOAD_STATUS = 'ERROR'
7977: where imp_xml_element_id = l_ocont_imp_xml_element_id;
7978: end if;
7979: if l_col6 = 'Y' then
7980: update AMS_IMP_XML_ELEMENTS
7981: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col6,'Y',l_col66||l_invalid_date),
7982: LOAD_STATUS = 'ERROR'
7983: where imp_xml_element_id = l_ocont_imp_xml_element_id;
7984: end if;

Line 7986: update AMS_IMP_XML_ELEMENTS

7982: LOAD_STATUS = 'ERROR'
7983: where imp_xml_element_id = l_ocont_imp_xml_element_id;
7984: end if;
7985: if l_col5 = 'Y' then
7986: update AMS_IMP_XML_ELEMENTS
7987: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col5,'Y',l_col55||l_invalid_date),
7988: LOAD_STATUS = 'ERROR'
7989: where imp_xml_element_id = l_org_imp_xml_element_id;
7990: end if;

Line 7994: update AMS_IMP_XML_ELEMENTS

7990: end if;
7991: end if;
7992: if (l_imp_type in ('B2C') and (l_col3 = 'Y' or l_col4 = 'Y' or l_col6 = 'Y'))then
7993: if l_col3 = 'Y' then
7994: update AMS_IMP_XML_ELEMENTS
7995: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col3,'Y',l_col33||l_invalid_date),
7996: LOAD_STATUS = 'ERROR'
7997: where imp_xml_element_id = l_per_imp_xml_element_id;
7998: end if;

Line 8000: update AMS_IMP_XML_ELEMENTS

7996: LOAD_STATUS = 'ERROR'
7997: where imp_xml_element_id = l_per_imp_xml_element_id;
7998: end if;
7999: if l_col4 = 'Y' then
8000: update AMS_IMP_XML_ELEMENTS
8001: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col4,'Y',l_col44||l_invalid_date),
8002: LOAD_STATUS = 'ERROR'
8003: where imp_xml_element_id = l_per_imp_xml_element_id;
8004: end if;

Line 8006: update AMS_IMP_XML_ELEMENTS

8002: LOAD_STATUS = 'ERROR'
8003: where imp_xml_element_id = l_per_imp_xml_element_id;
8004: end if;
8005: if l_col6 = 'Y' then
8006: update AMS_IMP_XML_ELEMENTS
8007: set ERROR_TEXT = ERROR_TEXT ||','||decode(l_col6,'Y',l_col66||l_invalid_date),
8008: LOAD_STATUS = 'ERROR'
8009: where imp_xml_element_id = l_per_imp_xml_element_id;
8010: end if;

Line 13700: select 'Y' from ams_imp_xml_elements e, ams_imp_documents d

13696: and load_status in ('ACTIVE','RELOAD')
13697: and rownum < 2;
13698:
13699: cursor c_rec_in_xml_stag_tab is
13700: select 'Y' from ams_imp_xml_elements e, ams_imp_documents d
13701: where d.import_list_header_id = p_import_list_header_id
13702: and d.imp_document_id = e.imp_xml_document_id
13703: and e.load_status in ('ACTIVE','RELOAD')
13704: and rownum < 2;

Line 16023: root_node_rec_type AMS_IMP_XML_ELEMENTS%ROWTYPE;

16019: p_update_flag IN VARCHAR2
16020: ) IS
16021:
16022:
16023: root_node_rec_type AMS_IMP_XML_ELEMENTS%ROWTYPE;
16024: l_child_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
16025: l_orgid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;
16026:
16027: l_perid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;

Line 16024: l_child_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

16020: ) IS
16021:
16022:
16023: root_node_rec_type AMS_IMP_XML_ELEMENTS%ROWTYPE;
16024: l_child_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
16025: l_orgid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;
16026:
16027: l_perid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;
16028:

Line 18320: select 'Y' from AMS_IMP_XML_ELEMENTS where IMP_XML_ELEMENT_ID = p_xml_element_id

18316: x_return_status VARCHAR2(1);
18317: x_msg_data VARCHAR2(2000);
18318: l_error_exist VARCHAR2(1);
18319: cursor c_error_text is
18320: select 'Y' from AMS_IMP_XML_ELEMENTS where IMP_XML_ELEMENT_ID = p_xml_element_id
18321: and error_text like '%'||p_colName||'%';
18322: begin
18323: open c_error_text;
18324: fetch c_error_text into l_error_exist;

Line 18327: update AMS_IMP_XML_ELEMENTS

18323: open c_error_text;
18324: fetch c_error_text into l_error_exist;
18325: close c_error_text;
18326: if l_error_exist is NULL then
18327: update AMS_IMP_XML_ELEMENTS
18328: set ERROR_TEXT = substr((ERROR_TEXT ||','||p_error_text),1,4000),
18329: LOAD_STATUS = 'ERROR'
18330: where imp_xml_element_id = p_xml_element_id;
18331: end if;

Line 21308: update AMS_IMP_XML_ELEMENTS

21304: loop
21305: fetch c_b2bxmlrec into l_org_imp_xml_element_id, l_add_imp_xml_element_id,
21306: l_ocont_imp_xml_element_id, l_cp_imp_xml_element_id, l_em_imp_xml_element_id;
21307: exit when c_b2bxmlrec%notfound;
21308: update AMS_IMP_XML_ELEMENTS
21309: set ERROR_TEXT = NULL
21310: where imp_xml_element_id = l_org_imp_xml_element_id;
21311: update AMS_IMP_XML_ELEMENTS
21312: set ERROR_TEXT = NULL

Line 21311: update AMS_IMP_XML_ELEMENTS

21307: exit when c_b2bxmlrec%notfound;
21308: update AMS_IMP_XML_ELEMENTS
21309: set ERROR_TEXT = NULL
21310: where imp_xml_element_id = l_org_imp_xml_element_id;
21311: update AMS_IMP_XML_ELEMENTS
21312: set ERROR_TEXT = NULL
21313: where imp_xml_element_id = l_add_imp_xml_element_id;
21314: update AMS_IMP_XML_ELEMENTS
21315: set ERROR_TEXT = NULL

Line 21314: update AMS_IMP_XML_ELEMENTS

21310: where imp_xml_element_id = l_org_imp_xml_element_id;
21311: update AMS_IMP_XML_ELEMENTS
21312: set ERROR_TEXT = NULL
21313: where imp_xml_element_id = l_add_imp_xml_element_id;
21314: update AMS_IMP_XML_ELEMENTS
21315: set ERROR_TEXT = NULL
21316: where imp_xml_element_id = l_ocont_imp_xml_element_id;
21317: update AMS_IMP_XML_ELEMENTS
21318: set ERROR_TEXT = NULL

Line 21317: update AMS_IMP_XML_ELEMENTS

21313: where imp_xml_element_id = l_add_imp_xml_element_id;
21314: update AMS_IMP_XML_ELEMENTS
21315: set ERROR_TEXT = NULL
21316: where imp_xml_element_id = l_ocont_imp_xml_element_id;
21317: update AMS_IMP_XML_ELEMENTS
21318: set ERROR_TEXT = NULL
21319: where imp_xml_element_id = l_cp_imp_xml_element_id;
21320: update AMS_IMP_XML_ELEMENTS
21321: set ERROR_TEXT = NULL

Line 21320: update AMS_IMP_XML_ELEMENTS

21316: where imp_xml_element_id = l_ocont_imp_xml_element_id;
21317: update AMS_IMP_XML_ELEMENTS
21318: set ERROR_TEXT = NULL
21319: where imp_xml_element_id = l_cp_imp_xml_element_id;
21320: update AMS_IMP_XML_ELEMENTS
21321: set ERROR_TEXT = NULL
21322: where imp_xml_element_id = l_em_imp_xml_element_id;
21323: end loop;
21324: close c_b2bxmlrec;

Line 21334: update AMS_IMP_XML_ELEMENTS

21330: loop
21331: fetch c_b2cxmlrec into l_per_imp_xml_element_id , l_add_imp_xml_element_id,
21332: l_cp_imp_xml_element_id, l_em_imp_xml_element_id;
21333: exit when c_b2cxmlrec%notfound;
21334: update AMS_IMP_XML_ELEMENTS
21335: set ERROR_TEXT = NULL
21336: where imp_xml_element_id = l_per_imp_xml_element_id;
21337: update AMS_IMP_XML_ELEMENTS
21338: set ERROR_TEXT = NULL

Line 21337: update AMS_IMP_XML_ELEMENTS

21333: exit when c_b2cxmlrec%notfound;
21334: update AMS_IMP_XML_ELEMENTS
21335: set ERROR_TEXT = NULL
21336: where imp_xml_element_id = l_per_imp_xml_element_id;
21337: update AMS_IMP_XML_ELEMENTS
21338: set ERROR_TEXT = NULL
21339: where imp_xml_element_id = l_add_imp_xml_element_id;
21340: update AMS_IMP_XML_ELEMENTS
21341: set ERROR_TEXT = NULL

Line 21340: update AMS_IMP_XML_ELEMENTS

21336: where imp_xml_element_id = l_per_imp_xml_element_id;
21337: update AMS_IMP_XML_ELEMENTS
21338: set ERROR_TEXT = NULL
21339: where imp_xml_element_id = l_add_imp_xml_element_id;
21340: update AMS_IMP_XML_ELEMENTS
21341: set ERROR_TEXT = NULL
21342: where imp_xml_element_id = l_cp_imp_xml_element_id;
21343: update AMS_IMP_XML_ELEMENTS
21344: set ERROR_TEXT = NULL

Line 21343: update AMS_IMP_XML_ELEMENTS

21339: where imp_xml_element_id = l_add_imp_xml_element_id;
21340: update AMS_IMP_XML_ELEMENTS
21341: set ERROR_TEXT = NULL
21342: where imp_xml_element_id = l_cp_imp_xml_element_id;
21343: update AMS_IMP_XML_ELEMENTS
21344: set ERROR_TEXT = NULL
21345: where imp_xml_element_id = l_em_imp_xml_element_id;
21346: end loop;
21347: close c_b2cxmlrec;