APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_NSC_PKG

Line 1: PACKAGE BODY IGS_EN_NSC_PKG AS

1: PACKAGE BODY IGS_EN_NSC_PKG AS
2: /* $Header: IGSEN87B.pls 120.7 2006/08/11 10:34:37 smaddali noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGS_EN_NSC_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGS_EN_NSC_PKG';

1: PACKAGE BODY IGS_EN_NSC_PKG AS
2: /* $Header: IGSEN87B.pls 120.7 2006/08/11 10:34:37 smaddali noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGS_EN_NSC_PKG';
6: g_debug_mode BOOLEAN := FALSE;
7: g_branch_id VARCHAR2(25);
8: g_school_id VARCHAR2(30);
9: g_include_gen VARCHAR2(1);

Line 409: AND child_org_unit_cd<>g_branch_id AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL

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
409: AND child_org_unit_cd<>g_branch_id AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL
410: START WITH child_org_unit_cd=cp_org_unit_cd
411: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;
412:
413:

Line 411: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;

407: WHERE parent_org_unit_cd=g_branch_id
408: CONNECT BY child_org_unit_cd=PRIOR parent_org_unit_cd
409: AND child_org_unit_cd<>g_branch_id AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL
410: START WITH child_org_unit_cd=cp_org_unit_cd
411: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;
412:
413:
414: --org needs to satisfy either c_validate_org_all or c_validate_org_all_inst if g_branch_id='00'
415: --c_validate_org_all returns 'Valid' only if there is path from the program org to the

Line 426: AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL

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'
424: AND ihp.institution_cd = g_school_id)
425: CONNECT BY child_org_unit_cd=PRIOR parent_org_unit_cd
426: AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL
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

Line 428: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;

424: AND ihp.institution_cd = g_school_id)
425: CONNECT BY child_org_unit_cd=PRIOR parent_org_unit_cd
426: AND igs_en_nsc_pkg.org_alt_check(child_org_unit_cd) IS NULL
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

Line 437: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;

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
436: AND ihp.institution_cd = g_school_id
437: AND igs_en_nsc_pkg.org_alt_check(cp_org_unit_cd) IS NULL;
438:
439:
440:
441: CURSOR c_org_unit_cd(g_branch_id VARCHAR2, l_branch_code VARCHAR2) IS

Line 3187: END IGS_EN_NSC_PKG;

3183: CLOSE c_alt_id;
3184: RETURN l_alt_id.org_structure_id;
3185: END org_alt_check ;
3186:
3187: END IGS_EN_NSC_PKG;