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_CA_INST

Line 129: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

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
133: -- Derive Calander Type and Sequence Number

Line 130: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

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
133: -- Derive Calander Type and Sequence Number
134: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_rsv_rec.teach_cal_alternate_code,

Line 449: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

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:
453: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_rsv_usec_pri.priority_value%type) IS

Line 450: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

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:
453: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_rsv_usec_pri.priority_value%type) IS
454: SELECT rsv_usec_pri_id

Line 893: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

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

Line 894: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

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

Line 1182: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

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:
1186: BEGIN

Line 1183: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

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:
1186: BEGIN
1187:

Line 1529: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

1525: END check_insert_update;
1526:
1527: -- Carry out derivations and validate them
1528: PROCEDURE validate_derivations ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS
1529: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
1530: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
1531: l_c_message VARCHAR2(30);
1532: BEGIN
1533:

Line 1530: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

1526:
1527: -- Carry out derivations and validate them
1528: PROCEDURE validate_derivations ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS
1529: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
1530: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
1531: l_c_message VARCHAR2(30);
1532: BEGIN
1533:
1534:

Line 2011: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

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

Line 2012: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

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
2015:
2016:

Line 2388: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

2384: WHERE uoo_id = cp_n_uoo_id
2385: AND ass_id = cp_assessment_id
2386: AND sequence_number=cp_sequence_number;
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;

Line 2389: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

2385: AND ass_id = cp_assessment_id
2386: AND sequence_number=cp_sequence_number;
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:

Line 2394: l_c_exam_cal_type igs_ca_inst_all.cal_type%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:
2397: l_n_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%type;
2398:

Line 2395: l_n_exam_seq_num igs_ca_inst_all.sequence_number%TYPE;

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:
2397: l_n_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%type;
2398:
2399: -- validate parameters passed.

Line 2486: CURSOR cal_type (cp_alternate_code igs_ca_inst_all.alternate_code%TYPE) IS

2482: AND sequence_number=cp_sequence_number;
2483:
2484: c_unitass_item_rec c_unitass_item%ROWTYPE;
2485:
2486: CURSOR cal_type (cp_alternate_code igs_ca_inst_all.alternate_code%TYPE) IS
2487: SELECT cal_type,sequence_number
2488: FROM igs_ca_inst_all
2489: WHERE alternate_code = cp_alternate_code;
2490:

Line 2488: FROM igs_ca_inst_all

2484: c_unitass_item_rec c_unitass_item%ROWTYPE;
2485:
2486: CURSOR cal_type (cp_alternate_code igs_ca_inst_all.alternate_code%TYPE) IS
2487: SELECT cal_type,sequence_number
2488: FROM igs_ca_inst_all
2489: WHERE alternate_code = cp_alternate_code;
2490:
2491: CURSOR cur_exam_cal(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
2492: SELECT 'X'

Line 2491: CURSOR cur_exam_cal(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS

2487: SELECT cal_type,sequence_number
2488: FROM igs_ca_inst_all
2489: WHERE alternate_code = cp_alternate_code;
2490:
2491: CURSOR cur_exam_cal(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
2492: SELECT 'X'
2493: FROM igs_ca_inst ci,
2494: igs_ca_type cat
2495: WHERE cat.s_cal_cat = 'EXAM'

Line 2493: FROM igs_ca_inst ci,

2489: WHERE alternate_code = cp_alternate_code;
2490:
2491: CURSOR cur_exam_cal(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE ) IS
2492: SELECT 'X'
2493: FROM igs_ca_inst ci,
2494: igs_ca_type cat
2495: WHERE cat.s_cal_cat = 'EXAM'
2496: AND ci.cal_type = cat.cal_type
2497: AND ci.cal_type = cp_cal_type

Line 2500: FROM igs_ca_inst ci2,

2496: AND ci.cal_type = cat.cal_type
2497: AND ci.cal_type = cp_cal_type
2498: AND ci.sequence_number = cp_sequence_number
2499: AND ci.sequence_number IN (SELECT ci2.sequence_number
2500: FROM igs_ca_inst ci2,
2501: igs_ca_inst_rel cir
2502: WHERE ci2.cal_type = cir.sup_cal_type
2503: AND ci2.sequence_number = cir.sup_ci_sequence_number
2504: AND cir.sub_cal_type = l_c_cal_type

Line 2501: igs_ca_inst_rel cir

2497: AND ci.cal_type = cp_cal_type
2498: AND ci.sequence_number = cp_sequence_number
2499: AND ci.sequence_number IN (SELECT ci2.sequence_number
2500: FROM igs_ca_inst ci2,
2501: igs_ca_inst_rel cir
2502: WHERE ci2.cal_type = cir.sup_cal_type
2503: AND ci2.sequence_number = cir.sup_ci_sequence_number
2504: AND cir.sub_cal_type = l_c_cal_type
2505: AND cir.sub_ci_sequence_number = l_n_seq_num);

Line 3163: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

3159:
3160: -- Carry out derivations and validate them
3161: PROCEDURE validate_derivations ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type) AS
3162:
3163: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3164: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3165: l_c_message VARCHAR2(30);
3166: BEGIN
3167:

Line 3164: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

3160: -- Carry out derivations and validate them
3161: PROCEDURE validate_derivations ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type) AS
3162:
3163: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3164: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3165: l_c_message VARCHAR2(30);
3166: BEGIN
3167:
3168:

Line 3268: IF NOT igs_ca_inst_pkg.get_pk_for_validation (x_cal_type =>l_c_cal_type,

3264:
3265: END IF;
3266:
3267: /* Validate FK Constraints*/
3268: IF NOT igs_ca_inst_pkg.get_pk_for_validation (x_cal_type =>l_c_cal_type,
3269: x_sequence_number =>l_n_seq_num) THEN
3270: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'TEACH_CAL_ALTERNATE_CD', 'LEGACY_TOKENS', FALSE);
3271: p_uso_cm_grp_rec.status := 'E';
3272: END IF;

Line 3909: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

3905: END check_insert_update;
3906:
3907: -- Carry out derivations and validate them
3908: PROCEDURE validate_derivations ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type) AS
3909: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3910: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3911: l_c_message VARCHAR2(30);
3912: BEGIN
3913:

Line 3910: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

3906:
3907: -- Carry out derivations and validate them
3908: PROCEDURE validate_derivations ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type) AS
3909: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3910: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3911: l_c_message VARCHAR2(30);
3912: BEGIN
3913:
3914: -- Derive Calander Type and Sequence Number

Line 4018: IF NOT igs_ca_inst_pkg.get_pk_for_validation (x_cal_type =>l_c_cal_type,

4014:
4015: END IF;
4016:
4017: /* Validate FK Constraints*/
4018: IF NOT igs_ca_inst_pkg.get_pk_for_validation (x_cal_type =>l_c_cal_type,
4019: x_sequence_number =>l_n_seq_num) THEN
4020: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'TEACH_CAL_ALTERNATE_CD', 'LEGACY_TOKENS', FALSE);
4021: p_usec_x_grp_rec.status := 'E';
4022: END IF;

Line 4651: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

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:
4655: BEGIN

Line 4652: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

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:
4655: BEGIN
4656: -- Derive Calander Type and Sequence Number

Line 5375: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

5371: END check_insert_update;
5372:
5373: -- Carry out derivations and validate them
5374: PROCEDURE validate_derivations ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS
5375: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5376: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5377: l_c_message VARCHAR2(30);
5378: BEGIN
5379:

Line 5376: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

5372:
5373: -- Carry out derivations and validate them
5374: PROCEDURE validate_derivations ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS
5375: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5376: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5377: l_c_message VARCHAR2(30);
5378: BEGIN
5379:
5380:

Line 5800: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;

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

Line 5801: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

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
5804:
5805:

Line 6333: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;

6329: SELECT A.uoo_id
6330: FROM igs_ps_usec_occurs_all A
6331: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
6332:
6333: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6334: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6335: l_d_start igs_ca_inst_all.start_dt%TYPE;
6336: l_d_end igs_ca_inst_all.end_dt%TYPE;
6337: l_c_ret_status VARCHAR2(30);

Line 6334: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;

6330: FROM igs_ps_usec_occurs_all A
6331: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
6332:
6333: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6334: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6335: l_d_start igs_ca_inst_all.start_dt%TYPE;
6336: l_d_end igs_ca_inst_all.end_dt%TYPE;
6337: l_c_ret_status VARCHAR2(30);
6338: l_c_msg VARCHAR2(30);

Line 6335: l_d_start igs_ca_inst_all.start_dt%TYPE;

6331: WHERE A.unit_section_occurrence_id = cp_n_uso_id;
6332:
6333: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6334: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6335: l_d_start igs_ca_inst_all.start_dt%TYPE;
6336: l_d_end igs_ca_inst_all.end_dt%TYPE;
6337: l_c_ret_status VARCHAR2(30);
6338: l_c_msg VARCHAR2(30);
6339:

Line 6336: l_d_end igs_ca_inst_all.end_dt%TYPE;

6332:
6333: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6334: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6335: l_d_start igs_ca_inst_all.start_dt%TYPE;
6336: l_d_end igs_ca_inst_all.end_dt%TYPE;
6337: l_c_ret_status VARCHAR2(30);
6338: l_c_msg VARCHAR2(30);
6339:
6340: BEGIN

Line 6840: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;

6836: END validate_parameters;
6837:
6838: PROCEDURE validate_derivation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6839:
6840: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6841: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6842: l_d_start igs_ca_inst_all.start_dt%TYPE;
6843: l_d_end igs_ca_inst_all.end_dt%TYPE;
6844: l_c_ret_status VARCHAR2(30);

Line 6841: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;

6837:
6838: PROCEDURE validate_derivation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6839:
6840: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6841: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6842: l_d_start igs_ca_inst_all.start_dt%TYPE;
6843: l_d_end igs_ca_inst_all.end_dt%TYPE;
6844: l_c_ret_status VARCHAR2(30);
6845:

Line 6842: l_d_start igs_ca_inst_all.start_dt%TYPE;

6838: PROCEDURE validate_derivation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6839:
6840: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6841: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6842: l_d_start igs_ca_inst_all.start_dt%TYPE;
6843: l_d_end igs_ca_inst_all.end_dt%TYPE;
6844: l_c_ret_status VARCHAR2(30);
6845:
6846: BEGIN

Line 6843: l_d_end igs_ca_inst_all.end_dt%TYPE;

6839:
6840: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6841: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6842: l_d_start igs_ca_inst_all.start_dt%TYPE;
6843: l_d_end igs_ca_inst_all.end_dt%TYPE;
6844: l_c_ret_status VARCHAR2(30);
6845:
6846: BEGIN
6847: -- Initialize the variable use to store the derived values.

Line 7481: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;

7477: on insert and update, removed the hard coded format checks.
7478: sommukhe 18-Jan-2006 Bug#4926548, modified cursorc_fee_type_exists to address the performance issue.
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:

Line 7482: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;

7478: sommukhe 18-Jan-2006 Bug#4926548, modified cursorc_fee_type_exists to address the performance issue.
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

Line 7545: l_d_start igs_ca_inst_all.start_dt%TYPE;

7541: END validate_parameters;
7542:
7543: PROCEDURE validate_derivation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS
7544:
7545: l_d_start igs_ca_inst_all.start_dt%TYPE;
7546: l_d_end igs_ca_inst_all.end_dt%TYPE;
7547: l_c_ret_status VARCHAR2(30);
7548:
7549: BEGIN

Line 7546: l_d_end igs_ca_inst_all.end_dt%TYPE;

7542:
7543: PROCEDURE validate_derivation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS
7544:
7545: l_d_start igs_ca_inst_all.start_dt%TYPE;
7546: l_d_end igs_ca_inst_all.end_dt%TYPE;
7547: l_c_ret_status VARCHAR2(30);
7548:
7549: BEGIN
7550:

Line 7693: igs_ca_inst ci,

7689: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
7690: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
7691: FROM igs_fi_fee_type ft,
7692: igs_fi_f_typ_ca_inst ftci,
7693: igs_ca_inst ci,
7694: igs_ca_type ct,
7695: igs_ca_stat cs
7696: WHERE ft.s_fee_type = 'SPECIAL'
7697: AND ft.closed_ind = 'N'

Line 7713: cal_type igs_ca_inst_all.cal_type%TYPE,

7709: l_message_name VARCHAR2(30);
7710: l_c_var VARCHAR2(1);
7711:
7712: TYPE teach_cal_rec IS RECORD(
7713: cal_type igs_ca_inst_all.cal_type%TYPE,
7714: sequence_number igs_ca_inst_all.sequence_number%TYPE
7715: );
7716: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
7717: teachCalendar_tbl teachCalendar;

Line 7714: sequence_number igs_ca_inst_all.sequence_number%TYPE

7710: l_c_var VARCHAR2(1);
7711:
7712: TYPE teach_cal_rec IS RECORD(
7713: cal_type igs_ca_inst_all.cal_type%TYPE,
7714: sequence_number igs_ca_inst_all.sequence_number%TYPE
7715: );
7716: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
7717: teachCalendar_tbl teachCalendar;
7718: l_n_counter NUMBER(10);

Line 7727: FROM igs_ca_inst_rel

7723:
7724: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
7725: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
7726: SELECT sup_cal_type,sup_ci_sequence_number
7727: FROM igs_ca_inst_rel
7728: WHERE sub_cal_type = cp_load_cal
7729: AND sub_ci_sequence_number = cp_load_seq;
7730:
7731: CURSOR cur_cal_load IS

Line 7750: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,

7746: END LOOP;
7747:
7748: END createCalendar;
7749:
7750: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
7751: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
7752: BEGIN
7753: IF teachCalendar_tbl.EXISTS(1) THEN
7754: FOR i IN 1..teachCalendar_tbl.last LOOP

Line 7751: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS

7747:
7748: END createCalendar;
7749:
7750: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
7751: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
7752: BEGIN
7753: IF teachCalendar_tbl.EXISTS(1) THEN
7754: FOR i IN 1..teachCalendar_tbl.last LOOP
7755: IF cp_cal_type=teachCalendar_tbl(i).cal_type AND

Line 8110: l_d_start igs_ca_inst_all.start_dt%TYPE;

8106:
8107: PROCEDURE validate_derivation(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS
8108: l_c_cal_type VARCHAR2(10);
8109: l_n_seq_num NUMBER;
8110: l_d_start igs_ca_inst_all.start_dt%TYPE;
8111: l_d_end igs_ca_inst_all.end_dt%TYPE;
8112: l_c_ret_status VARCHAR2(30);
8113:
8114: CURSOR cur_activity_cd(cp_activity_type_code IN VARCHAR2) IS

Line 8111: l_d_end igs_ca_inst_all.end_dt%TYPE;

8107: PROCEDURE validate_derivation(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS
8108: l_c_cal_type VARCHAR2(10);
8109: l_n_seq_num NUMBER;
8110: l_d_start igs_ca_inst_all.start_dt%TYPE;
8111: l_d_end igs_ca_inst_all.end_dt%TYPE;
8112: l_c_ret_status VARCHAR2(30);
8113:
8114: CURSOR cur_activity_cd(cp_activity_type_code IN VARCHAR2) IS
8115: SELECT activity_type_id

Line 8658: l_d_start igs_ca_inst_all.start_dt%TYPE;

8654:
8655: PROCEDURE validate_derivation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8656: l_c_cal_type VARCHAR2(10);
8657: l_n_seq_num NUMBER;
8658: l_d_start igs_ca_inst_all.start_dt%TYPE;
8659: l_d_end igs_ca_inst_all.end_dt%TYPE;
8660: l_c_ret_status VARCHAR2(30);
8661:
8662:

Line 8659: l_d_end igs_ca_inst_all.end_dt%TYPE;

8655: PROCEDURE validate_derivation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8656: l_c_cal_type VARCHAR2(10);
8657: l_n_seq_num NUMBER;
8658: l_d_start igs_ca_inst_all.start_dt%TYPE;
8659: l_d_end igs_ca_inst_all.end_dt%TYPE;
8660: l_c_ret_status VARCHAR2(30);
8661:
8662:
8663: BEGIN

Line 9047: l_d_start igs_ca_inst_all.start_dt%TYPE;

9043: PROCEDURE validate_derivation(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS
9044:
9045: l_c_cal_type VARCHAR2(10);
9046: l_n_seq_num NUMBER;
9047: l_d_start igs_ca_inst_all.start_dt%TYPE;
9048: l_d_end igs_ca_inst_all.end_dt%TYPE;
9049: l_c_ret_status VARCHAR2(30);
9050:
9051:

Line 9048: l_d_end igs_ca_inst_all.end_dt%TYPE;

9044:
9045: l_c_cal_type VARCHAR2(10);
9046: l_n_seq_num NUMBER;
9047: l_d_start igs_ca_inst_all.start_dt%TYPE;
9048: l_d_end igs_ca_inst_all.end_dt%TYPE;
9049: l_c_ret_status VARCHAR2(30);
9050:
9051:
9052: BEGIN

Line 9610: l_d_start igs_ca_inst_all.start_dt%TYPE;

9606: PROCEDURE validate_derivation(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS
9607:
9608: l_c_cal_type VARCHAR2(10);
9609: l_n_seq_num NUMBER;
9610: l_d_start igs_ca_inst_all.start_dt%TYPE;
9611: l_d_end igs_ca_inst_all.end_dt%TYPE;
9612: l_c_ret_status VARCHAR2(30);
9613:
9614:

Line 9611: l_d_end igs_ca_inst_all.end_dt%TYPE;

9607:
9608: l_c_cal_type VARCHAR2(10);
9609: l_n_seq_num NUMBER;
9610: l_d_start igs_ca_inst_all.start_dt%TYPE;
9611: l_d_end igs_ca_inst_all.end_dt%TYPE;
9612: l_c_ret_status VARCHAR2(30);
9613:
9614:
9615: BEGIN

Line 10213: l_d_start igs_ca_inst_all.start_dt%TYPE;

10209: END validate_parameters;
10210:
10211: PROCEDURE validate_derivation(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS
10212:
10213: l_d_start igs_ca_inst_all.start_dt%TYPE;
10214: l_d_end igs_ca_inst_all.end_dt%TYPE;
10215: l_c_ret_status VARCHAR2(30);
10216:
10217:

Line 10214: l_d_end igs_ca_inst_all.end_dt%TYPE;

10210:
10211: PROCEDURE validate_derivation(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS
10212:
10213: l_d_start igs_ca_inst_all.start_dt%TYPE;
10214: l_d_end igs_ca_inst_all.end_dt%TYPE;
10215: l_c_ret_status VARCHAR2(30);
10216:
10217:
10218: BEGIN

Line 10351: igs_ca_inst ci,

10347: CURSOR cur_fee(cp_fee_type IN VARCHAR2) IS
10348: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
10349: FROM igs_fi_fee_type ft,
10350: igs_fi_f_typ_ca_inst ftci,
10351: igs_ca_inst ci,
10352: igs_ca_type ct,
10353: igs_ca_stat cs
10354: WHERE ft.s_fee_type IN ('TUTNFEE', 'OTHER', 'SPECIAL', 'AUDIT')
10355: AND ft.closed_ind = 'N'

Line 10383: cal_type igs_ca_inst_all.cal_type%TYPE,

10379: AND override_date_flag = 'N';
10380: l_offset_date DATE;
10381:
10382: TYPE teach_cal_rec IS RECORD(
10383: cal_type igs_ca_inst_all.cal_type%TYPE,
10384: sequence_number igs_ca_inst_all.sequence_number%TYPE
10385: );
10386: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
10387: teachCalendar_tbl teachCalendar;

Line 10384: sequence_number igs_ca_inst_all.sequence_number%TYPE

10380: l_offset_date DATE;
10381:
10382: TYPE teach_cal_rec IS RECORD(
10383: cal_type igs_ca_inst_all.cal_type%TYPE,
10384: sequence_number igs_ca_inst_all.sequence_number%TYPE
10385: );
10386: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
10387: teachCalendar_tbl teachCalendar;
10388: l_n_counter NUMBER(10);

Line 10397: FROM igs_ca_inst_rel

10393:
10394: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
10395: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
10396: SELECT sup_cal_type,sup_ci_sequence_number
10397: FROM igs_ca_inst_rel
10398: WHERE sub_cal_type = cp_load_cal
10399: AND sub_ci_sequence_number = cp_load_seq;
10400:
10401: CURSOR cur_cal_load IS

Line 10420: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,

10416: END LOOP;
10417:
10418: END createCalendar;
10419:
10420: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
10421: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
10422: BEGIN
10423: IF teachCalendar_tbl.EXISTS(1) THEN
10424: FOR i IN 1..teachCalendar_tbl.last LOOP

Line 10421: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS

10417:
10418: END createCalendar;
10419:
10420: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
10421: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
10422: BEGIN
10423: IF teachCalendar_tbl.EXISTS(1) THEN
10424: FOR i IN 1..teachCalendar_tbl.last LOOP
10425: IF cp_cal_type=teachCalendar_tbl(i).cal_type AND

Line 10823: l_d_start igs_ca_inst_all.start_dt%TYPE;

10819:
10820: PROCEDURE validate_derivation(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS
10821: l_c_cal_type VARCHAR2(10);
10822: l_n_seq_num NUMBER;
10823: l_d_start igs_ca_inst_all.start_dt%TYPE;
10824: l_d_end igs_ca_inst_all.end_dt%TYPE;
10825: l_c_ret_status VARCHAR2(30);
10826:
10827: CURSOR c_ret_usec IS

Line 10824: l_d_end igs_ca_inst_all.end_dt%TYPE;

10820: PROCEDURE validate_derivation(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS
10821: l_c_cal_type VARCHAR2(10);
10822: l_n_seq_num NUMBER;
10823: l_d_start igs_ca_inst_all.start_dt%TYPE;
10824: l_d_end igs_ca_inst_all.end_dt%TYPE;
10825: l_c_ret_status VARCHAR2(30);
10826:
10827: CURSOR c_ret_usec IS
10828: SELECT non_std_usec_rtn_id,formula_method,round_method,incl_wkend_duration_flag