APPS.IGS_GR_GEN_001 dependencies on IGS_GR_AWD_CRMN_HIST

Line 47: FROM igs_gr_awd_crmn_hist

43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
45: ) IS
46: SELECT person_id
47: FROM igs_gr_awd_crmn_hist
48: WHERE person_id = cp_person_id
49: AND create_dt = cp_create_dt
50: AND grd_cal_type = cp_grd_cal_type
51: AND grd_ci_sequence_number = cp_grd_ci_sequence_number

Line 106: FROM igs_gr_awd_crmn_hist

102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
103: ) IS
104: SELECT ROWID,
105: person_id
106: FROM igs_gr_awd_crmn_hist
107: WHERE person_id = cp_person_id
108: AND create_dt = cp_create_dt
109: AND grd_cal_type = cp_grd_cal_type
110: AND grd_ci_sequence_number = cp_grd_ci_sequence_number

Line 128: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);

124: p_award_course_cd,
125: p_award_crs_version_number,
126: p_award_cd
127: ) LOOP
128: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);
129: END LOOP;
130: --
131: RETURN TRUE;
132: END;

Line 282: FROM igs_gr_awd_crmn_hist gach

278: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
279: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
280: ) IS
281: SELECT ROWID
282: FROM igs_gr_awd_crmn_hist gach
283: WHERE gach.person_id = cp_gr_person_id
284: AND gach.create_dt = cp_gr_create_dt
285: AND gach.grd_cal_type = p_grd_cal_type
286: AND gach.grd_ci_sequence_number = p_grd_ci_sequence_number

Line 329: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);

325: --
326: -- 4.2 Delete any Graduand Award Ceremony History records found.
327: --
328: FOR v_gach_rec IN c_gach (v_gr_rec.person_id, v_gr_rec.create_dt) LOOP
329: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);
330: END LOOP;
331: --
332: EXCEPTION
333: WHEN e_resource_busy THEN

Line 769: v_gac_rec igs_gr_awd_crmn_hist%ROWTYPE;

765: );
766: END IF;
767: --
768: DECLARE
769: v_gac_rec igs_gr_awd_crmn_hist%ROWTYPE;
770: v_create_history BOOLEAN DEFAULT FALSE;
771: BEGIN
772: --
773: -- If any of the old values (p_old_) are different from the

Line 877: igs_gr_awd_crmn_hist_pkg.insert_row (

873: DECLARE
874: lv_rowid VARCHAR2 (25);
875: lv_seqnc NUMBER;
876: BEGIN
877: igs_gr_awd_crmn_hist_pkg.insert_row (
878: x_rowid => lv_rowid,
879: x_gach_id => lv_seqnc,
880: x_name_pronunciation => v_gac_rec.name_pronunciation,
881: x_name_announced => v_gac_rec.name_announced,