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 IGS_CA_INST

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 292: CURSOR c_ld_calendars_end (cp_aw_cal_type igs_ca_inst.cal_type%TYPE,

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;
291:
292: CURSOR c_ld_calendars_end (cp_aw_cal_type igs_ca_inst.cal_type%TYPE,
293: cp_aw_seq_no igs_ca_inst.sequence_number%TYPE) IS
294: SELECT ci.cal_type enrl_load_cal_type,
295: ci.sequence_number enrl_load_seq_num ,
296: ci.alternate_code terms,

Line 293: cp_aw_seq_no igs_ca_inst.sequence_number%TYPE) IS

289: fa.ci_sequence_number = ci.sequence_number;
290: l_base_rec C_FA_BASE_REC%ROWTYPE;
291:
292: CURSOR c_ld_calendars_end (cp_aw_cal_type igs_ca_inst.cal_type%TYPE,
293: cp_aw_seq_no igs_ca_inst.sequence_number%TYPE) IS
294: SELECT ci.cal_type enrl_load_cal_type,
295: ci.sequence_number enrl_load_seq_num ,
296: ci.alternate_code terms,
297: TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,

Line 300: igs_ca_inst ci,

296: ci.alternate_code terms,
297: TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,
298: TRUNC(ci.end_dt) enrolled_end_dt
299: FROM
300: igs_ca_inst ci,
301: igs_ca_type cty
302: WHERE cty.s_cal_cat = 'LOAD'
303: AND cty.cal_type = ci.cal_type
304: AND (ci.cal_type, ci.sequence_number)IN

Line 307: FROM igs_ca_inst_rel

303: AND cty.cal_type = ci.cal_type
304: AND (ci.cal_type, ci.sequence_number)IN
305: (SELECT sup_cal_type,
306: sup_ci_sequence_number
307: FROM igs_ca_inst_rel
308: WHERE sub_cal_type = cp_aw_cal_type
309: AND sub_ci_sequence_number = cp_aw_seq_no
310: UNION
311: SELECT sub_cal_type,

Line 313: FROM igs_ca_inst_rel

309: AND sub_ci_sequence_number = cp_aw_seq_no
310: UNION
311: SELECT sub_cal_type,
312: sub_ci_sequence_number
313: FROM igs_ca_inst_rel
314: WHERE sup_cal_type = cp_aw_cal_type
315: AND sup_ci_sequence_number = cp_aw_seq_no
316: )
317: ORDER BY enrolled_end_dt DESC;

Line 319: CURSOR c_ld_calendars_start(cp_aw_cal_type igs_ca_inst.cal_type%TYPE,

315: AND sup_ci_sequence_number = cp_aw_seq_no
316: )
317: ORDER BY enrolled_end_dt DESC;
318:
319: CURSOR c_ld_calendars_start(cp_aw_cal_type igs_ca_inst.cal_type%TYPE,
320: cp_aw_seq_no igs_ca_inst.sequence_number%TYPE)IS
321: SELECT ci.cal_type enrl_load_cal_type,
322: ci.sequence_number enrl_load_seq_num ,
323: ci.alternate_code terms,

Line 320: cp_aw_seq_no igs_ca_inst.sequence_number%TYPE)IS

316: )
317: ORDER BY enrolled_end_dt DESC;
318:
319: CURSOR c_ld_calendars_start(cp_aw_cal_type igs_ca_inst.cal_type%TYPE,
320: cp_aw_seq_no igs_ca_inst.sequence_number%TYPE)IS
321: SELECT ci.cal_type enrl_load_cal_type,
322: ci.sequence_number enrl_load_seq_num ,
323: ci.alternate_code terms,
324: TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,

Line 327: igs_ca_inst ci,

323: ci.alternate_code terms,
324: TRUNC(NVL(get_enr_eff_dt_alias_val(ci.cal_type,ci.sequence_number),ci.start_dt)) enrolled_start_dt,
325: TRUNC(ci.end_dt) enrolled_end_dt
326: FROM
327: igs_ca_inst ci,
328: igs_ca_type cty
329: WHERE cty.s_cal_cat = 'LOAD'
330: AND cty.cal_type = ci.cal_type
331: AND (ci.cal_type, ci.sequence_number)IN

Line 334: FROM igs_ca_inst_rel

330: AND cty.cal_type = ci.cal_type
331: AND (ci.cal_type, ci.sequence_number)IN
332: (SELECT sup_cal_type,
333: sup_ci_sequence_number
334: FROM igs_ca_inst_rel
335: WHERE sub_cal_type = cp_aw_cal_type
336: AND sub_ci_sequence_number = cp_aw_seq_no
337: UNION
338: SELECT sub_cal_type,

Line 340: FROM igs_ca_inst_rel

336: AND sub_ci_sequence_number = cp_aw_seq_no
337: UNION
338: SELECT sub_cal_type,
339: sub_ci_sequence_number
340: FROM igs_ca_inst_rel
341: WHERE sup_cal_type = cp_aw_cal_type
342: AND sup_ci_sequence_number = cp_aw_seq_no
343: )
344: ORDER BY enrolled_start_dt;

Line 346: CURSOR c_spa_terms( cp_person_id hz_parties.party_id%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_no igs_ca_inst.sequence_number%TYPE)IS

342: AND sup_ci_sequence_number = cp_aw_seq_no
343: )
344: ORDER BY enrolled_start_dt;
345:
346: CURSOR c_spa_terms( cp_person_id hz_parties.party_id%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_no igs_ca_inst.sequence_number%TYPE)IS
347: SELECT spa.*
348: FROM IGS_EN_SPA_TERMS spa,
349: (SELECT su.person_id,
350: su.course_cd,

Line 477: FUNCTION get_enr_eff_dt_alias_val (cp_cal_type IN igs_Ca_inst.cal_type%TYPE,

473: END LOOP;
474: END get_term_enrlmnt_dtl;
475:
476: --Function to get the end date alias value from the Date alias instances table
477: FUNCTION get_enr_eff_dt_alias_val (cp_cal_type IN igs_Ca_inst.cal_type%TYPE,
478: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE)RETURN DATE IS
479: CURSOR c_min_date IS
480: SELECT TRUNC(MIN(daiv.alias_val)) enrolled_start_dt
481: FROM igs_ca_da_inst_v daiv,

Line 478: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE)RETURN DATE IS

474: END get_term_enrlmnt_dtl;
475:
476: --Function to get the end date alias value from the Date alias instances table
477: FUNCTION get_enr_eff_dt_alias_val (cp_cal_type IN igs_Ca_inst.cal_type%TYPE,
478: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE)RETURN DATE IS
479: CURSOR c_min_date IS
480: SELECT TRUNC(MIN(daiv.alias_val)) enrolled_start_dt
481: FROM igs_ca_da_inst_v daiv,
482: igs_en_cal_conf secc

Line 496: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

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,
500: p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,

Line 497: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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,
500: p_program_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
501: p_org_unit OUT NOCOPY igs_ps_ver_all.responsible_org_unit_cd%TYPE

Line 527: cp_cal_type igs_ca_inst.cal_type%TYPE,

523: l_fa_base_rec c_fa_base_rec%ROWTYPE;
524:
525: CURSOR c_spa_terms(
526: cp_person_id hz_parties.party_id%TYPE,
527: cp_cal_type igs_ca_inst.cal_type%TYPE,
528: cp_seq_no igs_ca_inst.sequence_number%TYPE
529: ) IS
530: SELECT *
531: FROM igs_en_spa_terms

Line 528: cp_seq_no igs_ca_inst.sequence_number%TYPE

524:
525: CURSOR c_spa_terms(
526: cp_person_id hz_parties.party_id%TYPE,
527: cp_cal_type igs_ca_inst.cal_type%TYPE,
528: cp_seq_no igs_ca_inst.sequence_number%TYPE
529: ) IS
530: SELECT *
531: FROM igs_en_spa_terms
532: WHERE person_id = cp_person_id

Line 550: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

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 *
554: FROM igf_ap_fa_ant_data

Line 551: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

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 *
554: FROM igf_ap_fa_ant_data
555: WHERE base_id = cp_base_id

Line 633: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

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
637: ) IS

Line 634: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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
637: ) IS
638: ------------------------------------------------------------------

Line 710: p_cal_type IN igs_ca_inst.cal_type%TYPE,

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

Line 711: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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
714: ------------------------------------------------------------------
715: --Created by : ssanyal