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.

[Home] [Help]

APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_IMPORT_XML_PVT

Line 5089: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5085: x_return_status VARCHAR2(1);
5086: x_msg_data VARCHAR2(2000);
5087: l_imp_type VARCHAR2(30);
5088:
5089: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5090: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5091: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5092: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5090: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5086: x_msg_data VARCHAR2(2000);
5087: l_imp_type VARCHAR2(30);
5088:
5089: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5090: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5091: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5092: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5094: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5091: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5087: l_imp_type VARCHAR2(30);
5088:
5089: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5090: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5091: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5092: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5094: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5095:

Line 5092: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5088:
5089: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5090: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5091: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5092: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5094: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5095:
5096: cursor c_imp_type is

Line 5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5089: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5090: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5091: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5092: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5094: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5095:
5096: cursor c_imp_type is
5097: select import_type from ams_imp_list_headers_all

Line 5094: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5090: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5091: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5092: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5093: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5094: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5095:
5096: cursor c_imp_type is
5097: select import_type from ams_imp_list_headers_all
5098: where import_list_header_id = p_import_list_header_id;

Line 5109: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5111: x_child_set => l_org_record_in_tbl,
5112: x_return_status => x_return_status,
5113: x_msg_data => x_msg_data);

Line 5122: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5123: p_imp_xml_element_id => l_org_record_in_tbl(i).imp_xml_element_id,
5124: x_child_set => l_loc_record_in_tbl,
5125: x_return_status => x_return_status,
5126: x_msg_data => x_msg_data);

Line 5134: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5135: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5136: x_child_set => l_con_record_in_tbl,
5137: x_return_status => x_return_status,
5138: x_msg_data => x_msg_data);

Line 5146: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5147: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5148: x_child_set => l_pho_record_in_tbl,
5149: x_return_status => x_return_status,
5150: x_msg_data => x_msg_data);

Line 5160: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5156: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5157: end if;
5158: END LOOP; -- FOR PHONE
5159: -- FOR EMAIL
5160: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5161: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5162: x_child_set => l_eml_record_in_tbl,
5163: x_return_status => x_return_status,
5164: x_msg_data => x_msg_data);

Line 5186: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5188: x_child_set => l_per_record_in_tbl,
5189: x_return_status => x_return_status,
5190: x_msg_data => x_msg_data);

Line 5199: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5200: p_imp_xml_element_id => l_per_record_in_tbl(i).imp_xml_element_id,
5201: x_child_set => l_loc_record_in_tbl,
5202: x_return_status => x_return_status,
5203: x_msg_data => x_msg_data);

Line 5211: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5212: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5213: x_child_set => l_pho_record_in_tbl,
5214: x_return_status => x_return_status,
5215: x_msg_data => x_msg_data);

Line 5225: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5221: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5222: end if;
5223: END LOOP; -- FOR PHONE
5224: -- FOR EMAIL
5225: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5226: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5227: x_child_set => l_eml_record_in_tbl,
5228: x_return_status => x_return_status,
5229: x_msg_data => x_msg_data);

Line 5272: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5268: x_return_status VARCHAR2(1);
5269: x_msg_data VARCHAR2(2000);
5270: l_imp_type VARCHAR2(30);
5271:
5272: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5273: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5274: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5275: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5273: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5269: x_msg_data VARCHAR2(2000);
5270: l_imp_type VARCHAR2(30);
5271:
5272: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5273: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5274: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5275: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5277: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 5274: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5270: l_imp_type VARCHAR2(30);
5271:
5272: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5273: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5274: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5275: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5277: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5278:

Line 5275: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5271:
5272: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5273: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5274: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5275: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5277: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5278:
5279: cursor c_imp_type is

Line 5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5272: l_per_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5273: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5274: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5275: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5277: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5278:
5279: cursor c_imp_type is
5280: select import_type from ams_imp_list_headers_all

Line 5277: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

5273: l_org_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5274: l_loc_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5275: l_con_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5276: l_pho_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5277: l_eml_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
5278:
5279: cursor c_imp_type is
5280: select import_type from ams_imp_list_headers_all
5281: where import_list_header_id = p_import_list_header_id;

Line 5301: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5303: x_child_set => l_org_record_in_tbl,
5304: x_return_status => x_return_status,
5305: x_msg_data => x_msg_data);

Line 5314: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5315: p_imp_xml_element_id => l_org_record_in_tbl(i).imp_xml_element_id,
5316: x_child_set => l_loc_record_in_tbl,
5317: x_return_status => x_return_status,
5318: x_msg_data => x_msg_data);

Line 5326: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5327: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5328: x_child_set => l_con_record_in_tbl,
5329: x_return_status => x_return_status,
5330: x_msg_data => x_msg_data);

Line 5338: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5339: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5340: x_child_set => l_pho_record_in_tbl,
5341: x_return_status => x_return_status,
5342: x_msg_data => x_msg_data);

Line 5352: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5348: where imp_xml_element_id = l_pho_record_in_tbl(l).imp_xml_element_id;
5349: end if;
5350: END LOOP; -- FOR PHONE
5351: -- FOR EMAIL
5352: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5353: p_imp_xml_element_id => l_con_record_in_tbl(k).imp_xml_element_id,
5354: x_child_set => l_eml_record_in_tbl,
5355: x_return_status => x_return_status,
5356: x_msg_data => x_msg_data);

Line 5378: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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,
5380: x_child_set => l_per_record_in_tbl,
5381: x_return_status => x_return_status,
5382: x_msg_data => x_msg_data);

Line 5391: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5392: p_imp_xml_element_id => l_per_record_in_tbl(i).imp_xml_element_id,
5393: x_child_set => l_loc_record_in_tbl,
5394: x_return_status => x_return_status,
5395: x_msg_data => x_msg_data);

Line 5403: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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 (
5404: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5405: x_child_set => l_pho_record_in_tbl,
5406: x_return_status => x_return_status,
5407: x_msg_data => x_msg_data);

Line 5417: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

5413: where imp_xml_element_id = l_pho_record_in_tbl(k).imp_xml_element_id;
5414: end if;
5415: END LOOP; -- FOR PHONE
5416: -- FOR EMAIL
5417: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
5418: p_imp_xml_element_id => l_loc_record_in_tbl(j).imp_xml_element_id,
5419: x_child_set => l_eml_record_in_tbl,
5420: x_return_status => x_return_status,
5421: x_msg_data => x_msg_data);