APPS.IGS_AD_GEN_011 dependencies on IGS_AD_PS_APLINSTHST

Line 152: v_acaih_rec IGS_AD_PS_APLINSTHST%ROWTYPE;

148: BEGIN -- admp_ins_acai_hist
149: -- Routine to create a history for the IGS_AD_PS_APPL_INST table.
150: DECLARE
151: v_changed_flag BOOLEAN DEFAULT FALSE;
152: v_acaih_rec IGS_AD_PS_APLINSTHST%ROWTYPE;
153: lv_rowid VARCHAR2(25);
154: l_org_id NUMBER(15);
155: l_old_hist_start_dt VARCHAR2(2);
156: CURSOR c_old_hist_dt

Line 159: FROM IGS_AD_PS_APLINSTHST

155: l_old_hist_start_dt VARCHAR2(2);
156: CURSOR c_old_hist_dt
157: IS
158: SELECT 'x'
159: FROM IGS_AD_PS_APLINSTHST
160: WHERE person_id = p_person_id
161: AND admission_appl_number = p_admission_appl_number
162: AND nominated_course_cd = p_nominated_course_cd
163: AND sequence_number = p_sequence_number

Line 179: FROM IGS_AD_PS_APLINSTHST

175: -- end apadegal adtd001 igs.m
176:
177: CURSOR c_latest_hist_dt IS
178: SELECT MAX(hist_start_dt) max_hist_start_dt, MAX(hist_end_dt) max_hist_end_dt
179: FROM IGS_AD_PS_APLINSTHST
180: WHERE person_id = p_person_id
181: AND admission_appl_number = p_admission_appl_number
182: AND nominated_course_cd = p_nominated_course_cd
183: AND sequence_number = p_sequence_number;

Line 477: -- Create and IGS_AD_PS_APLINSTHST history record.

473:
474:
475:
476:
477: -- Create and IGS_AD_PS_APLINSTHST history record.
478: v_acaih_rec.person_id := p_person_id;
479: v_acaih_rec.admission_appl_number :=p_admission_appl_number;
480: v_acaih_rec.nominated_course_cd := p_nominated_course_cd;
481: v_acaih_rec.sequence_number := p_sequence_number;

Line 511: IGS_AD_PS_APLINSTHST_Pkg.Insert_Row (

507:
508:
509:
510: l_org_id := igs_ge_gen_003.get_org_id;
511: IGS_AD_PS_APLINSTHST_Pkg.Insert_Row (
512: X_Mode => 'R',
513: X_RowId => lv_rowid,
514: X_Person_Id => v_acaih_rec.person_id,
515: X_Admission_Appl_Number => v_acaih_rec.admission_appl_number,