DBA Data[Home] [Help]

APPS.CZ_UPGRADE dependencies on CZ_PB_LANGUAGES

Line 83: v_base_language cz_pb_languages.language%TYPE;

79: v_org_id NUMBER;
80: v_pr_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE := 'DUMMY';
81: v_pb_run_id NUMBER;
82: v_pb_status VARCHAR2(3);
83: v_base_language cz_pb_languages.language%TYPE;
84: xERROR BOOLEAN:=FALSE;
85:
86:
87: CURSOR to_publish_cur IS

Line 179: INSERT INTO cz_pb_languages (publication_id,language)

175: WHEN OTHERS THEN
176: cz_pb_mgr.log_pb_errors(SQLERRM,1,'AUTO PUBLISH',SQLCODE);
177: END;
178:
179: INSERT INTO cz_pb_languages (publication_id,language)
180: values (cz_model_publications_s.CURRVAL,v_base_language);
181: END LOOP;
182: CLOSE appl_cur;
183:

Line 362: INSERT INTO cz_pb_languages (publication_id,language)

358: VALUES (cz_model_publications_s.CURRVAL,
359: -1
360: );
361:
362: INSERT INTO cz_pb_languages (publication_id,language)
363: values (cz_model_publications_s.CURRVAL,v_base_language);
364: EXCEPTION
365: WHEN OTHERS THEN
366: cz_pb_mgr.log_pb_errors(SQLERRM,1,'AUTO PUBLISH',SQLCODE);