DBA Data[Home] [Help]

APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FEM_HIER_DIMENSION_GRPS

Line 710: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',

706: IF (pv_new_hier_obj_created) THEN
707: v_rel_dim_group_seq := v_parent_level+1;
708: FEM_ENGINES_PKG.Tech_Message
709: (p_severity => pc_log_level_statement,
710: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
711: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id ||
712: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);
713: -- insert the new level to fem_hier_dimension_grps
714: --dedutta : 5035567 : if check for pv_sequence_enforced_flag

Line 713: -- insert the new level to fem_hier_dimension_grps

709: (p_severity => pc_log_level_statement,
710: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
711: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id ||
712: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);
713: -- insert the new level to fem_hier_dimension_grps
714: --dedutta : 5035567 : if check for pv_sequence_enforced_flag
715: IF (pv_sequence_enforced_flag = 'Y') THEN
716: INSERT INTO fem_hier_dimension_grps
717: (dimension_group_id,

Line 716: INSERT INTO fem_hier_dimension_grps

712: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);
713: -- insert the new level to fem_hier_dimension_grps
714: --dedutta : 5035567 : if check for pv_sequence_enforced_flag
715: IF (pv_sequence_enforced_flag = 'Y') THEN
716: INSERT INTO fem_hier_dimension_grps
717: (dimension_group_id,
718: hierarchy_obj_id,
719: relative_dimension_group_seq,
720: creation_date,

Line 802: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',

798: IF (pv_new_hier_obj_created) THEN
799: v_rel_dim_group_seq := v_parent_level+1 ;
800: FEM_ENGINES_PKG.Tech_Message
801: (p_severity => pc_log_level_statement,
802: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
803: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id ||
804: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);
805: -- insert the new level to fem_hier_dimension_grps
806: --dedutta : 5035567 : if check for pv_sequence_enforced_flag

Line 805: -- insert the new level to fem_hier_dimension_grps

801: (p_severity => pc_log_level_statement,
802: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
803: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id ||
804: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);
805: -- insert the new level to fem_hier_dimension_grps
806: --dedutta : 5035567 : if check for pv_sequence_enforced_flag
807: IF (pv_sequence_enforced_flag = 'Y') THEN
808: INSERT INTO fem_hier_dimension_grps
809: (dimension_group_id,

Line 808: INSERT INTO fem_hier_dimension_grps

804: ' v_rel_dim_group_seq:' || v_rel_dim_group_seq);
805: -- insert the new level to fem_hier_dimension_grps
806: --dedutta : 5035567 : if check for pv_sequence_enforced_flag
807: IF (pv_sequence_enforced_flag = 'Y') THEN
808: INSERT INTO fem_hier_dimension_grps
809: (dimension_group_id,
810: hierarchy_obj_id,
811: relative_dimension_group_seq,
812: creation_date,

Line 2531: -- insert the new level to fem_hier_dimension_grps

2527: (p_app_name => 'FEM',
2528: p_msg_name => 'FEM_INTG_FAIL_DIM_GRP');
2529: RAISE FEM_INTG_fatal_err;
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

Line 2532: -- 14OCT2005 b4652450 MOVED HERE WAS AFTER fem_hier_dimension_grps INSERT

2528: p_msg_name => 'FEM_INTG_FAIL_DIM_GRP');
2529: RAISE FEM_INTG_fatal_err;
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;

Line 2556: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',

2552: COMMIT;
2553: IF (pv_new_hier_obj_created) THEN
2554: FEM_ENGINES_PKG.Tech_Message(
2555: p_severity => pc_log_level_statement,
2556: p_module => 'fem.plsql.'||'insert into fem_hier_dimension_grps',
2557: p_msg_text => 'v_dimension_group_id:' || v_dimension_group_id || ' v_rel_dim_group_seq:' || v_counter);
2558: -- 14OCT2005 b4652450 first is already added from call in Main()
2559: if v_counter > 1 then
2560: --dedutta : 5035567 : if check for pv_sequence_enforced_flag

Line 2562: INSERT INTO fem_hier_dimension_grps

2558: -- 14OCT2005 b4652450 first is already added from call in Main()
2559: if v_counter > 1 then
2560: --dedutta : 5035567 : if check for pv_sequence_enforced_flag
2561: IF (pv_sequence_enforced_flag = 'Y') THEN
2562: INSERT INTO fem_hier_dimension_grps
2563: (dimension_group_id,
2564: hierarchy_obj_id,
2565: relative_dimension_group_seq,
2566: creation_date,