APPS.IGS_PS_GEN_001 dependencies on IGS_PS_CATEGORISE

Line 95: gv_ccat_rec IGS_PS_CATEGORISE%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;
99: gv_err_msg_proc VARCHAR2(255);

Line 179: FROM IGS_PS_CATEGORISE

175: WHERE course_cd = p_old_course_cd AND
176: version_number = p_old_version_number;
177: CURSOR gc_ccat_rec IS
178: SELECT *
179: FROM IGS_PS_CATEGORISE
180: WHERE course_cd = p_old_course_cd AND
181: version_number = p_old_version_number;
182: CURSOR gc_crcd_rec IS
183: SELECT *

Line 1493: -- procedure for inserting new IGS_PS_CATEGORISE records

1489: ELSE
1490: App_Exception.Raise_Exception;
1491: END IF;
1492: END crsp_ins_cfos_rec;
1493: -- procedure for inserting new IGS_PS_CATEGORISE records
1494: PROCEDURE crsp_ins_ccat_rec (
1495: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1496: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1497:

Line 1502: IGS_PS_CATEGORISE_PKG.INSERT_ROW(

1498: l_org_id NUMBER(15);
1499: BEGIN
1500: x_rowid := NULL;
1501: l_org_id := IGS_GE_GEN_003.GET_ORG_ID;
1502: IGS_PS_CATEGORISE_PKG.INSERT_ROW(
1503: X_ROWID => x_rowid,
1504: X_COURSE_CD => p_new_course_cd,
1505: X_VERSION_NUMBER => p_new_version_number,
1506: X_COURSE_CAT => gv_ccat_rec.course_cat,

Line 1975: -- calling procedure to insert IGS_PS_CATEGORISE records

1971: EXIT;
1972: END IF;
1973: END LOOP;
1974: CLOSE gc_cgm_rec;
1975: -- calling procedure to insert IGS_PS_CATEGORISE records
1976: OPEN gc_ccat_rec;
1977: LOOP
1978: FETCH gc_ccat_rec INTO gv_ccat_rec;
1979: IF gc_ccat_rec%FOUND THEN