[Home] [Help]
85:
86: -- Forward declaration of function retro_update_balance
87: FUNCTION retro_update_balance
88: (
89: p_n_party_id IN igs_fi_balances.party_id%TYPE ,
90: /* Removed th parameter p_n_subaccount_id, as a part of Bug # 2564643 */
91: p_c_balance_type IN igs_lookups_view.lookup_code%TYPE ,
92: p_d_balance_date IN igs_fi_balances.balance_date%TYPE ,
93: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
88: (
89: p_n_party_id IN igs_fi_balances.party_id%TYPE ,
90: /* Removed th parameter p_n_subaccount_id, as a part of Bug # 2564643 */
91: p_c_balance_type IN igs_lookups_view.lookup_code%TYPE ,
92: p_d_balance_date IN igs_fi_balances.balance_date%TYPE ,
93: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
94: p_c_message OUT NOCOPY fnd_new_messages.message_name%TYPE
95: )
96: RETURN BOOLEAN;
103:
104: PROCEDURE calculate_balance(
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
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: ------------------------------------------------------------------
114: --Created by : Sanil Madathil, Oracle IDC
216:
217: -- Added by sarakshi, as a part of SFCR010
218: CURSOR cur_rec_exists IS
219: SELECT ifb.rowid, ifb.*
220: FROM igs_fi_balances ifb
221: WHERE party_id = p_person_id
222: AND TRUNC(balance_date) = TRUNC(p_balance_date);
223:
224: l_cur_rec_exists cur_rec_exists%ROWTYPE;
221: WHERE party_id = p_person_id
222: AND TRUNC(balance_date) = TRUNC(p_balance_date);
223:
224: l_cur_rec_exists cur_rec_exists%ROWTYPE;
225: l_invoice_amount igs_fi_balances.standard_balance%TYPE := 0.0;
226: l_credit_amount igs_fi_credits_all.amount%TYPE := 0.0;
227: l_balance igs_fi_balances.standard_balance%TYPE := 0.0;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
229: l_balance_id igs_fi_balances.balance_id%TYPE;
223:
224: l_cur_rec_exists cur_rec_exists%ROWTYPE;
225: l_invoice_amount igs_fi_balances.standard_balance%TYPE := 0.0;
226: l_credit_amount igs_fi_credits_all.amount%TYPE := 0.0;
227: l_balance igs_fi_balances.standard_balance%TYPE := 0.0;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
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;
225: l_invoice_amount igs_fi_balances.standard_balance%TYPE := 0.0;
226: l_credit_amount igs_fi_credits_all.amount%TYPE := 0.0;
227: l_balance igs_fi_balances.standard_balance%TYPE := 0.0;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
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;
226: l_credit_amount igs_fi_credits_all.amount%TYPE := 0.0;
227: l_balance igs_fi_balances.standard_balance%TYPE := 0.0;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
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;
227: l_balance igs_fi_balances.standard_balance%TYPE := 0.0;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
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;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
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;
314: l_bal_rule_hold := p_balance_rule_id;
315: END IF;
316:
317: --Added by sarakshi , as a part of SFCR010
318: --insertion/updation of record in igs_fi_balances table will happen only if p_action is 'ASONBALDATE'.
319: IF p_action = l_as_on_baldate THEN
320: OPEN cur_rec_exists ;
321: FETCH cur_rec_exists INTO l_cur_rec_exists;
322: IF cur_rec_exists%FOUND THEN
332: END IF;
333:
334: l_balance_id:= l_cur_rec_exists.balance_id;
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,
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,
347: X_FEE_BALANCE_RULE_ID => l_cur_rec_exists.fee_balance_rule_id,
348: X_HOLDS_BALANCE_RULE_ID => l_cur_rec_exists.holds_balance_rule_id,
349: X_MODE => 'R'
350: );
351: ELSE --if no record exists in igs_fi_balances...
352: l_balance_id:=null;
353: CLOSE cur_rec_exists;
354: --Insert a row in igs_fi_balances table.
355: -- Removed the parameter subaccount_id, as a part of Bug # 2564643
350: );
351: ELSE --if no record exists in igs_fi_balances...
352: l_balance_id:=null;
353: CLOSE cur_rec_exists;
354: --Insert a row in igs_fi_balances table.
355: -- Removed the parameter subaccount_id, as a part of Bug # 2564643
356:
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);
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,
408: -- Enh# 2562745.
409: --smvk 17-Sep-2002 Removed the input parameter p_subaccount_id and its usage
410: -- in this functin as a part of Bug # 2564643
411: -------------------------------------------------------------------
412: l_bal_date igs_fi_balances.balance_date%TYPE ;
413:
414: BEGIN
415:
416: -- This concurrent job is made obsolete as part of Enh#2562745. If user tried to
430:
431: END calc_balances ; /* procedure ends here */
432:
433: /**************The below procedure added as part of SFCR 10 **************/
434: PROCEDURE update_balances ( p_party_id IN igs_fi_balances.party_id%TYPE ,
435: p_balance_type IN igs_lookups_view.lookup_code%TYPE ,
436: p_balance_date IN igs_fi_balances.balance_date%TYPE ,
437: p_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
438: p_source IN VARCHAR2 ,
432:
433: /**************The below procedure added as part of SFCR 10 **************/
434: PROCEDURE update_balances ( p_party_id IN igs_fi_balances.party_id%TYPE ,
435: p_balance_type IN igs_lookups_view.lookup_code%TYPE ,
436: p_balance_date IN igs_fi_balances.balance_date%TYPE ,
437: p_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
438: p_source IN VARCHAR2 ,
439: p_source_id IN NUMBER ,
440: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
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
543: -- which are created before the balance date parameter in the descending order of balance date
544:
545: CURSOR c_std_balance IS
546: SELECT standard_balance
547: FROM igs_fi_balances
548: WHERE party_id = p_party_id
549: /* Removed the parameter p_subaccount_id from the where clause, as a part of Bug # 2564643 */
550: AND standard_balance IS NOT NULL
551: AND TO_CHAR(balance_date,'YYYYMMDD') <= TO_CHAR(p_balance_date,'YYYYMMDD')
553:
554:
555: CURSOR c_fee_balance IS
556: SELECT fee_balance
557: FROM igs_fi_balances
558: WHERE party_id = p_party_id
559: /* Removed the parameter p_subaccount_id from the where clause, as a part of Bug # 2564643 */
560: AND fee_balance IS NOT NULL
561: AND TO_CHAR(balance_date,'YYYYMMDD') <= TO_CHAR(p_balance_date,'YYYYMMDD')
563:
564:
565: CURSOR c_holds_balance IS
566: SELECT holds_balance
567: FROM igs_fi_balances
568: WHERE party_id = p_party_id
569: /* Removed the parameter p_subaccount_id from the where clause, as a part of Bug # 2564643 */
570: AND holds_balance IS NOT NULL
571: AND TO_CHAR(balance_date,'YYYYMMDD') <= TO_CHAR(p_balance_date,'YYYYMMDD')
571: AND TO_CHAR(balance_date,'YYYYMMDD') <= TO_CHAR(p_balance_date,'YYYYMMDD')
572: ORDER by balance_date desc;
573:
574:
575: /* Cursor used for updation into the table igs_fi_balances for the party_id, subaccount_id and balance_date */
576: CURSOR c_upd_balance IS
577: SELECT bal.rowid, bal.*
578: FROM igs_fi_balances bal
579: WHERE party_id = p_party_id
574:
575: /* Cursor used for updation into the table igs_fi_balances for the party_id, subaccount_id and balance_date */
576: CURSOR c_upd_balance IS
577: SELECT bal.rowid, bal.*
578: FROM igs_fi_balances bal
579: WHERE party_id = p_party_id
580: /* Removed the parameter p_subaccount_id from the where clause, as a part of Bug # 2564643 */
581: AND TO_CHAR(balance_date,'YYYYMMDD') = TO_CHAR(p_balance_date,'YYYYMMDD');
582:
584: l_b_insert BOOLEAN := FALSE;
585: rec_upd_balance c_upd_balance%ROWTYPE;
586:
587: l_rowid rowid;
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 ;
585: rec_upd_balance c_upd_balance%ROWTYPE;
586:
587: l_rowid rowid;
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 ;
586:
587: l_rowid rowid;
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:
587: l_rowid rowid;
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;
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;
598:
599:
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;
598:
599:
600:
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;
598:
599:
600:
601: BEGIN
659: p_message := 'IGS_GE_INVALID_VALUE';
660: RETURN FALSE;
661: END IF;
662:
663: /* Start of insert into the IGS_FI_BALANCES */
664: BEGIN
665: l_bal_standard := igs_fi_gen_gl.get_formatted_amount(l_bal_standard);
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);
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 ,
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 ,
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 */
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 */
1069:
1070:
1071: FUNCTION retro_update_balance
1072: (
1073: p_n_party_id IN igs_fi_balances.party_id%TYPE ,
1074: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
1075: p_c_balance_type IN igs_lookups_view.lookup_code%TYPE ,
1076: p_d_balance_date IN igs_fi_balances.balance_date%TYPE ,
1077: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
1072: (
1073: p_n_party_id IN igs_fi_balances.party_id%TYPE ,
1074: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
1075: p_c_balance_type IN igs_lookups_view.lookup_code%TYPE ,
1076: p_d_balance_date IN igs_fi_balances.balance_date%TYPE ,
1077: p_n_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
1078: p_c_message OUT NOCOPY fnd_new_messages.message_name%TYPE
1079: )
1080: RETURN BOOLEAN AS
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
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
1099: --party_id, subaccount_id and balance_date
1100:
1101: CURSOR c_igs_fi_balances IS
1102: SELECT bal.rowid, bal.*
1097: ------------------------------------------------------------------
1098: --Cursor used for retroactive updation of the table igs_fi_balances for the
1099: --party_id, subaccount_id and balance_date
1100:
1101: CURSOR c_igs_fi_balances IS
1102: SELECT bal.rowid, bal.*
1103: FROM igs_fi_balances bal
1104: WHERE party_id = p_n_party_id
1105: AND TO_CHAR(balance_date,'YYYYMMDD') > TO_CHAR(p_d_balance_date,'YYYYMMDD')
1099: --party_id, subaccount_id and balance_date
1100:
1101: CURSOR c_igs_fi_balances IS
1102: SELECT bal.rowid, bal.*
1103: FROM igs_fi_balances bal
1104: WHERE party_id = p_n_party_id
1105: AND TO_CHAR(balance_date,'YYYYMMDD') > TO_CHAR(p_d_balance_date,'YYYYMMDD')
1106: ORDER BY balance_date ;
1107:
1104: WHERE party_id = p_n_party_id
1105: AND TO_CHAR(balance_date,'YYYYMMDD') > TO_CHAR(p_d_balance_date,'YYYYMMDD')
1106: ORDER BY balance_date ;
1107:
1108: rec_c_igs_fi_balances c_igs_fi_balances%ROWTYPE;
1109:
1110: BEGIN
1111: -- for retroactive updation all the records whose balance date is greater than the
1112: -- parameter balance date will be fetched and updated with the amount
1109:
1110: BEGIN
1111: -- for retroactive updation all the records whose balance date is greater than the
1112: -- parameter balance date will be fetched and updated with the amount
1113: FOR rec_c_igs_fi_balances IN c_igs_fi_balances
1114: LOOP
1115: IF p_c_balance_type = 'STANDARD'
1116: THEN
1117: BEGIN
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 ,
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 ,
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
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 ,
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
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 ,
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
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 ,
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1127: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1128: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1121: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1122: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1127: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1128: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1129: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1122: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1127: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1128: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1129: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1130: X_MODE => 'R'
1123: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1127: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1128: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1129: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1130: X_MODE => 'R'
1131: ) ;
1124: X_STANDARD_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.standard_balance,0) + NVL(p_n_amount,0)) ,
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1127: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1128: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1129: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1130: X_MODE => 'R'
1131: ) ;
1132: EXCEPTION
1125: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1126: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1127: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1128: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1129: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1130: X_MODE => 'R'
1131: ) ;
1132: EXCEPTION
1133: WHEN OTHERS THEN
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 ,
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 ,
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
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 ,
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
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 ,
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
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 ,
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1150: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1151: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1144: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1145: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1150: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1151: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1152: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1145: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1150: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1151: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1152: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1153: X_MODE => 'R'
1146: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1150: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1151: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1152: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1153: X_MODE => 'R'
1154: ) ;
1147: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1150: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1151: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1152: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1153: X_MODE => 'R'
1154: ) ;
1155: EXCEPTION
1148: X_FEE_BALANCE => igs_fi_gen_gl.get_formatted_amount(NVL(rec_c_igs_fi_balances.fee_balance,0) + NVL(p_n_amount,0) ) ,
1149: X_HOLDS_BALANCE => rec_c_igs_fi_balances.holds_balance ,
1150: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1151: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1152: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1153: X_MODE => 'R'
1154: ) ;
1155: EXCEPTION
1156: WHEN OTHERS THEN
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 ,
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 ,
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
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 ,
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
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 ,
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
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 ,
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
1173: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1174: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1167: X_BALANCE_ID => rec_c_igs_fi_balances.balance_id ,
1168: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
1173: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1174: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1175: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1168: X_PARTY_ID => rec_c_igs_fi_balances.party_id ,
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
1173: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1174: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1175: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1176: X_MODE => 'R'
1169: /* Removed subaccount_id from this procedure call, as a part of Bug # 2564643 */
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
1173: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1174: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1175: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1176: X_MODE => 'R'
1177: ) ;
1170: X_STANDARD_BALANCE => rec_c_igs_fi_balances.standard_balance ,
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
1173: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1174: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1175: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1176: X_MODE => 'R'
1177: ) ;
1178: EXCEPTION
1171: X_FEE_BALANCE => rec_c_igs_fi_balances.fee_balance ,
1172: X_HOLDS_BALANCE => igs_fi_gen_gl.get_formatted_amount( NVL(rec_c_igs_fi_balances.holds_balance,0) + NVL(p_n_amount,0) ) ,
1173: X_BALANCE_DATE => rec_c_igs_fi_balances.balance_date ,
1174: X_FEE_BALANCE_RULE_ID => rec_c_igs_fi_balances.fee_balance_rule_id ,
1175: X_HOLDS_BALANCE_RULE_ID => rec_c_igs_fi_balances.holds_balance_rule_id ,
1176: X_MODE => 'R'
1177: ) ;
1178: EXCEPTION
1179: WHEN OTHERS THEN
1314:
1315: -- to obtain all the records in the balances table for conversion
1316: CURSOR c_get_balances IS
1317: SELECT fb.rowid, fb.*
1318: FROM igs_fi_balances fb
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
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;
1338: l_message_name_1 fnd_new_messages.message_name%TYPE := NULL;
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;
1338: l_message_name_1 fnd_new_messages.message_name%TYPE := NULL;
1339: l_msg_str_0 VARCHAR2(1000) := NULL;
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;
1338: l_message_name_1 fnd_new_messages.message_name%TYPE := NULL;
1339: l_msg_str_0 VARCHAR2(1000) := NULL;
1340: l_msg_str_1 VARCHAR2(1000) := NULL;
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,