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.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FEM_INTG_DIM_HIER_GT

Line 272: -- Population of pv_traversal_rarray - dispaly_order will overload the fem_intg_dim_hier_gt.hier_obj_def_id

268: AND d.dimension_id = dr.dimension_id;
269: if pv_traversal_rarray.count > 0 then
270: pv_traversal_rarray.DELETE;
271: end if;
272: -- Population of pv_traversal_rarray - dispaly_order will overload the fem_intg_dim_hier_gt.hier_obj_def_id
273: -- as ID for temporary component hierarchy
274: FOR v_traversal_info in c_traversal_info LOOP
275: l_rec.display_order := v_traversal_info.display_order_num;
276: l_rec.top_parent_value := v_traversal_info.top_parent_value;

Line 512: INSERT INTO fem_intg_dim_hier_gt

508: ' pv_top_parent_id:' || pv_top_parent_id ||
509: ' pv_top_parent_disp_code:' || pv_top_parent_disp_code);
510:
511: -- Insert self mapping record for hierarchy top node into the _GT table
512: INSERT INTO fem_intg_dim_hier_gt
513: (hierarchy_obj_def_id,
514: parent_depth_num,
515: parent_id,
516: parent_display_code,

Line 620: 'INSERT INTO fem_intg_dim_hier_gt

616: ' v_parent_level:' || v_parent_level ||
617: ' pv_dim_vs_id:' || pv_dim_vs_id);
618: -- Insert immediate children for each parent into the _GT table
619: v_sql_stmt :=
620: 'INSERT INTO fem_intg_dim_hier_gt
621: (hierarchy_obj_def_id,
622: parent_depth_num,
623: parent_id,
624: parent_display_code,

Line 641: FROM fem_intg_dim_hier_gt gt,

637: ff.flex_value,
638: ''Y'',
639: -1,
640: :v_dimension_group_id
641: FROM fem_intg_dim_hier_gt gt,
642: fnd_flex_value_norm_hierarchy vh,
643: fnd_flex_values ff
644: WHERE gt.child_depth_num = :v_parent_level
645: AND vh.flex_value_set_id = :pv_aol_vs_id

Line 683: 'UPDATE fem_intg_dim_hier_gt

679: ' x_row_count_tot:' || x_row_count_tot);
680: -- update the display_order num. Not handled in above insert statement
681: -- because the distinct not allowed with nextval.
682: v_sql_stmt :=
683: 'UPDATE fem_intg_dim_hier_gt
684: SET display_order_num = '||v_seq_name||'.nextval
685: WHERE rowid in
686: (select rowid
687: from fem_intg_dim_hier_gt)

Line 687: from fem_intg_dim_hier_gt)

683: 'UPDATE fem_intg_dim_hier_gt
684: SET display_order_num = '||v_seq_name||'.nextval
685: WHERE rowid in
686: (select rowid
687: from fem_intg_dim_hier_gt)
688: AND display_order_num = -1';
689:
690:
691: FEM_ENGINES_PKG.Tech_Message

Line 844: 'INSERT INTO fem_intg_dim_hier_gt

840:
841: -- insert all bottom level detail children
842: --dedutta : 5035567 : introduced the bind variable dgid
843: v_sql_stmt :=
844: 'INSERT INTO fem_intg_dim_hier_gt
845: (hierarchy_obj_def_id,
846: parent_depth_num,
847: parent_id,
848: parent_display_code,

Line 866: FROM fem_intg_dim_hier_gt gt,

862: m.'||pv_dim_memb_disp_col||',
863: ''Y'',
864: -1,
865: :dgid
866: FROM fem_intg_dim_hier_gt gt,
867: fnd_flex_value_norm_hierarchy vh,
868: '||pv_dim_memb_b_tab||' m
869: WHERE vh.flex_value_set_id = '||pv_aol_vs_id||'
870: AND vh.parent_flex_value = gt.child_display_code

Line 877: FROM fem_intg_dim_hier_gt inner_gt)

873: AND m.'||pv_dim_memb_disp_col||'
874: BETWEEN vh.child_flex_value_low AND vh.child_flex_value_high
875: AND m.'||pv_dim_memb_col||' NOT IN
876: (SELECT inner_gt.child_id
877: FROM fem_intg_dim_hier_gt inner_gt)
878: AND m.'||pv_dim_memb_col||' NOT IN
879: (SELECT mh.parent_id
880: FROM '||pv_dim_hier_tab||' mh,
881: fem_object_definition_b odb,

Line 909: 'UPDATE fem_intg_dim_hier_gt

905: COMMIT;
906: -- update the display_order num. Not handled in above insert statement
907: -- because the distinct not allowed with nextval.
908: v_sql_stmt :=
909: 'UPDATE fem_intg_dim_hier_gt
910: SET display_order_num = '||v_seq_name||'.nextval
911: WHERE rowid in
912: (select rowid
913: from fem_intg_dim_hier_gt)

Line 913: from fem_intg_dim_hier_gt)

909: 'UPDATE fem_intg_dim_hier_gt
910: SET display_order_num = '||v_seq_name||'.nextval
911: WHERE rowid in
912: (select rowid
913: from fem_intg_dim_hier_gt)
914: AND display_order_num = -1';
915: FEM_ENGINES_PKG.Tech_Message
916: (p_severity => pc_log_level_procedure,
917: p_module => 'fem.plsql.fem_intg_hier_eng.Bld_Hier_Single_Segment.seq.nextval',

Line 1019: -- Populates the fem_intg_dim_hier_gt table with each single segement

1015: -- ======================================================================
1016: -- Procedure
1017: -- Bld_Component_Hiers
1018: -- Purpose
1019: -- Populates the fem_intg_dim_hier_gt table with each single segement
1020: -- hierarchy to be used as base components for to build the
1021: -- mult segment concatenatned hierarchy.
1022: -- The selected Multi Segment hierarchy rule is the driving defintion.
1023: -- Uses PL/SQL table tr_hier_traversal to do this.

Line 1699: INSERT INTO fem_intg_dim_hier_gt

1695: The varing items are:
1696: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name
1697: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name
1698: FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).id_col_name
1699: INSERT INTO fem_intg_dim_hier_gt
1700: (hierarchy_obj_def_id,
1701: parent_depth_num,
1702: parent_id,
1703: parent_display_code,

Line 1720: FROM fem_intg_dim_hier_gt gt,

1716: MEANING,
1717: 'Y',
1718: -1,
1719: 'Y'
1720: FROM fem_intg_dim_hier_gt gt,
1721: FND_LOOKUPS,
1722: fnd_flex_value_norm_hierarchy vh
1723: WHERE FND_LOOKUPS.LOOKUP_TYPE = 'YES_NO'
1724: AND vh.flex_value_set_id = 1002723

Line 1992: commit; -- one component hier has been built to fem_intg_dim_hier_gt

1988: RAISE FEM_INTG_fatal_err;
1989: END IF;
1990:
1991: i_hier_ctr := pv_traversal_rarray.next(i_hier_ctr);
1992: commit; -- one component hier has been built to fem_intg_dim_hier_gt
1993:
1994: END loop; -- Main Loop for traversing each component hierarchy
1995:
1996: x_completion_code := 0;

Line 2129: update FEM_INTG_DIM_HIER_GT

2125: p_value1 => 'FEM_INTG_HIER_RULE_ENG_PKG.Bld_Hier_Multi_Segment',
2126: p_token2 => 'TIME',
2127: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2128: -- trim the display codes to 15 chars
2129: update FEM_INTG_DIM_HIER_GT
2130: set child_display_code = substr(child_display_code, 1, pc_max_disp_len)
2131: , parent_display_code = substr(parent_display_code, 1, pc_max_disp_len);
2132: -- create a pl/sql table that holds the segments in concatenations order
2133: v_concat_rarray.extend(pv_traversal_rarray.count);

Line 2143: INSERT INTO FEM_INTG_DIM_HIER_GT

2139: end loop;
2140: -- create dynamic SQL to insert the leaf nodes
2141: /*
2142: Sample SQL stmt :
2143: INSERT INTO FEM_INTG_DIM_HIER_GT
2144: (HIERARCHY_OBJ_DEF_ID
2145: , child_display_code
2146: , child_id
2147: , parent_display_code

Line 2167: FEM_INTG_DIM_HIER_GT gt1

2163: , 'Y'
2164: , 'N'
2165: , -1
2166: from
2167: FEM_INTG_DIM_HIER_GT gt1
2168: , FEM_INTG_DIM_HIER_GT gt2
2169: , FEM_INTG_DIM_HIER_GT gt3
2170: , FEM_INTG_DIM_HIER_GT gt4
2171: , FEM_INTG_DIM_HIER_GT gt5

Line 2168: , FEM_INTG_DIM_HIER_GT gt2

2164: , 'N'
2165: , -1
2166: from
2167: FEM_INTG_DIM_HIER_GT gt1
2168: , FEM_INTG_DIM_HIER_GT gt2
2169: , FEM_INTG_DIM_HIER_GT gt3
2170: , FEM_INTG_DIM_HIER_GT gt4
2171: , FEM_INTG_DIM_HIER_GT gt5
2172: , FEM_CUSTOMERS_B b

Line 2169: , FEM_INTG_DIM_HIER_GT gt3

2165: , -1
2166: from
2167: FEM_INTG_DIM_HIER_GT gt1
2168: , FEM_INTG_DIM_HIER_GT gt2
2169: , FEM_INTG_DIM_HIER_GT gt3
2170: , FEM_INTG_DIM_HIER_GT gt4
2171: , FEM_INTG_DIM_HIER_GT gt5
2172: , FEM_CUSTOMERS_B b
2173: WHERE gt1.hierarchy_obj_def_id = 1

Line 2170: , FEM_INTG_DIM_HIER_GT gt4

2166: from
2167: FEM_INTG_DIM_HIER_GT gt1
2168: , FEM_INTG_DIM_HIER_GT gt2
2169: , FEM_INTG_DIM_HIER_GT gt3
2170: , FEM_INTG_DIM_HIER_GT gt4
2171: , FEM_INTG_DIM_HIER_GT gt5
2172: , FEM_CUSTOMERS_B b
2173: WHERE gt1.hierarchy_obj_def_id = 1
2174: and gt1.child_leaf_flag = 'Y'

Line 2171: , FEM_INTG_DIM_HIER_GT gt5

2167: FEM_INTG_DIM_HIER_GT gt1
2168: , FEM_INTG_DIM_HIER_GT gt2
2169: , FEM_INTG_DIM_HIER_GT gt3
2170: , FEM_INTG_DIM_HIER_GT gt4
2171: , FEM_INTG_DIM_HIER_GT gt5
2172: , FEM_CUSTOMERS_B b
2173: WHERE gt1.hierarchy_obj_def_id = 1
2174: and gt1.child_leaf_flag = 'Y'
2175: and gt2.hierarchy_obj_def_id = 2

Line 2186: v_sql := 'INSERT INTO FEM_INTG_DIM_HIER_GT

2182: and gt5.child_leaf_flag = 'Y'
2183: and b.CUSTOMER_DISPLAY_CODE = gt1.child_display_code || '-' || gt2.child_display_code || '-' || gt3.child_display_code || '-' || gt4.child_display_code || '-' || gt5.child_display_code
2184: and b.value_set_id = :pv_aol_vs_id)
2185: */
2186: v_sql := 'INSERT INTO FEM_INTG_DIM_HIER_GT
2187: (HIERARCHY_OBJ_DEF_ID
2188: , child_display_code
2189: , child_id
2190: , parent_display_code

Line 2262: -- construct sql for : FROM FEM_INTG_DIM_HIER_GT gt1, FEM_INTG_DIM_HIER_GT gt2, fem_cctr_orgs_b b

2258: , ''N''
2259: , -1
2260: from ';
2261:
2262: -- construct sql for : FROM FEM_INTG_DIM_HIER_GT gt1, FEM_INTG_DIM_HIER_GT gt2, fem_cctr_orgs_b b
2263: v_counter := pv_traversal_rarray.first;
2264: while v_counter is not null
2265: loop
2266: v_sql := v_sql || 'FEM_INTG_DIM_HIER_C' || v_counter || '_GT gt' || v_counter;

Line 2304: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;

2300: -- the final )
2301: v_sql := v_sql || ')';
2302:
2303: -- execute the SQL to insert the leaf nodes
2304: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;
2305:
2306: FEM_ENGINES_PKG.Tech_Message(
2307: p_severity => pc_log_level_statement,
2308: p_module => 'fem.plsql.Bld_Hier_Multi_Segment1',

Line 2321: INSERT INTO FEM_INTG_DIM_HIER_GT

2317: loop
2318: loop
2319: /*
2320: Sample SQL stmt :
2321: INSERT INTO FEM_INTG_DIM_HIER_GT
2322: (HIERARCHY_OBJ_DEF_ID
2323: , child_display_code
2324: , child_id
2325: , parent_display_code

Line 2364: FEM_INTG_DIM_HIER_GT gtm

2360: , 'N'
2361: , -1
2362: --, 1
2363: FROM
2364: FEM_INTG_DIM_HIER_GT gtm
2365: , FEM_INTG_DIM_HIER_GT gts
2366: ------------ WHERE gtm.HIERARCHY_OBJ_DEF_ID = :pv_hier_obj_def_id
2367: ------------ AND gts.hierarchy_obj_def_id = :display_order
2368: ------------ AND gts.child_display_code =

Line 2365: , FEM_INTG_DIM_HIER_GT gts

2361: , -1
2362: --, 1
2363: FROM
2364: FEM_INTG_DIM_HIER_GT gtm
2365: , FEM_INTG_DIM_HIER_GT gts
2366: ------------ WHERE gtm.HIERARCHY_OBJ_DEF_ID = :pv_hier_obj_def_id
2367: ------------ AND gts.hierarchy_obj_def_id = :display_order
2368: ------------ AND gts.child_display_code =
2369: WHERE gts.child_display_code =

Line 2387: and not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code)

2383: ------------ after (one of the three)
2384:
2385:
2386: AND gts.child_display_code <> gts.parent_display_code
2387: and not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code)
2388: */
2389: v_sql := 'INSERT INTO FEM_INTG_DIM_HIER_GT
2390: (HIERARCHY_OBJ_DEF_ID
2391: , child_display_code

Line 2389: v_sql := 'INSERT INTO FEM_INTG_DIM_HIER_GT

2385:
2386: AND gts.child_display_code <> gts.parent_display_code
2387: and not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code)
2388: */
2389: v_sql := 'INSERT INTO FEM_INTG_DIM_HIER_GT
2390: (HIERARCHY_OBJ_DEF_ID
2391: , child_display_code
2392: , child_id
2393: , parent_display_code

Line 2426: FEM_INTG_DIM_HIER_GT gtm

2422: , ''N''
2423: , ''N''
2424: , -1
2425: FROM
2426: FEM_INTG_DIM_HIER_GT gtm
2427: , FEM_INTG_DIM_HIER_C' || pv_traversal_rarray(v_hier_counter).display_order || '_GT gts
2428: WHERE gts.child_display_code = ';
2429:
2430: IF v_hier_counter = v_concat_rarray(v_concat_rarray.first) THEN

Line 2447: and not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code))';

2443: END IF;
2444:
2445: v_sql := v_sql || '
2446: AND gts.child_display_code <> gts.parent_display_code
2447: and not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code))';
2448: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;
2449:
2450: FEM_ENGINES_PKG.Tech_Message(
2451: p_severity => pc_log_level_statement,

Line 2448: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;

2444:
2445: v_sql := v_sql || '
2446: AND gts.child_display_code <> gts.parent_display_code
2447: and not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code))';
2448: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;
2449:
2450: FEM_ENGINES_PKG.Tech_Message(
2451: p_severity => pc_log_level_statement,
2452: p_module => 'fem.plsql.Bld_Hier_Multi_Segment2',

Line 2458: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;

2454:
2455: execute immediate v_sql;
2456: v_counter := v_counter + 1;
2457: exit when SQL%ROWCOUNT = 0;
2458: select count(*) into v_debug from FEM_INTG_DIM_HIER_GT;
2459: end loop;
2460: v_hier_counter := pv_traversal_rarray.next(v_hier_counter);
2461: end loop;
2462: -- insert the SQL for the top member

Line 2463: INSERT INTO FEM_INTG_DIM_HIER_GT

2459: end loop;
2460: v_hier_counter := pv_traversal_rarray.next(v_hier_counter);
2461: end loop;
2462: -- insert the SQL for the top member
2463: INSERT INTO FEM_INTG_DIM_HIER_GT
2464: (HIERARCHY_OBJ_DEF_ID
2465: , child_display_code
2466: , child_id
2467: , parent_display_code

Line 2485: FROM FEM_INTG_DIM_HIER_GT gtm

2481: , gtm.parent_depth_num
2482: , 'N'
2483: , 'N'
2484: , -1
2485: FROM FEM_INTG_DIM_HIER_GT gtm
2486: WHERE not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code));
2487: -- Processing for creating level based hierarchies
2488: v_counter :=1;
2489: -- 17OCT2005 BUG 4681970

Line 2486: WHERE not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code));

2482: , 'N'
2483: , 'N'
2484: , -1
2485: FROM FEM_INTG_DIM_HIER_GT gtm
2486: WHERE not exists (select 1 from FEM_INTG_DIM_HIER_GT gte where gte.child_display_code = gtm.parent_display_code));
2487: -- Processing for creating level based hierarchies
2488: v_counter :=1;
2489: -- 17OCT2005 BUG 4681970
2490: -- CREATE sequence for display order

Line 2534: update fem_intg_dim_hier_gt

2530: END IF;
2531: -- insert the new level to fem_hier_dimension_grps
2532: -- 14OCT2005 b4652450 MOVED HERE WAS AFTER fem_hier_dimension_grps INSERT
2533: -- update the _GT table with the dimension_group_id
2534: update fem_intg_dim_hier_gt
2535: set dimension_group_id = v_dimension_group_id
2536: where child_depth_num = v_counter;
2537: if SQL%ROWCOUNT <= 0 then
2538: exit;

Line 2542: 'UPDATE fem_intg_dim_hier_gt

2538: exit;
2539: end if;
2540: -- 17OCT2005 BUG 4681970
2541: v_sql_stmt :=
2542: 'UPDATE fem_intg_dim_hier_gt
2543: SET display_order_num = '||v_seq_name||'.nextval
2544: WHERE child_depth_num = '||v_counter||' AND display_order_num = -1';
2545:
2546: FEM_ENGINES_PKG.Tech_Message(

Line 2597: v_sql := 'update FEM_INTG_DIM_HIER_GT gt

2593: THEN
2594: raise_application_error(-20001, fnd_message.get);
2595: END IF;
2596: -- update the hier GT table with the member_ids
2597: v_sql := 'update FEM_INTG_DIM_HIER_GT gt
2598: set gt.parent_id = (select distinct b1.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b1 ';
2599: v_sql := v_sql || ' where b1.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.parent_display_code and b1.VALUE_SET_ID = :pv_dim_vs_id)';
2600: v_sql := v_sql || ', gt.child_id = (select distinct b2.' || fem_intg_new_dim_member_pkg.pv_local_member_col || ' from ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' b2 ';
2601: v_sql := v_sql || ' where b2.' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_display_code_col || ' = gt.child_display_code and b2.VALUE_SET_ID = :pv_dim_vs_id)';

Line 2660: FROM fem_intg_dim_hier_gt gt

2656: v_parent_display_code VARCHAR2(150);
2657: v_offending_parents_list VARCHAR2(4000);
2658: CURSOR c_child_of_multi_parent IS
2659: SELECT gt.child_display_code
2660: FROM fem_intg_dim_hier_gt gt
2661: WHERE gt.parent_display_code <> gt.child_display_code
2662: and gt.hierarchy_obj_def_id = pv_hier_obj_def_id
2663: GROUP BY gt.child_display_code
2664: HAVING count(gt.child_display_code) > 1;

Line 2668: FROM fem_intg_dim_hier_gt gt

2664: HAVING count(gt.child_display_code) > 1;
2665:
2666: CURSOR c_multi_parent (p_child_display_code VARCHAR2) IS
2667: SELECT DISTINCT gt.parent_display_code
2668: FROM fem_intg_dim_hier_gt gt
2669: WHERE gt.parent_display_code <> gt.child_display_code
2670: and gt.hierarchy_obj_def_id = pv_hier_obj_def_id
2671: and gt.child_display_code = p_child_display_code;
2672: -- bug fix 4563603

Line 2692: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table

2688: -- 5. Check if any children within the hierarchy are assigned to
2689: -- multiple parents.
2690: -- 6. IF v_new_hier_obj_def_created = TRUE THEN
2691: -- Call INSERT statement to copy hierarchy structure from the
2692: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table
2693: -- ELSE
2694: -- Call DELETE statement to delete existing hierarchy structure
2695: -- for the hierarchy object definition.
2696: -- Call INSERT statement to copy hierarchy structure from the

Line 2697: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table

2693: -- ELSE
2694: -- Call DELETE statement to delete existing hierarchy structure
2695: -- for the hierarchy object definition.
2696: -- Call INSERT statement to copy hierarchy structure from the
2697: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table
2698: -- 7. Call routine FEM_INTG_PL_PKG.Final_Process_Logging( ) to complete
2699: -- final process logging. Message name to print will be
2700: -- FEM_INTG_PROC_SUCCESS and the number of output rows will be the
2701: -- return row count from the hierarchy building routine

Line 3024: FROM fem_intg_dim_hier_gt gt

3020: INTO v_duplicate_parent
3021: FROM dual
3022: WHERE EXISTS
3023: (SELECT gt.child_id
3024: FROM fem_intg_dim_hier_gt gt
3025: WHERE gt.parent_id <> gt.child_id
3026: GROUP BY gt.child_id
3027: HAVING count(gt.child_id) > 1);
3028: EXCEPTION

Line 3121: fem_intg_dim_hier_gt gt

3117: -- To check for the confict dimension group
3118: v_sql_stmt :=
3119: 'SELECT gt.child_display_code
3120: FROM '||pv_dim_memb_b_tab||' b,
3121: fem_intg_dim_hier_gt gt
3122: WHERE b.'||pv_dim_memb_disp_col ||'= gt.child_display_code
3123: AND b.value_set_id = '||pv_dim_vs_id||'
3124: AND b.dimension_group_id <> gt.dimension_group_id';
3125: FEM_ENGINES_PKG.Tech_Message

Line 3162: FROM fem_intg_dim_hier_gt

3158: v_sql_stmt :=
3159: 'UPDATE ' ||pv_dim_memb_b_tab||'
3160: SET dimension_group_id =
3161: (SELECT dimension_group_id
3162: FROM fem_intg_dim_hier_gt
3163: WHERE child_display_code = '||pv_dim_memb_disp_col||'),
3164: last_updated_by = :pv_user_id,
3165: last_update_date = sysdate,
3166: last_update_login = :pv_login_id

Line 3170: FROM fem_intg_dim_hier_gt)';

3166: last_update_login = :pv_login_id
3167: WHERE value_set_id = :pv_dim_vs_id
3168: AND '||pv_dim_memb_col||' IN
3169: (SELECT child_id
3170: FROM fem_intg_dim_hier_gt)';
3171: FEM_ENGINES_PKG.Tech_Message
3172: (p_severity => pc_log_level_procedure,
3173: p_module => 'fem.plsql.fem_intg_hier_eng.main.' ,
3174: p_app_name => 'FEM',

Line 3188: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table

3184: END IF;
3185: COMMIT;
3186: IF (v_new_hier_obj_def_created = TRUE) THEN
3187: -- Call INSERT statement to copy hierarchy structure from the
3188: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table
3189: -- 29AUG05 added WHERE hierarchy_obj_def_id = :pv_hier_obj_def_id
3190: v_sql_stmt :=
3191: 'INSERT INTO '||pv_dim_hier_tab||'
3192: (hierarchy_obj_def_id, parent_depth_num, parent_id,

Line 3214: FROM fem_intg_dim_hier_gt gt

3210: SYSDATE,
3211: :pv_user_id,
3212: :pv_login_id,
3213: 1
3214: FROM fem_intg_dim_hier_gt gt
3215: WHERE hierarchy_obj_def_id = :pv_hier_obj_def_id';
3216: FEM_ENGINES_PKG.Tech_Message
3217: (p_severity => pc_log_level_procedure,
3218: p_module => 'fem.plsql.fem_intg_hier_eng.main.' ,

Line 3251: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table

3247: p_value2 => v_sql_stmt);
3248: EXECUTE IMMEDIATE v_sql_stmt
3249: USING pv_hier_obj_def_id;
3250: -- Call INSERT statement to copy hierarchy structure from the
3251: -- global temporary table FEM_INTG_DIM_HIER_GT to the FEM hierarchy table
3252: v_sql_stmt :=
3253: 'INSERT INTO '||pv_dim_hier_tab||'
3254: (hierarchy_obj_def_id, parent_depth_num, parent_id,
3255: parent_value_set_id, child_depth_num, child_id,

Line 3276: FROM fem_intg_dim_hier_gt gt

3272: SYSDATE,
3273: :pv_user_id,
3274: :pv_login_id,
3275: 1
3276: FROM fem_intg_dim_hier_gt gt
3277: WHERE gt.hierarchy_obj_def_id = :pv_hier_obj_def_id';
3278: FEM_ENGINES_PKG.Tech_Message
3279: (p_severity => pc_log_level_procedure,
3280: p_module => 'fem.plsql.fem_intg_hier_eng.main.',