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

Line 3442: update AMS_IMP_XML_ELEMENTS

3438: end if;
3439:
3440: end if;
3441: if p_field_name is null then
3442: update AMS_IMP_XML_ELEMENTS
3443: set ERROR_TEXT = substr(p_error_text,1,2000),
3444: LOAD_STATUS = 'ERROR'
3445: where imp_xml_element_id = l_imp_xml_element_id;
3446: else

Line 5113: update AMS_IMP_XML_ELEMENTS

5109: fetch c_imp_type into l_imp_type;
5110: close c_imp_type;
5111:
5112: if l_imp_type = 'B2B' then
5113: update AMS_IMP_XML_ELEMENTS
5114: set LOAD_STATUS = 'SUCCESS'
5115: where imp_xml_element_id = p_xml_element_id;
5116: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5117: p_imp_xml_element_id => p_xml_element_id,

Line 5125: update AMS_IMP_XML_ELEMENTS

5121: -- FOR ORGANIZATION
5122: FOR i IN 1..l_org_record_in_tbl.COUNT
5123: LOOP
5124: if l_org_record_in_tbl(i).data_type = 'T' then
5125: update AMS_IMP_XML_ELEMENTS
5126: set LOAD_STATUS = 'SUCCESS'
5127: where imp_xml_element_id = l_org_record_in_tbl(i).imp_xml_element_id;
5128: -- FOR LOCATION
5129: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5137: update AMS_IMP_XML_ELEMENTS

5133: x_msg_data => x_msg_data);
5134: FOR j IN 1..l_loc_record_in_tbl.COUNT
5135: LOOP
5136: if l_loc_record_in_tbl(j).data_type = 'T' then
5137: update AMS_IMP_XML_ELEMENTS
5138: set LOAD_STATUS = 'SUCCESS'
5139: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5140: -- FOR ORG CONTACT
5141: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5149: update AMS_IMP_XML_ELEMENTS

5145: x_msg_data => x_msg_data);
5146: FOR k IN 1..l_con_record_in_tbl.COUNT
5147: LOOP
5148: if l_con_record_in_tbl(k).data_type = 'T' then
5149: update AMS_IMP_XML_ELEMENTS
5150: set LOAD_STATUS = 'SUCCESS'
5151: where imp_xml_element_id = l_con_record_in_tbl(k).imp_xml_element_id;
5152: -- FOR PHONE
5153: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5161: update AMS_IMP_XML_ELEMENTS

5157: x_msg_data => x_msg_data);
5158: FOR l IN 1..l_pho_record_in_tbl.COUNT
5159: LOOP
5160: if l_pho_record_in_tbl(l).data_type = 'T' then
5161: update AMS_IMP_XML_ELEMENTS
5162: set LOAD_STATUS = 'SUCCESS'
5163: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5164: end if;
5165: END LOOP; -- FOR PHONE

Line 5175: update AMS_IMP_XML_ELEMENTS

5171: x_msg_data => x_msg_data);
5172: FOR m IN 1..l_eml_record_in_tbl.COUNT
5173: LOOP
5174: if l_eml_record_in_tbl(m).data_type = 'T' then
5175: update AMS_IMP_XML_ELEMENTS
5176: set LOAD_STATUS = 'SUCCESS'
5177: where imp_xml_element_id = l_eml_record_in_tbl(m).imp_xml_element_id;
5178: end if;
5179: END LOOP; -- FOR EMAIL

Line 5190: update AMS_IMP_XML_ELEMENTS

5186: end if;
5187:
5188:
5189: if l_imp_type = 'B2C' then
5190: update AMS_IMP_XML_ELEMENTS
5191: set LOAD_STATUS = 'SUCCESS'
5192: where imp_xml_element_id = p_xml_element_id;
5193: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5194: p_imp_xml_element_id => p_xml_element_id,

Line 5202: update AMS_IMP_XML_ELEMENTS

5198: -- FOR PERSON
5199: FOR i IN 1..l_per_record_in_tbl.COUNT
5200: LOOP
5201: if l_per_record_in_tbl(i).data_type = 'T' then
5202: update AMS_IMP_XML_ELEMENTS
5203: set LOAD_STATUS = 'SUCCESS'
5204: where imp_xml_element_id = l_per_record_in_tbl(i).imp_xml_element_id;
5205: -- FOR LOCATION
5206: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5214: update AMS_IMP_XML_ELEMENTS

5210: x_msg_data => x_msg_data);
5211: FOR j IN 1..l_loc_record_in_tbl.COUNT
5212: LOOP
5213: if l_loc_record_in_tbl(j).data_type = 'T' then
5214: update AMS_IMP_XML_ELEMENTS
5215: set LOAD_STATUS = 'SUCCESS'
5216: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5217: -- FOR PHONE
5218: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5226: update AMS_IMP_XML_ELEMENTS

5222: x_msg_data => x_msg_data);
5223: FOR k IN 1..l_pho_record_in_tbl.COUNT
5224: LOOP
5225: if l_pho_record_in_tbl(k).data_type = 'T' then
5226: update AMS_IMP_XML_ELEMENTS
5227: set LOAD_STATUS = 'SUCCESS'
5228: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5229: end if;
5230: END LOOP; -- FOR PHONE

Line 5240: update AMS_IMP_XML_ELEMENTS

5236: x_msg_data => x_msg_data);
5237: FOR l IN 1..l_eml_record_in_tbl.COUNT
5238: LOOP
5239: if l_eml_record_in_tbl(l).data_type = 'T' then
5240: update AMS_IMP_XML_ELEMENTS
5241: set LOAD_STATUS = 'SUCCESS'
5242: where imp_xml_element_id = l_eml_record_in_tbl(l).imp_xml_element_id;
5243: end if;
5244: END LOOP; -- FOR EMAIL

Line 5305: update AMS_IMP_XML_ELEMENTS

5301: p_log_used_by_id => p_import_list_header_id,
5302: p_msg_data => 'p_xml_element_id := '||p_xml_element_id,
5303: p_msg_type => 'DEBUG');
5304: end if;
5305: update AMS_IMP_XML_ELEMENTS
5306: set LOAD_STATUS = 'DUPLICATE'
5307: where imp_xml_element_id = p_xml_element_id;
5308: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5309: p_imp_xml_element_id => p_xml_element_id,

Line 5317: update AMS_IMP_XML_ELEMENTS

5313: -- FOR ORGANIZATION
5314: FOR i IN 1..l_org_record_in_tbl.COUNT
5315: LOOP
5316: if l_org_record_in_tbl(i).data_type = 'T' then
5317: update AMS_IMP_XML_ELEMENTS
5318: set LOAD_STATUS = 'DUPLICATE'
5319: where imp_xml_element_id = l_org_record_in_tbl(i).imp_xml_element_id;
5320: -- FOR LOCATION
5321: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5329: update AMS_IMP_XML_ELEMENTS

5325: x_msg_data => x_msg_data);
5326: FOR j IN 1..l_loc_record_in_tbl.COUNT
5327: LOOP
5328: if l_loc_record_in_tbl(j).data_type = 'T' then
5329: update AMS_IMP_XML_ELEMENTS
5330: set LOAD_STATUS = 'DUPLICATE'
5331: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5332: -- FOR ORG CONTACT
5333: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5341: update AMS_IMP_XML_ELEMENTS

5337: x_msg_data => x_msg_data);
5338: FOR k IN 1..l_con_record_in_tbl.COUNT
5339: LOOP
5340: if l_con_record_in_tbl(k).data_type = 'T' then
5341: update AMS_IMP_XML_ELEMENTS
5342: set LOAD_STATUS = 'DUPLICATE'
5343: where imp_xml_element_id = l_con_record_in_tbl(k).imp_xml_element_id;
5344: -- FOR PHONE
5345: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5353: update AMS_IMP_XML_ELEMENTS

5349: x_msg_data => x_msg_data);
5350: FOR l IN 1..l_pho_record_in_tbl.COUNT
5351: LOOP
5352: if l_pho_record_in_tbl(l).data_type = 'T' then
5353: update AMS_IMP_XML_ELEMENTS
5354: set LOAD_STATUS = 'DUPLICATE'
5355: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5356: end if;
5357: END LOOP; -- FOR PHONE

Line 5367: update AMS_IMP_XML_ELEMENTS

5363: x_msg_data => x_msg_data);
5364: FOR m IN 1..l_eml_record_in_tbl.COUNT
5365: LOOP
5366: if l_eml_record_in_tbl(m).data_type = 'T' then
5367: update AMS_IMP_XML_ELEMENTS
5368: set LOAD_STATUS = 'DUPLICATE'
5369: where imp_xml_element_id = l_eml_record_in_tbl(m).imp_xml_element_id;
5370: end if;
5371: END LOOP; -- FOR EMAIL

Line 5382: update AMS_IMP_XML_ELEMENTS

5378: end if;
5379:
5380:
5381: if l_imp_type = 'B2C' then
5382: update AMS_IMP_XML_ELEMENTS
5383: set LOAD_STATUS = 'DUPLICATE'
5384: where imp_xml_element_id = p_xml_element_id;
5385: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5386: p_imp_xml_element_id => p_xml_element_id,

Line 5394: update AMS_IMP_XML_ELEMENTS

5390: -- FOR PERSON
5391: FOR i IN 1..l_per_record_in_tbl.COUNT
5392: LOOP
5393: if l_per_record_in_tbl(i).data_type = 'T' then
5394: update AMS_IMP_XML_ELEMENTS
5395: set LOAD_STATUS = 'DUPLICATE'
5396: where imp_xml_element_id = l_per_record_in_tbl(i).imp_xml_element_id;
5397: -- FOR LOCATION
5398: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5406: update AMS_IMP_XML_ELEMENTS

5402: x_msg_data => x_msg_data);
5403: FOR j IN 1..l_loc_record_in_tbl.COUNT
5404: LOOP
5405: if l_loc_record_in_tbl(j).data_type = 'T' then
5406: update AMS_IMP_XML_ELEMENTS
5407: set LOAD_STATUS = 'DUPLICATE'
5408: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5409: -- FOR PHONE
5410: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5418: update AMS_IMP_XML_ELEMENTS

5414: x_msg_data => x_msg_data);
5415: FOR k IN 1..l_pho_record_in_tbl.COUNT
5416: LOOP
5417: if l_pho_record_in_tbl(k).data_type = 'T' then
5418: update AMS_IMP_XML_ELEMENTS
5419: set LOAD_STATUS = 'DUPLICATE'
5420: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5421: end if;
5422: END LOOP; -- FOR PHONE

Line 5432: update AMS_IMP_XML_ELEMENTS

5428: x_msg_data => x_msg_data);
5429: FOR l IN 1..l_eml_record_in_tbl.COUNT
5430: LOOP
5431: if l_eml_record_in_tbl(l).data_type = 'T' then
5432: update AMS_IMP_XML_ELEMENTS
5433: set LOAD_STATUS = 'DUPLICATE'
5434: where imp_xml_element_id = l_eml_record_in_tbl(l).imp_xml_element_id;
5435: end if;
5436: END LOOP; -- FOR EMAIL