APPS.IGS_PS_GEN_001 dependencies on IGS_PS_FIELD_STUDY

Line 94: gv_cfos_rec IGS_PS_FIELD_STUDY%ROWTYPE;

90: gv_cvn_rec IGS_PS_VER_NOTE%ROWTYPE;
91: gv_ae_rec IGS_PE_ALTERNATV_EXT%ROWTYPE;
92: gv_cgm_rec IGS_PS_GRP_MBR%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;

Line 174: FROM IGS_PS_FIELD_STUDY

170: WHERE course_cd = p_old_course_cd AND
171: version_number = p_old_version_number;
172: CURSOR gc_cfos_rec IS
173: SELECT *
174: FROM IGS_PS_FIELD_STUDY
175: WHERE course_cd = p_old_course_cd AND
176: version_number = p_old_version_number;
177: CURSOR gc_ccat_rec IS
178: SELECT *

Line 1470: -- procedure for inserting new IGS_PS_FIELD_STUDY records

1466: ELSE
1467: App_Exception.Raise_Exception;
1468: END IF;
1469: END crsp_ins_fsr_rec;
1470: -- procedure for inserting new IGS_PS_FIELD_STUDY records
1471: PROCEDURE crsp_ins_cfos_rec (
1472: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1473: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1474: BEGIN

Line 1476: IGS_PS_FIELD_STUDY_PKG.INSERT_ROW(

1472: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1473: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1474: BEGIN
1475: x_rowid := NULL;
1476: IGS_PS_FIELD_STUDY_PKG.INSERT_ROW(
1477: X_ROWID => x_rowid,
1478: X_COURSE_CD => p_new_course_cd,
1479: X_FIELD_OF_STUDY => gv_cfos_rec.field_of_study,
1480: X_VERSION_NUMBER => p_new_version_number,

Line 1953: -- calling procedure to insert IGS_PS_FIELD_STUDY records

1949: EXIT;
1950: END IF;
1951: END LOOP;
1952: CLOSE gc_fsr_rec;
1953: -- calling procedure to insert IGS_PS_FIELD_STUDY records
1954: OPEN gc_cfos_rec;
1955: LOOP
1956: FETCH gc_cfos_rec INTO gv_cfos_rec;
1957: IF gc_cfos_rec%FOUND THEN