APPS.IGS_PS_GEN_001 dependencies on IGS_PS_PAT_STUDY_UNT

Line 30: -- added it to the insert row call of igs_ps_pat_study_unt_pkg

26: --vvutukur 01-Nov-2002 Enh#2636716.Modifications done in crsp_ins_unit_section.
27: --vvutukur 28-Oct-2002 Enh#2613933.Modifications done in crsp_ins_unit_section.
28: --shtatiko 21-OCT-2002 Added two parameters, program_length and program_length_measurement, to insert_row call of IGS_PS_OFR_OPT_PKG as per bug# 2608227.
29: --amuthu 24-Sep-02 added core_ind column to the cursor c_posu and also
30: -- added it to the insert row call of igs_ps_pat_study_unt_pkg
31: --jbegum 11-Sep-02 1)As part of bug#2563596 modified CURSOR us_req_refcd.
32: -- 2)Also added a for loop which inserts into the igs_ps_usec_ref_cd
33: -- all reference code records from old unit section to new unit section.
34: -- 3)Added an IF condition that checks if the function igs_ru_gen_002.rulp_ins_parser

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 920: v_posu_seq_num IGS_PS_PAT_STUDY_UNT.sequence_number%TYPE;

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;
924: CURSOR c_posp_seq_num IS

Line 925: SELECT IGS_PS_PAT_STUDY_UNT_POSPSEQ_S.NEXTVAL

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;
927: CURSOR c_posu_seq_num IS
928: SELECT IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S.NEXTVAL
929: FROM DUAL;

Line 928: SELECT IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S.NEXTVAL

924: CURSOR c_posp_seq_num IS
925: SELECT IGS_PS_PAT_STUDY_UNT_POSPSEQ_S.NEXTVAL
926: FROM DUAL;
927: CURSOR c_posu_seq_num IS
928: SELECT IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S.NEXTVAL
929: FROM DUAL;
930: CURSOR c_pos IS
931: SELECT pos.cal_type,
932: pos.sequence_number,

Line 972: FROM IGS_PS_PAT_STUDY_UNT posu

968: posu.unit_location_cd,
969: posu.unit_class,
970: posu.description,
971: posu.core_ind
972: FROM IGS_PS_PAT_STUDY_UNT posu
973: WHERE posu.course_cd = p_old_course_cd AND
974: posu.version_number = p_old_version_number AND
975: posu.cal_type = gv_co_rec.cal_type AND
976: posu.pos_sequence_number = cp_pos_seq_num AND

Line 1022: -- inserts into IGS_PS_PAT_STUDY_UNT table

1018: X_TEACH_CAL_TYPE => v_posp_rec.teach_cal_type,
1019: X_DESCRIPTION => v_posp_rec.description,
1020: X_MODE => 'R'
1021: );
1022: -- inserts into IGS_PS_PAT_STUDY_UNT table
1023: FOR v_posu_rec IN c_posu (
1024: v_pos_rec.sequence_number,
1025: v_posp_rec.sequence_number) LOOP
1026: OPEN c_posu_seq_num;

Line 1030: IGS_PS_PAT_STUDY_UNT_PKG.INSERT_ROW(

1026: OPEN c_posu_seq_num;
1027: FETCH c_posu_seq_num INTO v_posu_seq_num;
1028: CLOSE c_posu_seq_num;
1029: x_rowid := NULL;
1030: IGS_PS_PAT_STUDY_UNT_PKG.INSERT_ROW(
1031: X_ROWID => x_rowid,
1032: X_COURSE_CD => p_new_course_cd,
1033: X_VERSION_NUMBER => p_new_version_number,
1034: X_POS_SEQUENCE_NUMBER => v_pos_seq_num,