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_PRC_FEE_ROLLV dependencies on IGS_PS_TYPE_FEE_TRG

Line 226: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,

222:
223: --
224: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances
225: FUNCTION finp_ins_roll_ctft(
226: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
227: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
228: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
229: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
230: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 231: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,

227: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
228: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
229: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
230: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
231: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
232: p_message_name OUT NOCOPY VARCHAR2 )
233: RETURN BOOLEAN;
234: --
235: -- Routine to rollover IGS_PS_COURSE group fee triggers between cal instances

Line 2729: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,

2725: END finp_ins_roll_er;
2726: --
2727: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances
2728: FUNCTION finp_ins_roll_ctft(
2729: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
2730: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2731: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2732: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2733: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 2734: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,

2730: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2731: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2732: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2733: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2734: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
2735: p_message_name OUT NOCOPY VARCHAR2 )
2736: RETURN BOOLEAN AS
2737: /*******************************************************************/
2738: --Change History

Line 2746: v_course_type IGS_PS_TYPE_FEE_TRG.course_type%TYPE;

2742: /*******************************************************************/
2743: gv_other_detail VARCHAR2(255);
2744: BEGIN
2745: DECLARE
2746: v_course_type IGS_PS_TYPE_FEE_TRG.course_type%TYPE;
2747: v_logical_delete_dt IGS_PS_TYPE_FEE_TRG.logical_delete_dt%TYPE;
2748: v_record_inserted_ind BOOLEAN;
2749: v_record_exists_ind BOOLEAN;
2750: v_message_name VARCHAR2(30);

Line 2747: v_logical_delete_dt IGS_PS_TYPE_FEE_TRG.logical_delete_dt%TYPE;

2743: gv_other_detail VARCHAR2(255);
2744: BEGIN
2745: DECLARE
2746: v_course_type IGS_PS_TYPE_FEE_TRG.course_type%TYPE;
2747: v_logical_delete_dt IGS_PS_TYPE_FEE_TRG.logical_delete_dt%TYPE;
2748: v_record_inserted_ind BOOLEAN;
2749: v_record_exists_ind BOOLEAN;
2750: v_message_name VARCHAR2(30);
2751: l_rowid VARCHAR2(25);

Line 2754: FROM IGS_PS_TYPE_FEE_TRG ctft

2750: v_message_name VARCHAR2(30);
2751: l_rowid VARCHAR2(25);
2752: CURSOR c_ctft_source IS
2753: SELECT ctft.course_type
2754: FROM IGS_PS_TYPE_FEE_TRG ctft
2755: WHERE ctft.fee_cat = p_fee_cat AND
2756: ctft.fee_cal_type = p_source_cal_type AND
2757: ctft.fee_ci_sequence_number = p_source_sequence_number AND
2758: ctft.fee_type = p_fee_type AND

Line 2761: cp_course_type IGS_PS_TYPE_FEE_TRG.COURSE_TYPE%TYPE) IS

2757: ctft.fee_ci_sequence_number = p_source_sequence_number AND
2758: ctft.fee_type = p_fee_type AND
2759: ctft.logical_delete_dt IS NULL;
2760: CURSOR c_ctft_dest (
2761: cp_course_type IGS_PS_TYPE_FEE_TRG.COURSE_TYPE%TYPE) IS
2762: SELECT ctft.COURSE_TYPE,
2763: ctft.logical_delete_dt
2764: FROM IGS_PS_TYPE_FEE_TRG ctft
2765: WHERE ctft.fee_cat = p_fee_cat AND

Line 2764: FROM IGS_PS_TYPE_FEE_TRG ctft

2760: CURSOR c_ctft_dest (
2761: cp_course_type IGS_PS_TYPE_FEE_TRG.COURSE_TYPE%TYPE) IS
2762: SELECT ctft.COURSE_TYPE,
2763: ctft.logical_delete_dt
2764: FROM IGS_PS_TYPE_FEE_TRG ctft
2765: WHERE ctft.fee_cat = p_fee_cat AND
2766: ctft.fee_cal_type = p_dest_cal_type AND
2767: ctft.fee_ci_sequence_number = p_dest_sequence_number AND
2768: ctft.fee_type = p_fee_type AND

Line 2772: -- This function will roll all IGS_PS_TYPE_FEE_TRG records underneath a

2768: ctft.fee_type = p_fee_type AND
2769: ctft.COURSE_TYPE = cp_course_type;
2770: X_SYSDATE DATE;
2771: BEGIN
2772: -- This function will roll all IGS_PS_TYPE_FEE_TRG records underneath a
2773: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2774: -- The assumption is being made that the "destination" IGS_CA_INST
2775: -- is open and active - it is the responsibility of the calling routine to
2776: -- check for this.

Line 2777: -- IGS_GE_NOTE: If some of the IGS_PS_TYPE_FEE_TRG records already exist then these

2773: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2774: -- The assumption is being made that the "destination" IGS_CA_INST
2775: -- is open and active - it is the responsibility of the calling routine to
2776: -- check for this.
2777: -- IGS_GE_NOTE: If some of the IGS_PS_TYPE_FEE_TRG records already exist then these
2778: -- will remain unaltered.
2779: p_message_name := Null;
2780: -- 1. Process the IGS_PS_COURSE type fee trigger records matching the source
2781: -- calendar instance

Line 2785: -- Check for the existence of the IGS_PS_TYPE_FEE_TRG

2781: -- calendar instance
2782: v_record_inserted_ind := FALSE;
2783: v_record_exists_ind := FALSE;
2784: FOR v_ctft_source_rec IN c_ctft_source LOOP
2785: -- Check for the existence of the IGS_PS_TYPE_FEE_TRG
2786: -- record under the destination calendar
2787: OPEN c_ctft_dest(v_ctft_source_rec.course_type);
2788: FETCH c_ctft_dest INTO v_course_type,
2789: v_logical_delete_dt;

Line 2801: IGS_PS_TYPE_FEE_TRG_PKG.INSERT_ROW(

2797: BEGIN
2798: X_SYSDATE:=SYSDATE;
2799: l_rowid := NULL; -- initialise l_rowid to null before passing into the TBH
2800: -- l_rowid with a value will throw Un-Handled Exception
2801: IGS_PS_TYPE_FEE_TRG_PKG.INSERT_ROW(
2802: X_ROWID=>l_rowid,
2803: X_FEE_CAT=>p_fee_cat,
2804: X_FEE_TYPE=>p_fee_type,
2805: X_CREATE_DT=>X_SYSDATE,