APPS.IGS_PR_GEN_004 dependencies on IGS_PR_STDNT_PR_PS_PKG

Line 3878: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (

3874: v_poc_rec_found := TRUE;
3875: DECLARE
3876: LV_ROWID VARCHAR2(25);
3877: BEGIN
3878: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (
3879: X_ROWID =>LV_ROWID,
3880: X_PERSON_ID =>p_person_id,
3881: X_SPO_COURSE_CD => p_course_cd,
3882: X_SPO_SEQUENCE_NUMBER => v_spo_sequence_number,

Line 3899: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (

3895: -- the enrolled course
3896: DECLARE
3897: LV_ROWID VARCHAR2(25);
3898: BEGIN
3899: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (
3900: X_ROWID =>LV_ROWID,
3901: X_PERSON_ID =>p_person_id,
3902: X_SPO_COURSE_CD => p_course_cd,
3903: X_SPO_SEQUENCE_NUMBER => v_spo_sequence_number,

Line 4476: IGS_PR_STDNT_PR_PS_PKG.DELETE_ROW(

4472: IF v_spo_rec.decision_status = cst_pending THEN
4473: -- Delete from IGS_PR_STDNT_PR_PS
4474: BEGIN
4475: FOR v_spc_rec IN c_spc (v_spo_rec.sequence_number) LOOP
4476: IGS_PR_STDNT_PR_PS_PKG.DELETE_ROW(
4477: v_spc_rec.ROWID
4478: );
4479: END LOOP;
4480: EXCEPTION