APPS.FEM_DIM_MEMBER_LOADER_PKG dependencies on DUAL

Line 942: FROM dual;

938:
939:
940: SELECT FEM_DHM_METADATA_OPS_KEY_S.nextval
941: INTO v_event_sequence
942: FROM dual;
943:
944:
945: WF_EVENT.addparametertolist
946: (p_name => 'DIMENSION_VARCHAR_LABEL',

Line 2706: | then each assignment record is validated individually:

2702: | 3. If number attribute assignments < number of required attributes, the member
2703: | fails with status = 'MISSING_REQUIRED_ATTRIBUTE'. The _TL_T gets
2704: | 'INVALID_MEMBER' and all of the _ATTR_T records get 'INVALID_MEMBER'.
2705: | 4. If the number of attribute assignments = number of required attributes,
2706: | then each assignment record is validated individually:
2707: | For Dimension Groups - check the Dim Group Sequence. Failure =
2708: | 'DIM_GROUP_SEQUENCE_NOT_UNIQUE'.
2709: | For Dimension Groups (CAL_PERIOD only) - check Time Group Type Code.
2710: | Failure = 'INVALID_TIME_GROUP_TYPE'.

Line 4290: FROM dual;

4286:
4287: IF (p_load_type = 'DIMENSION_GROUP') THEN
4288: SELECT fem_dimension_grps_b_s.nextval
4289: INTO tf_dimgrp_dimension_group_id(v_mbr_final_count)
4290: FROM dual;
4291:
4292: SELECT fem_time_dimension_group_key_s.nextval
4293: INTO tf_time_dimension_group_key(v_mbr_final_count)
4294: FROM dual;

Line 4294: FROM dual;

4290: FROM dual;
4291:
4292: SELECT fem_time_dimension_group_key_s.nextval
4293: INTO tf_time_dimension_group_key(v_mbr_final_count)
4294: FROM dual;
4295:
4296: tf_time_group_type_code(v_mbr_final_count) :=t_time_group_type_code(v_mbr_count);
4297: tf_dimension_group_seq(v_mbr_final_count) :=t_dimension_group_seq(v_mbr_count);
4298:

Line 8679: ' FROM dual'||

8675: ',:b_cal_period_name'||
8676: ',:b_description'||
8677: ',''N'''||
8678: ',:b_adj_period_flag'||
8679: ' FROM dual'||
8680: ' WHERE :b_use_interim_table_flag = ''Y'''||
8681: ' AND :b_status = ''LOAD''';
8682: x_insert_calp_attr_stmt := 'INSERT INTO fem_calp_attr_interim_t'||
8683: '(CAL_PERIOD_ID'||

Line 8704: ' FROM dual'||

8700: ',:b_number_assign_value'||
8701: ',:b_varchar_assign_value'||
8702: ',:b_date_assign_value'||
8703: ',''N'''||
8704: ' FROM dual'||
8705: ' WHERE :b_use_interim_table_flag = ''Y'''||
8706: ' AND :b_status = ''LOAD''';
8707:
8708:

Line 13482: FROM dual;

13478: ,gv_apps_user_id
13479: ,sysdate
13480: ,gv_login_id
13481: ,1
13482: FROM dual;
13483: ELSE
13484: UPDATE fem_dim_load_status
13485: SET load_status = v_dim_load_status,
13486: last_updated_by = gv_apps_user_id,

Line 13649: | This procedure concatenates the individual component dimension members

13645: | PROCEDURE
13646: | Get_Display_Code
13647: |
13648: | DESCRIPTION
13649: | This procedure concatenates the individual component dimension members
13650: | of the Composite Dimensions(Activity and Cost Objects).
13651: |
13652: | The component dimension members are concatenated to form a
13653: | single Composite Dimension Member.The component dimension members

Line 14378: ' FROM dual'||

14374: ' :b_OBJECT_VERSION_NUMBER, '||
14375: ' :b_ENABLED_FLAG, '||
14376: ' :b_PERSONAL_FLAG, '||
14377: ' :b_read_only_flag '||
14378: ' FROM dual'||
14379: ' WHERE :b_status = ''LOAD''';
14380:
14381: v_insert_activity_stmt CONSTANT LONG :=
14382: 'INSERT INTO FEM_ACTIVITIES ('||

Line 14507: ' FROM dual'||

14503: ' :b_OBJECT_VERSION_NUMBER, '||
14504: ' :b_ENABLED_FLAG, '||
14505: ' :b_PERSONAL_FLAG, '||
14506: ' :b_read_only_flag '||
14507: ' FROM dual'||
14508: ' WHERE :b_status = ''LOAD''';
14509:
14510: v_update_cost_stmt CONSTANT VARCHAR2(4000) :=
14511: 'UPDATE FEM_COST_OBJECTS_T '||