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_EN_UNITSETFEETRG

Line 267: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%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 ,
268: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
269: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
270: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
271: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 272: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,

268: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
269: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
270: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
271: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
272: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
273: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
274:
275: --
276: -- To rollover Ancillary related segments and the rate when the Fee Calendar Instance gets rolled over

Line 3837: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,

3833:
3834: END finp_ins_roll_uft;
3835:
3836:
3837: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
3838: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3839: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3840: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3841: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

Line 3842: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,

3838: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3839: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3840: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3841: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3842: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
3843: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3844: /*************************************************************
3845: Created By : Priya Athipatla
3846: Date Created By : 12-Jul-2004

Line 3855: l_v_unit_set_cd igs_en_unitsetfeetrg.unit_set_cd%TYPE;

3851: (reverse chronological order - newest change first)
3852: sapanigr 14-Jun-2006 Bug 5148913. Unhandled exceptions at insert row caught and appropriate
3853: error message logged.
3854: ***************************************************************/
3855: l_v_unit_set_cd igs_en_unitsetfeetrg.unit_set_cd%TYPE;
3856: l_v_version_number igs_en_unitsetfeetrg.version_number%TYPE;
3857: l_d_logical_delete_dt igs_en_unitsetfeetrg.logical_delete_dt%TYPE;
3858: l_b_record_inserted_ind BOOLEAN := FALSE;
3859: l_b_record_exists_ind BOOLEAN := FALSE;

Line 3856: l_v_version_number igs_en_unitsetfeetrg.version_number%TYPE;

3852: sapanigr 14-Jun-2006 Bug 5148913. Unhandled exceptions at insert row caught and appropriate
3853: error message logged.
3854: ***************************************************************/
3855: l_v_unit_set_cd igs_en_unitsetfeetrg.unit_set_cd%TYPE;
3856: l_v_version_number igs_en_unitsetfeetrg.version_number%TYPE;
3857: l_d_logical_delete_dt igs_en_unitsetfeetrg.logical_delete_dt%TYPE;
3858: l_b_record_inserted_ind BOOLEAN := FALSE;
3859: l_b_record_exists_ind BOOLEAN := FALSE;
3860: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 3857: l_d_logical_delete_dt igs_en_unitsetfeetrg.logical_delete_dt%TYPE;

3853: error message logged.
3854: ***************************************************************/
3855: l_v_unit_set_cd igs_en_unitsetfeetrg.unit_set_cd%TYPE;
3856: l_v_version_number igs_en_unitsetfeetrg.version_number%TYPE;
3857: l_d_logical_delete_dt igs_en_unitsetfeetrg.logical_delete_dt%TYPE;
3858: l_b_record_inserted_ind BOOLEAN := FALSE;
3859: l_b_record_exists_ind BOOLEAN := FALSE;
3860: l_v_message_name fnd_new_messages.message_name%TYPE;
3861: l_rowid ROWID := NULL;

Line 3862: l_d_create_dt igs_en_unitsetfeetrg.create_dt%TYPE;

3858: l_b_record_inserted_ind BOOLEAN := FALSE;
3859: l_b_record_exists_ind BOOLEAN := FALSE;
3860: l_v_message_name fnd_new_messages.message_name%TYPE;
3861: l_rowid ROWID := NULL;
3862: l_d_create_dt igs_en_unitsetfeetrg.create_dt%TYPE;
3863:
3864: -- Cursor to obtain data from Source Calendar Instance
3865: CURSOR c_usft_source IS
3866: SELECT uft.unit_set_cd,

Line 3869: FROM igs_en_unitsetfeetrg uft

3865: CURSOR c_usft_source IS
3866: SELECT uft.unit_set_cd,
3867: uft.version_number,
3868: uft.fee_trigger_group_number
3869: FROM igs_en_unitsetfeetrg uft
3870: WHERE uft.fee_cat = p_fee_cat
3871: AND uft.fee_cal_type = p_source_cal_type
3872: AND uft.fee_ci_sequence_number = p_source_sequence_number
3873: AND uft.fee_type = p_fee_type

Line 3877: CURSOR c_usft_dest (cp_unit_set_cd igs_en_unitsetfeetrg.unit_set_cd%TYPE,

3873: AND uft.fee_type = p_fee_type
3874: AND uft.logical_delete_dt IS NULL;
3875:
3876: -- Cursor to check IF data already exists in Destination Calendar Instance
3877: CURSOR c_usft_dest (cp_unit_set_cd igs_en_unitsetfeetrg.unit_set_cd%TYPE,
3878: cp_version_number igs_en_unitsetfeetrg.version_number%TYPE) IS
3879: SELECT uft.unit_set_cd,
3880: uft.version_number,
3881: uft.logical_delete_dt

Line 3878: cp_version_number igs_en_unitsetfeetrg.version_number%TYPE) IS

3874: AND uft.logical_delete_dt IS NULL;
3875:
3876: -- Cursor to check IF data already exists in Destination Calendar Instance
3877: CURSOR c_usft_dest (cp_unit_set_cd igs_en_unitsetfeetrg.unit_set_cd%TYPE,
3878: cp_version_number igs_en_unitsetfeetrg.version_number%TYPE) IS
3879: SELECT uft.unit_set_cd,
3880: uft.version_number,
3881: uft.logical_delete_dt
3882: FROM igs_en_unitsetfeetrg uft

Line 3882: FROM igs_en_unitsetfeetrg uft

3878: cp_version_number igs_en_unitsetfeetrg.version_number%TYPE) IS
3879: SELECT uft.unit_set_cd,
3880: uft.version_number,
3881: uft.logical_delete_dt
3882: FROM igs_en_unitsetfeetrg uft
3883: WHERE uft.fee_cat = p_fee_cat
3884: AND uft.fee_cal_type = p_dest_cal_type
3885: AND uft.fee_ci_sequence_number = p_dest_sequence_number
3886: AND uft.fee_type = p_fee_type

Line 3916: igs_en_unitsetfeetrg_pkg.insert_row( x_rowid => l_rowid,

3912: CLOSE c_usft_dest;
3913: l_rowid := NULL;
3914: l_d_create_dt := SYSDATE;
3915: BEGIN
3916: igs_en_unitsetfeetrg_pkg.insert_row( x_rowid => l_rowid,
3917: x_fee_cat => p_fee_cat,
3918: x_fee_cal_type => p_dest_cal_type,
3919: x_fee_ci_sequence_number => p_dest_sequence_number,
3920: x_fee_type => p_fee_type,