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_CREATE_GENERIC_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 62: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

58: ********************************************************************************************** */
59: /* Private Procedures for create_usec_res_seat */
60:
61: l_insert_update VARCHAR2(1);
62: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
63: l_n_rsv_usec_pri_id igs_ps_rsv_usec_pri.rsv_usec_pri_id%type;
64: l_n_group_id igs_pe_persid_group_all.group_id%TYPE;
65:
66: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;

Line 127: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

123:
124:
125: --validate derivations of priority
126: PROCEDURE validate_derivations_pri ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
127: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
128: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
129: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
130: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
131: l_c_message VARCHAR2(30);

Line 128: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

124:
125: --validate derivations of priority
126: PROCEDURE validate_derivations_pri ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
127: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
128: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
129: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
130: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
131: l_c_message VARCHAR2(30);
132: BEGIN

Line 447: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

443: END validate_parameters_prf ;
444:
445: -- Carry out derivations and validate them
446: PROCEDURE validate_derivations_prf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
447: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
448: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
449: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
450: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
451: l_c_message VARCHAR2(30);

Line 448: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

444:
445: -- Carry out derivations and validate them
446: PROCEDURE validate_derivations_prf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
447: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
448: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
449: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
450: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
451: l_c_message VARCHAR2(30);
452:

Line 838: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

834: Change History (in reverse chronological order)
835: Who When What
836:
837: ********************************************************************************************** */
838: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
839: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
840:
841: /* Private Procedures for create_uso_facility */
842: PROCEDURE trim_values ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS

Line 891: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

887:
888: END validate_parameters;
889:
890: PROCEDURE validate_derivations ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
891: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
892: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
893: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
894: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
895: l_c_message VARCHAR2(30);

Line 892: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

888: END validate_parameters;
889:
890: PROCEDURE validate_derivations ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
891: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
892: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
893: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
894: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
895: l_c_message VARCHAR2(30);
896:

Line 897: CURSOR c_uso_id (cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

893: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
894: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
895: l_c_message VARCHAR2(30);
896:
897: CURSOR c_uso_id (cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
898: SELECT unit_section_occurrence_id
899: FROM igs_ps_usec_occurs_all
900: WHERE uoo_id = cp_n_uoo_id
901: AND occurrence_identifier = cp_occurrence_identifier;

Line 1135: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

1131: Change History (in reverse chronological order)
1132: Who When What
1133:
1134: ********************************************************************************************** */
1135: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
1136:
1137: /* Private Procedures for create_usec_cat */
1138: PROCEDURE trim_values ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1139: BEGIN

Line 1180: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

1176:
1177: END validate_parameters;
1178:
1179: PROCEDURE validate_derivations ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1180: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
1181: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
1182: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
1183: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
1184: l_c_message VARCHAR2(30);

Line 1181: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

1177: END validate_parameters;
1178:
1179: PROCEDURE validate_derivations ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1180: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
1181: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
1182: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
1183: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
1184: l_c_message VARCHAR2(30);
1185:

Line 1401: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

1397: Change History (in reverse chronological order)
1398: Who When What
1399: ********************************************************************************************** */
1400: l_insert_update VARCHAR2(1);
1401: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
1402: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
1403: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
1404:
1405: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;

Line 1402: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

1398: Who When What
1399: ********************************************************************************************** */
1400: l_insert_update VARCHAR2(1);
1401: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
1402: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
1403: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
1404:
1405: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
1406:

Line 1403: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

1399: ********************************************************************************************** */
1400: l_insert_update VARCHAR2(1);
1401: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
1402: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
1403: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
1404:
1405: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
1406:
1407: CURSOR c_tch_rsp_ovrd(p_unit_cd IN VARCHAR2,

Line 1908: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

1904: Known limitations,enhancements,remarks:
1905: Change History (in reverse chronological order)
1906: Who When What
1907: ********************************************************************************************** */
1908: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
1909: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
1910: l_insert_update VARCHAR2(1);
1911:
1912:

Line 2009: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

2005: END check_insert_update;
2006:
2007: -- Carry out derivations and validate them
2008: PROCEDURE validate_derivations ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type) AS
2009: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2010: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2011: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2012: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2013: l_c_message VARCHAR2(30);

Line 2010: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

2006:
2007: -- Carry out derivations and validate them
2008: PROCEDURE validate_derivations ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type) AS
2009: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2010: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2011: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2012: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2013: l_c_message VARCHAR2(30);
2014: BEGIN

Line 2391: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

2387:
2388: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2389: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2390:
2391: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2392: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2393:
2394: l_c_exam_cal_type igs_ca_inst_all.cal_type%TYPE;
2395: l_n_exam_seq_num igs_ca_inst_all.sequence_number%TYPE;

Line 2392: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

2388: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2389: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
2390:
2391: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2392: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2393:
2394: l_c_exam_cal_type igs_ca_inst_all.cal_type%TYPE;
2395: l_n_exam_seq_num igs_ca_inst_all.sequence_number%TYPE;
2396:

Line 3081: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

3077: Who When What
3078: ********************************************************************************************** */
3079:
3080: l_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type;
3081: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3082: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3083: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3084: l_insert_update VARCHAR2(1);
3085:

Line 3082: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

3078: ********************************************************************************************** */
3079:
3080: l_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type;
3081: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3082: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3083: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3084: l_insert_update VARCHAR2(1);
3085:
3086: FUNCTION ifexists(p_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type,

Line 3083: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

3079:
3080: l_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type;
3081: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3082: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3083: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3084: l_insert_update VARCHAR2(1);
3085:
3086: FUNCTION ifexists(p_n_class_meet_group_id igs_ps_uso_cm_grp.class_meet_group_id%type,
3087: p_old_max_enr_group igs_ps_uso_cm_grp.max_enr_group%TYPE

Line 3830: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

3826: Who When What
3827: ********************************************************************************************** */
3828:
3829: l_n_usec_x_listed_group_id igs_ps_usec_x_grp.usec_x_listed_group_id%type;
3830: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3831: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3832: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3833: l_insert_update VARCHAR2(1);
3834:

Line 3831: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

3827: ********************************************************************************************** */
3828:
3829: l_n_usec_x_listed_group_id igs_ps_usec_x_grp.usec_x_listed_group_id%type;
3830: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3831: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3832: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3833: l_insert_update VARCHAR2(1);
3834:
3835: FUNCTION ifexists(p_n_usec_x_listed_group_id igs_ps_usec_x_grp.usec_x_listed_group_id%type,

Line 3832: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

3828:
3829: l_n_usec_x_listed_group_id igs_ps_usec_x_grp.usec_x_listed_group_id%type;
3830: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3831: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3832: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3833: l_insert_update VARCHAR2(1);
3834:
3835: FUNCTION ifexists(p_n_usec_x_listed_group_id igs_ps_usec_x_grp.usec_x_listed_group_id%type,
3836: p_old_max_enr_group igs_ps_usec_x_grp.max_enr_group%TYPE) RETURN BOOLEAN AS

Line 4592: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

4588: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
4589: ********************************************************************************************** */
4590:
4591: l_insert_update VARCHAR2(1);
4592: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
4593: l_n_wlst_usec_pri_id igs_ps_usec_wlst_pri.unit_sec_waitlist_priority_id%type;
4594: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
4595:
4596: /* Private Procedures for create_usec_waitlist */

Line 4649: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

4645:
4646:
4647: --Validate the derivations
4648: PROCEDURE validate_derivations_pri ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4649: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
4650: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
4651: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
4652: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
4653: l_c_message VARCHAR2(30);

Line 4650: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

4646:
4647: --Validate the derivations
4648: PROCEDURE validate_derivations_pri ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4649: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
4650: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
4651: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
4652: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
4653: l_c_message VARCHAR2(30);
4654:

Line 5309: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

5305: Change History (in reverse chronological order)
5306: Who When What
5307: ********************************************************************************************** */
5308: l_insert_update VARCHAR2(1);
5309: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5310: l_n_reference_number igs_ge_note.reference_number%TYPE;
5311: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5312: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5313:

Line 5311: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

5307: ********************************************************************************************** */
5308: l_insert_update VARCHAR2(1);
5309: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5310: l_n_reference_number igs_ge_note.reference_number%TYPE;
5311: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5312: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5313:
5314: /* Private Procedures for create_usec_notes */
5315: PROCEDURE trim_values ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS

Line 5312: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

5308: l_insert_update VARCHAR2(1);
5309: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5310: l_n_reference_number igs_ge_note.reference_number%TYPE;
5311: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5312: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5313:
5314: /* Private Procedures for create_usec_notes */
5315: PROCEDURE trim_values ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS
5316: BEGIN

Line 5691: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

5687: Change History (in reverse chronological order)
5688: Who When What
5689: ***********************************************************************************************/
5690: l_insert_update VARCHAR2(1);
5691: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5692: l_n_building_id NUMBER;
5693: l_n_room_id NUMBER;
5694: l_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE;
5695: l_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE;

Line 5798: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

5794: WHERE room_cd = cp_room_cd
5795: AND building_id = cp_building_id;
5796:
5797:
5798: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5799: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5800: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5801: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5802: l_c_message VARCHAR2(30);

Line 5799: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

5795: AND building_id = cp_building_id;
5796:
5797:
5798: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5799: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5800: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5801: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5802: l_c_message VARCHAR2(30);
5803: BEGIN

Line 6215: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

6211: ***********************************************************************************************/
6212:
6213: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6214: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
6215: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6216: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6217: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6218: l_insert_status BOOLEAN;
6219: l_delete_status BOOLEAN;

Line 6405: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b

6401:
6402: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
6403: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
6404: SELECT a.unit_cd, a.version_number
6405: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
6406: WHERE a.uoo_id = b.uoo_id
6407: AND b.unit_section_occurrence_id = cp_n_uso_id;
6408:
6409: rec_unit_ver c_unit_ver%ROWTYPE;

Line 6484: FROM igs_ps_unit_ofr_opt_all

6480: AND a.instructor_id=cp_ins_id);
6481:
6482: CURSOR cur_enr(cp_uoo_id IN NUMBER) IS
6483: SELECT 'X'
6484: FROM igs_ps_unit_ofr_opt_all
6485: WHERE uoo_id= cp_uoo_id
6486: AND ENROLLMENT_ACTUAL > 0;
6487:
6488: l_c_var VARCHAR2(1);

Line 6770: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

6766: Change History
6767: Who When What
6768: ***********************************************************************************************/
6769: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6770: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6771: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6772: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6773: l_message_name VARCHAR2(30);
6774:

Line 6777: TYPE usec_sr_rectype IS RECORD( uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

6773: l_message_name VARCHAR2(30);
6774:
6775:
6776: -- for doing certain validation at unit section level while importing unit section occurrence of instructors
6777: TYPE usec_sr_rectype IS RECORD( uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
6778: instr_index NUMBER);
6779: TYPE usec_sr_tbltype IS TABLE OF usec_sr_rectype INDEX BY BINARY_INTEGER;
6780: v_tab_usec_sr usec_sr_tbltype;
6781:

Line 7032: CURSOR c_lead_cnd (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%type) IS

7028:
7029: END Assign_default;
7030:
7031: PROCEDURE Business_validation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
7032: CURSOR c_lead_cnd (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%type) IS
7033: SELECT COUNT(*)
7034: FROM IGS_PS_USEC_TCH_RESP
7035: WHERE lead_instructor_flag='Y'
7036: AND uoo_id = cp_n_uoo_id

Line 7043: FROM IGS_PS_UNIT_OFR_OPT_ALL A

7039: CURSOR c_cal_inst (cp_n_uoo_id IN NUMBER) IS
7040: SELECT A.cal_type,
7041: A.ci_sequence_number,
7042: A.unit_section_status
7043: FROM IGS_PS_UNIT_OFR_OPT_ALL A
7044: WHERE A.uoo_id = cp_n_uoo_id;
7045:
7046: CURSOR c_cal_setup IS
7047: SELECT 'x'

Line 7150: CURSOR c_count_lead (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

7146:
7147:
7148: l_tab_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
7149:
7150: CURSOR c_count_lead (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7151: SELECT count(*)
7152: FROM IGS_PS_USEC_TCH_RESP
7153: WHERE uoo_id = cp_n_uoo_id
7154: AND lead_instructor_flag = 'Y';

Line 7156: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

7152: FROM IGS_PS_USEC_TCH_RESP
7153: WHERE uoo_id = cp_n_uoo_id
7154: AND lead_instructor_flag = 'Y';
7155:
7156: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7157: SELECT SUM(PERCENTAGE_ALLOCATION)
7158: FROM IGS_PS_USEC_TCH_RESP
7159: WHERE confirmed_flag = 'Y'
7160: AND uoo_id = cp_n_uoo_id;

Line 7162: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

7158: FROM IGS_PS_USEC_TCH_RESP
7159: WHERE confirmed_flag = 'Y'
7160: AND uoo_id = cp_n_uoo_id;
7161:
7162: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7163: SELECT unit_cd,
7164: version_number
7165: FROM igs_ps_unit_ofr_opt_all
7166: WHERE uoo_id = cp_n_uoo_id

Line 7165: FROM igs_ps_unit_ofr_opt_all

7161:
7162: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7163: SELECT unit_cd,
7164: version_number
7165: FROM igs_ps_unit_ofr_opt_all
7166: WHERE uoo_id = cp_n_uoo_id
7167: AND ROWNUM < 2;
7168:
7169: CURSOR c_null IS

Line 7483: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

7479: Created local procedures and functions.
7480: ***********************************************************************************************/
7481: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
7482: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
7483: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
7484: l_insert_update VARCHAR2(1);
7485:
7486: PROCEDURE trim_values ( p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS
7487: BEGIN

Line 8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

8969: Who When What
8970: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsu_dlstp with igs_en_nsu_dlstp_all for cursor cur_dead_details
8971: in proccedure Assign_defaults
8972: ***********************************************************************************************/
8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
8975: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
8976: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
8977: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;

Line 9130: FROM igs_ps_unit_ofr_opt_all

9126: PROCEDURE Assign_defaults (p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type,p_insert_update IN VARCHAR2) AS
9127:
9128: CURSOR cur_usec(cp_uoo_id IN NUMBER) IS
9129: SELECT owner_org_unit_cd
9130: FROM igs_ps_unit_ofr_opt_all
9131: WHERE uoo_id=cp_uoo_id;
9132: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;
9133:
9134: CURSOR cur_dead_details (cp_org_unit_cd IN VARCHAR2,cp_function_name IN VARCHAR2) IS

Line 9132: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;

9128: CURSOR cur_usec(cp_uoo_id IN NUMBER) IS
9129: SELECT owner_org_unit_cd
9130: FROM igs_ps_unit_ofr_opt_all
9131: WHERE uoo_id=cp_uoo_id;
9132: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;
9133:
9134: CURSOR cur_dead_details (cp_org_unit_cd IN VARCHAR2,cp_function_name IN VARCHAR2) IS
9135: SELECT formula_method,round_method,offset_duration,non_std_usec_dls_id,offset_dt_code,org_unit_code,definition_code
9136: FROM igs_en_nsu_dlstp_all

Line 9268: FROM igs_ps_unit_ofr_opt_all

9264:
9265: PROCEDURE Business_validation(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS
9266: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
9267: SELECT 'X'
9268: FROM igs_ps_unit_ofr_opt_all
9269: WHERE uoo_id = cp_n_uoo_id
9270: AND non_std_usec_ind = 'Y';
9271: l_c_var VARCHAR2(1);
9272:

Line 9541: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

9537: Who When What
9538: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsd_dlstp with igs_en_nsd_dlstp_all for cursor cur_disc_details
9539: in proccedure Assign_defaults
9540: ***********************************************************************************************/
9541: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;
9543: l_c_org_unit_code igs_en_nsu_dlstp.org_unit_code%TYPE;
9544: l_c_definition_code igs_en_nsu_dlstp.definition_code%TYPE;
9545: l_c_formula_method igs_en_nsu_dlstp.formula_method%TYPE;

Line 9710: FROM igs_ps_unit_ofr_opt_all

9706: PROCEDURE Assign_defaults ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type,p_insert_update IN VARCHAR2) AS
9707:
9708: CURSOR cur_usec(cp_uoo_id IN NUMBER) IS
9709: SELECT owner_org_unit_cd
9710: FROM igs_ps_unit_ofr_opt_all
9711: WHERE uoo_id=cp_uoo_id;
9712: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;
9713:
9714: CURSOR cur_disc_details (cp_org_unit_cd IN VARCHAR2,cp_administrative_unit_status IN VARCHAR2) IS

Line 9712: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;

9708: CURSOR cur_usec(cp_uoo_id IN NUMBER) IS
9709: SELECT owner_org_unit_cd
9710: FROM igs_ps_unit_ofr_opt_all
9711: WHERE uoo_id=cp_uoo_id;
9712: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;
9713:
9714: CURSOR cur_disc_details (cp_org_unit_cd IN VARCHAR2,cp_administrative_unit_status IN VARCHAR2) IS
9715: SELECT formula_method,round_method,offset_duration,non_std_disc_dl_stp_id,offset_dt_code,org_unit_code,definition_code
9716: FROM igs_en_nsd_dlstp_all

Line 9849: FROM igs_ps_unit_ofr_opt_all

9845:
9846: PROCEDURE Business_validation(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS
9847: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
9848: SELECT 'X'
9849: FROM igs_ps_unit_ofr_opt_all
9850: WHERE uoo_id = cp_n_uoo_id
9851: AND non_std_usec_ind = 'Y';
9852: l_c_var VARCHAR2(1);
9853:

Line 10121: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

10117: sommukhe 18-Jan-2006 Bug#4926548, modified cur_fee to address the performance issue. Created local procedures and functions.
10118: ***********************************************************************************************/
10119: l_c_cal_type VARCHAR2(10);
10120: l_n_seq_num NUMBER;
10121: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
10122: l_n_non_std_usec_rtn_id NUMBER;
10123: l_insert_update VARCHAR2(1);
10124:
10125: PROCEDURE trim_values ( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS

Line 10340: FROM igs_ps_unit_ofr_opt_all

10336:
10337: PROCEDURE Business_validation(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type,p_insert_update IN VARCHAR2) AS
10338: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
10339: SELECT 'X'
10340: FROM igs_ps_unit_ofr_opt_all
10341: WHERE uoo_id = cp_n_uoo_id
10342: AND non_std_usec_ind = 'Y';
10343: l_c_var VARCHAR2(1);
10344:

Line 10722: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

10718: Known limitations,enhancements,remarks:
10719: Change History
10720: Who When What
10721: ***********************************************************************************************/
10722: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
10723: l_n_non_std_usec_rtn_id NUMBER;
10724: l_d_offset_date DATE;
10725: l_insert_update VARCHAR2(1);
10726:

Line 11027: FROM igs_ps_unit_ofr_opt_all

11023:
11024: PROCEDURE Business_validation(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS
11025: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
11026: SELECT 'X'
11027: FROM igs_ps_unit_ofr_opt_all
11028: WHERE uoo_id = cp_n_uoo_id
11029: AND non_std_usec_ind = 'Y';
11030: l_c_var VARCHAR2(1);
11031: