APPS.IGS_PS_GEN_001 dependencies on IGS_PS_GRP_MBR

Line 92: gv_cgm_rec IGS_PS_GRP_MBR%ROWTYPE;

88: gv_cao_rec IGS_PS_AWD_OWN%ROWTYPE;
89: gv_cow_rec IGS_PS_OWN%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;

Line 164: FROM IGS_PS_GRP_MBR

160: WHERE course_cd = p_old_course_cd AND
161: version_number = p_old_version_number;
162: CURSOR gc_cgm_rec IS
163: SELECT *
164: FROM IGS_PS_GRP_MBR
165: WHERE course_cd = p_old_course_cd AND
166: version_number = p_old_version_number;
167: CURSOR gc_fsr_rec IS
168: SELECT *

Line 1420: -- procedure for inserting new IGS_PS_GRP_MBR records

1416: ELSE
1417: App_Exception.Raise_Exception;
1418: END IF;
1419: END crsp_ins_ae_rec;
1420: -- procedure for inserting new IGS_PS_GRP_MBR records
1421: PROCEDURE crsp_ins_cgm_rec (
1422: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1423: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1424: BEGIN

Line 1426: IGS_PS_GRP_MBR_PKG.INSERT_ROW(

1422: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1423: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1424: BEGIN
1425: x_rowid := NULL;
1426: IGS_PS_GRP_MBR_PKG.INSERT_ROW(
1427: X_ROWID => x_rowid,
1428: X_COURSE_CD => p_new_course_cd,
1429: X_COURSE_GROUP_CD => gv_cgm_rec.course_group_cd,
1430: X_VERSION_NUMBER => p_new_version_number,

Line 1964: -- calling procedure to insert IGS_PS_GRP_MBR records

1960: EXIT;
1961: END IF;
1962: END LOOP;
1963: CLOSE gc_cfos_rec;
1964: -- calling procedure to insert IGS_PS_GRP_MBR records
1965: OPEN gc_cgm_rec;
1966: LOOP
1967: FETCH gc_cgm_rec INTO gv_cgm_rec;
1968: IF gc_cgm_rec%FOUND THEN