APPS.IGS_PR_GEN_004 dependencies on IGS_PR_STDNT_PR_AWD

Line 750: cp_person_id igs_pr_stdnt_pr_awd.person_id%TYPE,

746: pra2.logical_delete_dt IS NULL) ;
747: --FOR UPDATE NOWAIT; -- commented by Prajeesh
748:
749: CURSOR c_spa(
750: cp_person_id igs_pr_stdnt_pr_awd.person_id%TYPE,
751: cp_course_cd igs_pr_stdnt_pr_awd.course_cd%TYPE,
752: cp_spo_sequence_number igs_pr_stdnt_pr_awd.spo_sequence_number%TYPE) IS
753: SELECT spa.award_cd
754: FROM igs_pr_stdnt_pr_awd spa

Line 751: cp_course_cd igs_pr_stdnt_pr_awd.course_cd%TYPE,

747: --FOR UPDATE NOWAIT; -- commented by Prajeesh
748:
749: CURSOR c_spa(
750: cp_person_id igs_pr_stdnt_pr_awd.person_id%TYPE,
751: cp_course_cd igs_pr_stdnt_pr_awd.course_cd%TYPE,
752: cp_spo_sequence_number igs_pr_stdnt_pr_awd.spo_sequence_number%TYPE) IS
753: SELECT spa.award_cd
754: FROM igs_pr_stdnt_pr_awd spa
755: WHERE person_id = cp_person_id

Line 752: cp_spo_sequence_number igs_pr_stdnt_pr_awd.spo_sequence_number%TYPE) IS

748:
749: CURSOR c_spa(
750: cp_person_id igs_pr_stdnt_pr_awd.person_id%TYPE,
751: cp_course_cd igs_pr_stdnt_pr_awd.course_cd%TYPE,
752: cp_spo_sequence_number igs_pr_stdnt_pr_awd.spo_sequence_number%TYPE) IS
753: SELECT spa.award_cd
754: FROM igs_pr_stdnt_pr_awd spa
755: WHERE person_id = cp_person_id
756: AND course_cd = cp_course_cd

Line 754: FROM igs_pr_stdnt_pr_awd spa

750: cp_person_id igs_pr_stdnt_pr_awd.person_id%TYPE,
751: cp_course_cd igs_pr_stdnt_pr_awd.course_cd%TYPE,
752: cp_spo_sequence_number igs_pr_stdnt_pr_awd.spo_sequence_number%TYPE) IS
753: SELECT spa.award_cd
754: FROM igs_pr_stdnt_pr_awd spa
755: WHERE person_id = cp_person_id
756: AND course_cd = cp_course_cd
757: AND spa.spo_sequence_number = cp_spo_sequence_number;
758:

Line 3974: IGS_PR_STDNT_PR_AWD_PKG.INSERT_ROW (

3970: FOR v_poa_rec IN c_poa LOOP
3971: DECLARE
3972: LV_ROWID VARCHAR2(25);
3973: BEGIN
3974: IGS_PR_STDNT_PR_AWD_PKG.INSERT_ROW (
3975: X_ROWID =>lv_rowid,
3976: X_PERSON_ID => p_person_id,
3977: X_COURSE_CD => P_COURSE_CD,
3978: X_SPO_SEQUENCE_NUMBER =>v_spo_sequence_number,

Line 4360: FROM IGS_PR_STDNT_PR_AWD spaw

4356:
4357: CURSOR c_spaw (
4358: cp_sequence_number IGS_PR_SDT_PR_UNT_ST.spo_sequence_number%TYPE) IS
4359: SELECT spaw.ROWID
4360: FROM IGS_PR_STDNT_PR_AWD spaw
4361: WHERE spaw.person_id = p_person_id AND
4362: spaw.course_cd = p_course_cd AND
4363: spaw.spo_sequence_number = cp_sequence_number
4364: FOR UPDATE NOWAIT;

Line 4512: -- Delete from IGS_PR_STDNT_PR_AWD

4508: WHEN OTHERS THEN
4509: RAISE;
4510: END;
4511:
4512: -- Delete from IGS_PR_STDNT_PR_AWD
4513: BEGIN
4514: FOR v_spaw_rec IN c_spaw (v_spo_rec.sequence_number) LOOP
4515: IGS_PR_STDNT_PR_AWD_PKG.DELETE_ROW(
4516: v_spaw_rec.ROWID

Line 4515: IGS_PR_STDNT_PR_AWD_PKG.DELETE_ROW(

4511:
4512: -- Delete from IGS_PR_STDNT_PR_AWD
4513: BEGIN
4514: FOR v_spaw_rec IN c_spaw (v_spo_rec.sequence_number) LOOP
4515: IGS_PR_STDNT_PR_AWD_PKG.DELETE_ROW(
4516: v_spaw_rec.ROWID
4517: );
4518: END LOOP;
4519: EXCEPTION