APPS.FEM_COMP_DIM_MEMBER_LOADER_PKG dependencies on FEM_ACTIVITIES

Line 668: ' FROM FEM_ACTIVITIES_T B'||

664: ' user_dim8_display_code,'||
665: ' user_dim9_display_code,'||
666: ' user_dim10_display_code,'||
667: ' status'||
668: ' FROM FEM_ACTIVITIES_T B'||
669: ' WHERE {{data_slice}} ';
670: END IF;
671:
672: --Need to confirm with Nico

Line 717: | table of composite dimensions (FEM_ACTIVITIES_T/FEM_COST_OBJECTS_T) and

713: |
714: | DESCRIPTION
715: |
716: | This procedure is used to process all the rows in the interface
717: | table of composite dimensions (FEM_ACTIVITIES_T/FEM_COST_OBJECTS_T) and
718: | performs various validations on these records,concatenate the component
719: | dimension members and inserts only the valid records into the member table
720: | of Composite Dimensions.The invalid records will be processed in
721: | 'Error Reproceesing' Mode.

Line 763: v_activity_dc FEM_ACTIVITIES.activity_display_code%TYPE;

759: v_rows_rejected NUMBER :=0;
760: v_rows_loaded NUMBER :=0;
761:
762: v_cost_object_dc FEM_COST_OBJECTS.cost_object_display_code%TYPE;
763: v_activity_dc FEM_ACTIVITIES.activity_display_code%TYPE;
764:
765: v_cost_structure_id NUMBER;
766: v_activity_structure_id NUMBER;
767:

Line 957: 'INSERT INTO FEM_ACTIVITIES ('||

953: ' FROM dual'||
954: ' WHERE :b_status = ''LOAD''';
955:
956: v_insert_activity_stmt CONSTANT LONG :=
957: 'INSERT INTO FEM_ACTIVITIES ('||
958: ' ACTIVITY_ID, '||
959: ' ACTIVITY_DISPLAY_CODE, '||
960: ' SUMMARY_FLAG, '||
961: ' START_DATE_ACTIVE, '||

Line 1020: ' SELECT fem_activities_s.nextval,'||

1016: ' OBJECT_VERSION_NUMBER, '||
1017: ' ENABLED_FLAG, '||
1018: ' PERSONAL_FLAG, '||
1019: ' READ_ONLY_FLAG )'||
1020: ' SELECT fem_activities_s.nextval,'||
1021: ' :b_ACTIVITY_DISPLAY_CODE, '||
1022: ' :b_SUMMARY_FLAG, '||
1023: ' :b_START_DATE_ACTIVE, '||
1024: ' :b_END_DATE_ACTIVE, '||

Line 1091: 'UPDATE FEM_ACTIVITIES_T '||

1087: ' SET status = :b_status'||
1088: ' WHERE rowid = :b_rowid';
1089:
1090: v_update_activity_stmt CONSTANT VARCHAR2(4000) :=
1091: 'UPDATE FEM_ACTIVITIES_T '||
1092: ' SET status = :b_status'||
1093: ' WHERE rowid = :b_rowid';
1094:
1095: v_delete_cost_stmt CONSTANT VARCHAR2(4000) :=

Line 1101: 'DELETE FROM FEM_ACTIVITIES_T '||

1097: ' WHERE rowid = :b_rowid'||
1098: ' AND :b_status = ''LOAD''';
1099:
1100: v_delete_activity_stmt CONSTANT VARCHAR2(4000) :=
1101: 'DELETE FROM FEM_ACTIVITIES_T '||
1102: ' WHERE rowid = :b_rowid'||
1103: ' AND :b_status = ''LOAD''';
1104:
1105:

Line 1185: v_member_table_name := 'fem_activities_t';

1181:
1182: ELSIF (p_dimension_varchar_label = 'ACTIVITY') THEN
1183: v_update_stmt := v_update_activity_stmt;
1184: v_delete_stmt := v_delete_activity_stmt;
1185: v_member_table_name := 'fem_activities_t';
1186:
1187: END IF;
1188:
1189: