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_IMPORT_XML_PVT

Line 5096: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5092: x_return_status VARCHAR2(1);
5093: x_msg_data VARCHAR2(2000);
5094: l_imp_type VARCHAR2(30);
5095:
5096: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5097: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5098: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5099: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5097: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5093: x_msg_data VARCHAR2(2000);
5094: l_imp_type VARCHAR2(30);
5095:
5096: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5097: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5098: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5099: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5101: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5098: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5094: l_imp_type VARCHAR2(30);
5095:
5096: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5097: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5098: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5099: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5101: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5102:

Line 5099: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5095:
5096: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5097: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5098: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5099: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5101: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5102:
5103: cursor c_imp_type is

Line 5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5096: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5097: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5098: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5099: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5101: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5102:
5103: cursor c_imp_type is
5104: select import_type from ams_imp_list_headers_all

Line 5101: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5097: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5098: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5099: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5100: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5101: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5102:
5103: cursor c_imp_type is
5104: select import_type from ams_imp_list_headers_all
5105: where import_list_header_id = p_import_list_header_id;

Line 5116: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5118: x_child_set => l_org_record_in_tbl,
5119: x_return_status => x_return_status,
5120: x_msg_data => x_msg_data);

Line 5129: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5130: p_imp_xml_element_id => l_org_record_in_tbl(i).imp_xml_element_id,
5131: x_child_set => l_loc_record_in_tbl,
5132: x_return_status => x_return_status,
5133: x_msg_data => x_msg_data);

Line 5141: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5142: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5143: x_child_set => l_con_record_in_tbl,
5144: x_return_status => x_return_status,
5145: x_msg_data => x_msg_data);

Line 5153: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5154: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5155: x_child_set => l_pho_record_in_tbl,
5156: x_return_status => x_return_status,
5157: x_msg_data => x_msg_data);

Line 5167: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5163: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5164: end if;
5165: END LOOP; -- FOR PHONE
5166: -- FOR EMAIL
5167: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5168: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5169: x_child_set => l_eml_record_in_tbl,
5170: x_return_status => x_return_status,
5171: x_msg_data => x_msg_data);

Line 5193: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5195: x_child_set => l_per_record_in_tbl,
5196: x_return_status => x_return_status,
5197: x_msg_data => x_msg_data);

Line 5206: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5207: p_imp_xml_element_id => l_per_record_in_tbl(i).imp_xml_element_id,
5208: x_child_set => l_loc_record_in_tbl,
5209: x_return_status => x_return_status,
5210: x_msg_data => x_msg_data);

Line 5218: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5219: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5220: x_child_set => l_pho_record_in_tbl,
5221: x_return_status => x_return_status,
5222: x_msg_data => x_msg_data);

Line 5232: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5228: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5229: end if;
5230: END LOOP; -- FOR PHONE
5231: -- FOR EMAIL
5232: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5233: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5234: x_child_set => l_eml_record_in_tbl,
5235: x_return_status => x_return_status,
5236: x_msg_data => x_msg_data);

Line 5279: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5275: x_return_status VARCHAR2(1);
5276: x_msg_data VARCHAR2(2000);
5277: l_imp_type VARCHAR2(30);
5278:
5279: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5280: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5281: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5282: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5280: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5276: x_msg_data VARCHAR2(2000);
5277: l_imp_type VARCHAR2(30);
5278:
5279: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5280: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5281: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5282: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5284: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5281: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5277: l_imp_type VARCHAR2(30);
5278:
5279: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5280: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5281: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5282: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5284: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5285:

Line 5282: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5278:
5279: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5280: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5281: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5282: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5284: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5285:
5286: cursor c_imp_type is

Line 5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5279: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5280: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5281: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5282: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5284: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5285:
5286: cursor c_imp_type is
5287: select import_type from ams_imp_list_headers_all

Line 5284: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5280: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5281: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5282: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5283: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5284: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5285:
5286: cursor c_imp_type is
5287: select import_type from ams_imp_list_headers_all
5288: where import_list_header_id = p_import_list_header_id;

Line 5308: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5310: x_child_set => l_org_record_in_tbl,
5311: x_return_status => x_return_status,
5312: x_msg_data => x_msg_data);

Line 5321: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5322: p_imp_xml_element_id => l_org_record_in_tbl(i).imp_xml_element_id,
5323: x_child_set => l_loc_record_in_tbl,
5324: x_return_status => x_return_status,
5325: x_msg_data => x_msg_data);

Line 5333: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5334: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5335: x_child_set => l_con_record_in_tbl,
5336: x_return_status => x_return_status,
5337: x_msg_data => x_msg_data);

Line 5345: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5346: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5347: x_child_set => l_pho_record_in_tbl,
5348: x_return_status => x_return_status,
5349: x_msg_data => x_msg_data);

Line 5359: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5355: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5356: end if;
5357: END LOOP; -- FOR PHONE
5358: -- FOR EMAIL
5359: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5360: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5361: x_child_set => l_eml_record_in_tbl,
5362: x_return_status => x_return_status,
5363: x_msg_data => x_msg_data);

Line 5385: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5387: x_child_set => l_per_record_in_tbl,
5388: x_return_status => x_return_status,
5389: x_msg_data => x_msg_data);

Line 5398: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5399: p_imp_xml_element_id => l_per_record_in_tbl(i).imp_xml_element_id,
5400: x_child_set => l_loc_record_in_tbl,
5401: x_return_status => x_return_status,
5402: x_msg_data => x_msg_data);

Line 5410: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5411: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5412: x_child_set => l_pho_record_in_tbl,
5413: x_return_status => x_return_status,
5414: x_msg_data => x_msg_data);

Line 5424: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5420: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5421: end if;
5422: END LOOP; -- FOR PHONE
5423: -- FOR EMAIL
5424: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5425: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5426: x_child_set => l_eml_record_in_tbl,
5427: x_return_status => x_return_status,
5428: x_msg_data => x_msg_data);