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 7961: update AMS_IMP_XML_ELEMENTS

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

Line 7969: update AMS_IMP_XML_ELEMENTS

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

Line 7975: update AMS_IMP_XML_ELEMENTS

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

Line 7981: update AMS_IMP_XML_ELEMENTS

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

Line 7987: update AMS_IMP_XML_ELEMENTS

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

Line 7995: update AMS_IMP_XML_ELEMENTS

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

Line 8001: update AMS_IMP_XML_ELEMENTS

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

Line 8007: update AMS_IMP_XML_ELEMENTS

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

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

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

Line 16024: root_node_rec_type AMS_IMP_XML_ELEMENTS%ROWTYPE;

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

Line 16025: l_child_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

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

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

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

Line 18328: update AMS_IMP_XML_ELEMENTS

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

Line 21309: update AMS_IMP_XML_ELEMENTS

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

Line 21312: update AMS_IMP_XML_ELEMENTS

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

Line 21315: update AMS_IMP_XML_ELEMENTS

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

Line 21318: update AMS_IMP_XML_ELEMENTS

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

Line 21321: update AMS_IMP_XML_ELEMENTS

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

Line 21335: update AMS_IMP_XML_ELEMENTS

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

Line 21338: update AMS_IMP_XML_ELEMENTS

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

Line 21341: update AMS_IMP_XML_ELEMENTS

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

Line 21344: update AMS_IMP_XML_ELEMENTS

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