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.

[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_OCCURS_ALL

Line 56: TYPE uso_tbl_type IS TABLE OF igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE INDEX BY BINARY_INTEGER;

52: ********************************************************************************************** */
53:
54: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
55: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
56: TYPE uso_tbl_type IS TABLE OF igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE INDEX BY BINARY_INTEGER;
57: l_tbl_uso uso_tbl_type;
58:
59:
60:

Line 6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;

6057: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6063:
6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;
6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;

Line 6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;

6058: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
6059: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6063:
6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;
6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;

Line 6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;

6060: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6063:
6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;
6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
6067:
6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;

Line 6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;

6061: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6063:
6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;
6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
6067:
6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;
6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;

Line 6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;

6062: l_n_usec_occurs_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
6063:
6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;
6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
6067:
6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;
6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
6070: l_n_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;

Line 6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;

6064: l_n_building_code igs_ps_usec_occurs_all.building_code%TYPE;
6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
6067:
6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;
6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
6070: l_n_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
6071:
6072: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;

Line 6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;

6065: l_n_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
6067:
6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;
6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
6070: l_n_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
6071:
6072: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
6073: l_notify_status igs_ps_usec_occurs_all.notify_status%TYPE;

Line 6070: l_n_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;

6066: l_n_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
6067:
6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;
6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
6070: l_n_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
6071:
6072: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
6073: l_notify_status igs_ps_usec_occurs_all.notify_status%TYPE;
6074:

Line 6072: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;

6068: l_n_room_code igs_ps_usec_occurs_all.room_code%TYPE;
6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
6070: l_n_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
6071:
6072: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
6073: l_notify_status igs_ps_usec_occurs_all.notify_status%TYPE;
6074:
6075: l_insert_update VARCHAR2(1);
6076: l_n_tbl_cnt NUMBER;

Line 6073: l_notify_status igs_ps_usec_occurs_all.notify_status%TYPE;

6069: l_n_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
6070: l_n_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
6071:
6072: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
6073: l_notify_status igs_ps_usec_occurs_all.notify_status%TYPE;
6074:
6075: l_insert_update VARCHAR2(1);
6076: l_n_tbl_cnt NUMBER;
6077:

Line 6459: FROM igs_ps_usec_occurs_all

6455: FUNCTION check_insert_update ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) RETURN VARCHAR2 IS
6456:
6457: CURSOR c_occr IS
6458: SELECT unit_section_occurrence_id
6459: FROM igs_ps_usec_occurs_all
6460: WHERE uoo_id = l_n_uoo_id
6461: AND occurrence_identifier=p_uso_rec.occurrence_identifier;
6462:
6463: l_c_occr c_occr%ROWTYPE;

Line 6483: FROM igs_ps_usec_occurs_all

6479:
6480: PROCEDURE assign_defaults ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type, p_insert IN VARCHAR2) IS
6481: CURSOR cur_usec_ocurs ( cp_uso_id IN NUMBER) IS
6482: SELECT *
6483: FROM igs_ps_usec_occurs_all
6484: WHERE unit_section_occurrence_id = cp_uso_id;
6485: l_cur_usec_ocurs cur_usec_ocurs%ROWTYPE;
6486:
6487: CURSOR cur_room (cp_building_id IN NUMBER, cp_room_cd IN VARCHAR2) IS

Line 6998: INSERT INTO igs_ps_usec_occurs_all

6994:
6995: IF p_tab_usec_occur(I).status = 'S' THEN
6996: IF l_insert_update = 'I' THEN
6997: /* Insert Record */
6998: INSERT INTO igs_ps_usec_occurs_all
6999: (unit_section_occurrence_id,
7000: uoo_id,
7001: monday,
7002: tuesday,

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

7121: ELSE
7122:
7123: DECLARE
7124:
7125: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
7126: SELECT rowid,uso.*
7127: FROM igs_ps_usec_occurs_all uso
7128: WHERE uso.unit_section_occurrence_id=cp_n_uso_id;
7129: rec_prd_uso c_prd_uso%ROWTYPE;

Line 7127: FROM igs_ps_usec_occurs_all uso

7123: DECLARE
7124:
7125: CURSOR c_prd_uso(cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
7126: SELECT rowid,uso.*
7127: FROM igs_ps_usec_occurs_all uso
7128: WHERE uso.unit_section_occurrence_id=cp_n_uso_id;
7129: rec_prd_uso c_prd_uso%ROWTYPE;
7130:
7131: CURSOR check_ovrd IS

Line 7136: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;

7132: SELECT day_ovrd_flag, time_ovrd_flag, scheduled_bld_ovrd_flag, scheduled_room_ovrd_flag,date_ovrd_flag
7133: FROM igs_ps_sch_ocr_cfig;
7134:
7135: l_check_ovrd check_ovrd%ROWTYPE;
7136: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
7137: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;

Line 7137: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;

7133: FROM igs_ps_sch_ocr_cfig;
7134:
7135: l_check_ovrd check_ovrd%ROWTYPE;
7136: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
7137: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;

Line 7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;

7134:
7135: l_check_ovrd check_ovrd%ROWTYPE;
7136: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
7137: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;

Line 7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;

7135: l_check_ovrd check_ovrd%ROWTYPE;
7136: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
7137: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;

Line 7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;

7136: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
7137: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;

Line 7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;

7137: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;

Line 7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;

7138: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;

Line 7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;

7139: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
7147: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;

Line 7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;

7140: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
7147: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
7148: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;

Line 7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;

7141: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
7147: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
7148: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;
7149: BEGIN

Line 7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;

7142: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
7147: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
7148: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;
7149: BEGIN
7150: OPEN c_prd_uso (l_n_uso_id);

Line 7147: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;

7143: l_d_uso_start_date igs_ps_usec_occurs_all.start_date%TYPE;
7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
7147: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
7148: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;
7149: BEGIN
7150: OPEN c_prd_uso (l_n_uso_id);
7151: FETCH c_prd_uso INTO rec_prd_uso;

Line 7148: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;

7144: l_d_uso_end_date igs_ps_usec_occurs_all.end_date%TYPE;
7145: l_start_time igs_ps_usec_occurs_all.start_time%TYPE;
7146: l_end_time igs_ps_usec_occurs_all.end_time%TYPE;
7147: l_sch_bld igs_ps_usec_occurs_all.building_code%TYPE;
7148: l_sch_room igs_ps_usec_occurs_all.room_code%TYPE;
7149: BEGIN
7150: OPEN c_prd_uso (l_n_uso_id);
7151: FETCH c_prd_uso INTO rec_prd_uso;
7152: CLOSE c_prd_uso;

Line 7230: UPDATE IGS_PS_USEC_OCCURS_ALL SET

7226: END IF;
7227: CLOSE check_ovrd;
7228:
7229: /*Update record*/
7230: UPDATE IGS_PS_USEC_OCCURS_ALL SET
7231: monday = l_c_monday,
7232: tuesday = l_c_tuesday,
7233: wednesday = l_c_wednesday,
7234: thursday =l_c_thursday,

Line 7343: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE; -- Holds the Unit Section Occurrence Identifier

7339: l_c_cal_type igs_ca_inst_all.cal_type%TYPE; -- Holds Calendar Type
7340: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE; -- Holds Calendar Instance Sequence Number
7341: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- Holds Unit Offering Options Identifier
7342: l_n_usec_ref_id igs_ps_usec_ref.unit_section_reference_id%TYPE; -- Holds Unit Section Reference Identifier
7343: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE; -- Holds the Unit Section Occurrence Identifier
7344:
7345: --
7346: l_insert_update VARCHAR2(1);
7347: --

Line 8295: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;

8291:
8292: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
8293: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
8294: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8295: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
8297:
8298: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8299: SELECT uso.unit_section_occurrence_id

Line 8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;

8292: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
8293: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
8294: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8295: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
8297:
8298: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8299: SELECT uso.unit_section_occurrence_id
8300: FROM igs_ps_usec_occurs_all uso

Line 8298: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

8294: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8295: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
8297:
8298: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8299: SELECT uso.unit_section_occurrence_id
8300: FROM igs_ps_usec_occurs_all uso
8301: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
8302: AND uso.no_set_day_ind ='N'

Line 8300: FROM igs_ps_usec_occurs_all uso

8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
8297:
8298: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8299: SELECT uso.unit_section_occurrence_id
8300: FROM igs_ps_usec_occurs_all uso
8301: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
8302: AND uso.no_set_day_ind ='N'
8303: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
8304:

Line 8430: CURSOR c_uoo_id (cp_n_uso_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

8426: Modified the two cursors c_tba_count,c_tba_uso_id
8427: ***********************************************************************************************/
8428:
8429:
8430: CURSOR c_uoo_id (cp_n_uso_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8431: SELECT A.uoo_id
8432: FROM igs_ps_usec_occurs_all A
8433: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
8434:

Line 8432: FROM igs_ps_usec_occurs_all A

8428:
8429:
8430: CURSOR c_uoo_id (cp_n_uso_id IN igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8431: SELECT A.uoo_id
8432: FROM igs_ps_usec_occurs_all A
8433: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
8434:
8435: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
8436: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;

Line 8505: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

8501: END IF;
8502: END validate_derivation;
8503:
8504: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
8505: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8506: SELECT a.unit_cd, a.version_number
8507: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
8508: WHERE a.uoo_id = b.uoo_id
8509: AND b.unit_section_occurrence_id = cp_n_uso_id;

Line 8507: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b

8503:
8504: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
8505: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8506: SELECT a.unit_cd, a.version_number
8507: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
8508: WHERE a.uoo_id = b.uoo_id
8509: AND b.unit_section_occurrence_id = cp_n_uso_id;
8510:
8511: rec_unit_ver c_unit_ver%ROWTYPE;

Line 8513: CURSOR c_occur_status (cp_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

8509: AND b.unit_section_occurrence_id = cp_n_uso_id;
8510:
8511: rec_unit_ver c_unit_ver%ROWTYPE;
8512:
8513: CURSOR c_occur_status (cp_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8514: SELECT 'X'
8515: FROM igs_ps_usec_occurs_all
8516: WHERE unit_section_occurrence_id = cp_uso_id
8517: AND schedule_status = 'PROCESSING';

Line 8515: FROM igs_ps_usec_occurs_all

8511: rec_unit_ver c_unit_ver%ROWTYPE;
8512:
8513: CURSOR c_occur_status (cp_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8514: SELECT 'X'
8515: FROM igs_ps_usec_occurs_all
8516: WHERE unit_section_occurrence_id = cp_uso_id
8517: AND schedule_status = 'PROCESSING';
8518: l_c_var VARCHAR2(1);
8519: