APPS.CZ_UPGRADE dependencies on CZ_RULE_FOLDERS

Line 924: --Insert into cz_rule_folders

920: WHERE deleted_flag = flag_not_deleted
921: START WITH ps_node_id = ntpsnodeid(i)
922: CONNECT BY PRIOR ps_node_id = parent_id);
923:
924: --Insert into cz_rule_folders
925:
926: INSERT INTO cz_rule_folders
927: (rule_folder_id,name,tree_seq,devl_project_id,created_by,last_updated_by,
928: creation_date,last_update_date,deleted_flag)

Line 926: INSERT INTO cz_rule_folders

922: CONNECT BY PRIOR ps_node_id = parent_id);
923:
924: --Insert into cz_rule_folders
925:
926: INSERT INTO cz_rule_folders
927: (rule_folder_id,name,tree_seq,devl_project_id,created_by,last_updated_by,
928: creation_date,last_update_date,deleted_flag)
929: SELECT cz_rule_folders_s.NEXTVAL,ntname(i)||' Rules',0,
930: ntpsnodeid(i),UID,UID,SYSDATE,SYSDATE,'0'

Line 929: SELECT cz_rule_folders_s.NEXTVAL,ntname(i)||' Rules',0,

925:
926: INSERT INTO cz_rule_folders
927: (rule_folder_id,name,tree_seq,devl_project_id,created_by,last_updated_by,
928: creation_date,last_update_date,deleted_flag)
929: SELECT cz_rule_folders_s.NEXTVAL,ntname(i)||' Rules',0,
930: ntpsnodeid(i),UID,UID,SYSDATE,SYSDATE,'0'
931: FROM dual WHERE NOT EXISTS
932: (SELECT 1 FROM cz_rule_folders WHERE
933: devl_project_id=ntpsnodeid(i) AND

Line 932: (SELECT 1 FROM cz_rule_folders WHERE

928: creation_date,last_update_date,deleted_flag)
929: SELECT cz_rule_folders_s.NEXTVAL,ntname(i)||' Rules',0,
930: ntpsnodeid(i),UID,UID,SYSDATE,SYSDATE,'0'
931: FROM dual WHERE NOT EXISTS
932: (SELECT 1 FROM cz_rule_folders WHERE
933: devl_project_id=ntpsnodeid(i) AND
934: parent_rule_folder_id IS NULL AND name=ntname(i)||' Rules');
935:
936: --Insert and take care of orig_sys_ref

Line 1887: FOR folder IN (SELECT name FROM cz_rule_folders

1883: BEGIN
1884: IF(nRuleFolderId IS NULL OR nRuleFolderId = -1)THEN RETURN vRuleName; END IF;
1885: IF(v_RuleQualifiedName.EXISTS(nRuleFolderId))THEN RETURN v_RuleQualifiedName(nRuleFolderId) || vRuleName; END IF;
1886: nRuleName := LENGTH(vRuleName);
1887: FOR folder IN (SELECT name FROM cz_rule_folders
1888: WHERE deleted_flag = FLAG_NOT_DELETED
1889: AND parent_rule_folder_id IS NOT NULL
1890: START WITH rule_folder_id = nRuleFolderId
1891: CONNECT BY PRIOR parent_rule_folder_id = rule_folder_id)LOOP