APPS.CZ_PB_MGR dependencies on CZ_FCE_FILES

Line 16036: SELECT cz_pb_mgr.sequence_generate(CZ_FCE_FILES_SEQ

16032: l_newid_tbl.DELETE;
16033: l_oldid_tbl.DELETE;
16034: l_comid_tbl.DELETE;
16035:
16036: SELECT cz_pb_mgr.sequence_generate(CZ_FCE_FILES_SEQ
16037: ,'CZ_FCE_FILES_S.NEXTVAL' || cz_pb_mgr.v_db_link
16038: ,cz_pb_mgr.v_oraclesequenceincr
16039: ),
16040: fce_file_id, component_id

Line 16037: ,'CZ_FCE_FILES_S.NEXTVAL' || cz_pb_mgr.v_db_link

16033: l_oldid_tbl.DELETE;
16034: l_comid_tbl.DELETE;
16035:
16036: SELECT cz_pb_mgr.sequence_generate(CZ_FCE_FILES_SEQ
16037: ,'CZ_FCE_FILES_S.NEXTVAL' || cz_pb_mgr.v_db_link
16038: ,cz_pb_mgr.v_oraclesequenceincr
16039: ),
16040: fce_file_id, component_id
16041: BULK COLLECT INTO l_newid_tbl, l_oldid_tbl, l_comid_tbl

Line 16042: FROM cz_fce_files

16038: ,cz_pb_mgr.v_oraclesequenceincr
16039: ),
16040: fce_file_id, component_id
16041: BULK COLLECT INTO l_newid_tbl, l_oldid_tbl, l_comid_tbl
16042: FROM cz_fce_files
16043: WHERE deleted_flag = '0' AND component_id = cz_pb_mgr.v_models_to_be_exported(i);
16044:
16045: IF l_newid_tbl.COUNT > 0 THEN
16046: FOR j IN l_newid_tbl.FIRST .. l_newid_tbl.LAST LOOP

Line 16062: insert_into_table('CZ_FCE_FILES'

16058: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_fcefile_new_id_tbl';
16059: l_plsql_table_list(2).col_name := 'COMPONENT_ID';
16060: l_plsql_table_list(2).table_name := 'cz_pb_mgr.g_fcefile_compid_tbl';
16061:
16062: insert_into_table('CZ_FCE_FILES'
16063: ,'FCE_FILE_ID'
16064: , cz_pb_mgr.v_db_link
16065: , l_plsql_table_list
16066: ,'cz_pb_mgr.g_fcefile_old_id_tbl'

Line 19714: FROM cz_fce_files

19710: l_is_solver_model := (l_engine_type IS NOT NULL AND l_engine_type = ENGINE_TYPE_FCE);
19711:
19712: IF l_is_solver_model THEN
19713: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
19714: FROM cz_fce_files
19715: WHERE component_id = p_model_id AND deleted_flag = '0';
19716: ELSE
19717: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
19718: FROM cz_lce_headers

Line 19747: FROM cz_fce_files

19743:
19744: IF l_prj_last_logic_update IS NOT NULL THEN
19745: IF l_is_solver_model THEN
19746: SELECT MAX(last_update_date) INTO l_logic_last_update_date
19747: FROM cz_fce_files
19748: WHERE component_id = l_component_id AND deleted_flag = '0';
19749: ELSE
19750: SELECT MAX(last_update_date) INTO l_logic_last_update_date
19751: FROM cz_lce_headers