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_INT

Line 17: igs_ps_sch_int_pkg.

13: As part of PSP Scheduling Interface Enhancements TD added a local procedure purge_schd_record.
14: Added a new public function get_enrollment_max
15: Added the columns preferred_region_code,no_set_day_ind to the call of igs_ps_usec_occurs_pkg.update_row
16: Added the columns preferred_region_code to the calls of insert_row and update_row of
17: igs_ps_sch_int_pkg.
18: (reverse chronological order - newest change first)
19: */
20:
21:

Line 213: FROM igs_ps_sch_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 *
213: FROM igs_ps_sch_int_all
214: WHERE int_usec_id=cp_int_usec_id;
215:
216: l_int_pat_id NUMBER;
217: l_valid_occur BOOLEAN;

Line 225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553

221: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;
222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;
224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;
225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553
226: l_int_sch_status igs_ps_sch_int_all.transaction_type%TYPE;
227: l_cal_type igs_ca_inst.cal_type%TYPE;
228: l_enrollment_maximum igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
229: l_enrollment_expected igs_ps_usec_lim_wlst.enrollment_expected%TYPE;

Line 226: l_int_sch_status igs_ps_sch_int_all.transaction_type%TYPE;

222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;
224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;
225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553
226: l_int_sch_status igs_ps_sch_int_all.transaction_type%TYPE;
227: l_cal_type igs_ca_inst.cal_type%TYPE;
228: l_enrollment_maximum igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
229: l_enrollment_expected igs_ps_usec_lim_wlst.enrollment_expected%TYPE;
230: l_override_enrollment_max igs_ps_usec_lim_wlst.override_enrollment_max%TYPE;

Line 234: l_trans_type igs_ps_sch_int_all.transaction_type%TYPE;

230: l_override_enrollment_max igs_ps_usec_lim_wlst.override_enrollment_max%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 ;

Line 904: l_int_occurs_id igs_ps_sch_int_all.int_occurs_id%TYPE;

900:
901: Who When What
902: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_pe_person_v with hz_parties for cursor instrs
903: ***************************************************************/
904: l_int_occurs_id igs_ps_sch_int_all.int_occurs_id%TYPE;
905: -- Get the reference code and reference code type
906: CURSOR ref_cd( l_usec_id igs_ps_usec_occurs.unit_section_occurrence_id%TYPE) IS
907: SELECT reference_code,
908: reference_code_description,

Line 966: -- Added the column preferred_region_code to the call igs_ps_sch_int_pkg.insert_row

