APPS.IGS_PS_GEN_001 dependencies on IGS_PS_ANL_LOAD

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 97: gv_cal_rec IGS_PS_ANL_LOAD%ROWTYPE;

93: gv_fsr_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;
94: gv_cfos_rec IGS_PS_FIELD_STUDY%ROWTYPE;
95: gv_ccat_rec IGS_PS_CATEGORISE%ROWTYPE;
96: gv_crcd_rec IGS_PS_REF_CD%ROWTYPE;
97: gv_cal_rec IGS_PS_ANL_LOAD%ROWTYPE;
98: gv_revseg_rec IGS_PS_ACCTS%ROWTYPE;
99: gv_err_msg_proc VARCHAR2(255);
100: gv_err_msg_proc1 VARCHAR2(255);
101: gv_err_msg_proc2 VARCHAR2(255);

Line 189: FROM IGS_PS_ANL_LOAD

185: WHERE course_cd = p_old_course_cd AND
186: version_number = p_old_version_number;
187: CURSOR gc_cal_rec IS
188: SELECT *
189: FROM IGS_PS_ANL_LOAD
190: WHERE course_cd = p_old_course_cd AND
191: version_number = p_old_version_number;
192: CURSOR gc_calulink_rec IS
193: SELECT *

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 1541: -- procedure for inserting new IGS_PS_ANL_LOAD records

1537: ELSE
1538: App_Exception.Raise_Exception;
1539: END IF;
1540: END crsp_ins_crcd_rec;
1541: -- procedure for inserting new IGS_PS_ANL_LOAD records
1542: PROCEDURE crsp_ins_cal_rec (
1543: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1544: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1545: BEGIN

Line 1547: IGS_PS_ANL_LOAD_PKG.INSERT_ROW(

1543: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1544: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1545: BEGIN
1546: x_rowid := NULL;
1547: IGS_PS_ANL_LOAD_PKG.INSERT_ROW(
1548: X_ROWID => x_rowid,
1549: X_VERSION_NUMBER => p_new_version_number,
1550: X_COURSE_CD => p_new_course_cd,
1551: X_YR_NUM => gv_cal_rec.yr_num,

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;

Line 1558: -- associated with each IGS_PS_ANL_LOAD record

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;
1562: IF gc_calulink_rec%FOUND THEN

Line 1997: -- calling procedure to insert IGS_PS_ANL_LOAD records

1993: EXIT;
1994: END IF;
1995: END LOOP;
1996: CLOSE gc_crcd_rec;
1997: -- calling procedure to insert IGS_PS_ANL_LOAD records
1998: OPEN gc_cal_rec;
1999: LOOP
2000: FETCH gc_cal_rec INTO gv_cal_rec;
2001: IF gc_cal_rec%FOUND THEN