APPS.IGS_PR_GEN_004 dependencies on IGS_PR_STDNT_PR_OU_PKG

Line 1042: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

1038: show_cause_expiry_dt = v_spo_rec.show_cause_expiry_dt,
1039: appeal_expiry_dt = v_spo_rec.appeal_expiry_dt
1040: WHERE CURRENT OF c_spo;
1041: */
1042: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
1043: X_ROWID => v_spo_rec.ROWID,
1044: X_PERSON_ID => v_spo_rec.PERSON_ID,
1045: X_COURSE_CD => v_spo_rec.COURSE_CD,
1046: X_SEQUENCE_NUMBER => v_spo_rec.SEQUENCE_NUMBER,

Line 1090: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

1086: show_cause_expiry_dt = v_spo_rec.show_cause_expiry_dt,
1087: appeal_expiry_dt = v_spo_rec.appeal_expiry_dt
1088: WHERE CURRENT OF c_spo;
1089: */
1090: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
1091: X_ROWID => v_spo_rec.ROWID,
1092: X_PERSON_ID => v_spo_rec.PERSON_ID,
1093: X_COURSE_CD => v_spo_rec.COURSE_CD,
1094: X_SEQUENCE_NUMBER => v_spo_rec.SEQUENCE_NUMBER,

Line 1137: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

1133: SET applied_dt = NULL,
1134: expiry_dt = NULL
1135: WHERE CURRENT OF c_spo;
1136: */
1137: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
1138: X_ROWID => v_spo_rec.ROWID,
1139: X_PERSON_ID => v_spo_rec.PERSON_ID,
1140: X_COURSE_CD => v_spo_rec.COURSE_CD,
1141: X_SEQUENCE_NUMBER => v_spo_rec.SEQUENCE_NUMBER,

Line 3833: igs_pr_stdnt_pr_ou_pkg.insert_row (

3829: lv_rowid VARCHAR2(25);
3830: lv_org_id NUMBER(15);
3831: BEGIN
3832: lv_org_id := igs_ge_gen_003.get_org_id;
3833: igs_pr_stdnt_pr_ou_pkg.insert_row (
3834: x_rowid => lv_rowid,
3835: x_person_id => p_person_id,
3836: x_course_cd => p_course_cd,
3837: x_sequence_number => v_spo_sequence_number,

Line 4695: IGS_PR_STDNT_PR_OU_PKG.DELETE_ROW(

4691: EXIT;
4692: WHEN OTHERS THEN
4693: RAISE;
4694: END;
4695: IGS_PR_STDNT_PR_OU_PKG.DELETE_ROW(
4696: v_spo_rec.ROWID
4697: );
4698: ELSE
4699: -- Outcome has not yet been applied, so it can be removed

Line 4704: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

4700: /* UPDATE IGS_PR_STDNT_PR_OU spo
4701: SET spo.decision_status = cst_removed
4702: WHERE CURRENT OF c_spo;
4703: */
4704: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
4705: x_rowid => v_spo_rec.ROWID,
4706: x_person_id => v_spo_rec.person_id,
4707: x_course_cd => v_spo_rec.course_cd,
4708: x_sequence_number => v_spo_rec.sequence_number,

Line 6240: igs_pr_stdnt_pr_ou_pkg.update_row(

6236: UPDATE IGS_PR_STDNT_PR_OU
6237: SET applied_dt = cst_applied_dt
6238: WHERE CURRENT OF c_spo_upd;
6239: */
6240: igs_pr_stdnt_pr_ou_pkg.update_row(
6241: x_rowid => v_spo_upd_rec.ROWID,
6242: x_person_id => v_spo_upd_rec.person_id,
6243: x_course_cd => v_spo_upd_rec.course_cd,
6244: x_sequence_number => v_spo_upd_rec.sequence_number,

Line 6515: igs_pr_stdnt_pr_ou_pkg.update_row(

6511: SET expiry_dt = v_expiry_dt,
6512: applied_dt = igs_ge_date.igsdate('0001/01/01')
6513: WHERE CURRENT OF c_spo_upd;
6514: */
6515: igs_pr_stdnt_pr_ou_pkg.update_row(
6516: x_rowid => v_spo_upd_rec.ROWID,
6517: x_person_id => v_spo_upd_rec.person_id,
6518: x_course_cd => v_spo_upd_rec.course_cd,
6519: x_sequence_number => v_spo_upd_rec.sequence_number,