DBA Data[Home] [Help]

APPS.IGS_RE_GEN_002 dependencies on IGS_RE_CDT_HIST

Line 1275: -- Description: Insert IGS_RE_CANDIDATURE history (IGS_RE_CDT_HIST)

1271: AS
1272: LV_ROWID VARCHAR2(25);
1273: v_org_id igs_re_cdt_att_hist.org_id%TYPE;
1274: BEGIN -- resp_ins_ca_hist
1275: -- Description: Insert IGS_RE_CANDIDATURE history (IGS_RE_CDT_HIST)
1276: v_org_id := IGS_GE_GEN_003.Get_Org_Id;
1277: DECLARE
1278: r_ch IGS_RE_CDT_HIST%ROWTYPE;
1279: v_create_history BOOLEAN := FALSE;

Line 1278: r_ch IGS_RE_CDT_HIST%ROWTYPE;

1274: BEGIN -- resp_ins_ca_hist
1275: -- Description: Insert IGS_RE_CANDIDATURE history (IGS_RE_CDT_HIST)
1276: v_org_id := IGS_GE_GEN_003.Get_Org_Id;
1277: DECLARE
1278: r_ch IGS_RE_CDT_HIST%ROWTYPE;
1279: v_create_history BOOLEAN := FALSE;
1280:
1281: BEGIN
1282: IF NVL(p_new_sca_course_cd, 'NULL') <>

Line 1338: IGS_RE_CDT_HIST_PKG.INSERT_ROW(

1334: r_ch.sequence_number := p_sequence_number;
1335: r_ch.hist_start_dt := p_old_update_on;
1336: r_ch.hist_end_dt := p_new_update_on;
1337: r_ch.hist_who := p_old_update_who;
1338: IGS_RE_CDT_HIST_PKG.INSERT_ROW(
1339: X_ROWID => LV_ROWID,
1340: X_person_id => r_ch.person_id,
1341: X_sequence_number => r_ch.sequence_number,
1342: X_hist_start_dt => r_ch.hist_start_dt,