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_USEC_SCHEDULE dependencies on IGS_PS_SCH_USEC_INT_ALL

Line 193: FROM igs_ps_sch_usec_int_all

189: l_c_var VARCHAR2(1);
190:
191: CURSOR c_section_int_exists(cp_int_pat_id IN NUMBER) IS
192: SELECT 'X'
193: FROM igs_ps_sch_usec_int_all
194: WHERE int_pat_id = cp_int_pat_id;
195:
196: CURSOR c_pattern_int_exists(cp_transaction_id IN NUMBER) IS
197: SELECT 'X'

Line 208: FROM igs_ps_sch_usec_int_all

204: WHERE transaction_id=cp_transaction_id;
205:
206: CURSOR c_section(cp_int_pat_id IN NUMBER) IS
207: SELECT *
208: FROM igs_ps_sch_usec_int_all
209: WHERE int_pat_id=cp_int_pat_id;
210:
211: CURSOR c_occurrence(cp_int_usec_id IN NUMBER) IS
212: SELECT *

Line 235: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE;

231: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
232: l_start_date igs_ca_inst.start_dt%TYPE;
233: l_end_date igs_ca_inst.end_dt%TYPE;
234: l_trans_type igs_ps_sch_int_all.transaction_type%TYPE;
235: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE;
236: l_max_enr_meet_grp igs_ps_uso_clas_meet_v.enrollment_maximum%TYPE;
237: l_lead_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE;
238: l_surname igs_pe_person.surname%TYPE ;
239: l_given_names igs_pe_person.given_names%TYPE ;

Line 658: -- Insert Unit Section Occurs Interface Records (IGS_PS_SCH_USEC_INT_ALL)

