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_USEC_OCCURS_ALL

Line 38: p_usec_occur_rec IN igs_ps_usec_occurs_all%ROWTYPE,

34: p_n_enrollment_maximum IN NUMBER);
35:
36: PROCEDURE log_usec_occurs (p_c_trans_type IN VARCHAR2,
37: p_n_lead_instructor_id IN NUMBER,
38: p_usec_occur_rec IN igs_ps_usec_occurs_all%ROWTYPE,
39: p_c_call IN VARCHAR2);
40:
41: PROCEDURE log_messages ( p_msg_name IN VARCHAR2,
42: p_msg_val IN VARCHAR2,

Line 127: cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

123: -- Modified the following cursor for Enh bug#2833850
124: -- Added the no_set_day_ind check in the where clause and also replaced the columns in the select statement with *.
125: -- Modified the following cursor for Enh Bug # 2918094. Removed schedule status 'PROCESSING' in the where clause.
126: CURSOR usec_occur(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
127: cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
128: SELECT *
129: FROM igs_ps_usec_occurs_all
130: WHERE uoo_id = l_uoo_id
131: AND no_set_day_ind = 'N'

Line 129: FROM igs_ps_usec_occurs_all

125: -- Modified the following cursor for Enh Bug # 2918094. Removed schedule status 'PROCESSING' in the where clause.
126: CURSOR usec_occur(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
127: cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
128: SELECT *
129: FROM igs_ps_usec_occurs_all
130: WHERE uoo_id = l_uoo_id
131: AND no_set_day_ind = 'N'
132: AND (unit_section_occurrence_id = cp_unit_section_occurrence_id OR cp_unit_section_occurrence_id IS NULL)
133: AND (

Line 151: cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,

147:
148: -- Check whether it is required to pass the unit section information to interface table or not.
149: -- for aborting occurrences no need to pass the unit section occurrence process.
150: CURSOR c_is_req (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
151: cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
152: cp_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE) IS
153: SELECT 'x'
154: FROM igs_ps_usec_occurs_all
155: WHERE NVL(schedule_status,'NULL') = DECODE(cp_unit_section_occurrence_id,NULL,cp_schedule_status,NVL(schedule_status,'NULL'))

Line 152: cp_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE) IS

148: -- Check whether it is required to pass the unit section information to interface table or not.
149: -- for aborting occurrences no need to pass the unit section occurrence process.
150: CURSOR c_is_req (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
151: cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
152: cp_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE) IS
153: SELECT 'x'
154: FROM igs_ps_usec_occurs_all
155: WHERE NVL(schedule_status,'NULL') = DECODE(cp_unit_section_occurrence_id,NULL,cp_schedule_status,NVL(schedule_status,'NULL'))
156: AND uoo_id = cp_n_uoo_id

Line 154: FROM igs_ps_usec_occurs_all

150: CURSOR c_is_req (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
151: cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
152: cp_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE) IS
153: SELECT 'x'
154: FROM igs_ps_usec_occurs_all
155: WHERE NVL(schedule_status,'NULL') = DECODE(cp_unit_section_occurrence_id,NULL,cp_schedule_status,NVL(schedule_status,'NULL'))
156: AND uoo_id = cp_n_uoo_id
157: AND no_set_day_ind = 'N'
158: AND (unit_section_occurrence_id = cp_unit_section_occurrence_id OR cp_unit_section_occurrence_id IS NULL)

Line 187: FROM igs_ps_usec_occurs_all

183:
184:
185: CURSOR c_occur_exists (cp_uoo_id IN NUMBER) IS
186: SELECT 'X'
187: FROM igs_ps_usec_occurs_all
188: WHERE uoo_id=cp_uoo_id;
189: l_c_var VARCHAR2(1);
190:
191: CURSOR c_section_int_exists(cp_int_pat_id IN NUMBER) IS

Line 939: FROM igs_ps_usec_occurs_all a,

935: -- Get the Facilities associated with the usec_id
936: CURSOR unit_facilities (l_usec_id igs_ps_usec_occurs.unit_section_occurrence_id%TYPE) IS
937: SELECT media_code,
938: media_description
939: FROM igs_ps_usec_occurs_all a,
940: igs_ps_unit_ofr_opt_all b,
941: igs_ps_unit_facility_v c
942: WHERE a.unit_section_occurrence_id = l_usec_id
943: AND a.uoo_id=b.uoo_id

Line 953: l_start_date igs_ps_usec_occurs_all.start_date%TYPE;

949: BEGIN
950:
951: -- Insert Unit Section Occurs Interface Records
952: DECLARE
953: l_start_date igs_ps_usec_occurs_all.start_date%TYPE;
954: l_end_date igs_ps_usec_occurs_all.end_date%TYPE;
955: BEGIN
956: IF p_usec_occur_rec.start_date IS NULL OR p_usec_occur_rec.end_date IS NULL THEN
957: l_start_date := p_uoo_cur_rec.cal_start_dt;

Line 954: l_end_date igs_ps_usec_occurs_all.end_date%TYPE;

950:
951: -- Insert Unit Section Occurs Interface Records
952: DECLARE
953: l_start_date igs_ps_usec_occurs_all.start_date%TYPE;
954: l_end_date igs_ps_usec_occurs_all.end_date%TYPE;
955: BEGIN
956: IF p_usec_occur_rec.start_date IS NULL OR p_usec_occur_rec.end_date IS NULL THEN
957: l_start_date := p_uoo_cur_rec.cal_start_dt;
958: l_end_date := p_uoo_cur_rec.cal_end_dt;

Line 1223: p_n_usec_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE ) AS

1219: PROCEDURE call_generic_transfer ( p_c_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1220: p_n_version_number IN igs_ps_unit_ver.version_number%TYPE,
1221: p_c_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1222: p_n_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1223: p_n_usec_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE ) AS
1224: /**********************************************************
1225: Created By : sarakshi
1226:
1227: Date Created By : 21-May-2005

Line 1261: FROM igs_ps_usec_occurs_all us

1257: l_cur_uoo_rec cur_prod_uoo%ROWTYPE;
1258:
1259: CURSOR cur_prod_uoo_occur(cp_unit_section_occurrence_id IN NUMBER) IS
1260: SELECT us.*,us.rowid
1261: FROM igs_ps_usec_occurs_all us
1262: WHERE us.unit_section_occurrence_id = cp_unit_section_occurrence_id;
1263: l_usec_occurs_rec cur_prod_uoo_occur%ROWTYPE;
1264:
1265: l_o_count NUMBER;

Line 1599: --UPDATE igs_ps_usec_occurs_all set abort_flag='N', schedule_status='PROCESSING',status_last_updated=SYSDATE,cancel_flag='N' where unit_section_occurrence_id=l_occurrence_prod_rec.unit_section_occurrence_id;

1595: x_occurrence_identifier => l_usec_occurs_rec.occurrence_identifier,
1596: x_abort_flag => 'N'
1597: );
1598:
1599: --UPDATE igs_ps_usec_occurs_all set abort_flag='N', schedule_status='PROCESSING',status_last_updated=SYSDATE,cancel_flag='N' where unit_section_occurrence_id=l_occurrence_prod_rec.unit_section_occurrence_id;
1600:
1601: END LOOP;
1602:
1603: END LOOP;

Line 1972: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;

1968: AND (schedule_status IS NULL OR schedule_status <> cp_c_schd_stat)
1969: AND NO_SET_DAY_IND ='N'
1970: FOR UPDATE NOWAIT;
1971:
1972: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;
1973: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
1974:
1975: BEGIN
1976:

Line 1973: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;

1969: AND NO_SET_DAY_IND ='N'
1970: FOR UPDATE NOWAIT;
1971:
1972: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;
1973: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
1974:
1975: BEGIN
1976:
1977: FOR c_usec_occurs_rec IN c_usec_occurs(p_uoo_id, schd_stat) LOOP

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 2653: FROM igs_ps_usec_occurs_all ipsuo

2649: WHERE transaction_id=p_transaction_id;
2650:
2651: CURSOR c_ipsuo(p_usec_id NUMBER) IS
2652: SELECT *
2653: FROM igs_ps_usec_occurs_all ipsuo
2654: WHERE unit_section_occurrence_id=p_usec_id
2655: FOR UPDATE NOWAIT;
2656:
2657:

Line 2709: PROCEDURE update_info( p_n_prd_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,

2705:
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,

Line 2711: p_c_sch_status igs_ps_usec_occurs_all.schedule_status%TYPE,

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,
2715: p_d_uso_start_dt igs_ps_usec_occurs_all.start_date%TYPE,

Line 2713: p_n_bldg_cd igs_ps_usec_occurs_all.building_code%TYPE,

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,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,

Line 2714: p_n_room_cd igs_ps_usec_occurs_all.room_code%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,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,

Line 2715: p_d_uso_start_dt igs_ps_usec_occurs_all.start_date%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,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,

Line 2716: p_d_uso_end_dt igs_ps_usec_occurs_all.end_date%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,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,

Line 2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%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,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,

Line 2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%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,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,

Line 2719: p_c_sunday igs_ps_usec_occurs_all.sunday%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,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,

Line 2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,

2716: p_d_uso_end_dt igs_ps_usec_occurs_all.end_date%TYPE,
2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,

Line 2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,

2717: p_d_uso_start_tm igs_ps_usec_occurs_all.start_time%TYPE,
2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,
2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,

Line 2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,

2718: p_d_uso_end_tm igs_ps_usec_occurs_all.end_time%TYPE,
2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,
2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,
2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,

Line 2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,

2719: p_c_sunday igs_ps_usec_occurs_all.sunday%TYPE,
2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,
2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,
2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,
2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE

Line 2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,

2720: p_c_monday igs_ps_usec_occurs_all.monday%TYPE,
2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,
2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,
2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,
2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE
2728: ) AS

Line 2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,

2721: p_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE,
2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,
2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,
2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,
2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE
2728: ) AS
2729: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

Line 2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,

2722: p_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE,
2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,
2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,
2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,
2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE
2728: ) AS
2729: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
2730: SELECT rowid,uso.*

Line 2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE

2723: p_c_thursday igs_ps_usec_occurs_all.thursday%TYPE,
2724: p_c_friday igs_ps_usec_occurs_all.friday%TYPE,
2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,
2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,
2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE
2728: ) AS
2729: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
2730: SELECT rowid,uso.*
2731: FROM igs_ps_usec_occurs_all uso

Line 2729: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

2725: p_c_saturday igs_ps_usec_occurs_all.saturday%TYPE,
2726: p_c_tba_uso igs_ps_usec_occurs_all.to_be_announced%TYPE,
2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE
2728: ) AS
2729: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_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:

Line 2731: FROM igs_ps_usec_occurs_all uso

2727: p_c_err_text igs_ps_usec_occurs_all.error_text%TYPE
2728: ) AS
2729: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_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

Line 2740: CURSOR c_print_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

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
2741: SELECT *
2742: FROM igs_ps_usec_occurs_all
2743: WHERE unit_section_occurrence_id=cp_n_uso_id;
2744:

Line 2742: FROM igs_ps_usec_occurs_all

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
2741: SELECT *
2742: FROM igs_ps_usec_occurs_all
2743: WHERE unit_section_occurrence_id=cp_n_uso_id;
2744:
2745: -- Bug #3060089. Cursor to check the unit section is non standard unit section or not.
2746: CURSOR c_nstd_us (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

Line 2746: CURSOR c_nstd_us (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

2742: FROM igs_ps_usec_occurs_all
2743: WHERE unit_section_occurrence_id=cp_n_uso_id;
2744:
2745: -- Bug #3060089. Cursor to check the unit section is non standard unit section or not.
2746: CURSOR c_nstd_us (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
2747: SELECT 'x'
2748: FROM igs_ps_usec_occurs_all uso,
2749: igs_ps_unit_ofr_opt_all uoo
2750: WHERE uoo.non_std_usec_ind = 'Y'

Line 2748: FROM igs_ps_usec_occurs_all uso,

2744:
2745: -- Bug #3060089. Cursor to check the unit section is non standard unit section or not.
2746: CURSOR c_nstd_us (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
2747: SELECT 'x'
2748: FROM igs_ps_usec_occurs_all uso,
2749: igs_ps_unit_ofr_opt_all uoo
2750: WHERE uoo.non_std_usec_ind = 'Y'
2751: AND uoo.uoo_id = uso.uoo_id
2752: AND uso.unit_section_occurrence_id=cp_n_uso_id;

Line 2757: l_c_prf_reg igs_ps_usec_occurs_all.preferred_region_code%TYPE;

2753:
2754: rec_prd_uso c_prd_uso%ROWTYPE;
2755: rec_int_uso c_int_uso%ROWTYPE;
2756: rec_print_uso c_print_uso%ROWTYPE;
2757: l_c_prf_reg igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2758: l_n_prf_bld igs_ps_usec_occurs_all.preferred_building_code%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;

Line 2758: l_n_prf_bld igs_ps_usec_occurs_all.preferred_building_code%TYPE;

2754: rec_prd_uso c_prd_uso%ROWTYPE;
2755: rec_int_uso c_int_uso%ROWTYPE;
2756: rec_print_uso c_print_uso%ROWTYPE;
2757: l_c_prf_reg igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2758: l_n_prf_bld igs_ps_usec_occurs_all.preferred_building_code%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;

Line 2759: l_n_prf_rom igs_ps_usec_occurs_all.preferred_room_code%TYPE;

2755: rec_int_uso c_int_uso%ROWTYPE;
2756: rec_print_uso c_print_uso%ROWTYPE;
2757: l_c_prf_reg igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2758: l_n_prf_bld igs_ps_usec_occurs_all.preferred_building_code%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;

Line 2760: l_n_ded_bld igs_ps_usec_occurs_all.dedicated_building_code%TYPE;

2756: rec_print_uso c_print_uso%ROWTYPE;
2757: l_c_prf_reg igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2758: l_n_prf_bld igs_ps_usec_occurs_all.preferred_building_code%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;

Line 2761: l_n_ded_rom igs_ps_usec_occurs_all.dedicated_room_code%TYPE;

2757: l_c_prf_reg igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2758: l_n_prf_bld igs_ps_usec_occurs_all.preferred_building_code%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);

Line 2762: l_c_sch_status igs_ps_usec_occurs_all.schedule_status%TYPE;

2758: l_n_prf_bld igs_ps_usec_occurs_all.preferred_building_code%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:

Line 2764: l_c_err_text igs_ps_usec_occurs_all.error_text%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
2768: SELECT day_ovrd_flag, time_ovrd_flag, scheduled_bld_ovrd_flag, scheduled_room_ovrd_flag

Line 2772: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;

2768: SELECT day_ovrd_flag, time_ovrd_flag, scheduled_bld_ovrd_flag, scheduled_room_ovrd_flag
2769: FROM igs_ps_sch_ocr_cfig;
2770:
2771: l_check_ovrd check_ovrd%ROWTYPE;
2772: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2773: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;

Line 2773: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;

2769: FROM igs_ps_sch_ocr_cfig;
2770:
2771: l_check_ovrd check_ovrd%ROWTYPE;
2772: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2773: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;

Line 2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;

2770:
2771: l_check_ovrd check_ovrd%ROWTYPE;
2772: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2773: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;

Line 2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;

2771: l_check_ovrd check_ovrd%ROWTYPE;
2772: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2773: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;

Line 2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;

2772: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2773: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;

Line 2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;

2773: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2781: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;

Line 2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;

2774: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2781: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
2782: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;*/

Line 2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;

2775: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2781: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
2782: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;*/
2783: l_import_done VARCHAR2(1);

Line 2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;

2776: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2781: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
2782: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;*/
2783: l_import_done VARCHAR2(1);
2784:

Line 2781: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;

2777: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2781: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
2782: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;*/
2783: l_import_done VARCHAR2(1);
2784:
2785: CURSOR cur_section_import(cp_int_usec_id IN NUMBER) IS

Line 2782: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;*/

2778: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2779: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2780: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2781: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
2782: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;*/
2783: l_import_done VARCHAR2(1);
2784:
2785: CURSOR cur_section_import(cp_int_usec_id IN NUMBER) IS
2786: SELECT 'X'

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 3613: FROM igs_ps_usec_occurs_all b

3609: AND a.abort_flag = 'N';
3610:
3611: CURSOR c_int_uso_prod (cp_rowid ROWID) IS
3612: SELECT b.ROWID prodrid,b.*
3613: FROM igs_ps_usec_occurs_all b
3614: WHERE rowid = cp_rowid;
3615:
3616: c_int_uso_prod_rec c_int_uso_prod%ROWTYPE;
3617:

Line 4368: p_usec_occur_rec IN igs_ps_usec_occurs_all%ROWTYPE,

4364: END log_usec_details;
4365:
4366: PROCEDURE log_usec_occurs (p_c_trans_type IN VARCHAR2,
4367: p_n_lead_instructor_id IN NUMBER,
4368: p_usec_occur_rec IN igs_ps_usec_occurs_all%ROWTYPE,
4369: p_c_call IN VARCHAR2) AS
4370: /**********************************************************************
4371: Created By : jbegum
4372:

Line 4560: FROM igs_ps_usec_occurs_all uso

4556: (reverse chronological order - newest change first)
4557: ************************************************************************/
4558: CURSOR c_occurs IS
4559: SELECT uso.*,uso.ROWID
4560: FROM igs_ps_usec_occurs_all uso
4561: WHERE unit_section_occurrence_id=p_unit_section_occurrence_id;
4562: l_usec_occurs_rec c_occurs%ROWTYPE;
4563:
4564: BEGIN