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_IMPORT_XML_PVT

Line 296: p_search_tbl IN AMS_IMPORT_XML_PVT.xml_element_set_type)

292: --
293: -- This function returns the value for the element.
294: --
295: FUNCTION Get_Element_VALUE (p_column_name IN VARCHAR2,
296: p_search_tbl IN AMS_IMPORT_XML_PVT.xml_element_set_type)
297: RETURN VARCHAR2
298: IS
299: x_element_id NUMBER;
300: x_value VARCHAR2(2000) := null;

Line 317: p_search_tbl IN AMS_IMPORT_XML_PVT.xml_element_set_type)

313: --
314: -- This function returns the id for the element.
315: --
316: FUNCTION Get_Element_ID (p_column_name IN VARCHAR2,
317: p_search_tbl IN AMS_IMPORT_XML_PVT.xml_element_set_type)
318: RETURN NUMBER
319: IS
320: x_element_id NUMBER;
321: x_value VARCHAR2(2000);

Line 16025: l_orgid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;

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

Line 16027: l_perid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;

16023: root_node_rec_type AMS_IMP_XML_ELEMENTS%ROWTYPE;
16024: l_child_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
16025: l_orgid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;
16026:
16027: l_perid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;
16028:
16029: l_cust_b2b_tbl cust_data_in_tbl;
16030: l_cust_b2c_tbl cust_b2c_data_in_tbl;
16031: l_cust_b2b_rec data_in_rec_type;

Line 16049: AMS_IMPORT_XML_PVT.Get_Root_Node (

16045:
16046:
16047: /********* Get the Root Node *****************************/
16048:
16049: AMS_IMPORT_XML_PVT.Get_Root_Node (
16050: p_import_list_header_id => p_import_list_header_id,
16051: x_node_rec => root_node_rec_type,
16052: x_return_status => x_return_status,
16053: x_msg_data => x_msg_data);

Line 16059: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16055: -- dbms_output.put_line( ' Root Id '||root_node_rec_type.IMP_XML_ELEMENT_ID);
16056: IF l_b2b_flag = 'Y' then
16057: /********* Get all the Organizations for the Root Node *****************************/
16058:
16059: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16060: p_imp_xml_element_id => root_node_rec_type.IMP_XML_ELEMENT_ID,
16061: x_child_ids => l_orgid_data_in_tbl,
16062: x_return_status => x_return_status,
16063: x_msg_data => x_msg_data);

Line 16094: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16090:
16091: IF l_b2b_flag = 'N' then
16092: /********* Get all the Persons for the Root Node *****************************/
16093:
16094: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16095: p_imp_xml_element_id => root_node_rec_type.IMP_XML_ELEMENT_ID,
16096: x_child_ids => l_perid_data_in_tbl,
16097: x_return_status => x_return_status,
16098: x_msg_data => x_msg_data);

Line 16173: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16169: telex_rec hz_contact_point_v2pub.telex_rec_type;
16170: web_rec hz_contact_point_v2pub.web_rec_type;
16171:
16172:
16173: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16174: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 16174: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16170: web_rec hz_contact_point_v2pub.web_rec_type;
16171:
16172:
16173: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16174: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16171:
16172:
16173: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16174: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16172:
16173: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16174: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16180: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16173: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16174: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16180: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16181: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16174: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16180: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16181: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16182: l_customer_tbl cust_data_in_tbl;

Line 16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16175: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16180: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16181: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16182: l_customer_tbl cust_data_in_tbl;
16183:

Line 16180: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16176: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16180: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16181: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16182: l_customer_tbl cust_data_in_tbl;
16183:
16184: begin

Line 16181: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

16177: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16178: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16179: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16180: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16181: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
16182: l_customer_tbl cust_data_in_tbl;
16183:
16184: begin
16185: /********* Get all the elements for the Organizations *****************************/

Line 16186: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16182: l_customer_tbl cust_data_in_tbl;
16183:
16184: begin
16185: /********* Get all the elements for the Organizations *****************************/
16186: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16187: p_imp_xml_element_id => p_xml_element_id,
16188: x_child_set => l_orgid_record_in_tbl,
16189: x_return_status => x_return_status,
16190: x_msg_data => x_msg_data);

Line 16299: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16295: l_loc_element_id := Get_Element_ID('LOCATION',l_orgid_record_in_tbl);
16296: -- dbms_output.put_line( ' l_loc_element_id = '||to_char(l_loc_element_id));
16297:
16298: /********* Get all the elements for the location *****************************/
16299: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16300: p_imp_xml_element_id => l_loc_element_id,
16301: x_child_set => l_locid_record_in_tbl,
16302: x_return_status => x_return_status,
16303: x_msg_data => x_msg_data);

Line 16306: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16302: x_return_status => x_return_status,
16303: x_msg_data => x_msg_data);
16304: -- dbms_output.put_line( ' Location attribute count '||l_locid_record_in_tbl.COUNT);
16305: FOR i IN 1..l_locid_record_in_tbl.COUNT LOOP
16306: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16307: p_imp_xml_element_id => l_locid_record_in_tbl(i).imp_xml_element_id,
16308: x_child_set => l_addid_record_in_tbl,
16309: x_return_status => x_return_status,
16310: x_msg_data => x_msg_data);

Line 16455: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16451: l_oct_element_id := Get_Element_ID('ORG_CONTACT',l_addid_record_in_tbl);
16452: -- dbms_output.put_line( ' l_oct_element_id = '||to_char(l_oct_element_id));
16453:
16454: /********* Get all the elements for Org Contact *****************************/
16455: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16456: p_imp_xml_element_id => l_oct_element_id,
16457: x_child_set => l_octid_record_in_tbl,
16458: x_return_status => x_return_status,
16459: x_msg_data => x_msg_data);

Line 16462: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16458: x_return_status => x_return_status,
16459: x_msg_data => x_msg_data);
16460: -- dbms_output.put_line( ' Org Con attribute count '||l_octid_record_in_tbl.COUNT);
16461: FOR j IN 1..l_octid_record_in_tbl.COUNT LOOP
16462: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16463: p_imp_xml_element_id => l_octid_record_in_tbl(j).imp_xml_element_id,
16464: x_child_set => l_conid_record_in_tbl,
16465: x_return_status => x_return_status,
16466: x_msg_data => x_msg_data);

Line 16660: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16656: l_pho_element_id := Get_Element_ID('PHONE',l_conid_record_in_tbl);
16657: -- dbms_output.put_line( ' l_pho_element_id = '||to_char(l_pho_element_id));
16658:
16659: /********* Get all the elements for phone *****************************/
16660: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16661: p_imp_xml_element_id => l_pho_element_id,
16662: x_child_set => l_phoid_record_in_tbl,
16663: x_return_status => x_return_status,
16664: x_msg_data => x_msg_data);

Line 16667: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16663: x_return_status => x_return_status,
16664: x_msg_data => x_msg_data);
16665: -- dbms_output.put_line( ' Phone attribute count '||l_phoid_record_in_tbl.COUNT);
16666: FOR k IN 1..l_phoid_record_in_tbl.COUNT LOOP
16667: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16668: p_imp_xml_element_id => l_phoid_record_in_tbl(k).imp_xml_element_id,
16669: x_child_set => l_phiid_record_in_tbl,
16670: x_return_status => x_return_status,
16671: x_msg_data => x_msg_data);

Line 16869: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16865: l_ema_element_id := Get_Element_ID('EMAIL',l_conid_record_in_tbl);
16866: -- dbms_output.put_line( ' l_ema_element_id = '||to_char(l_ema_element_id));
16867:
16868: /********* Get all the elements for email *****************************/
16869: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16870: p_imp_xml_element_id => l_ema_element_id,
16871: x_child_set => l_emaid_record_in_tbl,
16872: x_return_status => x_return_status,
16873: x_msg_data => x_msg_data);

Line 16876: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

16872: x_return_status => x_return_status,
16873: x_msg_data => x_msg_data);
16874: -- dbms_output.put_line( ' attributl email count '||l_emaid_record_in_tbl.COUNT);
16875: FOR l IN 1..l_emaid_record_in_tbl.COUNT LOOP
16876: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
16877: p_imp_xml_element_id => l_emaid_record_in_tbl(l).imp_xml_element_id,
16878: x_child_set => l_emlid_record_in_tbl,
16879: x_return_status => x_return_status,
16880: x_msg_data => x_msg_data);

Line 17122: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17118: edi_rec hz_contact_point_v2pub.edi_rec_type;
17119: telex_rec hz_contact_point_v2pub.telex_rec_type;
17120: web_rec hz_contact_point_v2pub.web_rec_type;
17121:
17122: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17123: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17123: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17119: telex_rec hz_contact_point_v2pub.telex_rec_type;
17120: web_rec hz_contact_point_v2pub.web_rec_type;
17121:
17122: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17123: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17120: web_rec hz_contact_point_v2pub.web_rec_type;
17121:
17122: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17123: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17121:
17122: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17123: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17129: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17122: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17123: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17129: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17130: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

Line 17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17123: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17129: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17130: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17131: l_customer_tbl cust_b2c_data_in_tbl;

Line 17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17124: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17129: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17130: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17131: l_customer_tbl cust_b2c_data_in_tbl;
17132:

Line 17129: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17125: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17129: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17130: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17131: l_customer_tbl cust_b2c_data_in_tbl;
17132:
17133: begin

Line 17130: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

17126: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17127: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17128: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17129: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17130: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;
17131: l_customer_tbl cust_b2c_data_in_tbl;
17132:
17133: begin
17134: /********* Get all the elements for the Person *****************************/

Line 17135: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

17131: l_customer_tbl cust_b2c_data_in_tbl;
17132:
17133: begin
17134: /********* Get all the elements for the Person *****************************/
17135: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
17136: p_imp_xml_element_id => p_xml_element_id,
17137: x_child_set => l_perid_record_in_tbl,
17138: x_return_status => x_return_status,
17139: x_msg_data => x_msg_data);

Line 17207: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

17203: l_loc_element_id := Get_Element_ID('LOCATION',l_perid_record_in_tbl);
17204: -- dbms_output.put_line( ' l_loc_element_id = '||to_char(l_loc_element_id));
17205:
17206: /********* Get all the elements for the location *****************************/
17207: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
17208: p_imp_xml_element_id => l_loc_element_id,
17209: x_child_set => l_locid_record_in_tbl,
17210: x_return_status => x_return_status,
17211: x_msg_data => x_msg_data);

Line 17214: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

17210: x_return_status => x_return_status,
17211: x_msg_data => x_msg_data);
17212: -- dbms_output.put_line( ' Location attribute count '||l_locid_record_in_tbl.COUNT);
17213: FOR i IN 1..l_locid_record_in_tbl.COUNT LOOP
17214: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
17215: p_imp_xml_element_id => l_locid_record_in_tbl(i).imp_xml_element_id,
17216: x_child_set => l_addid_record_in_tbl,
17217: x_return_status => x_return_status,
17218: x_msg_data => x_msg_data);

Line 17332: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

17328: l_pho_element_id := Get_Element_ID('PHONE',l_addid_record_in_tbl);
17329: -- dbms_output.put_line( ' l_pho_element_id = '||to_char(l_pho_element_id));
17330:
17331: /********* Get all the elements for phone *****************************/
17332: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
17333: p_imp_xml_element_id => l_pho_element_id,
17334: x_child_set => l_phoid_record_in_tbl,
17335: x_return_status => x_return_status,
17336: x_msg_data => x_msg_data);

Line 17339: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

17335: x_return_status => x_return_status,
17336: x_msg_data => x_msg_data);
17337: -- dbms_output.put_line( ' Phone attribute count '||l_phoid_record_in_tbl.COUNT);
17338: FOR k IN 1..l_phoid_record_in_tbl.COUNT LOOP
17339: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
17340: p_imp_xml_element_id => l_phoid_record_in_tbl(k).imp_xml_element_id,
17341: x_child_set => l_phiid_record_in_tbl,
17342: x_return_status => x_return_status,
17343: x_msg_data => x_msg_data);

Line 17461: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

17457: l_ema_element_id := Get_Element_ID('EMAIL',l_addid_record_in_tbl);
17458: -- dbms_output.put_line( ' l_ema_element_id = '||to_char(l_ema_element_id));
17459:
17460: /********* Get all the elements for email *****************************/
17461: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
17462: p_imp_xml_element_id => l_ema_element_id,
17463: x_child_set => l_emaid_record_in_tbl,
17464: x_return_status => x_return_status,
17465: x_msg_data => x_msg_data);

Line 17468: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

17464: x_return_status => x_return_status,
17465: x_msg_data => x_msg_data);
17466: -- dbms_output.put_line( ' attributl email count '||l_emaid_record_in_tbl.COUNT);
17467: FOR l IN 1..l_emaid_record_in_tbl.COUNT LOOP
17468: AMS_IMPORT_XML_PVT.Get_Children_Nodes (
17469: p_imp_xml_element_id => l_emaid_record_in_tbl(l).imp_xml_element_id,
17470: x_child_set => l_emlid_record_in_tbl,
17471: x_return_status => x_return_status,
17472: x_msg_data => x_msg_data);