DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_RULE_FOLDERS

Line 881: FOR folder IN (SELECT name FROM cz_rule_folders

877: BEGIN
878: IF(nRuleFolderId IS NULL OR nRuleFolderId = -1)THEN RETURN vRuleName; END IF;
879: IF(v_RuleQualifiedName.EXISTS(nRuleFolderId))THEN RETURN v_RuleQualifiedName(nRuleFolderId) || vRuleName; END IF;
880: nRuleName := LENGTHB(vRuleName);
881: FOR folder IN (SELECT name FROM cz_rule_folders
882: WHERE deleted_flag = FLAG_NOT_DELETED
883: AND parent_rule_folder_id IS NOT NULL
884: START WITH rule_folder_id = nRuleFolderId
885: AND object_type = 'RFL'

Line 908: FOR folder IN (SELECT name FROM cz_rule_folders

904: BEGIN
905: IF(inFolderId IS NULL OR inFolderId = -1)THEN RETURN inCompanionName; END IF;
906: IF(v_FuncQualifiedName.EXISTS(inFolderId))THEN RETURN v_FuncQualifiedName(inFolderId) || inCompanionName; END IF;
907: nameLen := LENGTHB(inCompanionName);
908: FOR folder IN (SELECT name FROM cz_rule_folders
909: WHERE deleted_flag = FLAG_NOT_DELETED
910: AND parent_rule_folder_id IS NOT NULL
911: START WITH rule_folder_id = inFolderId
912: CONNECT BY PRIOR parent_rule_folder_id = rule_folder_id)LOOP