962: END IF;
963:
964: -- The fields which are passed as NULL are OBSOLETE columns as per the Modified Scheduling Interface DLD 1.0
965: -- Enh bug #2833850.
966: -- Added the column preferred_region_code to the call igs_ps_sch_int_pkg.insert_row
967: INSERT INTO igs_ps_sch_int_all (
968: int_occurs_id ,
969: int_usec_id ,
970: calendar_type ,

Line 967: INSERT INTO igs_ps_sch_int_all (

963:
964: -- The fields which are passed as NULL are OBSOLETE columns as per the Modified Scheduling Interface DLD 1.0
965: -- Enh bug #2833850.
966: -- Added the column preferred_region_code to the call igs_ps_sch_int_pkg.insert_row
967: INSERT INTO igs_ps_sch_int_all (
968: int_occurs_id ,
969: int_usec_id ,
970: calendar_type ,
971: sequence_number ,

Line 1023: IGS_PS_SCH_INT_S.NEXTVAL,

1019: last_update_date ,
1020: last_update_login
1021: )
1022: VALUES (
1023: IGS_PS_SCH_INT_S.NEXTVAL,
1024: p_int_usec_id,
1025: NULL,
1026: NULL,
1027: P_trans_type,

Line 2599: l_transaction_type igs_ps_sch_int.transaction_type%TYPE;

2595: l_status igs_ps_usec_occurs.schedule_status%TYPE;
2596: l_unit_section_occurrence_id igs_ps_usec_occurs.unit_section_occurrence_id%TYPE;
2597: l_schedule_status igs_ps_usec_occurs.schedule_status%TYPE;
2598: l_inter_error_text igs_ps_usec_occurs.error_text%TYPE;
2599: l_transaction_type igs_ps_sch_int.transaction_type%TYPE;
2600: l_building_code igs_ps_usec_occurs.building_code%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;

Line 2614: l_set_scheduled_status igs_ps_sch_int_all.schedule_status%TYPE;

2610: l_thursday igs_ps_usec_occurs.thursday%TYPE;
2611: l_friday igs_ps_usec_occurs.friday%TYPE;
2612: l_saturday igs_ps_usec_occurs.saturday%TYPE;
2613: l_sunday igs_ps_usec_occurs.sunday%TYPE;
2614: l_set_scheduled_status igs_ps_sch_int_all.schedule_status%TYPE;
2615: l_set_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;
2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;
2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850
2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850

Line 2615: l_set_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;

2611: l_friday igs_ps_usec_occurs.friday%TYPE;
2612: l_saturday igs_ps_usec_occurs.saturday%TYPE;
2613: l_sunday igs_ps_usec_occurs.sunday%TYPE;
2614: l_set_scheduled_status igs_ps_sch_int_all.schedule_status%TYPE;
2615: l_set_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;
2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;
2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850
2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850
2619: l_c_t_cal_type igs_ca_inst_all.cal_type%TYPE;

Line 2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;

2612: l_saturday igs_ps_usec_occurs.saturday%TYPE;
2613: l_sunday igs_ps_usec_occurs.sunday%TYPE;
2614: l_set_scheduled_status igs_ps_sch_int_all.schedule_status%TYPE;
2615: l_set_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;
2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;
2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850
2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850
2619: l_c_t_cal_type igs_ca_inst_all.cal_type%TYPE;
2620: l_n_t_seq_num igs_ca_inst_all.sequence_number%TYPE;

Line 2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850

2613: l_sunday igs_ps_usec_occurs.sunday%TYPE;
2614: l_set_scheduled_status igs_ps_sch_int_all.schedule_status%TYPE;
2615: l_set_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;
2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;
2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850
2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850
2619: l_c_t_cal_type igs_ca_inst_all.cal_type%TYPE;
2620: l_n_t_seq_num igs_ca_inst_all.sequence_number%TYPE;
2621: l_n_t_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

Line 2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850

2614: l_set_scheduled_status igs_ps_sch_int_all.schedule_status%TYPE;
2615: l_set_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;
2616: l_tba_status igs_ps_sch_int_all.tba_status%TYPE;
2617: l_d_uso_start_date igs_ps_sch_int_all.unit_section_start_date%TYPE; -- Added as a part of Enh Bug #2833850
2618: l_d_uso_end_date igs_ps_sch_int_all.unit_section_end_date%TYPE; -- Added as a part of Enh Bug #2833850
2619: l_c_t_cal_type igs_ca_inst_all.cal_type%TYPE;
2620: l_n_t_seq_num igs_ca_inst_all.sequence_number%TYPE;
2621: l_n_t_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2622: l_b_print_cal BOOLEAN;

Line 2637: FROM igs_ps_sch_int_all ipsi, igs_ps_usec_occurs_all uso

2633: ORDER BY sui.calendar_type, sui.sequence_number, sui.uoo_id;
2634:
2635: CURSOR c_get_records_inter(cp_int_usec_id IN NUMBER) IS
2636: SELECT ipsi.rowid,ipsi.*
2637: FROM igs_ps_sch_int_all ipsi, igs_ps_usec_occurs_all uso
2638: WHERE ipsi.transaction_type IN ('REQUEST','UPDATE','CANCEL') AND ipsi.schedule_status IN ('OK','ERROR')
2639: AND ipsi.unit_section_occurrence_id=uso.unit_section_occurrence_id
2640: AND uso.schedule_status <> 'CANCELLED'
2641: AND uso.abort_flag = 'N'

Line 2710: p_n_int_uso_id igs_ps_sch_int_all.unit_section_occurrence_id%TYPE,

2706: l_check_ovrd check_ovrd%ROWTYPE;
2707:
2708:
2709: PROCEDURE update_info( p_n_prd_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
2710: p_n_int_uso_id igs_ps_sch_int_all.unit_section_occurrence_id%TYPE,
2711: p_c_sch_status igs_ps_usec_occurs_all.schedule_status%TYPE,
2712: p_c_trans_type igs_ps_sch_int_all.transaction_type%TYPE,
2713: p_n_bldg_cd igs_ps_usec_occurs_all.building_code%TYPE,
2714: p_n_room_cd igs_ps_usec_occurs_all.room_code%TYPE,

Line 2712: p_c_trans_type igs_ps_sch_int_all.transaction_type%TYPE,

2708:
2709: PROCEDURE update_info( p_n_prd_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
2710: p_n_int_uso_id igs_ps_sch_int_all.unit_section_occurrence_id%TYPE,
2711: p_c_sch_status igs_ps_usec_occurs_all.schedule_status%TYPE,
2712: p_c_trans_type igs_ps_sch_int_all.transaction_type%TYPE,
2713: p_n_bldg_cd igs_ps_usec_occurs_all.building_code%TYPE,
2714: p_n_room_cd igs_ps_usec_occurs_all.room_code%TYPE,
2715: p_d_uso_start_dt igs_ps_usec_occurs_all.start_date%TYPE,
2716: p_d_uso_end_dt igs_ps_usec_occurs_all.end_date%TYPE,

Line 2734: CURSOR c_int_uso (cp_n_uso_id igs_ps_sch_int_all.int_occurs_id%TYPE) IS

2730: SELECT rowid,uso.*
2731: FROM igs_ps_usec_occurs_all uso
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;

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 2763: l_c_trans_type igs_ps_sch_int_all.transaction_type%TYPE;

2759: l_n_prf_rom igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2760: l_n_ded_bld igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2761: l_n_ded_rom igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2762: l_c_sch_status igs_ps_usec_occurs_all.schedule_status%TYPE;
2763: l_c_trans_type igs_ps_sch_int_all.transaction_type%TYPE;
2764: l_c_err_text igs_ps_usec_occurs_all.error_text%TYPE;
2765: l_c_exists VARCHAR2(1);
2766:
2767: /*CURSOR check_ovrd IS

Line 2787: FROM igs_ps_sch_int_all

2783: l_import_done VARCHAR2(1);
2784:
2785: CURSOR cur_section_import(cp_int_usec_id IN NUMBER) IS
2786: SELECT 'X'
2787: FROM igs_ps_sch_int_all
2788: WHERE int_usec_id=cp_int_usec_id
2789: AND import_done_flag='N';
2790:
2791: CURSOR cur_pattern_import(cp_int_pat_id IN NUMBER) IS

Line 2949: UPDATE igs_ps_sch_int_all set transaction_type=p_c_trans_type,schedule_status=p_c_sch_status,error_text=p_c_err_text,

2945: ELSE
2946: l_import_done:= 'N';
2947: END IF;
2948: -- Update interface Occurrence table
2949: UPDATE igs_ps_sch_int_all set transaction_type=p_c_trans_type,schedule_status=p_c_sch_status,error_text=p_c_err_text,
2950: import_done_flag=l_import_done WHERE int_occurs_id = p_n_int_uso_id;
2951:
2952:
2953: IF l_import_done = 'Y' THEN

Line 3052: UPDATE igs_ps_sch_int_all set transaction_type=l_c_trans_type,schedule_status=l_c_sch_status,error_text=l_c_err_text

3048: );
3049:
3050: -- Update interface Occurrence table
3051: -- Update interface table (i.e. Transaction Type) by transaction status as 'INCOMPLETE' and Schedule status as 'ERROR'
3052: UPDATE igs_ps_sch_int_all set transaction_type=l_c_trans_type,schedule_status=l_c_sch_status,error_text=l_c_err_text
3053: WHERE int_occurs_id = p_n_int_uso_id;
3054:
3055: OPEN c_print_uso (p_n_prd_uso_id);
3056: FETCH c_print_uso INTO rec_print_uso;

Line 3086: tablenames_tbl(6) := 'IGS_PS_SCH_INT_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:
3090: FOR i IN 1.. tablenames_tbl.LAST

Line 3140: -- Cursor for fetching records from Interface Table(igs_ps_sch_int)

3136: app_exception.raise_exception;
3137: END IF;
3138: CLOSE c_get_originator; -- closing cursor for originator id
3139:
3140: -- Cursor for fetching records from Interface Table(igs_ps_sch_int)
3141: -- For each record fetched by the main Unit Section Details Cursor Loop,
3142: -- We Loop across the Scheduler Interface Details table.
3143:
3144: FOR fetch_records_inter IN c_get_records_inter(l_fetch_usec_inter.int_usec_id)

Line 3557: CURSOR c_int_uso_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,

3553: sommukhe 9-JAN-2006 Bug# 4869737,included call to igs_ge_gen_003.set_org_id
3554: ************************************************************************/
3555:
3556: --This cursor picks those occurrences from the interface table whose schedule status is null and filtered by the input parameters
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

Line 3558: cp_cal_type igs_ps_sch_int_all.calendar_type%type) IS

3554: ************************************************************************/
3555:
3556: --This cursor picks those occurrences from the interface table whose schedule status is null and filtered by the input parameters
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

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 3575: CURSOR c_int_usec_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,

3571: AND a.schedule_status IS NULL;
3572:
3573:
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

Line 3576: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE) IS

3572:
3573:
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

Line 3587: CURSOR c_int_pat_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,

3583: AND location_cd=NVL (p_location, us.location_cd)
3584: AND unit_class= NVL (p_unit_class, us.unit_class);
3585:
3586: --all the interface pattern records
3587: CURSOR c_int_pat_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3588: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE) IS
3589: SELECT pt.ROWID intrid,pt.*
3590: FROM igs_ps_sch_pat_int pt
3591: WHERE pt.calendar_type=cp_cal_type

Line 3588: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE) IS

3584: AND unit_class= NVL (p_unit_class, us.unit_class);
3585:
3586: --all the interface pattern records
3587: CURSOR c_int_pat_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3588: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE) IS
3589: SELECT pt.ROWID intrid,pt.*
3590: FROM igs_ps_sch_pat_int pt
3591: WHERE pt.calendar_type=cp_cal_type
3592: AND pt.sequence_number =cp_sequence_number

Line 3597: CURSOR c_int_uso (cp_n_int_usec_id igs_ps_sch_int_all.int_usec_id%TYPE) IS

3593: AND pt.unit_cd= NVL (p_unit_cd,pt.unit_cd)
3594: AND pt.version_number=NVL (p_version_number, pt.version_number);
3595:
3596:
3597: CURSOR c_int_uso (cp_n_int_usec_id igs_ps_sch_int_all.int_usec_id%TYPE) IS
3598: SELECT count(*)
3599: FROM igs_ps_sch_int_all a
3600: WHERE a.int_usec_id = cp_n_int_usec_id
3601: AND a.abort_flag = 'N';

Line 3599: FROM igs_ps_sch_int_all a

3595:
3596:
3597: CURSOR c_int_uso (cp_n_int_usec_id igs_ps_sch_int_all.int_usec_id%TYPE) IS
3598: SELECT count(*)
3599: FROM igs_ps_sch_int_all a
3600: WHERE a.int_usec_id = cp_n_int_usec_id
3601: AND a.abort_flag = 'N';
3602:
3603: c_int_uso_rec c_int_uso%ROWTYPE;

Line 3625: CURSOR c_prod_pat (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,

3621: WHERE a.uoo_id=cp_uoo_id;
3622:
3623: c_prod_usec_rec c_prod_usec%ROWTYPE;
3624:
3625: CURSOR c_prod_pat (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*

Line 3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,

3622:
3623: c_prod_usec_rec c_prod_usec%ROWTYPE;
3624:
3625: CURSOR c_prod_pat (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*
3630: FROM igs_ps_unit_ofr_pat_all pt

Line 3706: UPDATE igs_ps_sch_int_all SET abort_flag = 'Y'

3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );
3704: fnd_file.put_line(fnd_file.log,' ');
3705:
3706: UPDATE igs_ps_sch_int_all SET abort_flag = 'Y'
3707: WHERE ROWID = c_int_uso_ss_rec.intrid;
3708:
3709: OPEN c_int_uso_prod(c_int_uso_ss_rec.prodrid);
3710: FETCH c_int_uso_prod INTO c_int_uso_prod_rec;

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 4021: AND NOT EXISTS (SELECT 'X' FROM igs_ps_sch_int_all uso WHERE uso.int_usec_id=us.int_usec_id) ;

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) ;
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,

Line 4117: DELETE FROM igs_ps_sch_int_all WHERE int_occurs_id=rec_uso.int_occurs_id;

4113: DELETE FROM igs_ps_sch_faclt_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4114: DELETE FROM igs_ps_sch_instr_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4115:
4116: --Deleting the occurrence record
4117: DELETE FROM igs_ps_sch_int_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4118:
4119: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4120: || ' : ' || rec_uso.unit_cd );
4121: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )