APPS.IGS_PS_GEN_001 dependencies on IGS_PS_PAT_STUDY_PRD

Line 911: -- IGS_PS_PAT_STUDY_PRD and IGS_PS_PAT_STUDY_UNT

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
915: --sarakshi 15-May-2006 Bug#3460640,modified the call to IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW with correct values

Line 915: --sarakshi 15-May-2006 Bug#3460640,modified the call to IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW with correct values

911: -- IGS_PS_PAT_STUDY_PRD and IGS_PS_PAT_STUDY_UNT
912: PROCEDURE crspl_ins_pos_rec
913: IS
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;

Line 919: v_posp_seq_num IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE;

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
923: FROM DUAL;

Line 955: FROM IGS_PS_PAT_STUDY_PRD posp

951: posp.sequence_number,
952: posp.acad_period_num,
953: posp.teach_cal_type,
954: posp.description
955: FROM IGS_PS_PAT_STUDY_PRD posp
956: WHERE posp.course_cd = p_old_course_cd AND
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;

Line 962: cp_posp_seq_num IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE) IS

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,
966: posu.sequence_number,

Line 1010: IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW(

1006: OPEN c_posp_seq_num;
1007: FETCH c_posp_seq_num INTO v_posp_seq_num;
1008: CLOSE c_posp_seq_num;
1009: x_rowid := NULL;
1010: IGS_PS_PAT_STUDY_PRD_PKG.INSERT_ROW(
1011: X_ROWID => x_rowid,
1012: X_COURSE_CD => p_new_course_cd,
1013: X_VERSION_NUMBER => p_new_version_number,
1014: X_POS_SEQUENCE_NUMBER => v_pos_seq_num,--this is the FK