APPS.IGS_FI_PRC_BALANCES dependencies on IGS_FI_BALANCES_PKG

Line 339: igs_fi_balances_pkg.update_row(

335:
336: --update the row in igs_fi_balances table if already a record exists with a combination of party,
337: --balance type and balance date.
338: -- Removed the parameter subaccount_id, as a part of Bug # 2564643
339: igs_fi_balances_pkg.update_row(
340: X_ROWID => l_cur_rec_exists.rowid,
341: X_BALANCE_ID => l_cur_rec_exists.balance_id,
342: X_PARTY_ID => l_cur_rec_exists.party_id,
343: X_STANDARD_BALANCE => l_cur_rec_exists.standard_balance,

Line 361: igs_fi_balances_pkg.insert_row

357: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
358: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
359: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
360:
361: igs_fi_balances_pkg.insert_row
362: ( X_ROWID => l_rowid,
363: X_BALANCE_ID => l_balance_id,
364: X_PARTY_ID => p_person_id,
365: X_STANDARD_BALANCE => l_bal_standard,

Line 531: -- OTHER as these have been obsolete.Modified tbh calls(igs_fi_balances_pkg)accordingly.

527: --Who When What
528: --abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
529: --vvutukur 01-Oct-2002 Enh#2562745.Removed cursors c_inst_balance,c_other_balance and their
530: -- usage in the code.Also removed references to balance types INSTALLMENT,
531: -- OTHER as these have been obsolete.Modified tbh calls(igs_fi_balances_pkg)accordingly.
532: --smvk 17-Sep-2002 Removed the references of the parameter p_subaccount_id from this function, as a part of Bug # 2564643
533: --smadathi 03-Jul-2002 Bug 2443082. Modified cursor c_std_balance, c_fee_balance, c_holds_balance,c_inst_balance,
534: -- c_other_balance select statements.
535: --agairola 30-May-2002 Bug # 2364505, modified the code for the removal of the Standard Balance Rule Id

Line 670: igs_fi_balances_pkg.insert_row ( X_ROWID => l_rowid ,

666: l_bal_fee := igs_fi_gen_gl.get_formatted_amount(l_bal_fee);
667: l_bal_hold := igs_fi_gen_gl.get_formatted_amount(l_bal_hold);
668:
669:
670: igs_fi_balances_pkg.insert_row ( X_ROWID => l_rowid ,
671: X_BALANCE_ID => l_balance_id ,
672: X_PARTY_ID => p_party_id ,
673: /* Removed the subaccount from this procedure call, as a part of Bug # 2564643 */
674: X_STANDARD_BALANCE => l_bal_standard ,

Line 694: igs_fi_balances_pkg.update_row

690:
691: IF p_balance_type = 'STANDARD' THEN
692: BEGIN
693: l_n_table_standard_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_standard_balance);
694: igs_fi_balances_pkg.update_row
695: (
696: X_ROWID => rec_upd_balance.rowid ,
697: X_BALANCE_ID => rec_upd_balance.balance_id ,
698: X_PARTY_ID => rec_upd_balance.party_id ,

Line 718: igs_fi_balances_pkg.update_row

714:
715: ELSIF p_balance_type = 'FEE' THEN
716: BEGIN
717: l_n_table_fee_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_fee_balance);
718: igs_fi_balances_pkg.update_row
719: ( X_ROWID => rec_upd_balance.rowid ,
720: X_BALANCE_ID => rec_upd_balance.balance_id ,
721: X_PARTY_ID => rec_upd_balance.party_id ,
722: /* Removed the subaccount from this procedure call, as a part of Bug # 2564643 */

Line 740: igs_fi_balances_pkg.update_row

736:
737: ELSIF p_balance_type = 'HOLDS' THEN
738: BEGIN
739: l_n_table_holds_balance :=igs_fi_gen_gl.get_formatted_amount(l_n_table_holds_balance);
740: igs_fi_balances_pkg.update_row
741: ( X_ROWID => rec_upd_balance.rowid ,
742: X_BALANCE_ID => rec_upd_balance.balance_id ,
743: X_PARTY_ID => rec_upd_balance.party_id ,
744: /* Removed the subaccount from this procedure call, as a part of Bug # 2564643 */

Line 1094: -- tbh calls(igs_fi_balances_pkg) as the same are obsolete.

1090: --Change History:
1091: --Who When What
1092: --abshriva 12-May-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
1093: --vvutukur 01-Oct-2002 Enh#2562745.Removed references to balance types INSTALLMENT,OTHER from
1094: -- tbh calls(igs_fi_balances_pkg) as the same are obsolete.
1095: --smvk 17-Sep-2002 Removed the input parameter p_n_subaccount_id and its usage
1096: -- in this function. As a part of Bug # 2564643
1097: ------------------------------------------------------------------
1098: --Cursor used for retroactive updation of the table igs_fi_balances for the

Line 1118: igs_fi_balances_pkg.update_row

1114: LOOP
1115: IF p_c_balance_type = 'STANDARD'
1116: THEN
1117: BEGIN
1118: igs_fi_balances_pkg.update_row
1119: (
1120: X_ROWID => rec_c_igs_fi_balances.rowid ,
1121: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1122: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,

Line 1141: igs_fi_balances_pkg.update_row

1137: END;
1138: ELSIF p_c_balance_type = 'FEE'
1139: THEN
1140: BEGIN
1141: igs_fi_balances_pkg.update_row
1142: (
1143: X_ROWID => rec_c_igs_fi_balances.rowid ,
1144: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1145: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,

Line 1164: igs_fi_balances_pkg.update_row

1160: END;
1161: ELSIF p_c_balance_type = 'HOLDS'
1162: THEN
1163: BEGIN
1164: igs_fi_balances_pkg.update_row
1165: (
1166: X_ROWID => rec_c_igs_fi_balances.rowid ,
1167: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1168: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,

Line 1529: IGS_FI_BALANCES_PKG.update_row ( x_rowid => l_rec_get_balances.rowid,

1525:
1526: l_balance_sum := igs_fi_gen_gl.get_formatted_amount(l_balance_sum);
1527: -- Update the cumulative balance amount in the fi_balances table under holds_balances
1528: -- and the balance_rule_id under holds_balance_rule_id
1529: IGS_FI_BALANCES_PKG.update_row ( x_rowid => l_rec_get_balances.rowid,
1530: x_balance_id => l_rec_get_balances.balance_id,
1531: x_party_id => l_rec_get_balances.party_id,
1532: x_standard_balance => l_rec_get_balances.standard_balance,
1533: x_fee_balance => l_rec_get_balances.fee_balance,