APPS.IGS_PS_GEN_001 dependencies on IGS_PS_ANL_LOAD_U_LN

Line 80: gv_calulink_rec IGS_PS_ANL_LOAD_U_LN%ROWTYPE;

76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%ROWTYPE;
77: gv_co_rec IGS_PS_OFR%ROWTYPE;
78: gv_coo_rec IGS_PS_OFR_OPT%ROWTYPE;
79: gv_ceprcd_rec IGS_PS_ENT_PT_REF_CD%ROWTYPE;
80: gv_calulink_rec IGS_PS_ANL_LOAD_U_LN%ROWTYPE;
81: gv_coi_rec IGS_PS_OFR_INST%ROWTYPE;
82: gv_cop_rec IGS_PS_OFR_PAT%ROWTYPE;
83: gv_copn_rec IGS_PS_OFR_PAT_NOTE%ROWTYPE;
84: gv_ref_num IGS_GE_NOTE.reference_number%TYPE;

Line 194: FROM IGS_PS_ANL_LOAD_U_LN

190: WHERE course_cd = p_old_course_cd AND
191: version_number = p_old_version_number;
192: CURSOR gc_calulink_rec IS
193: SELECT *
194: FROM IGS_PS_ANL_LOAD_U_LN
195: WHERE course_cd = p_old_course_cd AND
196: crv_version_number = p_old_version_number AND
197: yr_num = gv_cal_rec.yr_num AND
198: effective_start_dt = gv_cal_rec.effective_start_dt;

Line 1309: -- procedure for inserting new IGS_PS_ANL_LOAD_U_LN records

1305: ELSE
1306: App_Exception.Raise_Exception;
1307: END IF;
1308: END crsp_ins_cao_rec;
1309: -- procedure for inserting new IGS_PS_ANL_LOAD_U_LN records
1310: PROCEDURE crsp_ins_calulink_rec (
1311: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1312: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1313: BEGIN

Line 1315: IGS_PS_ANL_LOAD_U_LN_PKG.INSERT_ROW(

1311: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1312: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1313: BEGIN
1314: x_rowid := NULL;
1315: IGS_PS_ANL_LOAD_U_LN_PKG.INSERT_ROW(
1316: X_ROWID => x_rowid,
1317: X_COURSE_CD => p_new_course_cd,
1318: X_CRV_VERSION_NUMBER => p_new_version_number,
1319: X_EFFECTIVE_START_DT => gv_calulink_rec.effective_start_dt,

Line 1557: -- calling procedure to insert IGS_PS_ANL_LOAD_U_LN records

1553: X_EFFECTIVE_END_DT => gv_cal_rec.effective_end_dt,
1554: X_ANNUAL_LOAD_VAL => gv_cal_rec.annual_load_val,
1555: X_MODE => 'R'
1556: );
1557: -- calling procedure to insert IGS_PS_ANL_LOAD_U_LN records
1558: -- associated with each IGS_PS_ANL_LOAD record
1559: OPEN gc_calulink_rec;
1560: LOOP
1561: FETCH gc_calulink_rec INTO gv_calulink_rec;