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_BALANCES dependencies on IGS_FI_BALANCE_RULES

Line 109: p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,

105: p_person_id IN igs_pe_person_v.person_id%TYPE,
106: p_balance_type IN igs_lookup_values.lookup_code%TYPE,
107: p_balance_date IN igs_fi_balances.balance_date%TYPE,
108: p_action IN VARCHAR2,
109: p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,
110: p_balance_amount OUT NOCOPY igs_fi_balances.standard_balance%TYPE,
111: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
112: ) AS
113: ------------------------------------------------------------------

Line 233: l_bal_rule_fee igs_fi_balance_rules.balance_rule_id%TYPE := NULL;

229: l_balance_id igs_fi_balances.balance_id%TYPE;
230: l_bal_standard igs_fi_balances.standard_balance%TYPE := 0.0;
231: l_bal_fee igs_fi_balances.standard_balance%TYPE := 0.0;
232: l_bal_hold igs_fi_balances.standard_balance%TYPE := 0.0;
233: l_bal_rule_fee igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
234: l_bal_rule_hold igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
235: l_message fnd_new_messages.message_name%TYPE := NULL;
236: l_return_status BOOLEAN := FALSE;
237:

Line 234: l_bal_rule_hold igs_fi_balance_rules.balance_rule_id%TYPE := NULL;

230: l_bal_standard igs_fi_balances.standard_balance%TYPE := 0.0;
231: l_bal_fee igs_fi_balances.standard_balance%TYPE := 0.0;
232: l_bal_hold igs_fi_balances.standard_balance%TYPE := 0.0;
233: l_bal_rule_fee igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
234: l_bal_rule_hold igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
235: l_message fnd_new_messages.message_name%TYPE := NULL;
236: l_return_status BOOLEAN := FALSE;
237:
238: BEGIN

Line 480: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := NULL;

476: l_hold_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'HOLDS';
477: l_fee_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'FEE';
478: l_std_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'STANDARD';
479:
480: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
481: l_last_conversion_date DATE := NULL;
482: l_version_number igs_fi_balance_rules.version_number%TYPE := NULL;
483:
484: --removed cursor c_igs_fi_bal_rules.bug#2562745.

Line 482: l_version_number igs_fi_balance_rules.version_number%TYPE := NULL;

478: l_std_bal_type CONSTANT igs_lookup_values.lookup_code%TYPE := 'STANDARD';
479:
480: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := NULL;
481: l_last_conversion_date DATE := NULL;
482: l_version_number igs_fi_balance_rules.version_number%TYPE := NULL;
483:
484: --removed cursor c_igs_fi_bal_rules.bug#2562745.
485:
486: /** Local function for Validation of parameters **/

Line 516: FUNCTION insert_or_update_balance (p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,

512: /** Local function for Validation of parameters **/
513:
514: /* Local Function for Updation or insert into balances table */
515:
516: FUNCTION insert_or_update_balance (p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,
517: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN IS
518:
519: ------------------------------------------------------------------
520: --Created by : Syam Krishnan, Oracle IDC

Line 592: l_bal_rule_fee igs_fi_balance_rules.balance_rule_id%TYPE := NULL ;

588: l_balance_id igs_fi_balances.balance_id%TYPE := NULL;
589: l_bal_standard igs_fi_balances.standard_balance%TYPE := NULL;
590: l_bal_fee igs_fi_balances.standard_balance%TYPE := NULL;
591: l_bal_hold igs_fi_balances.standard_balance%TYPE := NULL;
592: l_bal_rule_fee igs_fi_balance_rules.balance_rule_id%TYPE := NULL ;
593: l_bal_rule_hold igs_fi_balance_rules.balance_rule_id%TYPE := NULL ;
594:
595: l_n_table_standard_balance igs_fi_balances.standard_balance%TYPE := NUll;
596: l_n_table_fee_balance igs_fi_balances.fee_balance%TYPE := NULL;

Line 593: l_bal_rule_hold igs_fi_balance_rules.balance_rule_id%TYPE := NULL ;

589: l_bal_standard igs_fi_balances.standard_balance%TYPE := NULL;
590: l_bal_fee igs_fi_balances.standard_balance%TYPE := NULL;
591: l_bal_hold igs_fi_balances.standard_balance%TYPE := NULL;
592: l_bal_rule_fee igs_fi_balance_rules.balance_rule_id%TYPE := NULL ;
593: l_bal_rule_hold igs_fi_balance_rules.balance_rule_id%TYPE := NULL ;
594:
595: l_n_table_standard_balance igs_fi_balances.standard_balance%TYPE := NUll;
596: l_n_table_fee_balance igs_fi_balances.fee_balance%TYPE := NULL;
597: l_n_table_holds_balance igs_fi_balances.holds_balance%TYPE := NUll;

Line 882: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE ,

878:
879: /*** The below check_exclusion_rules function added for the enhancement bug#2124001. ***/
880:
881: FUNCTION check_exclusion_rules (
882: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE ,
883: p_balance_date IN igs_fi_balance_rules.effective_start_date%TYPE,
884: p_source_type IN VARCHAR2 ,
885: p_source_id IN NUMBER ,
886: p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,

Line 883: p_balance_date IN igs_fi_balance_rules.effective_start_date%TYPE,

879: /*** The below check_exclusion_rules function added for the enhancement bug#2124001. ***/
880:
881: FUNCTION check_exclusion_rules (
882: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE ,
883: p_balance_date IN igs_fi_balance_rules.effective_start_date%TYPE,
884: p_source_type IN VARCHAR2 ,
885: p_source_id IN NUMBER ,
886: p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,
887: p_message_name OUT NOCOPY VARCHAR2 )

Line 886: p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,

882: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE ,
883: p_balance_date IN igs_fi_balance_rules.effective_start_date%TYPE,
884: p_source_type IN VARCHAR2 ,
885: p_source_id IN NUMBER ,
886: p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,
887: p_message_name OUT NOCOPY VARCHAR2 )
888: RETURN BOOLEAN AS
889: -------------------------------------------------------------------------------
890: -- Created By : Nishikant

Line 910: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := p_balance_rule_id;

906: -- (reverse chronological order - newest change first)
907: -------------------------------------------------------------------------------
908: l_fee_type igs_fi_inv_int_v.fee_type%TYPE;
909: l_credit_type_id igs_fi_credits_v.credit_type_id%TYPE;
910: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := p_balance_rule_id;
911: l_std_bal igs_lookup_values.lookup_code%TYPE := 'STANDARD';
912: l_sysdate DATE := TRUNC(SYSDATE);
913: l_lkp_type igs_lookup_values.lookup_type%TYPE := 'IGS_FI_BALANCE_TYPE';
914:

Line 915: CURSOR c_bal_type(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS

911: l_std_bal igs_lookup_values.lookup_code%TYPE := 'STANDARD';
912: l_sysdate DATE := TRUNC(SYSDATE);
913: l_lkp_type igs_lookup_values.lookup_type%TYPE := 'IGS_FI_BALANCE_TYPE';
914:
915: CURSOR c_bal_type(cp_balance_type igs_fi_balance_rules.balance_name%TYPE) IS
916: SELECT 'X'
917: FROM igs_lookup_values
918: WHERE lookup_type = l_lkp_type
919: AND lookup_code = cp_balance_type

Line 940: cp_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE

936:
937: /* Removed the cursor c_subacct_excl, as a part of Bug # 2564643 */
938:
939: CURSOR c_ftype_excl(cp_fee_type igs_fi_fee_type.fee_type%TYPE,
940: cp_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE
941: )IS
942: SELECT 'X'
943: FROM IGS_FI_BAL_EX_F_TYPS_V
944: WHERE fee_type = cp_fee_type

Line 948: cp_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE

944: WHERE fee_type = cp_fee_type
945: AND balance_rule_id = cp_balance_rule_id;
946:
947: CURSOR c_ctyp_excl(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
948: cp_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE
949: )IS
950: SELECT 'X'
951: FROM IGS_FI_BAL_EX_C_TYPS_V
952: WHERE credit_type_id = cp_credit_type_id

Line 1279: PROCEDURE convert_holds_balances( p_conv_st_date IN igs_fi_balance_rules.last_conversion_date%TYPE ) AS

1275:
1276: END finpl_upd_conv_prc_run_ind;
1277:
1278:
1279: PROCEDURE convert_holds_balances( p_conv_st_date IN igs_fi_balance_rules.last_conversion_date%TYPE ) AS
1280: ------------------------------------------------------------------
1281: --Created by : Priya Athipatla, Oracle IDC
1282: --Date created: 08-OCT-2002
1283: --

Line 1323: CURSOR c_rule_update(cp_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE) IS

1319: WHERE TRUNC(balance_date) >= TRUNC(p_conv_st_date)
1320: ORDER BY party_id, balance_date ;
1321:
1322: -- to obtain the rowid for the record that is to be updated after the conversion process is successful
1323: CURSOR c_rule_update(cp_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE) IS
1324: SELECT rowid
1325: FROM igs_fi_balance_rules
1326: WHERE balance_rule_id = cp_balance_rule_id;
1327:

Line 1325: FROM igs_fi_balance_rules

1321:
1322: -- to obtain the rowid for the record that is to be updated after the conversion process is successful
1323: CURSOR c_rule_update(cp_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE) IS
1324: SELECT rowid
1325: FROM igs_fi_balance_rules
1326: WHERE balance_rule_id = cp_balance_rule_id;
1327:
1328: l_rec_get_balances c_get_balances%ROWTYPE;
1329: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE;

Line 1331: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;

1327:
1328: l_rec_get_balances c_get_balances%ROWTYPE;
1329: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE;
1330: l_conv_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1331: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1332: l_version_number igs_fi_balance_rules.version_number%TYPE;
1333: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
1334: l_balance_amt igs_fi_balances.holds_balance%TYPE := 0;
1335: l_balance_sum igs_fi_balances.holds_balance%TYPE := 0;

Line 1332: l_version_number igs_fi_balance_rules.version_number%TYPE;

1328: l_rec_get_balances c_get_balances%ROWTYPE;
1329: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE;
1330: l_conv_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1331: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1332: l_version_number igs_fi_balance_rules.version_number%TYPE;
1333: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
1334: l_balance_amt igs_fi_balances.holds_balance%TYPE := 0;
1335: l_balance_sum igs_fi_balances.holds_balance%TYPE := 0;
1336: l_party_id igs_fi_balances.party_id%TYPE := NULL;

Line 1333: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;

1329: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE;
1330: l_conv_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1331: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1332: l_version_number igs_fi_balance_rules.version_number%TYPE;
1333: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
1334: l_balance_amt igs_fi_balances.holds_balance%TYPE := 0;
1335: l_balance_sum igs_fi_balances.holds_balance%TYPE := 0;
1336: l_party_id igs_fi_balances.party_id%TYPE := NULL;
1337: l_message_name fnd_new_messages.message_name%TYPE := NULL;

Line 1592: IGS_FI_BALANCE_RULES_PKG.update_row ( x_rowid => l_rowid,

1588: -- to be p_conv_st_date if the holds calculation process above completed without any errors
1589: OPEN c_rule_update(l_balance_rule_id);
1590: FETCH c_rule_update INTO l_rowid;
1591: CLOSE c_rule_update;
1592: IGS_FI_BALANCE_RULES_PKG.update_row ( x_rowid => l_rowid,
1593: x_balance_rule_id => l_balance_rule_id,
1594: x_balance_name => 'HOLDS',
1595: x_version_number => l_version_number,
1596: x_last_conversion_date => p_conv_st_date,