DBA Data[Home] [Help]

APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_EN_GEN_015

Line 2082: igs_en_gen_015.enrp_get_eff_load_ci(p_person_id, p_program_cd, SYSDATE,

2078: for update nowait;
2079: l_fee_assessed VARCHAR2(1);
2080: l_message VARCHAR2(2000);
2081: BEGIN
2082: igs_en_gen_015.enrp_get_eff_load_ci(p_person_id, p_program_cd, SYSDATE,
2083: l_acad_cal_type,
2084: l_acad_ci_seq_num,
2085: l_term_cal_type,
2086: l_term_sequence_number,

Line 2475: -- call package igs_en_gen_015 to retrieve sequence number for current term

2471: l_curr_term VARCHAR2(100);
2472:
2473: BEGIN
2474:
2475: -- call package igs_en_gen_015 to retrieve sequence number for current term
2476: -- for given academic calendar
2477: igs_en_gen_015.get_curr_acad_term_cal(
2478: p_acad_cal_type => p_cal_type,
2479: p_effective_dt => SYSDATE,

Line 2477: igs_en_gen_015.get_curr_acad_term_cal(

2473: BEGIN
2474:
2475: -- call package igs_en_gen_015 to retrieve sequence number for current term
2476: -- for given academic calendar
2477: igs_en_gen_015.get_curr_acad_term_cal(
2478: p_acad_cal_type => p_cal_type,
2479: p_effective_dt => SYSDATE,
2480: p_load_cal_type => l_load_cal_type,
2481: p_load_ci_seq_num => l_load_ci_seq_num,

Line 2545: -- call package igs_en_gen_015 to retrieve sequence number for current term

2541: l_message_name VARCHAR2(80);
2542:
2543: l_prev_term VARCHAR2(100);
2544: BEGIN
2545: -- call package igs_en_gen_015 to retrieve sequence number for current term
2546: -- for given academic calendar
2547: igs_en_gen_015.get_curr_acad_term_cal(
2548: p_acad_cal_type => p_cal_type,
2549: p_effective_dt => SYSDATE,

Line 2547: igs_en_gen_015.get_curr_acad_term_cal(

2543: l_prev_term VARCHAR2(100);
2544: BEGIN
2545: -- call package igs_en_gen_015 to retrieve sequence number for current term
2546: -- for given academic calendar
2547: igs_en_gen_015.get_curr_acad_term_cal(
2548: p_acad_cal_type => p_cal_type,
2549: p_effective_dt => SYSDATE,
2550: p_load_cal_type => l_load_cal_type,
2551: p_load_ci_seq_num => l_load_ci_seq_num,

Line 2615: -- call package igs_en_gen_015 to retrieve sequence number for current term

2611: l_message_name VARCHAR2(80);
2612:
2613: l_next_term VARCHAR2(100);
2614: BEGIN
2615: -- call package igs_en_gen_015 to retrieve sequence number for current term
2616: -- for given academic calendar
2617: igs_en_gen_015.get_curr_acad_term_cal(
2618: p_acad_cal_type => p_cal_type,
2619: p_effective_dt => SYSDATE,

Line 2617: igs_en_gen_015.get_curr_acad_term_cal(

2613: l_next_term VARCHAR2(100);
2614: BEGIN
2615: -- call package igs_en_gen_015 to retrieve sequence number for current term
2616: -- for given academic calendar
2617: igs_en_gen_015.get_curr_acad_term_cal(
2618: p_acad_cal_type => p_cal_type,
2619: p_effective_dt => SYSDATE,
2620: p_load_cal_type => l_load_cal_type,
2621: p_load_ci_seq_num => l_load_ci_seq_num,