DBA Data[Home] [Help]

APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_EN_WLST_GEN_PROC

Line 789: Igs_En_Wlst_Gen_Proc.enrp_wlst_pri_pref_calc(new_references.person_id,

785: AND NVL(old_references.unit_attempt_status,'UNCONFIRM') <> new_references.unit_attempt_status
786: AND new_references.waitlist_dt IS NOT NULL
787: AND new_references.administrative_priority IS NULL
788: AND new_references.wlst_priority_weight_num IS NULL) THEN
789: Igs_En_Wlst_Gen_Proc.enrp_wlst_pri_pref_calc(new_references.person_id,
790: new_references.course_cd,
791: new_references.uoo_id,
792: l_pri_weight,
793: l_pref_weight);

Line 1239: -- The uniqueness will be validated by the the new function igs_en_wlst_gen_proc.enrp_resequence_wlst();

1235: END BeforeRowInsertUpdateDelete1;
1236: -- Procedure for checking the uniqueness
1237: PROCEDURE Check_Uniqueness AS
1238: -- The Unique key has been commented as part of the bug fix 2554109
1239: -- The uniqueness will be validated by the the new function igs_en_wlst_gen_proc.enrp_resequence_wlst();
1240: BEGIN
1241:
1242: /*This Uk check was added as part of MUS build, # 2829262*/
1243: IF Get_Uk_For_Validation(x_unit_cd => new_references.unit_cd,

Line 2665: Igs_En_Wlst_Gen_proc.enrp_wlst_assign_pos(new_references.person_id,new_references.course_cd,new_references.uoo_id);

2661: AND new_references.wlst_preference_weight_num IS NOT NULL
2662: AND new_references.unit_attempt_status = 'WAITLISTED'
2663: AND new_references.administrative_priority IS NULL
2664: THEN
2665: Igs_En_Wlst_Gen_proc.enrp_wlst_assign_pos(new_references.person_id,new_references.course_cd,new_references.uoo_id);
2666: END IF;
2667:
2668: ELSIF (p_action = 'UPDATE') THEN
2669:

Line 2800: Igs_En_Wlst_Gen_proc.enrp_wlst_assign_pos(new_references.person_id,new_references.course_cd,new_references.uoo_id);

2796: AND new_references.wlst_preference_weight_num IS NOT NULL
2797: AND new_references.unit_attempt_status = 'WAITLISTED'
2798: AND new_references.administrative_priority IS NULL
2799: THEN
2800: Igs_En_Wlst_Gen_proc.enrp_wlst_assign_pos(new_references.person_id,new_references.course_cd,new_references.uoo_id);
2801: END IF;
2802:
2803: END IF;
2804: