APPS.CZ_PS_COPY dependencies on CZ_DEVL_PROJECTS

Line 4: GLOBAL_ORIG_SYS_REF CZ_DEVL_PROJECTS.orig_sys_ref%TYPE;

1: PACKAGE BODY cz_ps_copy AS
2: /* $Header: czpscpb.pls 120.0 2005/05/25 07:27:11 appldev noship $ */
3:
4: GLOBAL_ORIG_SYS_REF CZ_DEVL_PROJECTS.orig_sys_ref%TYPE;
5: BATCH_SIZE INTEGER:=20000;
6: numRecords INTEGER:=0;
7:
8: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 218: i CZ_DEVL_PROJECTS%ROWTYPE;

214:
215: PROCEDURE COPY_DEVL_PROJECT
216: (p_new_name IN VARCHAR2) IS
217:
218: i CZ_DEVL_PROJECTS%ROWTYPE;
219: var_name CZ_DEVL_PROJECTS.NAME%TYPE;
220: var_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
221:
222: BEGIN

Line 219: var_name CZ_DEVL_PROJECTS.NAME%TYPE;

215: PROCEDURE COPY_DEVL_PROJECT
216: (p_new_name IN VARCHAR2) IS
217:
218: i CZ_DEVL_PROJECTS%ROWTYPE;
219: var_name CZ_DEVL_PROJECTS.NAME%TYPE;
220: var_intl_text_id CZ_INTL_TEXTS.intl_text_id%TYPE;
221:
222: BEGIN
223:

Line 225: SELECT * INTO i FROM CZ_DEVL_PROJECTS

221:
222: BEGIN
223:
224: SELECT CZ_PS_NODES_S.NEXTVAL INTO NEW_PROJECT_ID FROM dual;
225: SELECT * INTO i FROM CZ_DEVL_PROJECTS
226: WHERE DEVL_PROJECT_ID=OLD_PROJECT_ID AND deleted_flag=NO_FLAG;
227:
228: GLOBAL_ORIG_SYS_REF:=i.ORIG_SYS_REF;
229:

Line 243: INSERT INTO CZ_DEVL_PROJECTS

239: Copy_INTL_TEXT(i.intl_text_id,var_intl_text_id,NEW_PROJECT_ID,NULL);
240: END IF;
241:
242:
243: INSERT INTO CZ_DEVL_PROJECTS
244: (DEVL_PROJECT_ID,
245: INTL_TEXT_ID,
246: NAME,
247: PERSISTENT_PROJECT_ID,