eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_PS_USEC_CAL_NUMS

Line 970: -- in the table igs_ps_usec_cal_nums

966: FUNCTION get_call_number ( p_c_cal_type IN igs_ca_type.cal_type%TYPE,
967: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE ) RETURN NUMBER AS
968:
969: -- Cursor to lock all the load calendars for the given teaching calendar instance
970: -- in the table igs_ps_usec_cal_nums
971: CURSOR c_loc_cal_num (cp_c_cal_type IN VARCHAR2,
972: cp_n_seq_num IN NUMBER) IS
973: SELECT call_number
974: FROM igs_ps_usec_cal_nums a,

Line 974: FROM igs_ps_usec_cal_nums a,

970: -- in the table igs_ps_usec_cal_nums
971: CURSOR c_loc_cal_num (cp_c_cal_type IN VARCHAR2,
972: cp_n_seq_num IN NUMBER) IS
973: SELECT call_number
974: FROM igs_ps_usec_cal_nums a,
975: igs_ca_teach_to_load_v b
976: WHERE a.calender_type = b.load_cal_type AND
977: a.ci_sequence_number = b.load_ci_sequence_number AND
978: b.teach_cal_type = cp_c_cal_type AND

Line 986: FROM igs_ps_usec_cal_nums a,

982: -- Cursor to get the maximum call number across different load calendars for the given teaching calendar instance
983: CURSOR c_max_cal_num (cp_c_cal_type IN VARCHAR2,
984: cp_n_seq_num IN NUMBER) IS
985: SELECT MAX(call_number)
986: FROM igs_ps_usec_cal_nums a,
987: igs_ca_teach_to_load_v b
988: WHERE a.calender_type = b.load_cal_type AND
989: a.ci_sequence_number = b.load_ci_sequence_number AND
990: b.teach_cal_type = cp_c_cal_type AND

Line 993: -- Cursor to get the information of igs_ps_usec_cal_nums record, for updating the record

989: a.ci_sequence_number = b.load_ci_sequence_number AND
990: b.teach_cal_type = cp_c_cal_type AND
991: b.teach_ci_sequence_number = cp_n_seq_num;
992:
993: -- Cursor to get the information of igs_ps_usec_cal_nums record, for updating the record
994: CURSOR c_call_number ( cp_cal_type igs_ca_type.cal_type%TYPE,
995: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
996: SELECT rowid ROW_ID, unit_section_call_number_id call_id
997: FROM igs_ps_usec_cal_nums

Line 997: FROM igs_ps_usec_cal_nums

993: -- Cursor to get the information of igs_ps_usec_cal_nums record, for updating the record
994: CURSOR c_call_number ( cp_cal_type igs_ca_type.cal_type%TYPE,
995: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
996: SELECT rowid ROW_ID, unit_section_call_number_id call_id
997: FROM igs_ps_usec_cal_nums
998: WHERE calender_type = cp_cal_type AND
999: ci_sequence_number = cp_seq_num;
1000:
1001: rec_call_number c_call_number%ROWTYPE;

Line 1003: -- Cursor to get load claendar instance information for creating new records in igs_ps_usec_cal_nums

999: ci_sequence_number = cp_seq_num;
1000:
1001: rec_call_number c_call_number%ROWTYPE;
1002:
1003: -- Cursor to get load claendar instance information for creating new records in igs_ps_usec_cal_nums
1004: CURSOR c_teach_to_load ( cp_cal_type igs_ca_type.cal_type%TYPE,
1005: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
1006: SELECT load_cal_type lcal_type, load_ci_sequence_number lseq_num
1007: FROM igs_ca_teach_to_load_v

Line 1013: l_n_max_cal_num igs_ps_usec_cal_nums.call_number%TYPE;

1009: teach_cal_type = cp_cal_type AND
1010: teach_ci_sequence_number = cp_seq_num;
1011:
1012: -- Gets the maximum call number
1013: l_n_max_cal_num igs_ps_usec_cal_nums.call_number%TYPE;
1014: l_c_rowid ROWID;
1015: l_n_usc_number_id igs_ps_usec_cal_nums.unit_section_call_number_id%TYPE;
1016:
1017: BEGIN

Line 1015: l_n_usc_number_id igs_ps_usec_cal_nums.unit_section_call_number_id%TYPE;

1011:
1012: -- Gets the maximum call number
1013: l_n_max_cal_num igs_ps_usec_cal_nums.call_number%TYPE;
1014: l_c_rowid ROWID;
1015: l_n_usc_number_id igs_ps_usec_cal_nums.unit_section_call_number_id%TYPE;
1016:
1017: BEGIN
1018:
1019: SAVEPOINT IGS_PS_USEC_CAL_NUMS;

Line 1019: SAVEPOINT IGS_PS_USEC_CAL_NUMS;

1015: l_n_usc_number_id igs_ps_usec_cal_nums.unit_section_call_number_id%TYPE;
1016:
1017: BEGIN
1018:
1019: SAVEPOINT IGS_PS_USEC_CAL_NUMS;
1020:
1021: OPEN c_loc_cal_num (p_c_cal_type,p_n_seq_num);
1022: FETCH c_loc_cal_num INTO l_n_max_cal_num;
1023: CLOSE c_loc_cal_num;

Line 1038: igs_ps_usec_cal_nums_pkg.update_row( x_mode => 'R',

1034: FOR rec_teach_to_load IN c_teach_to_load(p_c_cal_type,p_n_seq_num) LOOP
1035: OPEN c_call_number (rec_teach_to_load.lcal_type,rec_teach_to_load.lseq_num);
1036: FETCH c_call_number INTO rec_call_number;
1037: IF c_call_number%FOUND THEN
1038: igs_ps_usec_cal_nums_pkg.update_row( x_mode => 'R',
1039: x_rowid => rec_call_number.row_id,
1040: x_unit_section_call_number_id => rec_call_number.call_id,
1041: x_calender_type => rec_teach_to_load.lcal_type,
1042: x_ci_sequence_number => rec_teach_to_load.lseq_num,

Line 1048: igs_ps_usec_cal_nums_pkg.insert_row ( x_rowid => l_c_rowid,

1044:
1045: ELSE
1046: l_c_rowid := NULL;
1047: l_n_usc_number_id := NULL;
1048: igs_ps_usec_cal_nums_pkg.insert_row ( x_rowid => l_c_rowid,
1049: x_unit_section_call_number_id => l_n_usc_number_id,
1050: x_calender_type => rec_teach_to_load.lcal_type,
1051: x_ci_sequence_number => rec_teach_to_load.lseq_num,
1052: x_call_number => l_n_max_cal_num,

Line 1062: ROLLBACK TO IGS_PS_USEC_CAL_NUMS;

1058: RETURN l_n_max_cal_num;
1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: ROLLBACK TO IGS_PS_USEC_CAL_NUMS;
1063: RETURN -1;
1064: END get_call_number;
1065:
1066: PROCEDURE get_ufk_for_validation (