APPS.CZ_IMP_PS_NODE dependencies on CZ_RP_ENTRIES

Line 906: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv

902:
903: IF(NOT x_onl_devl_project_f)THEN
904: DECLARE
905: CURSOR c_check IS
906: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv
907: WHERE rp.deleted_flag = '0'
908: AND rp.object_type = 'PRJ'
909: AND rp.name = sName
910: AND dv.deleted_flag = '0'

Line 921: FROM cz_rp_entries rp, cz_devl_projects dv

917: IF(c_check%FOUND)THEN
918:
919: BEGIN
920: SELECT MAX(cz_utils.conv_num(SUBSTR(rp.name, 7, INSTR(rp.name, ')') - 7))) INTO nDummy
921: FROM cz_rp_entries rp, cz_devl_projects dv
922: WHERE rp.deleted_flag = '0'
923: AND rp.object_type = 'PRJ'
924: AND rp.name like 'Copy (%) of ' || sName
925: AND dv.deleted_flag = '0'

Line 1468: INSERT INTO CZ_RP_ENTRIES

1464: DEVL_PROJECT_ID=p_xfr_devl_project.devl_project_id AND
1465: PARENT_RULE_FOLDER_ID IS NULL AND NAME=p_xfr_devl_project.name||' Rules'
1466: AND deleted_flag = '0');
1467:
1468: INSERT INTO CZ_RP_ENTRIES
1469: (OBJECT_TYPE,OBJECT_ID,ENCLOSING_FOLDER,NAME,DESCRIPTION,DELETED_FLAG,SEEDED_FLAG)
1470: SELECT 'PRJ',p_xfr_devl_project.devl_project_id,p_rp_folder_id,
1471: p_xfr_devl_project.name,p_xfr_devl_project.desc_text,'0',p_xfr_devl_project.seeded_flag
1472: FROM DUAL WHERE NOT EXISTS

Line 1473: (SELECT 1 FROM CZ_RP_ENTRIES WHERE deleted_flag = '0' AND (

1469: (OBJECT_TYPE,OBJECT_ID,ENCLOSING_FOLDER,NAME,DESCRIPTION,DELETED_FLAG,SEEDED_FLAG)
1470: SELECT 'PRJ',p_xfr_devl_project.devl_project_id,p_rp_folder_id,
1471: p_xfr_devl_project.name,p_xfr_devl_project.desc_text,'0',p_xfr_devl_project.seeded_flag
1472: FROM DUAL WHERE NOT EXISTS
1473: (SELECT 1 FROM CZ_RP_ENTRIES WHERE deleted_flag = '0' AND (
1474: (OBJECT_TYPE='PRJ' AND OBJECT_ID=p_xfr_devl_project.devl_project_id) OR
1475: (ENCLOSING_FOLDER=p_rp_folder_id AND NAME=p_xfr_devl_project.name)));
1476:
1477:

Line 1545: UPDATE CZ_RP_ENTRIES SET

1541: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1542: AND DISPOSITION='M';
1543: END IF;
1544:
1545: UPDATE CZ_RP_ENTRIES SET
1546: NAME = DECODE(NOUPDATE_NAME,0,p_xfr_devl_project.name,name),
1547: DESCRIPTION = DECODE(NOUPDATE_DESC_TEXT,0,p_xfr_devl_project.desc_text,description),
1548: DELETED_FLAG = '0',
1549: SEEDED_FLAG = p_xfr_devl_project.seeded_flag

Line 1552: (SELECT 1 FROM CZ_RP_ENTRIES

1548: DELETED_FLAG = '0',
1549: SEEDED_FLAG = p_xfr_devl_project.seeded_flag
1550: WHERE OBJECT_TYPE='PRJ' AND OBJECT_ID=p_xfr_devl_project.devl_project_id
1551: AND NOT EXISTS
1552: (SELECT 1 FROM CZ_RP_ENTRIES
1553: WHERE ENCLOSING_FOLDER=0
1554: AND NAME=p_xfr_devl_project.name
1555: AND deleted_flag = '0');
1556: -- dbms_output.put_line ('Updating .. M : ' || p_xfr_devl_project.devl_project_id);

Line 4401: DELETE FROM cz_rp_entries

4397:
4398: IF l_c1_dis_tbl(i) = 'I' THEN
4399: DELETE FROM cz_devl_projects
4400: WHERE devl_project_id = l_c1_prj_id_tbl(i);
4401: DELETE FROM cz_rp_entries
4402: WHERE object_id = l_c1_prj_id_tbl(i)
4403: AND object_type = 'PRJ';
4404: END IF;
4405: END IF;

Line 4431: DELETE FROM cz_rp_entries

4427:
4428: IF l_c2_dis_tbl(i) = 'I' THEN
4429: DELETE FROM cz_devl_projects
4430: WHERE devl_project_id = l_c2_prj_id_tbl(i);
4431: DELETE FROM cz_rp_entries
4432: WHERE object_id = l_c2_prj_id_tbl(i)
4433: AND object_type = 'PRJ';
4434: END IF;
4435: END IF;

Line 4461: DELETE FROM cz_rp_entries

4457:
4458: IF l_c3_dis_tbl(i) = 'I' THEN
4459: DELETE FROM cz_devl_projects
4460: WHERE devl_project_id = l_c3_prj_id_tbl(i);
4461: DELETE FROM cz_rp_entries
4462: WHERE object_id = l_c3_prj_id_tbl(i)
4463: AND object_type = 'PRJ';
4464: END IF;
4465: END IF;

Line 4574: DELETE FROM cz_rp_entries

4570:
4571: IF l_c4_dis_tbl(i) = 'I' THEN
4572: DELETE FROM cz_devl_projects
4573: WHERE devl_project_id = l_c4_prj_id_tbl(i);
4574: DELETE FROM cz_rp_entries
4575: WHERE object_id = l_c4_prj_id_tbl(i)
4576: AND object_type = 'PRJ';
4577: END IF;
4578: END IF;