APPS.CZ_IMP_PS_NODE dependencies on CZ_RULE_FOLDERS

Line 1457: INSERT INTO CZ_RULE_FOLDERS

1453: SET REC_STATUS='OK'
1454: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1455: AND DISPOSITION='I';
1456:
1457: INSERT INTO CZ_RULE_FOLDERS
1458: (RULE_FOLDER_ID,NAME,TREE_SEQ,DEVL_PROJECT_ID,CREATED_BY,LAST_UPDATED_BY,
1459: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1460: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1461: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'

Line 1460: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,

1456:
1457: INSERT INTO CZ_RULE_FOLDERS
1458: (RULE_FOLDER_ID,NAME,TREE_SEQ,DEVL_PROJECT_ID,CREATED_BY,LAST_UPDATED_BY,
1459: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1460: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1461: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'
1462: FROM DUAL WHERE NOT EXISTS
1463: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE
1464: DEVL_PROJECT_ID=p_xfr_devl_project.devl_project_id AND

Line 1463: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE

1459: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1460: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1461: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'
1462: FROM DUAL WHERE NOT EXISTS
1463: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE
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: