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 16026: l_orgid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;

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

Line 16028: l_perid_data_in_tbl AMS_IMPORT_XML_PVT.xml_element_key_set_type;

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

Line 16050: AMS_IMPORT_XML_PVT.Get_Root_Node (

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

Line 16060: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16095: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16174: l_orgid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16175: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16176: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16177: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16178: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16179: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16180: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16181: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16182: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 16187: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16300: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16307: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16456: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16463: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16661: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16668: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16870: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 16877: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 17123: l_perid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17124: l_locid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17125: l_addid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17126: l_octid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17127: l_conid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17128: l_phoid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17129: l_phiid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17130: l_emaid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17131: l_emlid_record_in_tbl AMS_IMPORT_XML_PVT.xml_element_set_type;

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

Line 17136: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 17208: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 17215: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 17333: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 17340: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 17462: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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

Line 17469: AMS_IMPORT_XML_PVT.Get_Children_Nodes (

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