APPS.M4U_XML_EXTN_UTILS dependencies on M4U_ELEMENT_MAPPINGS

Line 568: -- Load data from m4u_element_mappings for

564: handle_exception(SQLCODE,SQLERRM,l_progress,'m4u_xml_extn_utils.init_hdr',
565: x_ret_sts,x_ret_msg);
566: END init_hdr;
567:
568: -- Load data from m4u_element_mappings for
569: -- given extn, tp_id
570: -- store level in g_elmnt_tab index by level-id
571: PROCEDURE load_elmnt_mapping(
572: x_ret_sts OUT NOCOPY VARCHAR2,

Line 585: FROM m4u_element_mappings

581: SELECT node_id, node_sequence, node_name, UPPER(TRIM(node_type)),
582: level_id, parent_node_id, UPPER(TRIM(mapping_type)),
583: UPPER(TRIM(view_name)), UPPER(TRIM(column_name)), view_level_id,
584: UPPER(TRIM(variable_name)), constant_val
585: FROM m4u_element_mappings
586: WHERE extn_name = a_extn_name
587: AND NVL(trading_partner_id,'@@') = NVL(a_tp_id,'@@')
588: AND ignore_mapping <> 'Y'
589: ORDER BY node_sequence ASC;

Line 592: l_progress := 'Loading m4u_element_mappings';

588: AND ignore_mapping <> 'Y'
589: ORDER BY node_sequence ASC;
590: l_progress VARCHAR2(4000);
591: BEGIN
592: l_progress := 'Loading m4u_element_mappings';
593: IF g_log_lvl <= 2 THEN
594: cln_debug_pub.add('Entering m4u_xml_extn_utils.load_elmnt_mapping',2);
595: END IF;
596:

Line 685: FROM m4u_element_mappings

681: CURSOR l_cur_lvls(a_extn_name IN VARCHAR2,
682: a_tp_id IN VARCHAR2)
683: IS
684: SELECT DISTINCT level_id
685: FROM m4u_element_mappings
686: WHERE extn_name = a_extn_name
687: AND NVL(trading_partner_id,'@@') = NVL(a_tp_id,'@@');
688: l_progress VARCHAR2(4000);
689: BEGIN

Line 907: FROM m4u_element_mappings

903: a_view_nam IN VARCHAR2
904: )
905: IS
906: SELECT DISTINCT UPPER(TRIM(column_name)) col
907: FROM m4u_element_mappings
908: WHERE extn_name = a_extn_name AND NVL(trading_partner_id,'@@') = a_tp_id
909: AND view_level_id = a_lvl_id AND view_name = a_view_nam
910: AND TRIM(column_name) IS NOT NULL
911: UNION

Line 919: l_col_nam m4u_element_mappings.column_name%TYPE;

915: AND source_level_id = a_lvl_id AND source_view = a_view_nam
916: AND TRIM(source_column) IS NOT NULL;
917:
918:
919: l_col_nam m4u_element_mappings.column_name%TYPE;
920: i NUMBER;
921: l_progress VARCHAR2(4000);
922: BEGIN
923: l_progress := 'Load columns for view sequels';

Line 1156: -- 2. element mapping from m4u_element_mappings

1152: END load_global_var;
1153:
1154: -- init map
1155: -- 1. load header info from m4u_xml_extensions
1156: -- 2. element mapping from m4u_element_mappings
1157: -- 3. level-ids from m4u_element_mappings
1158: -- 4. views for each level
1159: -- 5. columns for each view
1160: -- 6. bind variable and mapping info for each view

Line 1157: -- 3. level-ids from m4u_element_mappings

1153:
1154: -- init map
1155: -- 1. load header info from m4u_xml_extensions
1156: -- 2. element mapping from m4u_element_mappings
1157: -- 3. level-ids from m4u_element_mappings
1158: -- 4. views for each level
1159: -- 5. columns for each view
1160: -- 6. bind variable and mapping info for each view
1161: PROCEDURE init_map(a_extn_name IN VARCHAR2,

Line 1197: l_progress := 'Read from m4u_element_mappings';

1193: cln_debug_pub.add('x_ret_msg - ' || x_ret_msg, 1);
1194: END IF;
1195:
1196: -- load element mapping
1197: l_progress := 'Read from m4u_element_mappings';
1198: IF x_ret_sts = g_success_code THEN
1199: load_elmnt_mapping(x_ret_sts,x_ret_msg);
1200: IF g_log_lvl <= 1 THEN
1201: cln_debug_pub.add('Returned from m4u_xml_extn_utils.load_elmnt_mapping',1);