DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_GE_GEN_003

Line 134: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_rsv_rec.teach_cal_alternate_code,

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,
135: p_cal_type => l_c_cal_type,
136: p_ci_sequence_number => l_n_seq_num,
137: p_start_dt => l_d_start_dt,
138: p_end_dt => l_d_end_dt,

Line 908: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_uso_fclt_rec.teach_cal_alternate_code,

904: BEGIN
905:
906:
907: -- Derive Calander Type and Sequence Number
908: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_uso_fclt_rec.teach_cal_alternate_code,
909: p_cal_type => l_c_cal_type,
910: p_ci_sequence_number => l_n_seq_num,
911: p_start_dt => l_d_start_dt,
912: p_end_dt => l_d_end_dt,

Line 1190: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_cat_rec.teach_cal_alternate_code,

1186: BEGIN
1187:
1188:
1189: -- Derive Calander Type and Sequence Number
1190: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_cat_rec.teach_cal_alternate_code,
1191: p_cal_type => l_c_cal_type,
1192: p_ci_sequence_number => l_n_seq_num,
1193: p_start_dt => l_d_start_dt,
1194: p_end_dt => l_d_end_dt,

Line 1536: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_tch_rsp_ovrd_rec.teach_cal_alternate_code,

1532: BEGIN
1533:
1534:
1535: -- Derive Calander Type and Sequence Number
1536: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_tch_rsp_ovrd_rec.teach_cal_alternate_code,
1537: p_cal_type => l_c_cal_type,
1538: p_ci_sequence_number => l_n_seq_num,
1539: p_start_dt => l_d_start_dt,
1540: p_end_dt => l_d_end_dt,

Line 2018: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_as_us_ai_group_rec.teach_cal_alternate_code,

2014: BEGIN
2015:
2016:
2017: -- Derive Calander Type and Sequence Number
2018: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_as_us_ai_group_rec.teach_cal_alternate_code,
2019: p_cal_type => l_c_cal_type,
2020: p_ci_sequence_number => l_n_seq_num,
2021: p_start_dt => l_d_start_dt,
2022: p_end_dt => l_d_end_dt,

Line 2457: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_unitass_item_rec.teach_cal_alternate_code,

2453:
2454: BEGIN
2455:
2456: -- Derive Calander Type and Sequence Number
2457: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_unitass_item_rec.teach_cal_alternate_code,
2458: p_cal_type => l_c_cal_type,
2459: p_ci_sequence_number => l_n_seq_num,
2460: p_start_dt => l_d_start_dt,
2461: p_end_dt => l_d_end_dt,

Line 3170: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_uso_cm_grp_rec.teach_cal_alternate_code,

3166: BEGIN
3167:
3168:
3169: -- Derive Calander Type and Sequence Number
3170: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_uso_cm_grp_rec.teach_cal_alternate_code,
3171: p_cal_type => l_c_cal_type,
3172: p_ci_sequence_number => l_n_seq_num,
3173: p_start_dt => l_d_start_dt,
3174: p_end_dt => l_d_end_dt,

Line 3915: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_x_grp_rec.teach_cal_alternate_code,

3911: l_c_message VARCHAR2(30);
3912: BEGIN
3913:
3914: -- Derive Calander Type and Sequence Number
3915: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_x_grp_rec.teach_cal_alternate_code,
3916: p_cal_type => l_c_cal_type,
3917: p_ci_sequence_number => l_n_seq_num,
3918: p_start_dt => l_d_start_dt,
3919: p_end_dt => l_d_end_dt,

Line 4657: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_wlst_rec.teach_cal_alternate_code,

4653: l_c_message VARCHAR2(30);
4654:
4655: BEGIN
4656: -- Derive Calander Type and Sequence Number
4657: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_wlst_rec.teach_cal_alternate_code,
4658: p_cal_type => l_c_cal_type,
4659: p_ci_sequence_number => l_n_seq_num,
4660: p_start_dt => l_d_start_dt,
4661: p_end_dt => l_d_end_dt,

Line 5382: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_notes_rec.teach_cal_alternate_code,

5378: BEGIN
5379:
5380:
5381: -- Derive Calander Type and Sequence Number
5382: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_notes_rec.teach_cal_alternate_code,
5383: p_cal_type => l_c_cal_type,
5384: p_ci_sequence_number => l_n_seq_num,
5385: p_start_dt => l_d_start_dt,
5386: p_end_dt => l_d_end_dt,

Line 5807: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_assmnt_rec.teach_cal_alternate_code,

5803: BEGIN
5804:
5805:
5806: -- Derive Calander Type and Sequence Number
5807: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_assmnt_rec.teach_cal_alternate_code,
5808: p_cal_type => l_c_cal_type,
5809: p_ci_sequence_number => l_n_seq_num,
5810: p_start_dt => l_d_start_dt,
5811: p_end_dt => l_d_end_dt,

Line 6372: igs_ge_gen_003.get_calendar_instance(p_uso_ins_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

6368: ELSE
6369: -- Deriving the value of Unit section Occurrence identifier
6370:
6371: -- Deriving the Calendar Type and Calendar Sequence Number
6372: igs_ge_gen_003.get_calendar_instance(p_uso_ins_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
6373: IF l_c_ret_status <> 'SINGLE' THEN
6374: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
6375: p_uso_ins_rec.status := 'E';
6376: END IF;

Line 6861: igs_ge_gen_003.get_calendar_instance(p_usec_teach_resp_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

6857: END IF;
6858:
6859:
6860: -- Deriving the Calendar Type and Calendar Sequence Number
6861: igs_ge_gen_003.get_calendar_instance(p_usec_teach_resp_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
6862: IF l_c_ret_status <> 'SINGLE' THEN
6863: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
6864: p_usec_teach_resp_rec.status := 'E';
6865: END IF;

Line 7552: igs_ge_gen_003.get_calendar_instance(p_usec_sp_fee_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

7548:
7549: BEGIN
7550:
7551: -- Deriving the Calendar Type and Calendar Sequence Number
7552: igs_ge_gen_003.get_calendar_instance(p_usec_sp_fee_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
7553: IF l_c_ret_status <> 'SINGLE' THEN
7554: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
7555: p_usec_sp_fee_rec.status := 'E';
7556: END IF;

Line 8134: igs_ge_gen_003.get_calendar_instance(p_usec_plus_hr_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

8130:
8131: BEGIN
8132:
8133: -- Deriving the Calendar Type and Calendar Sequence Number
8134: igs_ge_gen_003.get_calendar_instance(p_usec_plus_hr_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
8135: IF l_c_ret_status <> 'SINGLE' THEN
8136: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
8137: p_usec_plus_hr_rec.status := 'E';
8138: END IF;

Line 8666: igs_ge_gen_003.get_calendar_instance(p_usec_rule_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

8662:
8663: BEGIN
8664:
8665: -- Deriving the Calendar Type and Calendar Sequence Number
8666: igs_ge_gen_003.get_calendar_instance(p_usec_rule_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
8667: IF l_c_ret_status <> 'SINGLE' THEN
8668: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
8669: p_usec_rule_rec.status := 'E';
8670: END IF;

Line 9055: igs_ge_gen_003.get_calendar_instance(p_usec_enr_dead_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

9051:
9052: BEGIN
9053:
9054: -- Deriving the Calendar Type and Calendar Sequence Number
9055: igs_ge_gen_003.get_calendar_instance(p_usec_enr_dead_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
9056: IF l_c_ret_status <> 'SINGLE' THEN
9057: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
9058: p_usec_enr_dead_rec.status := 'E';
9059: END IF;

Line 9618: igs_ge_gen_003.get_calendar_instance(p_usec_enr_dis_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

9614:
9615: BEGIN
9616:
9617: -- Deriving the Calendar Type and Calendar Sequence Number
9618: igs_ge_gen_003.get_calendar_instance(p_usec_enr_dis_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
9619: IF l_c_ret_status <> 'SINGLE' THEN
9620: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
9621: p_usec_enr_dis_rec.status := 'E';
9622: END IF;

Line 10221: igs_ge_gen_003.get_calendar_instance(p_usec_ret_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

10217:
10218: BEGIN
10219:
10220: -- Deriving the Calendar Type and Calendar Sequence Number
10221: igs_ge_gen_003.get_calendar_instance(p_usec_ret_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
10222: IF l_c_ret_status <> 'SINGLE' THEN
10223: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
10224: p_usec_ret_rec.status := 'E';
10225: END IF;

Line 10847: igs_ge_gen_003.get_calendar_instance(p_usec_ret_dtl_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);

10843:
10844: BEGIN
10845:
10846: -- Deriving the Calendar Type and Calendar Sequence Number
10847: igs_ge_gen_003.get_calendar_instance(p_usec_ret_dtl_rec.teach_cal_alternate_code,'''TEACHING''', l_c_cal_type, l_n_seq_num, l_d_start, l_d_end, l_c_ret_status);
10848: IF l_c_ret_status <> 'SINGLE' THEN
10849: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
10850: p_usec_ret_dtl_rec.status := 'E';
10851: END IF;