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.

[Home] [Help]

APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_FI_FEE_TRG_GRP

Line 215: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,

211: p_message_name OUT NOCOPY VARCHAR2 )
212: RETURN BOOLEAN;
213:
214: -- Function to roll over Fee Trigger Groups
215: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
216: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
217: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
218: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
219: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 220: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,

216: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
217: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
218: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
219: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
220: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
221: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
222:
223: --
224: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances

Line 3544: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,

3540:
3541: END finpl_ins_roll_over_ftci_accts;
3542:
3543:
3544: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
3545: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3546: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3547: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3548: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 3549: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,

3545: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3546: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3547: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3548: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3549: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
3550: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3551: /*************************************************************
3552: Created By : Priya Athipatla
3553: Date Created By : 12-Jul-2004

Line 3562: l_n_fee_trigger_group_number igs_fi_fee_trg_grp.fee_trigger_group_number%TYPE;

3558: (reverse chronological order - newest change first)
3559: sapanigr 14-Jun-2006 Bug 5148913. Unhandled exceptions at insert row caught and appropriate
3560: error message logged.
3561: ***************************************************************/
3562: l_n_fee_trigger_group_number igs_fi_fee_trg_grp.fee_trigger_group_number%TYPE;
3563: l_d_logical_delete_dt igs_fi_fee_trg_grp.logical_delete_dt%TYPE;
3564: l_b_record_inserted_ind BOOLEAN := FALSE;
3565: l_b_record_exists_ind BOOLEAN := FALSE;
3566: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 3563: l_d_logical_delete_dt igs_fi_fee_trg_grp.logical_delete_dt%TYPE;

3559: sapanigr 14-Jun-2006 Bug 5148913. Unhandled exceptions at insert row caught and appropriate
3560: error message logged.
3561: ***************************************************************/
3562: l_n_fee_trigger_group_number igs_fi_fee_trg_grp.fee_trigger_group_number%TYPE;
3563: l_d_logical_delete_dt igs_fi_fee_trg_grp.logical_delete_dt%TYPE;
3564: l_b_record_inserted_ind BOOLEAN := FALSE;
3565: l_b_record_exists_ind BOOLEAN := FALSE;
3566: l_v_message_name fnd_new_messages.message_name%TYPE;
3567: l_rowid ROWID := NULL;

Line 3574: FROM igs_fi_fee_trg_grp

3570: CURSOR c_trg_grp_source IS
3571: SELECT fee_trigger_group_number,
3572: description,
3573: comments
3574: FROM igs_fi_fee_trg_grp
3575: WHERE fee_cat = p_fee_cat
3576: AND fee_cal_type = p_source_cal_type
3577: AND fee_ci_sequence_number = p_source_sequence_number
3578: AND fee_type = p_fee_type

Line 3582: CURSOR c_trg_grp_dest (cp_fee_trigger_group_number igs_fi_fee_trg_grp.fee_trigger_group_number%TYPE) IS

3578: AND fee_type = p_fee_type
3579: AND logical_delete_dt IS NULL;
3580:
3581: -- Cursor to check IF data already exists in Destination Calendar Instance
3582: CURSOR c_trg_grp_dest (cp_fee_trigger_group_number igs_fi_fee_trg_grp.fee_trigger_group_number%TYPE) IS
3583: SELECT fee_trigger_group_number,
3584: logical_delete_dt
3585: FROM igs_fi_fee_trg_grp
3586: WHERE fee_cat = p_fee_cat

Line 3585: FROM igs_fi_fee_trg_grp

3581: -- Cursor to check IF data already exists in Destination Calendar Instance
3582: CURSOR c_trg_grp_dest (cp_fee_trigger_group_number igs_fi_fee_trg_grp.fee_trigger_group_number%TYPE) IS
3583: SELECT fee_trigger_group_number,
3584: logical_delete_dt
3585: FROM igs_fi_fee_trg_grp
3586: WHERE fee_cat = p_fee_cat
3587: AND fee_cal_type = p_dest_cal_type
3588: AND fee_ci_sequence_number = p_dest_sequence_number
3589: AND fee_type = p_fee_type

Line 3617: igs_fi_fee_trg_grp_pkg.insert_row( x_rowid => l_rowid,

3613: ELSE
3614: CLOSE c_trg_grp_dest;
3615: l_rowid := NULL;
3616: BEGIN
3617: igs_fi_fee_trg_grp_pkg.insert_row( x_rowid => l_rowid,
3618: x_fee_cat => p_fee_cat,
3619: x_fee_trigger_group_number => l_trg_grp_source_rec.fee_trigger_group_number,
3620: x_fee_cal_type => p_dest_cal_type,
3621: x_fee_ci_sequence_number => p_dest_sequence_number,