DBA Data[Home] [Help]

APPS.IGS_EN_GEN_009 dependencies on IGS_AS_SC_ATTEMPT_H

Line 1628: --stutta 11-Dec-2004 Replace insert_row of igs_as_sc_attempt_h_pkg with add_row. This is done

1624: -- Modified by rvangala
1625: -- Added 4 new parameters p_new_coo_id,p_old_coo_id,p_new_igs_pr_class_std_id,p_old_igs_pr_class_std_id
1626: --Change History:
1627: --Who When What
1628: --stutta 11-Dec-2004 Replace insert_row of igs_as_sc_attempt_h_pkg with add_row. This is done
1629: -- avoid record already exists msg when more than one history record is created
1630: -- within the same second. Bug # 4061929
1631: PROCEDURE Enrp_Ins_Sca_Hist(
1632: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

Line 1737: r_scah IGS_AS_SC_ATTEMPT_H%ROWTYPE;

1733: AS
1734:
1735: BEGIN
1736: DECLARE
1737: r_scah IGS_AS_SC_ATTEMPT_H%ROWTYPE;
1738: v_create_history BOOLEAN :=FALSE;
1739: v_fs_description IGS_FI_FUND_SRC.description%TYPE;
1740: v_elo_description IGS_AD_LOCATION.description%TYPE;
1741: v_fc_description IGS_FI_FEE_CAT.description%TYPE;

Line 2050: IGS_AS_SC_ATTEMPT_H_PKG.ADD_ROW (

2046: BEGIN
2047: -- ADD_ROW is used instead of INSERT_ROW, so that the history record is updated in
2048: -- case more than one history record is created within a second. More than one record
2049: -- are being created while recursive update_row of ps att table is performed.
2050: IGS_AS_SC_ATTEMPT_H_PKG.ADD_ROW (
2051: x_rowid => l_rowid,
2052: x_person_id => r_scah.person_id,
2053: x_course_cd => r_scah.course_cd,
2054: x_hist_start_dt => r_scah.hist_start_dt,