DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_RULE_FOLDERS

Line 892: FOR folder IN (SELECT name FROM cz_rule_folders

888: BEGIN
889: IF(nRuleFolderId IS NULL OR nRuleFolderId = -1)THEN RETURN vRuleName; END IF;
890: IF(v_RuleQualifiedName.EXISTS(nRuleFolderId))THEN RETURN v_RuleQualifiedName(nRuleFolderId) || vRuleName; END IF;
891: nRuleName := LENGTHB(vRuleName);
892: FOR folder IN (SELECT name FROM cz_rule_folders
893: WHERE deleted_flag = FLAG_NOT_DELETED
894: AND parent_rule_folder_id IS NOT NULL
895: START WITH rule_folder_id = nRuleFolderId
896: AND object_type = 'RFL'

Line 919: FOR folder IN (SELECT name FROM cz_rule_folders

915: BEGIN
916: IF(inFolderId IS NULL OR inFolderId = -1)THEN RETURN inCompanionName; END IF;
917: IF(v_FuncQualifiedName.EXISTS(inFolderId))THEN RETURN v_FuncQualifiedName(inFolderId) || inCompanionName; END IF;
918: nameLen := LENGTHB(inCompanionName);
919: FOR folder IN (SELECT name FROM cz_rule_folders
920: WHERE deleted_flag = FLAG_NOT_DELETED
921: AND parent_rule_folder_id IS NOT NULL
922: START WITH rule_folder_id = inFolderId
923: CONNECT BY PRIOR parent_rule_folder_id = rule_folder_id)LOOP