APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_GE_GEN_003

Line 309: instead of function igs_ge_gen_003.get_person_id to derive the person id.

305: sarakshi 11-Dec-2002 Bug#2702240,derived values for state_financail_aid,federal_financial_aid,
306: institutional_financial_aid,same_teaching_period,exclude_from_cp_limit,
307: record_exclusion_flag,ss_display_ind,special_permission_ind
308: smvk 26-Dec-2002 Bug # 2721495. Calling the procedure igs_ps_validate_lgcy_pkg.get_party_id
309: instead of function igs_ge_gen_003.get_person_id to derive the person id.
310: ***********************************************************************************************/
311: CURSOR c_unit_lvl(cp_level_code igs_ps_unit_type_lvl.level_code%TYPE) IS
312: SELECT unit_type_id
313: FROM igs_ps_unit_type_lvl

Line 464: igs_ge_gen_003.get_calendar_instance(p_unit_ver_rec.enrol_load_alt_cd,

460: END IF;
461:
462: --derive cal type and seq number for enrol load alternate code
463: IF p_unit_ver_rec.enrol_load_alt_cd IS NOT NULL THEN
464: igs_ge_gen_003.get_calendar_instance(p_unit_ver_rec.enrol_load_alt_cd,
465: NULL,
466: l_c_cal_type_enrol_load_cal,
467: l_n_seq_num_enrol_load_cal,
468: l_d_start_date,

Line 479: igs_ge_gen_003.get_calendar_instance(p_unit_ver_rec.offer_load_alt_cd,

475: END IF;
476:
477: --derive cal type and seq number for offer load alternate code
478: IF p_unit_ver_rec.offer_load_alt_cd IS NOT NULL THEN
479: igs_ge_gen_003.get_calendar_instance(p_unit_ver_rec.offer_load_alt_cd,
480: NULL,
481: l_c_cal_type_offer_load_cal,
482: l_n_seq_num_offer_load_cal,
483: l_d_start_date,

Line 1351: igs_ge_gen_003.get_org_id,

1347: (
1348: p_unit_ver_rec.curriculum_id,
1349: p_unit_ver_rec.curriculum_description,
1350: p_unit_ver_rec.curriculum_closed_ind,
1351: igs_ge_gen_003.get_org_id,
1352: SYSDATE,
1353: g_n_user_id,
1354: SYSDATE,
1355: g_n_user_id,

Line 1573: igs_ge_gen_003.get_org_id,

1569: p_unit_ver_rec.override_enrollment_max,
1570: l_n_rpt_fmly_id,
1571: l_n_unit_type_id,
1572: p_unit_ver_rec.special_permission_ind,
1573: igs_ge_gen_003.get_org_id,
1574: p_unit_ver_rec.ss_enrol_ind,
1575: p_unit_ver_rec.ivr_enrol_ind,
1576: p_unit_ver_rec.rev_account_cd,
1577: p_unit_ver_rec.claimable_hours,

Line 2506: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_rec.teach_cal_alternate_code,

2502: PROCEDURE validate_uo_derivations ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2503: l_c_message VARCHAR2(30);
2504: BEGIN
2505: -- Derive Calander Type and Sequence Number
2506: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_rec.teach_cal_alternate_code,
2507: p_cal_type => l_c_cal_type,
2508: p_ci_sequence_number => l_n_seq_num,
2509: p_start_dt => l_d_start_dt,
2510: p_end_dt => l_d_end_dt,

Line 2965: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_rec.sup_teach_cal_alternate_code,

2961: ELSIF p_usec_rec.sup_unit_cd IS NOT NULL THEN
2962:
2963:
2964: -- Derive Calander Type and Sequence Number for sup alternate code
2965: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_rec.sup_teach_cal_alternate_code,
2966: p_cal_type => l_c_sup_cal_type,
2967: p_ci_sequence_number => l_n_sup_seq_num,
2968: p_start_dt => l_d_sup_start_dt,
2969: p_end_dt => l_d_sup_end_dt,

Line 5761: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_gs_rec.teach_cal_alternate_code,

5757: BEGIN
5758:
5759:
5760: -- Derive Calander Type and Sequence Number
5761: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_gs_rec.teach_cal_alternate_code,
5762: p_cal_type => l_c_cal_type,
5763: p_ci_sequence_number => l_n_seq_num,
5764: p_start_dt => l_d_start_dt,
5765: p_end_dt => l_d_end_dt,

Line 6191: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_uso_rec.teach_cal_alternate_code,

6187: BEGIN
6188: l_c_message :=NULL;
6189:
6190: -- Derive Calander Type and Sequence Number
6191: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_uso_rec.teach_cal_alternate_code,
6192: p_cal_type => l_c_cal_type,
6193: p_ci_sequence_number => l_n_seq_num,
6194: p_start_dt => l_d_start_dt,
6195: p_end_dt => l_d_end_dt,

Line 7461: igs_ge_gen_003.get_calendar_instance(p_ref_cd_rec.teach_cal_alternate_code, '''TEACHING''', l_c_cal_type,l_n_seq_num,l_d_start,l_d_end,l_ret_status);

7457:
7458: BEGIN
7459:
7460: -- Deriving the Calendar Type and Calendar Sequence Number
7461: igs_ge_gen_003.get_calendar_instance(p_ref_cd_rec.teach_cal_alternate_code, '''TEACHING''', l_c_cal_type,l_n_seq_num,l_d_start,l_d_end,l_ret_status);
7462: IF l_ret_status <> 'SINGLE' THEN
7463: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
7464: p_ref_cd_rec.status := 'E';
7465: END IF;

Line 7510: igs_ge_gen_003.get_calendar_instance(p_ref_cd_rec.teach_cal_alternate_code, '''TEACHING''', l_c_cal_type,l_n_seq_num,l_d_start,l_d_end,l_ret_status);

7506:
7507: BEGIN
7508:
7509: -- Deriving the Calendar Type and Calendar Sequence Number
7510: igs_ge_gen_003.get_calendar_instance(p_ref_cd_rec.teach_cal_alternate_code, '''TEACHING''', l_c_cal_type,l_n_seq_num,l_d_start,l_d_end,l_ret_status);
7511: IF l_ret_status <> 'SINGLE' THEN
7512: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
7513: p_ref_cd_rec.status := 'E';
7514: END IF;

Line 8474: 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);

8470: ELSE
8471: -- Deriving the value of Unit section Occurrence identifier
8472:
8473: -- Deriving the Calendar Type and Calendar Sequence Number
8474: 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);
8475: IF l_c_ret_status <> 'SINGLE' THEN
8476: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);
8477: p_uso_ins_rec.status := 'E';
8478: END IF;