DBA Data[Home] [Help]

APPS.IGS_AD_GEN_011 dependencies on IGS_AD_PS_APPL_HIST

Line 645: v_acah_rec IGS_AD_PS_APPL_HIST%ROWTYPE;

641: BEGIN -- admp_ins_aca_hist
642: -- Routine to create a history for the IGS_AD_PS_APPL table.
643: DECLARE
644: v_changed_flag BOOLEAN DEFAULT FALSE;
645: v_acah_rec IGS_AD_PS_APPL_HIST%ROWTYPE;
646: lv_rowid VARCHAR2(25);
647: l_org_id NUMBER(15);
648: BEGIN
649: -- Check if any of the old IGS_AD_PS_APPL values are different from the

Line 690: -- Ceate an IGS_AD_PS_APPL_HIST history record.

686: v_acah_rec.nominated_course_cd := p_nominated_course_cd;
687: v_acah_rec.hist_start_dt := p_old_update_on;
688: v_acah_rec.hist_end_dt := p_new_update_on;
689: v_acah_rec.hist_who := p_old_update_who;
690: -- Ceate an IGS_AD_PS_APPL_HIST history record.
691: l_org_id := igs_ge_gen_003.get_org_id;
692: IGS_AD_PS_APPL_Hist_Pkg.Insert_Row (
693: X_Mode => 'R',
694: X_RowId => lv_rowid,

Line 692: IGS_AD_PS_APPL_Hist_Pkg.Insert_Row (

688: v_acah_rec.hist_end_dt := p_new_update_on;
689: v_acah_rec.hist_who := p_old_update_who;
690: -- Ceate an IGS_AD_PS_APPL_HIST history record.
691: l_org_id := igs_ge_gen_003.get_org_id;
692: IGS_AD_PS_APPL_Hist_Pkg.Insert_Row (
693: X_Mode => 'R',
694: X_RowId => lv_rowid,
695: X_Hist_Who => v_acah_rec.hist_who,
696: X_Transfer_Course_Cd => v_acah_rec.transfer_course_cd,