DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on CZ_FCE_FILES_S

Line 1061: SELECT cz_fce_files_s.NEXTVAL INTO this_file_id FROM DUAL;

1057: DBMS_LOB.WRITEAPPEND ( l_loc, 4, const_file_signature );
1058:
1059: IF ( this_segment_nbr = 1 ) THEN
1060:
1061: SELECT cz_fce_files_s.NEXTVAL INTO this_file_id FROM DUAL;
1062:
1063: --This does not delete a logic file if there is no such type in the current generation.
1064: --For example, if an only port has been removed from the model, there will be no port
1065: --file in this generation, so the current port file will not be deleted.

Line 1071: UPDATE cz_fce_files SET deleted_flag = '1'

1067: --#
1068: --Need a better handling of this problem. For now we will always create files of all
1069: --possible types even if they are empty. We do that for rule files anyway.
1070:
1071: UPDATE cz_fce_files SET deleted_flag = '1'
1072: WHERE component_id = p_component_id
1073: AND fce_file_type = p_type;
1074:
1075: ELSE