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_GRP_FEE_TRG

Line 237: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,

233: RETURN BOOLEAN;
234: --
235: -- Routine to rollover IGS_PS_COURSE group fee triggers between cal instances
236: FUNCTION finp_ins_roll_cgft(
237: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
238: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
239: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
240: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
241: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 242: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,

238: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
239: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
240: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
241: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
243: p_message_name OUT NOCOPY VARCHAR2 )
244: RETURN BOOLEAN;
245: --
246: -- Routine to rollover IGS_PS_COURSE fee triggers between cal instances

Line 2839: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,

2835: END finp_ins_roll_ctft;
2836: --
2837: -- Routine to rollover IGS_PS_COURSE group fee triggers between cal instances
2838: FUNCTION finp_ins_roll_cgft(
2839: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
2840: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2841: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2842: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2843: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 2844: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,

2840: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2841: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2842: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2843: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2844: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
2845: p_message_name OUT NOCOPY VARCHAR2 )
2846: RETURN BOOLEAN AS
2847: /*******************************************************************/
2848: --Change History

Line 2856: v_course_group_cd IGS_PS_GRP_FEE_TRG.course_group_cd%TYPE;

2852: /*******************************************************************/
2853: gv_other_detail VARCHAR2(255);
2854: BEGIN
2855: DECLARE
2856: v_course_group_cd IGS_PS_GRP_FEE_TRG.course_group_cd%TYPE;
2857: v_logical_delete_dt IGS_PS_GRP_FEE_TRG.logical_delete_dt%TYPE;
2858: v_record_inserted_ind BOOLEAN;
2859: v_record_exists_ind BOOLEAN;
2860: v_message_name VARCHAR2(30);

Line 2857: v_logical_delete_dt IGS_PS_GRP_FEE_TRG.logical_delete_dt%TYPE;

2853: gv_other_detail VARCHAR2(255);
2854: BEGIN
2855: DECLARE
2856: v_course_group_cd IGS_PS_GRP_FEE_TRG.course_group_cd%TYPE;
2857: v_logical_delete_dt IGS_PS_GRP_FEE_TRG.logical_delete_dt%TYPE;
2858: v_record_inserted_ind BOOLEAN;
2859: v_record_exists_ind BOOLEAN;
2860: v_message_name VARCHAR2(30);
2861: l_rowid VARCHAR2(25);

Line 2864: FROM IGS_PS_GRP_FEE_TRG cgft

2860: v_message_name VARCHAR2(30);
2861: l_rowid VARCHAR2(25);
2862: CURSOR c_cgft_source IS
2863: SELECT cgft.course_group_cd
2864: FROM IGS_PS_GRP_FEE_TRG cgft
2865: WHERE cgft.fee_cat = p_fee_cat AND
2866: cgft.fee_cal_type = p_source_cal_type AND
2867: cgft.fee_ci_sequence_number = p_source_sequence_number AND
2868: cgft.fee_type = p_fee_type AND

Line 2871: cp_course_group_cd IGS_PS_GRP_FEE_TRG.course_group_cd%TYPE) IS

2867: cgft.fee_ci_sequence_number = p_source_sequence_number AND
2868: cgft.fee_type = p_fee_type AND
2869: cgft.logical_delete_dt IS NULL;
2870: CURSOR c_cgft_dest (
2871: cp_course_group_cd IGS_PS_GRP_FEE_TRG.course_group_cd%TYPE) IS
2872: SELECT cgft.course_group_cd,
2873: cgft.logical_delete_dt
2874: FROM IGS_PS_GRP_FEE_TRG cgft
2875: WHERE cgft.fee_cat = p_fee_cat AND

Line 2874: FROM IGS_PS_GRP_FEE_TRG cgft

2870: CURSOR c_cgft_dest (
2871: cp_course_group_cd IGS_PS_GRP_FEE_TRG.course_group_cd%TYPE) IS
2872: SELECT cgft.course_group_cd,
2873: cgft.logical_delete_dt
2874: FROM IGS_PS_GRP_FEE_TRG cgft
2875: WHERE cgft.fee_cat = p_fee_cat AND
2876: cgft.fee_cal_type = p_dest_cal_type AND
2877: cgft.fee_ci_sequence_number = p_dest_sequence_number AND
2878: cgft.fee_type = p_fee_type AND

Line 2882: -- This function will roll all IGS_PS_GRP_FEE_TRG records underneath a

2878: cgft.fee_type = p_fee_type AND
2879: cgft.course_group_cd = cp_course_group_cd;
2880: X_SYSDATE DATE;
2881: BEGIN
2882: -- This function will roll all IGS_PS_GRP_FEE_TRG records underneath a
2883: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2884: -- The assumption is being made that the "destination" IGS_CA_INST
2885: -- is open and active - it is the responsibility of the calling routine to
2886: -- check for this.

Line 2887: -- IGS_GE_NOTE: If some of the IGS_PS_GRP_FEE_TRG records already exist then

2883: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2884: -- The assumption is being made that the "destination" IGS_CA_INST
2885: -- is open and active - it is the responsibility of the calling routine to
2886: -- check for this.
2887: -- IGS_GE_NOTE: If some of the IGS_PS_GRP_FEE_TRG records already exist then
2888: -- these will remain unaltered.
2889: p_message_name := Null;
2890: -- 1. Process the IGS_PS_COURSE group fee trigger records matching the source
2891: -- calendar instance

Line 2895: -- Check for the existence of the IGS_PS_GRP_FEE_TRG

2891: -- calendar instance
2892: v_record_inserted_ind := FALSE;
2893: v_record_exists_ind := FALSE;
2894: FOR v_cgft_source_rec IN c_cgft_source LOOP
2895: -- Check for the existence of the IGS_PS_GRP_FEE_TRG
2896: -- record under the destination calendar
2897: OPEN c_cgft_dest(v_cgft_source_rec.course_group_cd);
2898: FETCH c_cgft_dest INTO v_course_group_cd,
2899: v_logical_delete_dt;

Line 2911: IGS_PS_GRP_FEE_TRG_PKG.INSERT_ROW(

2907: BEGIN
2908: X_SYSDATE := SYSDATE;
2909: l_rowid := NULL; -- initialise l_rowid to null before passing into the TBH
2910: -- l_rowid with a value will throw Un-Handled Exception
2911: IGS_PS_GRP_FEE_TRG_PKG.INSERT_ROW(
2912: X_ROWID=>l_rowid,
2913: X_FEE_CAT=>p_fee_cat,
2914: X_CREATE_DT=>X_SYSDATE,
2915: X_COURSE_GROUP_CD=>v_cgft_source_rec.course_group_cd,