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_UNIT_OFR_OPT

Line 72: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_ps_unit_ofr_opt_v with igs_ps_unit_ofr_opt_all for cursor c_end_dt

68:
69: Change History
70:
71: Who When What
72: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_ps_unit_ofr_opt_v with igs_ps_unit_ofr_opt_all for cursor c_end_dt
73: sarakshi 12-Jan-2005 Bug#4926548, modified cursor uoo_cur to remove the two outer joins with two tables and included them in the place of open cursor .Also
74: modified the cursor usec_occur to use its base table rather than the view IGS_PS_USEC_OCCURS_V
75: sarakshi 06-Dec-2005 Bug#4863051,modified cursor pat_cur such that it excludes the inactive units for processing.
76: sarakshi 19-Sep-2005 Bug#4588504, modified cursor uoo_cur such it picks the subtitle correctly.

Line 106: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv,igs_ca_inst_all ci, igs_ad_location_all loc

102: ci.alternate_code teaching_cal_alternate_code,
103: NULL subtitle,
104: uv.subtitle_id,
105: NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd) owner_org_unit_cd
106: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv,igs_ca_inst_all ci, igs_ad_location_all loc
107: WHERE uoo.cal_type = l_cal_type
108: AND uoo.ci_sequence_number = l_ci_sequence_number
109: AND uoo.unit_cd=cp_unit_cd
110: AND uoo.version_number=cp_version_number

Line 126: CURSOR usec_occur(l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

122: -- Get the Usec Occurrence data for a given uoo_id
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

Line 141: CURSOR c_end_dt (cp_uoo_id IGS_PS_UNIT_OFR_OPT_V.UOO_ID%TYPE) IS

137: );
138:
139:
140: -- Get the calendar end date for the particular unit section for Bug # 2383553
141: CURSOR c_end_dt (cp_uoo_id IGS_PS_UNIT_OFR_OPT_V.UOO_ID%TYPE) IS
142: SELECT ci.end_dt cal_end_dt
143: FROM igs_ps_unit_ofr_opt_all uoo, igs_ca_inst_all ci
144: WHERE UOO_ID =cp_uoo_id
145: AND uoo.cal_type = ci.cal_type

Line 143: FROM igs_ps_unit_ofr_opt_all uoo, igs_ca_inst_all ci

139:
140: -- Get the calendar end date for the particular unit section for Bug # 2383553
141: CURSOR c_end_dt (cp_uoo_id IGS_PS_UNIT_OFR_OPT_V.UOO_ID%TYPE) IS
142: SELECT ci.end_dt cal_end_dt
143: FROM igs_ps_unit_ofr_opt_all uoo, igs_ca_inst_all ci
144: WHERE UOO_ID =cp_uoo_id
145: AND uoo.cal_type = ci.cal_type
146: AND uoo.ci_sequence_number = ci.sequence_number;
147:

Line 150: CURSOR c_is_req (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

146: AND uoo.ci_sequence_number = ci.sequence_number;
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

Line 164: FROM igs_ps_unit_ofr_opt_all

160:
161: ---
162: CURSOR c_usec_param(cp_uoo_id IN NUMBER) IS
163: SELECT unit_cd,version_number,cal_type,ci_sequence_number,unit_class,location_cd
164: FROM igs_ps_unit_ofr_opt_all
165: WHERE uoo_id=cp_uoo_id;
166: l_usec_param c_usec_param%ROWTYPE;
167:
168: CURSOR pat_cur(cp_cal_type IN VARCHAR2, cp_ci_sequence_number IN NUMBER,

Line 294: IGS_PS_UNIT_OFR_OPT_ALL usec

290: SELECT unit.enrollment_expected,
291: NVL(unit.enrollment_maximum, 999999),
292: NVL(unit.override_enrollment_max,999999)
293: FROM IGS_PS_UNIT_VER_ALL unit,
294: IGS_PS_UNIT_OFR_OPT_ALL usec
295: WHERE unit.unit_cd = usec.unit_cd
296: AND unit.version_number = usec.version_number
297: AND usec.uoo_id = cp_n_uoo_id;
298:

Line 380: CURSOR c_section_exists(cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,

376: l_u_enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%TYPE ;
377: l_u_override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%TYPE ;
378:
379:
380: CURSOR c_section_exists(cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
381: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
382: cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
383: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE) IS
384: SELECT 'X'

Line 381: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

377: l_u_override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%TYPE ;
378:
379:
380: CURSOR c_section_exists(cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
381: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
382: cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
383: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE) IS
384: SELECT 'X'
385: FROM igs_ps_unit_ofr_opt_all us

Line 382: cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

378:
379:
380: CURSOR c_section_exists(cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
381: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
382: cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
383: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE) IS
384: SELECT 'X'
385: FROM igs_ps_unit_ofr_opt_all us
386: WHERE us.cal_type=cp_cal_type

Line 383: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE) IS

379:
380: CURSOR c_section_exists(cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
381: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
382: cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
383: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE) IS
384: SELECT 'X'
385: FROM igs_ps_unit_ofr_opt_all us
386: WHERE us.cal_type=cp_cal_type
387: AND us.ci_sequence_number=cp_ci_sequence_number

Line 385: FROM igs_ps_unit_ofr_opt_all us

381: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
382: cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
383: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE) IS
384: SELECT 'X'
385: FROM igs_ps_unit_ofr_opt_all us
386: WHERE us.cal_type=cp_cal_type
387: AND us.ci_sequence_number=cp_ci_sequence_number
388: AND us.unit_cd=cp_unit_cd
389: AND us.version_number=cp_version_number;

Line 555: CURSOR org_unit( cp_owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE) IS

551: l_max_enr_x_grp igs_ps_usec_x_grpmem_v.enrollment_maximum%TYPE;
552: l_meet_with_grp_name igs_ps_uso_cm_grp.class_meet_group_name%TYPE;
553:
554: -- Get the Org Unit description for the unit
555: CURSOR org_unit( cp_owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE) IS
556: SELECT party_name org_unit_description
557: FROM igs_or_inst_org_base_v
558: WHERE party_number = cp_owner_org_unit_cd
559: AND inst_org_ind = 'O';

Line 563: CURSOR usec_x_list ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS

559: AND inst_org_ind = 'O';
560:
561:
562: -- Get unit Section Cross Section
563: CURSOR usec_x_list ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
564: SELECT unit_sec_cross_unit_sec_id,
565: parent_uoo_id,child_uoo_id,
566: child_unit_cd,child_version_number,
567: child_title,child_cal_type,

Line 575: CURSOR usec_x_grp_name ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS

571: FROM igs_ps_usec_x_usec_v
572: WHERE parent_uoo_id = l_uoo_id;
573:
574: -- Get the Cross Listed Group Name of the uoo_id
575: CURSOR usec_x_grp_name ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
576: SELECT A.usec_x_listed_group_name
577: FROM igs_ps_usec_x_grp_v A,
578: igs_ps_usec_x_grpmem_v B
579: WHERE A.usec_x_listed_group_id = B.usec_x_listed_group_id

Line 587: CURSOR max_enr_x_grp ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS

583: -- Get the Maximum Enrollment Number for the Cross Listed Group of the uoo_id
584: -- Modified the cursor to select Enrollment Maximum when it is defined at group level(Cross Listed Unit Section)
585: -- otherwise from the unit section level as a part of Enh Bug # 2613933
586:
587: CURSOR max_enr_x_grp ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
588: SELECT NVL(A.max_ovr_group, A.max_enr_group) enroll_max
589: FROM igs_ps_usec_x_grp A,
590: igs_ps_usec_x_grpmem B
591: WHERE A.max_enr_group IS NOT NULL AND

Line 940: igs_ps_unit_ofr_opt_all b,

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
944: AND b.unit_cd=c.unit_code

Line 1221: p_c_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,

1217: END transfer_occurrences;
1218:
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

Line 1222: p_n_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE,

1218:
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:

Line 1255: FROM igs_ps_unit_ofr_opt_all us

1251: l_prod_pattern cur_prod_pattern%ROWTYPE;
1252:
1253: CURSOR cur_prod_uoo(cp_uoo_id IN NUMBER) IS
1254: SELECT us.*,us.rowid
1255: FROM igs_ps_unit_ofr_opt_all us
1256: WHERE us.uoo_id = cp_uoo_id;
1257: l_cur_uoo_rec cur_prod_uoo%ROWTYPE;
1258:
1259: CURSOR cur_prod_uoo_occur(cp_unit_section_occurrence_id IN NUMBER) IS

Line 1473: igs_ps_unit_ofr_opt_pkg.update_row (

1469: OPEN cur_prod_uoo(l_section_prod_rec.uoo_id);
1470: FETCH cur_prod_uoo INTO l_cur_uoo_rec;
1471: CLOSE cur_prod_uoo;
1472:
1473: igs_ps_unit_ofr_opt_pkg.update_row (
1474: x_mode => 'R',
1475: x_rowid => l_cur_uoo_rec.rowid,
1476: x_unit_cd => l_cur_uoo_rec.unit_cd,
1477: x_version_number => l_cur_uoo_rec.version_number,

Line 1523: --UPDATE igs_ps_unit_ofr_opt_all set abort_flag='N' where uoo_id=l_section_prod_rec.uoo_id;

1519: x_abort_flag => 'N'
1520: );
1521:
1522:
1523: --UPDATE igs_ps_unit_ofr_opt_all set abort_flag='N' where uoo_id=l_section_prod_rec.uoo_id;
1524:
1525: l_o_count := 0;
1526: FOR l_occurrence_prod_rec IN c_occurrence(l_section_prod_rec.int_usec_id) LOOP
1527:

Line 1944: FROM igs_ps_unit_ofr_opt

1940: ***************************************************************/
1941:
1942: CURSOR c_loc_modified_chk ( p_uoo_id IN NUMBER ) IS -- To check if location code has undergone modification
1943: SELECT location_cd
1944: FROM igs_ps_unit_ofr_opt
1945: WHERE uoo_id = p_uoo_id;
1946:
1947: CURSOR c_maxenrl_modified_chk ( p_uoo_id IN NUMBER ) IS -- To check if max. enrollments has undergone modification
1948: SELECT enrollment_maximum ,

Line 2168: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;

2164: -- end of code as per theUnit Section Enrollment build
2165: --
2166: ELSIF p_location_cd IS NOT NULL THEN
2167: DECLARE
2168: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;
2169: BEGIN
2170: OPEN c_loc_modified_chk ( p_uoo_id );
2171: FETCH c_loc_modified_chk INTO lv_location_cd;
2172: IF nvl(p_location_cd,-999) <> nvl(lv_location_cd,-999) THEN -- Location has undergone modification

Line 2621: l_n_t_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%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;
2623: l_b_print_uoo BOOLEAN;
2624:
2625: -- is there any schduled records exists needs to be transfer to production table as per the Bug # 2427725

Line 2667: CURSOR c_date (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

2663: l_c_industry VARCHAR2(1);
2664: l_c_schema VARCHAR2(30);
2665: l_b_return BOOLEAN;
2666:
2667: CURSOR c_date (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2668: SELECT a.unit_section_start_date us_start_date,
2669: a.unit_section_end_date us_end_date,
2670: b.start_dt tp_start_date,
2671: b.end_dt tp_end_date

Line 2672: FROM igs_ps_unit_ofr_opt_all a,

2668: SELECT a.unit_section_start_date us_start_date,
2669: a.unit_section_end_date us_end_date,
2670: b.start_dt tp_start_date,
2671: b.end_dt tp_end_date
2672: FROM igs_ps_unit_ofr_opt_all a,
2673: igs_ca_inst_all b
2674: WHERE a.uoo_id = cp_n_uoo_id
2675: AND a.cal_type = b.cal_type
2676: AND a.ci_sequence_number = b.sequence_number;

Line 2749: igs_ps_unit_ofr_opt_all uoo

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;
2753:

Line 3618: CURSOR c_prod_usec (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

3614: WHERE rowid = cp_rowid;
3615:
3616: c_int_uso_prod_rec c_int_uso_prod%ROWTYPE;
3617:
3618: CURSOR c_prod_usec (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3619: SELECT a.rowid prodrid,a.*
3620: FROM igs_ps_unit_ofr_opt_all a
3621: WHERE a.uoo_id=cp_uoo_id;
3622:

Line 3620: FROM igs_ps_unit_ofr_opt_all a

3616: c_int_uso_prod_rec c_int_uso_prod%ROWTYPE;
3617:
3618: CURSOR c_prod_usec (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3619: SELECT a.rowid prodrid,a.*
3620: FROM igs_ps_unit_ofr_opt_all a
3621: WHERE a.uoo_id=cp_uoo_id;
3622:
3623: c_prod_usec_rec c_prod_usec%ROWTYPE;
3624:

Line 3825: igs_ps_unit_ofr_opt_pkg.update_row(

3821: --update the production table
3822: OPEN c_prod_usec(c_int_usec_ss_rec.uoo_id);
3823: FETCH c_prod_usec INTO c_prod_usec_rec;
3824:
3825: igs_ps_unit_ofr_opt_pkg.update_row(
3826: x_rowid => c_prod_usec_rec.prodrid,
3827: x_unit_cd => c_prod_usec_rec.unit_cd,
3828: x_version_number => c_prod_usec_rec.version_number,
3829: x_cal_type => c_prod_usec_rec.cal_type,