APPS.CZ_PB_MGR dependencies on CZ_FCE_FILES

Line 14922: SELECT cz_pb_mgr.sequence_generate(CZ_FCE_FILES_SEQ

14918: l_newid_tbl.DELETE;
14919: l_oldid_tbl.DELETE;
14920: l_comid_tbl.DELETE;
14921:
14922: SELECT cz_pb_mgr.sequence_generate(CZ_FCE_FILES_SEQ
14923: ,'CZ_FCE_FILES_S.NEXTVAL' || cz_pb_mgr.v_db_link
14924: ,cz_pb_mgr.v_oraclesequenceincr
14925: ),
14926: fce_file_id, component_id

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

14919: l_oldid_tbl.DELETE;
14920: l_comid_tbl.DELETE;
14921:
14922: SELECT cz_pb_mgr.sequence_generate(CZ_FCE_FILES_SEQ
14923: ,'CZ_FCE_FILES_S.NEXTVAL' || cz_pb_mgr.v_db_link
14924: ,cz_pb_mgr.v_oraclesequenceincr
14925: ),
14926: fce_file_id, component_id
14927: BULK COLLECT INTO l_newid_tbl, l_oldid_tbl, l_comid_tbl

Line 14928: FROM cz_fce_files

14924: ,cz_pb_mgr.v_oraclesequenceincr
14925: ),
14926: fce_file_id, component_id
14927: BULK COLLECT INTO l_newid_tbl, l_oldid_tbl, l_comid_tbl
14928: FROM cz_fce_files
14929: WHERE deleted_flag = '0' AND component_id = cz_pb_mgr.v_models_to_be_exported(i);
14930:
14931: IF l_newid_tbl.COUNT > 0 THEN
14932: FOR j IN l_newid_tbl.FIRST .. l_newid_tbl.LAST LOOP

Line 14948: insert_into_table('CZ_FCE_FILES'

14944: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_fcefile_new_id_tbl';
14945: l_plsql_table_list(2).col_name := 'COMPONENT_ID';
14946: l_plsql_table_list(2).table_name := 'cz_pb_mgr.g_fcefile_compid_tbl';
14947:
14948: insert_into_table('CZ_FCE_FILES'
14949: ,'FCE_FILE_ID'
14950: , cz_pb_mgr.v_db_link
14951: , l_plsql_table_list
14952: ,'cz_pb_mgr.g_fcefile_old_id_tbl'

Line 18577: FROM cz_fce_files

18573: l_is_solver_model := (l_engine_type IS NOT NULL AND l_engine_type = ENGINE_TYPE_FCE);
18574:
18575: IF l_is_solver_model THEN
18576: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
18577: FROM cz_fce_files
18578: WHERE component_id = p_model_id AND deleted_flag = '0';
18579: ELSE
18580: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
18581: FROM cz_lce_headers

Line 18610: FROM cz_fce_files

18606:
18607: IF l_prj_last_logic_update IS NOT NULL THEN
18608: IF l_is_solver_model THEN
18609: SELECT MAX(last_update_date) INTO l_logic_last_update_date
18610: FROM cz_fce_files
18611: WHERE component_id = l_component_id AND deleted_flag = '0';
18612: ELSE
18613: SELECT MAX(last_update_date) INTO l_logic_last_update_date
18614: FROM cz_lce_headers