654: -- and l_override_enrollment_max respectively.
655:
656: get_enrollment_lmts(p_uoo_cur_rec.uoo_id);
657:
658: -- Insert Unit Section Occurs Interface Records (IGS_PS_SCH_USEC_INT_ALL)
659: BEGIN
660: INSERT INTO igs_ps_sch_usec_int_all (
661: int_usec_id ,
662: calendar_type ,

Line 660: INSERT INTO igs_ps_sch_usec_int_all (

656: get_enrollment_lmts(p_uoo_cur_rec.uoo_id);
657:
658: -- Insert Unit Section Occurs Interface Records (IGS_PS_SCH_USEC_INT_ALL)
659: BEGIN
660: INSERT INTO igs_ps_sch_usec_int_all (
661: int_usec_id ,
662: calendar_type ,
663: sequence_number ,
664: unit_cd ,

Line 2605: l_trans_id igs_ps_sch_usec_int_all.transaction_id%TYPE;

2601: l_room_code igs_ps_usec_occurs.room_code%TYPE;
2602: l_start_time igs_ps_usec_occurs.start_time%TYPE;
2603: l_end_time igs_ps_usec_occurs.end_time%TYPE;
2604: l_error_text igs_ps_usec_occurs.error_text%TYPE;
2605: l_trans_id igs_ps_sch_usec_int_all.transaction_id%TYPE;
2606: --Added By Bayadav as a part of Nov,2001 SI Build
2607: l_monday igs_ps_usec_occurs.monday%TYPE;
2608: l_tuesday igs_ps_usec_occurs.tuesday%TYPE;
2609: l_wednesday igs_ps_usec_occurs.wednesday%TYPE;

Line 2630: FROM igs_ps_sch_usec_int_all sui

2626: l_valid_rec_for_prod BOOLEAN := FALSE;
2627:
2628: CURSOR c_get_usec_inter IS
2629: SELECT sui.*
2630: FROM igs_ps_sch_usec_int_all sui
2631: WHERE sui.import_done_flag = 'N'
2632: FOR UPDATE NOWAIT
2633: ORDER BY sui.calendar_type, sui.sequence_number, sui.uoo_id;
2634:

Line 2736: FROM igs_ps_sch_int_all uso, igs_ps_sch_usec_int_all usec

2732: WHERE uso.unit_section_occurrence_id=cp_n_uso_id;
2733:
2734: CURSOR c_int_uso (cp_n_uso_id igs_ps_sch_int_all.int_occurs_id%TYPE) IS
2735: SELECT uso.rowid, uso.*, usec.int_pat_id
2736: FROM igs_ps_sch_int_all uso, igs_ps_sch_usec_int_all usec
2737: WHERE uso.int_usec_id = usec.int_usec_id
2738: AND uso.int_occurs_id = cp_n_uso_id;
2739:
2740: CURSOR c_print_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

Line 2793: FROM igs_ps_sch_usec_int_all

2789: AND import_done_flag='N';
2790:
2791: CURSOR cur_pattern_import(cp_int_pat_id IN NUMBER) IS
2792: SELECT 'X'
2793: FROM igs_ps_sch_usec_int_all
2794: WHERE int_pat_id=cp_int_pat_id
2795: AND import_done_flag='N';
2796: l_c_var VARCHAR2(1);
2797:

Line 2958: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = rec_int_uso.int_usec_id;

2954: --Update the interface section import_done_flag
2955: OPEN cur_section_import(rec_int_uso.int_usec_id);
2956: FETCH cur_section_import INTO l_c_var;
2957: IF cur_section_import%NOTFOUND THEN
2958: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = rec_int_uso.int_usec_id;
2959: END IF;
2960: CLOSE cur_section_import;
2961:
2962: --Update the interface pattern import_done_flag

Line 3085: tablenames_tbl(5) := 'IGS_PS_SCH_USEC_INT_ALL';

3081: tablenames_tbl(1) := 'IGS_PS_SCH_INSTR_ALL';
3082: tablenames_tbl(2) := 'IGS_PS_SCH_MWC_ALL';
3083: tablenames_tbl(3) := 'IGS_PS_SCH_FACLT_ALL';
3084: tablenames_tbl(4) := 'IGS_PS_SCH_X_USEC_INT_ALL';
3085: tablenames_tbl(5) := 'IGS_PS_SCH_USEC_INT_ALL';
3086: tablenames_tbl(6) := 'IGS_PS_SCH_INT_ALL';
3087: tablenames_tbl(7) := 'IGS_PS_PREFS_SCH_INT_ALL';
3088: tablenames_tbl(8) := 'IGS_PS_SCH_HDR_INT_ALL';
3089:

Line 3561: FROM igs_ps_sch_int_all a,Igs_ps_usec_occurs_all b, igs_ps_sch_usec_int_all c

3557: CURSOR c_int_uso_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3558: cp_cal_type igs_ps_sch_int_all.calendar_type%type) IS
3559: SELECT a.ROWID intrid,a.*,b.ROWID prodrid,
3560: c.unit_cd UNIT_CODE,c.version_number UNIT_VERSION_NUMBER,c.location_cd LOCATION_CODE,c.unit_class UNIT_CLS
3561: FROM igs_ps_sch_int_all a,Igs_ps_usec_occurs_all b, igs_ps_sch_usec_int_all c
3562: WHERE a.unit_section_occurrence_id=b.unit_section_occurrence_id
3563: AND a.int_usec_id = c.int_usec_id
3564: AND c.calendar_type=cp_cal_type
3565: AND c.sequence_number =cp_sequence_number

Line 3578: FROM igs_ps_sch_usec_int_all us

3574: --all the interface section records
3575: CURSOR c_int_usec_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3576: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE) IS
3577: SELECT us.ROWID intrid,us.*
3578: FROM igs_ps_sch_usec_int_all us
3579: WHERE calendar_type=cp_cal_type
3580: AND sequence_number = cp_sequence_number
3581: AND unit_cd= NVL (p_unit_cd, us.unit_cd)
3582: AND version_number=NVL (p_version_number, us.version_number)

Line 3605: CURSOR c_int_usec (cp_n_int_pat_id igs_ps_sch_usec_int_all.int_pat_id%TYPE) IS

3601: AND a.abort_flag = 'N';
3602:
3603: c_int_uso_rec c_int_uso%ROWTYPE;
3604:
3605: CURSOR c_int_usec (cp_n_int_pat_id igs_ps_sch_usec_int_all.int_pat_id%TYPE) IS
3606: SELECT count(*)
3607: FROM igs_ps_sch_usec_int_all a
3608: WHERE a.int_pat_id = cp_n_int_pat_id
3609: AND a.abort_flag = 'N';

Line 3607: FROM igs_ps_sch_usec_int_all a

3603: c_int_uso_rec c_int_uso%ROWTYPE;
3604:
3605: CURSOR c_int_usec (cp_n_int_pat_id igs_ps_sch_usec_int_all.int_pat_id%TYPE) IS
3606: SELECT count(*)
3607: FROM igs_ps_sch_usec_int_all a
3608: WHERE a.int_pat_id = cp_n_int_pat_id
3609: AND a.abort_flag = 'N';
3610:
3611: CURSOR c_int_uso_prod (cp_rowid ROWID) IS

Line 3818: UPDATE igs_ps_sch_usec_int_all SET abort_flag = l_abort_flag

3814: END IF;
3815:
3816:
3817: --update the interface table
3818: UPDATE igs_ps_sch_usec_int_all SET abort_flag = l_abort_flag
3819: WHERE ROWID =c_int_usec_ss_rec.intrid ;
3820:
3821: --update the production table
3822: OPEN c_prod_usec(c_int_usec_ss_rec.uoo_id);

Line 3996: CURSOR c_uso( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,

3992: WHERE cal_type=cp_cal_type
3993: AND sequence_number=cp_sequence_number;
3994:
3995: -- cursor to select occurrence interface records for purging
3996: CURSOR c_uso( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
3997: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
3998: cp_completed VARCHAR2,
3999: cp_cancelled VARCHAR2,
4000: cp_aborted VARCHAR2) IS

Line 3997: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,

3993: AND sequence_number=cp_sequence_number;
3994:
3995: -- cursor to select occurrence interface records for purging
3996: CURSOR c_uso( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
3997: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
3998: cp_completed VARCHAR2,
3999: cp_cancelled VARCHAR2,
4000: cp_aborted VARCHAR2) IS
4001:

Line 4003: FROM igs_ps_sch_int_all uso, igs_ps_sch_usec_int_all us

3999: cp_cancelled VARCHAR2,
4000: cp_aborted VARCHAR2) IS
4001:
4002: SELECT uso.int_occurs_id int_occurs_id,uso.occurrence_identifier, us.unit_cd, us.version_number, us.unit_class, us.location_cd
4003: FROM igs_ps_sch_int_all uso, igs_ps_sch_usec_int_all us
4004: WHERE us.calendar_type= cp_c_cal_type
4005: AND us.sequence_number=cp_n_seq_num
4006: AND us.int_usec_id = uso.int_usec_id
4007: AND ((uso.transaction_type = 'COMPLETE' AND cp_completed ='Y')

Line 4013: CURSOR c_usec( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,

4009: OR (uso.abort_flag = 'Y' AND cp_aborted ='Y'))
4010: AND (uso.import_done_flag = 'Y' OR (uso.import_done_flag='N' AND (uso.abort_flag = 'Y' AND cp_aborted ='Y')));
4011:
4012: -- cursor to select section interface records for purging
4013: CURSOR c_usec( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
4014: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
4015: cp_aborted VARCHAR2) IS
4016: SELECT us.int_usec_id, us.unit_cd, us.version_number, us.unit_class, us.location_cd
4017: FROM igs_ps_sch_usec_int_all us

Line 4014: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,

4010: AND (uso.import_done_flag = 'Y' OR (uso.import_done_flag='N' AND (uso.abort_flag = 'Y' AND cp_aborted ='Y')));
4011:
4012: -- cursor to select section interface records for purging
4013: CURSOR c_usec( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
4014: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
4015: cp_aborted VARCHAR2) IS
4016: SELECT us.int_usec_id, us.unit_cd, us.version_number, us.unit_class, us.location_cd
4017: FROM igs_ps_sch_usec_int_all us
4018: WHERE us.calendar_type= cp_c_cal_type

Line 4017: FROM igs_ps_sch_usec_int_all us

4013: CURSOR c_usec( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
4014: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
4015: cp_aborted VARCHAR2) IS
4016: SELECT us.int_usec_id, us.unit_cd, us.version_number, us.unit_class, us.location_cd
4017: FROM igs_ps_sch_usec_int_all us
4018: WHERE us.calendar_type= cp_c_cal_type
4019: AND us.sequence_number=cp_n_seq_num
4020: AND (import_done_flag = 'Y' OR (import_done_flag='N' AND (us.abort_flag = 'Y' AND cp_aborted ='Y')))
4021: AND NOT EXISTS (SELECT 'X' FROM igs_ps_sch_int_all uso WHERE uso.int_usec_id=us.int_usec_id) ;

Line 4025: CURSOR c_pat( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,

4021: AND NOT EXISTS (SELECT 'X' FROM igs_ps_sch_int_all uso WHERE uso.int_usec_id=us.int_usec_id) ;
4022:
4023:
4024: -- cursor to select section interface records for purging
4025: CURSOR c_pat( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
4026: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
4027: cp_aborted VARCHAR2) IS
4028: SELECT pat.int_pat_id, pat.unit_cd,pat.version_number
4029: FROM igs_ps_sch_pat_int pat

Line 4026: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,

4022:
4023:
4024: -- cursor to select section interface records for purging
4025: CURSOR c_pat( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
4026: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
4027: cp_aborted VARCHAR2) IS
4028: SELECT pat.int_pat_id, pat.unit_cd,pat.version_number
4029: FROM igs_ps_sch_pat_int pat
4030: WHERE pat.calendar_type= cp_c_cal_type

Line 4033: AND NOT EXISTS (SELECT 'X' FROM igs_ps_sch_usec_int_all us WHERE us.int_pat_id=pat.int_pat_id) ;

4029: FROM igs_ps_sch_pat_int pat
4030: WHERE pat.calendar_type= cp_c_cal_type
4031: AND pat.sequence_number=cp_n_seq_num
4032: AND (import_done_flag = 'Y' OR (import_done_flag='N' AND (pat.abort_flag = 'Y' AND cp_aborted ='Y')))
4033: AND NOT EXISTS (SELECT 'X' FROM igs_ps_sch_usec_int_all us WHERE us.int_pat_id=pat.int_pat_id) ;
4034:
4035: CURSOR c_header IS
4036: SELECT hdr.transaction_id
4037: FROM igs_ps_sch_hdr_int hdr

Line 4156: DELETE FROM igs_ps_sch_usec_int_all WHERE int_usec_id=rec_usec.int_usec_id;

4152: DELETE FROM igs_ps_sch_x_usec_int_all WHERE int_usec_id=rec_usec.int_usec_id;
4153: DELETE FROM igs_ps_sch_mwc_all WHERE int_usec_id=rec_usec.int_usec_id;
4154:
4155: -- Deleting unit section record
4156: DELETE FROM igs_ps_sch_usec_int_all WHERE int_usec_id=rec_usec.int_usec_id;
4157:
4158:
4159: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4160: || ' : ' || rec_usec.unit_cd );