APPS.CZ_IMP_PS_NODE dependencies on CZ_RULE_FOLDERS

Line 1706: INSERT INTO CZ_RULE_FOLDERS

1702: SET REC_STATUS='OK'
1703: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1704: AND DISPOSITION='I';
1705:
1706: INSERT INTO CZ_RULE_FOLDERS
1707: (RULE_FOLDER_ID,NAME,TREE_SEQ,DEVL_PROJECT_ID,CREATED_BY,LAST_UPDATED_BY,
1708: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1709: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1710: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'

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

1705:
1706: INSERT INTO CZ_RULE_FOLDERS
1707: (RULE_FOLDER_ID,NAME,TREE_SEQ,DEVL_PROJECT_ID,CREATED_BY,LAST_UPDATED_BY,
1708: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1709: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1710: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'
1711: FROM DUAL WHERE NOT EXISTS
1712: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE
1713: DEVL_PROJECT_ID=p_xfr_devl_project.devl_project_id AND

Line 1712: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE

1708: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1709: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1710: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'
1711: FROM DUAL WHERE NOT EXISTS
1712: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE
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: