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

3431: end if;
3432:
3433: end if;
3434: if p_field_name is null then
3435: update AMS_IMP_XML_ELEMENTS
3436: set ERROR_TEXT = substr(p_error_text,1,2000),
3437: LOAD_STATUS = 'ERROR'
3438: where imp_xml_element_id = l_imp_xml_element_id;
3439: else

Line 5106: update AMS_IMP_XML_ELEMENTS

5102: fetch c_imp_type into l_imp_type;
5103: close c_imp_type;
5104:
5105: if l_imp_type = 'B2B' then
5106: update AMS_IMP_XML_ELEMENTS
5107: set LOAD_STATUS = 'SUCCESS'
5108: where imp_xml_element_id = p_xml_element_id;
5109: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5110: p_imp_xml_element_id => p_xml_element_id,

Line 5118: update AMS_IMP_XML_ELEMENTS

5114: -- FOR ORGANIZATION
5115: FOR i IN 1..l_org_record_in_tbl.COUNT
5116: LOOP
5117: if l_org_record_in_tbl(i).data_type = 'T' then
5118: update AMS_IMP_XML_ELEMENTS
5119: set LOAD_STATUS = 'SUCCESS'
5120: where imp_xml_element_id = l_org_record_in_tbl(i).imp_xml_element_id;
5121: -- FOR LOCATION
5122: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5130: update AMS_IMP_XML_ELEMENTS

5126: x_msg_data => x_msg_data);
5127: FOR j IN 1..l_loc_record_in_tbl.COUNT
5128: LOOP
5129: if l_loc_record_in_tbl(j).data_type = 'T' then
5130: update AMS_IMP_XML_ELEMENTS
5131: set LOAD_STATUS = 'SUCCESS'
5132: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5133: -- FOR ORG CONTACT
5134: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5142: update AMS_IMP_XML_ELEMENTS

5138: x_msg_data => x_msg_data);
5139: FOR k IN 1..l_con_record_in_tbl.COUNT
5140: LOOP
5141: if l_con_record_in_tbl(k).data_type = 'T' then
5142: update AMS_IMP_XML_ELEMENTS
5143: set LOAD_STATUS = 'SUCCESS'
5144: where imp_xml_element_id = l_con_record_in_tbl(k).imp_xml_element_id;
5145: -- FOR PHONE
5146: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5154: update AMS_IMP_XML_ELEMENTS

5150: x_msg_data => x_msg_data);
5151: FOR l IN 1..l_pho_record_in_tbl.COUNT
5152: LOOP
5153: if l_pho_record_in_tbl(l).data_type = 'T' then
5154: update AMS_IMP_XML_ELEMENTS
5155: set LOAD_STATUS = 'SUCCESS'
5156: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5157: end if;
5158: END LOOP; -- FOR PHONE

Line 5168: update AMS_IMP_XML_ELEMENTS

5164: x_msg_data => x_msg_data);
5165: FOR m IN 1..l_eml_record_in_tbl.COUNT
5166: LOOP
5167: if l_eml_record_in_tbl(m).data_type = 'T' then
5168: update AMS_IMP_XML_ELEMENTS
5169: set LOAD_STATUS = 'SUCCESS'
5170: where imp_xml_element_id = l_eml_record_in_tbl(m).imp_xml_element_id;
5171: end if;
5172: END LOOP; -- FOR EMAIL

Line 5183: update AMS_IMP_XML_ELEMENTS

5179: end if;
5180:
5181:
5182: if l_imp_type = 'B2C' then
5183: update AMS_IMP_XML_ELEMENTS
5184: set LOAD_STATUS = 'SUCCESS'
5185: where imp_xml_element_id = p_xml_element_id;
5186: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5187: p_imp_xml_element_id => p_xml_element_id,

Line 5195: update AMS_IMP_XML_ELEMENTS

5191: -- FOR PERSON
5192: FOR i IN 1..l_per_record_in_tbl.COUNT
5193: LOOP
5194: if l_per_record_in_tbl(i).data_type = 'T' then
5195: update AMS_IMP_XML_ELEMENTS
5196: set LOAD_STATUS = 'SUCCESS'
5197: where imp_xml_element_id = l_per_record_in_tbl(i).imp_xml_element_id;
5198: -- FOR LOCATION
5199: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5207: update AMS_IMP_XML_ELEMENTS

5203: x_msg_data => x_msg_data);
5204: FOR j IN 1..l_loc_record_in_tbl.COUNT
5205: LOOP
5206: if l_loc_record_in_tbl(j).data_type = 'T' then
5207: update AMS_IMP_XML_ELEMENTS
5208: set LOAD_STATUS = 'SUCCESS'
5209: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5210: -- FOR PHONE
5211: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5219: update AMS_IMP_XML_ELEMENTS

5215: x_msg_data => x_msg_data);
5216: FOR k IN 1..l_pho_record_in_tbl.COUNT
5217: LOOP
5218: if l_pho_record_in_tbl(k).data_type = 'T' then
5219: update AMS_IMP_XML_ELEMENTS
5220: set LOAD_STATUS = 'SUCCESS'
5221: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5222: end if;
5223: END LOOP; -- FOR PHONE

Line 5233: update AMS_IMP_XML_ELEMENTS

5229: x_msg_data => x_msg_data);
5230: FOR l IN 1..l_eml_record_in_tbl.COUNT
5231: LOOP
5232: if l_eml_record_in_tbl(l).data_type = 'T' then
5233: update AMS_IMP_XML_ELEMENTS
5234: set LOAD_STATUS = 'SUCCESS'
5235: where imp_xml_element_id = l_eml_record_in_tbl(l).imp_xml_element_id;
5236: end if;
5237: END LOOP; -- FOR EMAIL

Line 5298: update AMS_IMP_XML_ELEMENTS

5294: p_log_used_by_id => p_import_list_header_id,
5295: p_msg_data => 'p_xml_element_id := '||p_xml_element_id,
5296: p_msg_type => 'DEBUG');
5297: end if;
5298: update AMS_IMP_XML_ELEMENTS
5299: set LOAD_STATUS = 'DUPLICATE'
5300: where imp_xml_element_id = p_xml_element_id;
5301: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5302: p_imp_xml_element_id => p_xml_element_id,

Line 5310: update AMS_IMP_XML_ELEMENTS

5306: -- FOR ORGANIZATION
5307: FOR i IN 1..l_org_record_in_tbl.COUNT
5308: LOOP
5309: if l_org_record_in_tbl(i).data_type = 'T' then
5310: update AMS_IMP_XML_ELEMENTS
5311: set LOAD_STATUS = 'DUPLICATE'
5312: where imp_xml_element_id = l_org_record_in_tbl(i).imp_xml_element_id;
5313: -- FOR LOCATION
5314: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5322: update AMS_IMP_XML_ELEMENTS

5318: x_msg_data => x_msg_data);
5319: FOR j IN 1..l_loc_record_in_tbl.COUNT
5320: LOOP
5321: if l_loc_record_in_tbl(j).data_type = 'T' then
5322: update AMS_IMP_XML_ELEMENTS
5323: set LOAD_STATUS = 'DUPLICATE'
5324: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5325: -- FOR ORG CONTACT
5326: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5334: update AMS_IMP_XML_ELEMENTS

5330: x_msg_data => x_msg_data);
5331: FOR k IN 1..l_con_record_in_tbl.COUNT
5332: LOOP
5333: if l_con_record_in_tbl(k).data_type = 'T' then
5334: update AMS_IMP_XML_ELEMENTS
5335: set LOAD_STATUS = 'DUPLICATE'
5336: where imp_xml_element_id = l_con_record_in_tbl(k).imp_xml_element_id;
5337: -- FOR PHONE
5338: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5346: update AMS_IMP_XML_ELEMENTS

5342: x_msg_data => x_msg_data);
5343: FOR l IN 1..l_pho_record_in_tbl.COUNT
5344: LOOP
5345: if l_pho_record_in_tbl(l).data_type = 'T' then
5346: update AMS_IMP_XML_ELEMENTS
5347: set LOAD_STATUS = 'DUPLICATE'
5348: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5349: end if;
5350: END LOOP; -- FOR PHONE

Line 5360: update AMS_IMP_XML_ELEMENTS

5356: x_msg_data => x_msg_data);
5357: FOR m IN 1..l_eml_record_in_tbl.COUNT
5358: LOOP
5359: if l_eml_record_in_tbl(m).data_type = 'T' then
5360: update AMS_IMP_XML_ELEMENTS
5361: set LOAD_STATUS = 'DUPLICATE'
5362: where imp_xml_element_id = l_eml_record_in_tbl(m).imp_xml_element_id;
5363: end if;
5364: END LOOP; -- FOR EMAIL

Line 5375: update AMS_IMP_XML_ELEMENTS

5371: end if;
5372:
5373:
5374: if l_imp_type = 'B2C' then
5375: update AMS_IMP_XML_ELEMENTS
5376: set LOAD_STATUS = 'DUPLICATE'
5377: where imp_xml_element_id = p_xml_element_id;
5378: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5379: p_imp_xml_element_id => p_xml_element_id,

Line 5387: update AMS_IMP_XML_ELEMENTS

5383: -- FOR PERSON
5384: FOR i IN 1..l_per_record_in_tbl.COUNT
5385: LOOP
5386: if l_per_record_in_tbl(i).data_type = 'T' then
5387: update AMS_IMP_XML_ELEMENTS
5388: set LOAD_STATUS = 'DUPLICATE'
5389: where imp_xml_element_id = l_per_record_in_tbl(i).imp_xml_element_id;
5390: -- FOR LOCATION
5391: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5399: update AMS_IMP_XML_ELEMENTS

5395: x_msg_data => x_msg_data);
5396: FOR j IN 1..l_loc_record_in_tbl.COUNT
5397: LOOP
5398: if l_loc_record_in_tbl(j).data_type = 'T' then
5399: update AMS_IMP_XML_ELEMENTS
5400: set LOAD_STATUS = 'DUPLICATE'
5401: where imp_xml_element_id = l_loc_record_in_tbl(j).imp_xml_element_id;
5402: -- FOR PHONE
5403: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

Line 5411: update AMS_IMP_XML_ELEMENTS

5407: x_msg_data => x_msg_data);
5408: FOR k IN 1..l_pho_record_in_tbl.COUNT
5409: LOOP
5410: if l_pho_record_in_tbl(k).data_type = 'T' then
5411: update AMS_IMP_XML_ELEMENTS
5412: set LOAD_STATUS = 'DUPLICATE'
5413: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5414: end if;
5415: END LOOP; -- FOR PHONE

Line 5425: update AMS_IMP_XML_ELEMENTS

5421: x_msg_data => x_msg_data);
5422: FOR l IN 1..l_eml_record_in_tbl.COUNT
5423: LOOP
5424: if l_eml_record_in_tbl(l).data_type = 'T' then
5425: update AMS_IMP_XML_ELEMENTS
5426: set LOAD_STATUS = 'DUPLICATE'
5427: where imp_xml_element_id = l_eml_record_in_tbl(l).imp_xml_element_id;
5428: end if;
5429: END LOOP; -- FOR EMAIL