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.IGF_AP_GEN_001 dependencies on IGF_AP_FA_BASE_REC_ALL

Line 5: FUNCTION get_prog_att_start_dt(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

1: PACKAGE BODY IGF_AP_GEN_001 AS
2: /* $Header: IGFAP44B.pls 120.1 2005/11/07 01:53:12 appldev ship $ */
3:
4: --Function to get Program Attempt Start Date
5: FUNCTION get_prog_att_start_dt(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
6: RETURN DATE
7: AS
8: /*
9: || Created By : rasahoo

Line 48: FUNCTION get_anticip_compl_date(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

44: END get_prog_att_start_dt;
45:
46:
47: --Function for Anticipated Completion Date
48: FUNCTION get_anticip_compl_date(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
49: RETURN DATE
50: AS
51: /*
52: || Created By : rasahoo

Line 172: FUNCTION get_class_standing(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

168: END get_anticip_compl_date;
169:
170:
171: --Function to get Class Standing
172: FUNCTION get_class_standing(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
173: RETURN VARCHAR2
174: AS
175: /*
176: || Created By : rasahoo

Line 204: FUNCTION get_enrl_program_type(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

200: RETURN NULL;
201: END get_class_standing;
202:
203: --Function to get Program Type
204: FUNCTION get_enrl_program_type(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
205: RETURN VARCHAR2
206: AS
207: /*
208: || Created By : rasahoo

Line 241: PROCEDURE get_key_program(cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

237: RETURN NULL;
238: END get_enrl_program_type;
239:
240: --Function to get Key Program
241: PROCEDURE get_key_program(cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
242: cp_course_cd OUT NOCOPY VARCHAR2,
243: cp_version_number OUT NOCOPY NUMBER)AS
244: /*
245: || Created By : rasahoo

Line 269: PROCEDURE get_term_enrlmnt_dtl(cp_fa_base_id IN IGF_AP_FA_BASE_REC_ALL.BASE_ID%TYPE,

265: cp_version_number := NULL;
266: END get_key_program;
267:
268: --Procedure to get the applicable enrollment term details.
269: PROCEDURE get_term_enrlmnt_dtl(cp_fa_base_id IN IGF_AP_FA_BASE_REC_ALL.BASE_ID%TYPE,
270: cp_term_enr_dtl_rec OUT NOCOPY IGS_EN_SPA_TERMS%ROWTYPE) IS
271: /*
272: || Created By : sjalasut
273: || Created On : 03 Dec 2003

Line 284: CURSOR c_fa_base_rec(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)IS

280: || Change History :
281: || Who When What
282: || (reverse chronological order - newest change first)
283: */
284: CURSOR c_fa_base_rec(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)IS
285: SELECT fa.ci_cal_type, fa.ci_sequence_number, fa.person_id, ci.start_dt, ci.end_dt
286: FROM igf_ap_fa_base_rec_all fa, igs_ca_inst ci
287: WHERE fa.BASE_ID = cp_base_id and
288: fa.ci_cal_type = ci.cal_type and

Line 286: FROM igf_ap_fa_base_rec_all fa, igs_ca_inst ci

282: || (reverse chronological order - newest change first)
283: */
284: CURSOR c_fa_base_rec(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)IS
285: SELECT fa.ci_cal_type, fa.ci_sequence_number, fa.person_id, ci.start_dt, ci.end_dt
286: FROM igf_ap_fa_base_rec_all fa, igs_ca_inst ci
287: WHERE fa.BASE_ID = cp_base_id and
288: fa.ci_cal_type = ci.cal_type and
289: fa.ci_sequence_number = ci.sequence_number;
290: l_base_rec C_FA_BASE_REC%ROWTYPE;

Line 495: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

491: RETURN c_min_date_rec.enrolled_start_dt;
492: END get_enr_eff_dt_alias_val;
493:
494: PROCEDURE get_context_data_for_term(
495: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
496: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
497: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
498: p_program_cd OUT NOCOPY igs_ps_ver_all.course_cd%TYPE,
499: p_version_num OUT NOCOPY igs_ps_ver_all.version_number%TYPE,

Line 518: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

514: --veramach 29-Oct-2004 Plugged in logic to check profile value before using anticipated values
515: -------------------------------------------------------------------
516:
517: CURSOR c_fa_base_rec(
518: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
519: ) IS
520: SELECT fa.person_id
521: FROM igf_ap_fa_base_rec_all fa
522: WHERE fa.base_id = cp_base_id ;

Line 521: FROM igf_ap_fa_base_rec_all fa

517: CURSOR c_fa_base_rec(
518: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
519: ) IS
520: SELECT fa.person_id
521: FROM igf_ap_fa_base_rec_all fa
522: WHERE fa.base_id = cp_base_id ;
523: l_fa_base_rec c_fa_base_rec%ROWTYPE;
524:
525: CURSOR c_spa_terms(

Line 549: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

545: AND version_number = NVL(cp_version_num,version_number);
546: l_prog_dtls c_prog_dtls%ROWTYPE;
547:
548: CURSOR c_anticipated_val(
549: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
550: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
551: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
552: ) IS
553: SELECT *

Line 632: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

628: END get_context_data_for_term;
629:
630:
631: PROCEDURE get_term_dates(
632: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
633: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
634: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
635: p_ld_start_date OUT NOCOPY DATE,
636: p_ld_end_date OUT NOCOPY DATE

Line 709: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

705: END get_term_dates;
706:
707:
708: FUNCTION get_date_alias_val(
709: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
710: p_cal_type IN igs_ca_inst.cal_type%TYPE,
711: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
712: p_date_alias IN igs_ca_da_inst.dt_alias%TYPE
713: ) RETURN DATE IS