APPS.CZ_IMP_PS_NODE dependencies on CZ_RP_ENTRIES

Line 1106: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv

1102:
1103: IF(NOT x_onl_devl_project_f)THEN
1104: DECLARE
1105: CURSOR c_check IS
1106: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv
1107: WHERE rp.deleted_flag = '0'
1108: AND rp.object_type = 'PRJ'
1109: AND rp.name = sName
1110: AND dv.deleted_flag = '0'

Line 1121: FROM cz_rp_entries rp, cz_devl_projects dv

1117: IF(c_check%FOUND)THEN
1118:
1119: BEGIN
1120: SELECT MAX(cz_utils.conv_num(SUBSTR(rp.name, 7, INSTR(rp.name, ')') - 7))) INTO nDummy
1121: FROM cz_rp_entries rp, cz_devl_projects dv
1122: WHERE rp.deleted_flag = '0'
1123: AND rp.object_type = 'PRJ'
1124: AND rp.name like 'Copy (%) of ' || sName
1125: AND dv.deleted_flag = '0'

Line 1717: INSERT INTO CZ_RP_ENTRIES

1713: DEVL_PROJECT_ID=p_xfr_devl_project.devl_project_id AND
1714: PARENT_RULE_FOLDER_ID IS NULL AND NAME=p_xfr_devl_project.name||' Rules'
1715: AND deleted_flag = '0');
1716:
1717: INSERT INTO CZ_RP_ENTRIES
1718: (OBJECT_TYPE,OBJECT_ID,ENCLOSING_FOLDER,NAME,DESCRIPTION,DELETED_FLAG,SEEDED_FLAG)
1719: SELECT 'PRJ',p_xfr_devl_project.devl_project_id,p_rp_folder_id,
1720: p_xfr_devl_project.name,p_xfr_devl_project.desc_text,'0',p_xfr_devl_project.seeded_flag
1721: FROM DUAL WHERE NOT EXISTS

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

1718: (OBJECT_TYPE,OBJECT_ID,ENCLOSING_FOLDER,NAME,DESCRIPTION,DELETED_FLAG,SEEDED_FLAG)
1719: SELECT 'PRJ',p_xfr_devl_project.devl_project_id,p_rp_folder_id,
1720: p_xfr_devl_project.name,p_xfr_devl_project.desc_text,'0',p_xfr_devl_project.seeded_flag
1721: FROM DUAL WHERE NOT EXISTS
1722: (SELECT 1 FROM CZ_RP_ENTRIES WHERE deleted_flag = '0' AND (
1723: (OBJECT_TYPE='PRJ' AND OBJECT_ID=p_xfr_devl_project.devl_project_id) OR
1724: (ENCLOSING_FOLDER=p_rp_folder_id AND NAME=p_xfr_devl_project.name)));
1725:
1726:

Line 1794: UPDATE CZ_RP_ENTRIES SET

1790: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1791: AND DISPOSITION='M';
1792: END IF;
1793:
1794: UPDATE CZ_RP_ENTRIES SET
1795: NAME = DECODE(NOUPDATE_NAME,0,p_xfr_devl_project.name,name),
1796: DESCRIPTION = DECODE(NOUPDATE_DESC_TEXT,0,p_xfr_devl_project.desc_text,description),
1797: DELETED_FLAG = '0',
1798: SEEDED_FLAG = p_xfr_devl_project.seeded_flag

Line 1801: (SELECT 1 FROM CZ_RP_ENTRIES

1797: DELETED_FLAG = '0',
1798: SEEDED_FLAG = p_xfr_devl_project.seeded_flag
1799: WHERE OBJECT_TYPE='PRJ' AND OBJECT_ID=p_xfr_devl_project.devl_project_id
1800: AND NOT EXISTS
1801: (SELECT 1 FROM CZ_RP_ENTRIES
1802: WHERE ENCLOSING_FOLDER=0
1803: AND NAME=p_xfr_devl_project.name
1804: AND deleted_flag = '0');
1805: -- dbms_output.put_line ('Updating .. M : ' || p_xfr_devl_project.devl_project_id);

Line 4847: DELETE FROM cz_rp_entries

4843:
4844: IF l_c1_dis_tbl(i) = 'I' THEN
4845: DELETE FROM cz_devl_projects
4846: WHERE devl_project_id = l_c1_prj_id_tbl(i);
4847: DELETE FROM cz_rp_entries
4848: WHERE object_id = l_c1_prj_id_tbl(i)
4849: AND object_type = 'PRJ';
4850: END IF;
4851: END IF;

Line 4877: DELETE FROM cz_rp_entries

4873:
4874: IF l_c2_dis_tbl(i) = 'I' THEN
4875: DELETE FROM cz_devl_projects
4876: WHERE devl_project_id = l_c2_prj_id_tbl(i);
4877: DELETE FROM cz_rp_entries
4878: WHERE object_id = l_c2_prj_id_tbl(i)
4879: AND object_type = 'PRJ';
4880: END IF;
4881: END IF;

Line 4907: DELETE FROM cz_rp_entries

4903:
4904: IF l_c3_dis_tbl(i) = 'I' THEN
4905: DELETE FROM cz_devl_projects
4906: WHERE devl_project_id = l_c3_prj_id_tbl(i);
4907: DELETE FROM cz_rp_entries
4908: WHERE object_id = l_c3_prj_id_tbl(i)
4909: AND object_type = 'PRJ';
4910: END IF;
4911: END IF;

Line 5020: DELETE FROM cz_rp_entries

5016:
5017: IF l_c4_dis_tbl(i) = 'I' THEN
5018: DELETE FROM cz_devl_projects
5019: WHERE devl_project_id = l_c4_prj_id_tbl(i);
5020: DELETE FROM cz_rp_entries
5021: WHERE object_id = l_c4_prj_id_tbl(i)
5022: AND object_type = 'PRJ';
5023: END IF;
5024: END IF;