APPS.IGS_PS_GEN_001 dependencies on IGS_PS_REF_CD

Line 96: gv_crcd_rec IGS_PS_REF_CD%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;
99: gv_err_msg_proc VARCHAR2(255);
100: gv_err_msg_proc1 VARCHAR2(255);

Line 184: FROM IGS_PS_REF_CD

180: WHERE course_cd = p_old_course_cd AND
181: version_number = p_old_version_number;
182: CURSOR gc_crcd_rec IS
183: SELECT *
184: FROM IGS_PS_REF_CD
185: WHERE course_cd = p_old_course_cd AND
186: version_number = p_old_version_number;
187: CURSOR gc_cal_rec IS
188: SELECT *

Line 1518: -- procedure for inserting new IGS_PS_REF_CD records

1514: ELSE
1515: App_Exception.Raise_Exception;
1516: END IF;
1517: END crsp_ins_ccat_rec;
1518: -- procedure for inserting new IGS_PS_REF_CD records
1519: PROCEDURE crsp_ins_crcd_rec (
1520: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1521: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1522: BEGIN

Line 1524: IGS_PS_REF_CD_PKG.INSERT_ROW(

1520: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1521: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1522: BEGIN
1523: x_rowid := NULL;
1524: IGS_PS_REF_CD_PKG.INSERT_ROW(
1525: X_ROWID => x_rowid,
1526: X_COURSE_CD => p_new_course_cd,
1527: X_VERSION_NUMBER => p_new_version_number,
1528: X_REFERENCE_CD => gv_crcd_rec.reference_cd,

Line 1986: -- calling procedure to insert IGS_PS_REF_CD records

1982: EXIT;
1983: END IF;
1984: END LOOP;
1985: CLOSE gc_ccat_rec;
1986: -- calling procedure to insert IGS_PS_REF_CD records
1987: OPEN gc_crcd_rec;
1988: LOOP
1989: FETCH gc_crcd_rec INTO gv_crcd_rec;
1990: IF gc_crcd_rec%FOUND THEN