[Home] [Help]
400: --the only condition where this cursor return wrong result is if g_branch_id=cp_org_unit_cd and and alt_id is defined.
401: --this is checked before calling the cursor.
402: --The condition after the connect by stops the recursion when the Branch org is reached and prunes branches with alt ids
403: --The where clause filters the final hierarchy to see if te Branch org has been reached.
404: CURSOR c_validate_org_branch (cp_org_unit_cd igs_or_unit_v.org_unit_cd%TYPE) IS
405: SELECT cst_valid
406: FROM igs_or_unit_rel
407: WHERE parent_org_unit_cd=g_branch_id
408: CONNECT BY child_org_unit_cd=PRIOR parent_org_unit_cd
415: --c_validate_org_all returns 'Valid' only if there is path from the program org to the
416: --one of orgs in the institution (with none of the orgs in the pat having alt_ids)
417: --The condition after the connect by prunes branches with alt ids
418: --The where clause filters the final hierarchy to see if a branch org under the institution has been reached.
419: CURSOR c_validate_org_all (cp_org_unit_cd igs_or_unit_v.org_unit_cd%TYPE) IS
420: SELECT cst_valid
421: FROM igs_or_unit_rel
422: WHERE parent_org_unit_cd IN (SELECT ihp.oss_org_unit_cd org_unit_cd FROM hz_parties hp, igs_pe_hz_parties ihp
423: WHERE hp.party_id = ihp.party_id AND ihp.inst_org_ind = 'O'
427: START WITH child_org_unit_cd=cp_org_unit_cd
428: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;
429:
430: --c_validate_org_all_inst returns valid if org is directly under the institution
431: CURSOR c_validate_org_all_inst (cp_org_unit_cd igs_or_unit_v.org_unit_cd%TYPE) IS
432: SELECT cst_valid FROM hz_parties hp, igs_pe_hz_parties ihp
433: WHERE hp.party_id = ihp.party_id AND ihp.inst_org_ind = 'O'
434: AND ihp.oss_org_unit_cd = cp_org_unit_cd
435: AND ihp.party_id = hp.party_id