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_FI_UNIT_FEE_TRG

Line 258: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,

254: p_message_name OUT NOCOPY VARCHAR2 )
255: RETURN BOOLEAN;
256:
257: -- Function to roll over Unit Fee Triggers between Calendar Instances
258: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
259: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
260: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
261: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
262: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 263: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,

259: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
260: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
261: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
262: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
263: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
264: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
265:
266: -- Function to roll over Unit Set Fee Triggers between Calendar Instances
267: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,

Line 3657: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,

3653:
3654: END finp_ins_roll_trg_grp;
3655:
3656:
3657: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
3658: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3659: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3660: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3661: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 3662: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,

3658: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3659: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3660: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3661: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3662: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
3663: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3664: /*************************************************************
3665: Created By : Priya Athipatla
3666: Date Created By : 12-Jul-2004

Line 3679: l_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE;

3675: igs_ca_inst_all and to send as a token in IGS_FI_ROLLOVER_UFT_ERROR.
3676: Added an EXCEPTION to log a message in case of rolling over failure.
3677: (reverse chronological order - newest change first)
3678: ***************************************************************/
3679: l_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE;
3680: l_v_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE;
3681: l_d_logical_delete_dt igs_fi_unit_fee_trg.logical_delete_dt%TYPE;
3682: l_b_record_inserted_ind BOOLEAN := FALSE;
3683: l_b_record_exists_ind BOOLEAN := FALSE;

Line 3680: l_v_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE;

3676: Added an EXCEPTION to log a message in case of rolling over failure.
3677: (reverse chronological order - newest change first)
3678: ***************************************************************/
3679: l_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE;
3680: l_v_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE;
3681: l_d_logical_delete_dt igs_fi_unit_fee_trg.logical_delete_dt%TYPE;
3682: l_b_record_inserted_ind BOOLEAN := FALSE;
3683: l_b_record_exists_ind BOOLEAN := FALSE;
3684: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 3681: l_d_logical_delete_dt igs_fi_unit_fee_trg.logical_delete_dt%TYPE;

3677: (reverse chronological order - newest change first)
3678: ***************************************************************/
3679: l_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE;
3680: l_v_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE;
3681: l_d_logical_delete_dt igs_fi_unit_fee_trg.logical_delete_dt%TYPE;
3682: l_b_record_inserted_ind BOOLEAN := FALSE;
3683: l_b_record_exists_ind BOOLEAN := FALSE;
3684: l_v_message_name fnd_new_messages.message_name%TYPE;
3685: l_rowid ROWID := NULL;

Line 3700: FROM igs_fi_unit_fee_trg uft

3696: uft.unit_class,
3697: uft.create_dt,
3698: uft.fee_trigger_group_number
3699:
3700: FROM igs_fi_unit_fee_trg uft
3701: WHERE uft.fee_cat = p_fee_cat
3702: AND uft.fee_cal_type = p_source_cal_type
3703: AND uft.fee_ci_sequence_number = p_source_sequence_number
3704: AND uft.fee_type = p_fee_type

Line 3708: CURSOR c_alt_cd (cp_cal_type igs_fi_unit_fee_trg.cal_type%TYPE,

3704: AND uft.fee_type = p_fee_type
3705: AND uft.logical_delete_dt IS NULL;
3706:
3707:
3708: CURSOR c_alt_cd (cp_cal_type igs_fi_unit_fee_trg.cal_type%TYPE,
3709: cp_ci_sequence_number igs_fi_unit_fee_trg.ci_sequence_number%TYPE) IS
3710: SELECT cinst.alternate_code
3711: FROM igs_ca_inst_all cinst
3712: WHERE cinst.cal_type = cp_cal_type

Line 3709: cp_ci_sequence_number igs_fi_unit_fee_trg.ci_sequence_number%TYPE) IS

3705: AND uft.logical_delete_dt IS NULL;
3706:
3707:
3708: CURSOR c_alt_cd (cp_cal_type igs_fi_unit_fee_trg.cal_type%TYPE,
3709: cp_ci_sequence_number igs_fi_unit_fee_trg.ci_sequence_number%TYPE) IS
3710: SELECT cinst.alternate_code
3711: FROM igs_ca_inst_all cinst
3712: WHERE cinst.cal_type = cp_cal_type
3713: AND cinst.sequence_number = cp_ci_sequence_number;

Line 3716: CURSOR c_uft_dest (cp_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE,

3712: WHERE cinst.cal_type = cp_cal_type
3713: AND cinst.sequence_number = cp_ci_sequence_number;
3714:
3715: -- Cursor to check IF data already exists in Destination Calendar Instance
3716: CURSOR c_uft_dest (cp_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE,
3717: cp_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE) IS
3718: SELECT uft.unit_cd,
3719: uft.sequence_number,
3720: uft.logical_delete_dt

Line 3717: cp_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE) IS

3713: AND cinst.sequence_number = cp_ci_sequence_number;
3714:
3715: -- Cursor to check IF data already exists in Destination Calendar Instance
3716: CURSOR c_uft_dest (cp_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE,
3717: cp_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE) IS
3718: SELECT uft.unit_cd,
3719: uft.sequence_number,
3720: uft.logical_delete_dt
3721: FROM igs_fi_unit_fee_trg uft

Line 3721: FROM igs_fi_unit_fee_trg uft

3717: cp_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE) IS
3718: SELECT uft.unit_cd,
3719: uft.sequence_number,
3720: uft.logical_delete_dt
3721: FROM igs_fi_unit_fee_trg uft
3722: WHERE uft.fee_cat = p_fee_cat
3723: AND uft.fee_cal_type = p_dest_cal_type
3724: AND uft.fee_ci_sequence_number = p_dest_sequence_number
3725: AND uft.fee_type = p_fee_type

Line 3729: CURSOR cur_chk_version(cp_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE,cp_v_unit_version_number igs_fi_unit_fee_trg.version_number%TYPE) IS

3725: AND uft.fee_type = p_fee_type
3726: AND uft.unit_cd = cp_unit_cd
3727: AND uft.sequence_number = cp_sequence_number;
3728:
3729: CURSOR cur_chk_version(cp_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE,cp_v_unit_version_number igs_fi_unit_fee_trg.version_number%TYPE) IS
3730: SELECT 'x'
3731: FROM igs_ps_unit_ver psv,
3732: igs_ps_unit_stat stat
3733: WHERE psv.unit_cd = cp_v_unit_cd

Line 3774: igs_fi_unit_fee_trg_pkg.insert_row( x_rowid => l_rowid,

3770: app_exception.raise_exception;
3771: END IF;
3772: CLOSE cur_chk_version;
3773:
3774: igs_fi_unit_fee_trg_pkg.insert_row( x_rowid => l_rowid,
3775: x_fee_cat => p_fee_cat,
3776: x_fee_cal_type => p_dest_cal_type,
3777: x_fee_ci_sequence_number => p_dest_sequence_number,
3778: x_unit_cd => l_uft_source_rec.unit_cd,