APPS.IGS_PS_GEN_001 dependencies on IGS_PS_PAT_OF_STUDY

Line 910: -- inserts into IGS_PS_PAT_OF_STUDY and its child tables including

906: ELSE
907: App_Exception.Raise_Exception;
908: END IF;
909: END crsp_ins_coi_rec;
910: -- inserts into IGS_PS_PAT_OF_STUDY and its child tables including
911: -- IGS_PS_PAT_STUDY_PRD and IGS_PS_PAT_STUDY_UNT
912: PROCEDURE crspl_ins_pos_rec
913: IS
914: --WHo When WHAT

Line 918: v_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE;

914: --WHo When WHAT
915: --sarakshi 15-May-2006 Bug#3460640,modified the call to IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW with correct values
916: BEGIN
917: DECLARE
918: v_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE;
919: v_posp_seq_num IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE;
920: v_posu_seq_num IGS_PS_PAT_STUDY_UNT.sequence_number%TYPE;
921: CURSOR c_pos_seq_num IS
922: SELECT IGS_PS_PAT_OF_STUDY_POS_NUM_S.NEXTVAL

Line 922: SELECT IGS_PS_PAT_OF_STUDY_POS_NUM_S.NEXTVAL

918: v_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE;
919: v_posp_seq_num IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE;
920: v_posu_seq_num IGS_PS_PAT_STUDY_UNT.sequence_number%TYPE;
921: CURSOR c_pos_seq_num IS
922: SELECT IGS_PS_PAT_OF_STUDY_POS_NUM_S.NEXTVAL
923: FROM DUAL;
924: CURSOR c_posp_seq_num IS
925: SELECT IGS_PS_PAT_STUDY_UNT_POSPSEQ_S.NEXTVAL
926: FROM DUAL;

Line 943: FROM IGS_PS_PAT_OF_STUDY pos

939: pos.aprvd_ci_sequence_number,
940: pos.number_of_periods,
941: pos.always_pre_enrol_ind,
942: pos.acad_perd_unit_set
943: FROM IGS_PS_PAT_OF_STUDY pos
944: WHERE pos.course_cd = p_old_course_cd AND
945: pos.version_number = p_old_version_number AND
946: pos.cal_type = gv_co_rec.cal_type;
947: CURSOR c_posp (

Line 948: cp_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE) IS

944: WHERE pos.course_cd = p_old_course_cd AND
945: pos.version_number = p_old_version_number AND
946: pos.cal_type = gv_co_rec.cal_type;
947: CURSOR c_posp (
948: cp_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE) IS
949: SELECT posp.cal_type,
950: posp.pos_sequence_number,
951: posp.sequence_number,
952: posp.acad_period_num,

Line 961: cp_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE,

957: posp.version_number = p_old_version_number AND
958: posp.cal_type = gv_co_rec.cal_type AND
959: posp.pos_sequence_number = cp_pos_seq_num;
960: CURSOR c_posu (
961: cp_pos_seq_num IGS_PS_PAT_OF_STUDY.sequence_number%TYPE,
962: cp_posp_seq_num IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE) IS
963: SELECT posu.cal_type,
964: posu.pos_sequence_number,
965: posu.posp_sequence_number,

Line 985: IGS_PS_PAT_OF_STUDY_PKG.INSERT_ROW(

981: OPEN c_pos_seq_num;
982: FETCH c_pos_seq_num INTO v_pos_seq_num;
983: CLOSE c_pos_seq_num;
984: X_ROWID := NULL;
985: IGS_PS_PAT_OF_STUDY_PKG.INSERT_ROW(
986: X_ROWID => x_rowid,
987: X_COURSE_CD => p_new_course_cd,
988: X_CAL_TYPE => v_pos_rec.cal_type,
989: X_VERSION_NUMBER => p_new_version_number,

Line 1275: -- calling procedure to insert IGS_PS_PAT_OF_STUDY records

1271: EXIT;
1272: END IF;
1273: END LOOP;
1274: CLOSE gc_con_rec;
1275: -- calling procedure to insert IGS_PS_PAT_OF_STUDY records
1276: crspl_ins_pos_rec;
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: IF (SQLCODE >= cst_max_error_range AND SQLCODE <= cst_min_error_range) THEN