APPS.IGS_PR_GEN_006 dependencies on IGS_PR_OU_TYPE

Line 1606: v_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE;

1602: PRAGMA EXCEPTION_INIT (e_record_locked, -54);
1603: v_message_text1 VARCHAR2(255) DEFAULT NULL;
1604: v_message_text2 VARCHAR2(255) DEFAULT NULL;
1605: v_message_level VARCHAR2(10) DEFAULT NULL;
1606: v_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE;
1607: v_spo_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE;
1608: v_unresolved_clash BOOLEAN DEFAULT FALSE;
1609: v_clash_type VARCHAR2(10);
1610: v_expire BOOLEAN;

Line 1616: igs_pr_ou_type pot

1612: v_dummy VARCHAR2(1);
1613: CURSOR c_spo1 IS
1614: SELECT pot.encumbrance_type
1615: FROM IGS_PR_STDNT_PR_OU spo,
1616: igs_pr_ou_type pot
1617: WHERE spo.person_id = p_person_id AND
1618: spo.course_cd = p_course_cd AND
1619: spo.sequence_number = p_spo_sequence_number AND
1620: pot.progression_outcome_type = spo.progression_outcome_type;

Line 1627: igs_pr_ou_type pot

1623: spo.progression_outcome_type,
1624: spo.expiry_dt,
1625: pot.encumbrance_type
1626: FROM IGS_PR_STDNT_PR_OU spo,
1627: igs_pr_ou_type pot
1628: WHERE spo.person_id = p_person_id AND
1629: spo.course_cd = p_course_cd AND
1630: spo.sequence_number <> p_spo_sequence_number AND
1631: spo.decision_status = cst_approved AND

Line 1640: cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS

1636: p_course_cd,
1637: spo.sequence_number,
1638: spo.expiry_dt) <> cst_expired;
1639: CURSOR c_pee (
1640: cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS
1641: SELECT 'X'
1642: FROM IGS_PE_PERSENC_EFFCT pee,
1643: IGS_PE_PERS_ENCUMB pen
1644: WHERE pen.person_id = p_person_id AND

Line 1669: cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS

1665: FOR UPDATE NOWAIT;
1666:
1667: v_spo_expire_rec c_spo_expire%ROWTYPE;
1668: CURSOR c_edte (
1669: cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS
1670: SELECT edte.s_encmb_effect_type
1671: FROM igs_fi_enc_dflt_eft edte
1672: WHERE edte.encumbrance_type = cp_encumbrance_type AND
1673: edte.s_encmb_effect_type IN (

Line 2564: igs_pr_ou_type pot,

2560: spo.expiry_dt,
2561: pot.encumbrance_type,
2562: att.closed_ind
2563: FROM IGS_PR_STDNT_PR_OU spo,
2564: igs_pr_ou_type pot,
2565: igs_en_atd_type att
2566: WHERE spo.person_id = p_person_id AND
2567: spo.course_cd = p_course_cd AND
2568: spo.sequence_number = p_spo_sequence_number AND

Line 2586: cp_encumbrance_type IGS_PR_OU_TYPE.encumbrance_type%TYPE) IS

2582: WHERE pen.person_id = p_person_id AND
2583: pen.spo_course_cd = p_course_cd AND
2584: pen.spo_sequence_number = p_spo_sequence_number;
2585: CURSOR c_etde (
2586: cp_encumbrance_type IGS_PR_OU_TYPE.encumbrance_type%TYPE) IS
2587: SELECT etde.s_encmb_effect_type
2588: FROM igs_fi_enc_dflt_eft etde
2589: WHERE etde.encumbrance_type = cp_encumbrance_type;
2590: