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.IGS_FI_GEN_008 dependencies on IGS_FI_TP_RET_SCHD

Line 385: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,

381:
382: END get_retention_params;
383:
384:
385: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,
386: p_n_fee_ci_sequence_number IN igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
387: p_v_fee_type IN igs_fi_tp_ret_schd.fee_type%TYPE,
388: p_v_teach_cal_type IN igs_fi_tp_ret_schd.teach_cal_type%TYPE,
389: p_n_teach_ci_sequence_number IN igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,

Line 386: p_n_fee_ci_sequence_number IN igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,

382: END get_retention_params;
383:
384:
385: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,
386: p_n_fee_ci_sequence_number IN igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
387: p_v_fee_type IN igs_fi_tp_ret_schd.fee_type%TYPE,
388: p_v_teach_cal_type IN igs_fi_tp_ret_schd.teach_cal_type%TYPE,
389: p_n_teach_ci_sequence_number IN igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
390: p_d_effective_date IN DATE,

Line 387: p_v_fee_type IN igs_fi_tp_ret_schd.fee_type%TYPE,

383:
384:
385: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,
386: p_n_fee_ci_sequence_number IN igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
387: p_v_fee_type IN igs_fi_tp_ret_schd.fee_type%TYPE,
388: p_v_teach_cal_type IN igs_fi_tp_ret_schd.teach_cal_type%TYPE,
389: p_n_teach_ci_sequence_number IN igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
390: p_d_effective_date IN DATE,
391: p_n_diff_amount IN NUMBER) RETURN NUMBER IS

Line 388: p_v_teach_cal_type IN igs_fi_tp_ret_schd.teach_cal_type%TYPE,

384:
385: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,
386: p_n_fee_ci_sequence_number IN igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
387: p_v_fee_type IN igs_fi_tp_ret_schd.fee_type%TYPE,
388: p_v_teach_cal_type IN igs_fi_tp_ret_schd.teach_cal_type%TYPE,
389: p_n_teach_ci_sequence_number IN igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
390: p_d_effective_date IN DATE,
391: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
392: /**************************************************************************

Line 389: p_n_teach_ci_sequence_number IN igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,

385: FUNCTION get_teach_retention( p_v_fee_cal_type IN igs_fi_tp_ret_schd.fee_cal_type%TYPE,
386: p_n_fee_ci_sequence_number IN igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
387: p_v_fee_type IN igs_fi_tp_ret_schd.fee_type%TYPE,
388: p_v_teach_cal_type IN igs_fi_tp_ret_schd.teach_cal_type%TYPE,
389: p_n_teach_ci_sequence_number IN igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
390: p_d_effective_date IN DATE,
391: p_n_diff_amount IN NUMBER) RETURN NUMBER IS
392: /**************************************************************************
393: Created By : Priya Athipatla

Line 405: CURSOR cur_tp_ovrd_ret(cp_v_fee_type igs_fi_tp_ret_schd.fee_type%TYPE,

401: **************************************************************************/
402:
403: -- Cursor to fetch Retention Schedules defined at Teaching Period level and
404: -- overridden at the FTCI level.
405: CURSOR cur_tp_ovrd_ret(cp_v_fee_type igs_fi_tp_ret_schd.fee_type%TYPE,
406: cp_v_fee_cal_type igs_fi_tp_ret_schd.fee_cal_type%TYPE,
407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS

Line 406: cp_v_fee_cal_type igs_fi_tp_ret_schd.fee_cal_type%TYPE,

402:
403: -- Cursor to fetch Retention Schedules defined at Teaching Period level and
404: -- overridden at the FTCI level.
405: CURSOR cur_tp_ovrd_ret(cp_v_fee_type igs_fi_tp_ret_schd.fee_type%TYPE,
406: cp_v_fee_cal_type igs_fi_tp_ret_schd.fee_cal_type%TYPE,
407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
410: SELECT *

Line 407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,

403: -- Cursor to fetch Retention Schedules defined at Teaching Period level and
404: -- overridden at the FTCI level.
405: CURSOR cur_tp_ovrd_ret(cp_v_fee_type igs_fi_tp_ret_schd.fee_type%TYPE,
406: cp_v_fee_cal_type igs_fi_tp_ret_schd.fee_cal_type%TYPE,
407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
410: SELECT *
411: FROM igs_fi_tp_ret_schd_v

Line 408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,

404: -- overridden at the FTCI level.
405: CURSOR cur_tp_ovrd_ret(cp_v_fee_type igs_fi_tp_ret_schd.fee_type%TYPE,
406: cp_v_fee_cal_type igs_fi_tp_ret_schd.fee_cal_type%TYPE,
407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
410: SELECT *
411: FROM igs_fi_tp_ret_schd_v
412: WHERE teach_cal_type = cp_v_teach_cal_type

Line 409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS

405: CURSOR cur_tp_ovrd_ret(cp_v_fee_type igs_fi_tp_ret_schd.fee_type%TYPE,
406: cp_v_fee_cal_type igs_fi_tp_ret_schd.fee_cal_type%TYPE,
407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
410: SELECT *
411: FROM igs_fi_tp_ret_schd_v
412: WHERE teach_cal_type = cp_v_teach_cal_type
413: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num

Line 411: FROM igs_fi_tp_ret_schd_v

407: cp_n_fee_ci_sequence_num igs_fi_tp_ret_schd.fee_ci_sequence_number%TYPE,
408: cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
409: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
410: SELECT *
411: FROM igs_fi_tp_ret_schd_v
412: WHERE teach_cal_type = cp_v_teach_cal_type
413: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
414: AND fee_cal_type = cp_v_fee_cal_type
415: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num

Line 420: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,

416: AND fee_type = cp_v_fee_type
417: ORDER BY dai_alias_val;
418:
419: -- Cursor to fetch Retention Schedules defined at Teaching Period level
420: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
421: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
422: SELECT *
423: FROM igs_fi_tp_ret_schd_v
424: WHERE teach_cal_type = cp_v_teach_cal_type

Line 421: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS

417: ORDER BY dai_alias_val;
418:
419: -- Cursor to fetch Retention Schedules defined at Teaching Period level
420: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
421: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
422: SELECT *
423: FROM igs_fi_tp_ret_schd_v
424: WHERE teach_cal_type = cp_v_teach_cal_type
425: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num

Line 423: FROM igs_fi_tp_ret_schd_v

419: -- Cursor to fetch Retention Schedules defined at Teaching Period level
420: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
421: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE) IS
422: SELECT *
423: FROM igs_fi_tp_ret_schd_v
424: WHERE teach_cal_type = cp_v_teach_cal_type
425: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
426: AND fee_type IS NULL
427: AND fee_cal_type IS NULL

Line 431: l_n_ret_amount igs_fi_tp_ret_schd.ret_amount%TYPE := 0;

427: AND fee_cal_type IS NULL
428: AND fee_ci_sequence_number IS NULL
429: ORDER BY dai_alias_val;
430:
431: l_n_ret_amount igs_fi_tp_ret_schd.ret_amount%TYPE := 0;
432: l_n_ret_percent igs_fi_tp_ret_schd.ret_percentage%TYPE := 0;
433:
434: -- Flag to indicate whether or not overridden retention schedules were found
435: l_b_override_ret BOOLEAN := FALSE;

Line 432: l_n_ret_percent igs_fi_tp_ret_schd.ret_percentage%TYPE := 0;

428: AND fee_ci_sequence_number IS NULL
429: ORDER BY dai_alias_val;
430:
431: l_n_ret_amount igs_fi_tp_ret_schd.ret_amount%TYPE := 0;
432: l_n_ret_percent igs_fi_tp_ret_schd.ret_percentage%TYPE := 0;
433:
434: -- Flag to indicate whether or not overridden retention schedules were found
435: l_b_override_ret BOOLEAN := FALSE;
436:

Line 663: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,

659: AND (igs_fi_gen_008.chk_unit_prg_transfer(sua.dcnt_reason_cd) = 'N');
660:
661: -- Cursor to fetch Retention Schedules defined at Teaching Period level
662: -- Also to filter based on the Discontinued Date.
663: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
664: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
665: cp_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE) IS
666: SELECT 'X'
667: FROM igs_fi_tp_ret_schd_v

Line 664: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,

660:
661: -- Cursor to fetch Retention Schedules defined at Teaching Period level
662: -- Also to filter based on the Discontinued Date.
663: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
664: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
665: cp_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE) IS
666: SELECT 'X'
667: FROM igs_fi_tp_ret_schd_v
668: WHERE teach_cal_type = cp_v_teach_cal_type

Line 667: FROM igs_fi_tp_ret_schd_v

663: CURSOR cur_tp_ret(cp_v_teach_cal_type igs_fi_tp_ret_schd.teach_cal_type%TYPE,
664: cp_n_teach_ci_seq_num igs_fi_tp_ret_schd.teach_ci_sequence_number%TYPE,
665: cp_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE) IS
666: SELECT 'X'
667: FROM igs_fi_tp_ret_schd_v
668: WHERE teach_cal_type = cp_v_teach_cal_type
669: AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
670: AND fee_type IS NULL
671: AND fee_cal_type IS NULL