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_CA_TEACH_TO_LOAD_V

Line 524: FUNCTION check_call_number (p_teach_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,

520: END IF;
521: END IF;
522: END BeforeRowInsertUpdateDelete1;
523:
524: FUNCTION check_call_number (p_teach_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
525: p_teach_sequence_num igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE,
526: p_call_number igs_ps_unit_ofr_opt_pe_v.call_number%TYPE,
527: p_rowid VARCHAR2)
528: RETURN BOOLEAN AS

Line 525: p_teach_sequence_num igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE,

521: END IF;
522: END BeforeRowInsertUpdateDelete1;
523:
524: FUNCTION check_call_number (p_teach_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
525: p_teach_sequence_num igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE,
526: p_call_number igs_ps_unit_ofr_opt_pe_v.call_number%TYPE,
527: p_rowid VARCHAR2)
528: RETURN BOOLEAN AS
529: /*************************************************************

Line 541: CURSOR cur_teach_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,

537: to igs_pe_unit_ofr_opt_all in the cursor cur_detail.
538: (reverse chronological order - newest change first)
539: ***************************************************************/
540:
541: CURSOR cur_teach_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
542: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
543: SELECT load_cal_type,load_ci_sequence_number
544: FROM igs_ca_teach_to_load_v
545: WHERE teach_cal_type=cp_cal_type

Line 542: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS

538: (reverse chronological order - newest change first)
539: ***************************************************************/
540:
541: CURSOR cur_teach_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
542: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
543: SELECT load_cal_type,load_ci_sequence_number
544: FROM igs_ca_teach_to_load_v
545: WHERE teach_cal_type=cp_cal_type
546: AND teach_ci_sequence_number=cp_sequence_number;

Line 544: FROM igs_ca_teach_to_load_v

540:
541: CURSOR cur_teach_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
542: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
543: SELECT load_cal_type,load_ci_sequence_number
544: FROM igs_ca_teach_to_load_v
545: WHERE teach_cal_type=cp_cal_type
546: AND teach_ci_sequence_number=cp_sequence_number;
547:
548: CURSOR cur_load_teach(cp_cal_type igs_ca_load_to_teach_v.load_cal_type%TYPE,

Line 975: igs_ca_teach_to_load_v b

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
979: b.teach_ci_sequence_number = cp_n_seq_num

Line 987: igs_ca_teach_to_load_v b

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
991: b.teach_ci_sequence_number = cp_n_seq_num;

Line 1007: FROM igs_ca_teach_to_load_v

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
1008: WHERE
1009: teach_cal_type = cp_cal_type AND
1010: teach_ci_sequence_number = cp_seq_num;
1011:

Line 1611: CURSOR cur_teach_to_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,

1607: rgangara 07-May-2001 Added ss_enrol_ind column
1608: (reverse chronological order - newest change first)
1609: ***************************************************************/
1610: --Bug#2563596,Check that teach calendar is associated to a load calendar
1611: CURSOR cur_teach_to_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
1612: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE)
1613: IS
1614: SELECT load_cal_type,load_ci_sequence_number
1615: FROM igs_ca_teach_to_load_v

Line 1612: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE)

1608: (reverse chronological order - newest change first)
1609: ***************************************************************/
1610: --Bug#2563596,Check that teach calendar is associated to a load calendar
1611: CURSOR cur_teach_to_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
1612: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE)
1613: IS
1614: SELECT load_cal_type,load_ci_sequence_number
1615: FROM igs_ca_teach_to_load_v
1616: WHERE teach_cal_type=cp_cal_type

Line 1615: FROM igs_ca_teach_to_load_v

1611: CURSOR cur_teach_to_load(cp_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
1612: cp_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE)
1613: IS
1614: SELECT load_cal_type,load_ci_sequence_number
1615: FROM igs_ca_teach_to_load_v
1616: WHERE teach_cal_type=cp_cal_type
1617: AND teach_ci_sequence_number=cp_sequence_number;
1618: l_cur_teach_to_load cur_teach_to_load%ROWTYPE;
1619: