APPS.IGS_FI_BALANCES_PKG dependencies on IGS_FI_BALANCES

Line 1: PACKAGE BODY igs_fi_balances_pkg AS

1: PACKAGE BODY igs_fi_balances_pkg AS
2: /* $Header: IGSSI99B.pls 115.12 2003/02/14 07:32:31 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_balances%ROWTYPE;

Line 5: old_references igs_fi_balances%ROWTYPE;

1: PACKAGE BODY igs_fi_balances_pkg AS
2: /* $Header: IGSSI99B.pls 115.12 2003/02/14 07:32:31 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_balances%ROWTYPE;
6: new_references igs_fi_balances%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_balances%ROWTYPE;

2: /* $Header: IGSSI99B.pls 115.12 2003/02/14 07:32:31 pathipat ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_balances%ROWTYPE;
6: new_references igs_fi_balances%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 43: FROM IGS_FI_BALANCES

39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_FI_BALANCES
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 169: igs_fi_balances_hst_pkg.get_fk_igs_fi_balances(

165: || (reverse chronological order - newest change first)
166: */
167: BEGIN
168:
169: igs_fi_balances_hst_pkg.get_fk_igs_fi_balances(
170: old_references.balance_id
171: );
172: END check_child_existance;
173:

Line 189: FROM igs_fi_balances

185: || (reverse chronological order - newest change first)
186: */
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM igs_fi_balances
190: WHERE balance_id = x_balance_id
191: FOR UPDATE NOWAIT;
192:
193: lv_rowid cur_rowid%RowType;

Line 226: FROM IGS_FI_BALANCES

222: || (reverse chronological order - newest change first)
223: */
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM IGS_FI_BALANCES
227: WHERE party_id = new_references.party_id
228: AND TRUNC(balance_date) = TRUNC(new_references.balance_date)
229: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
230: FOR UPDATE NOWAIT;

Line 284: l_v_balance_type igs_fi_balances_hst.balance_type%TYPE;

280: || Change History :
281: || Who When What
282: || (reverse chronological order - newest change first)
283: */
284: l_v_balance_type igs_fi_balances_hst.balance_type%TYPE;
285: l_v_balance_amount igs_fi_balances_hst.balance_amount%TYPE;
286: l_v_balance_rule_id igs_fi_balances_hst.balance_rule_id%TYPE;
287: l_record_changed BOOLEAN := FALSE;
288: l_balance_hist_id igs_fi_balances_hst.balance_hist_id%TYPE := NULL;

Line 285: l_v_balance_amount igs_fi_balances_hst.balance_amount%TYPE;

281: || Who When What
282: || (reverse chronological order - newest change first)
283: */
284: l_v_balance_type igs_fi_balances_hst.balance_type%TYPE;
285: l_v_balance_amount igs_fi_balances_hst.balance_amount%TYPE;
286: l_v_balance_rule_id igs_fi_balances_hst.balance_rule_id%TYPE;
287: l_record_changed BOOLEAN := FALSE;
288: l_balance_hist_id igs_fi_balances_hst.balance_hist_id%TYPE := NULL;
289:

Line 286: l_v_balance_rule_id igs_fi_balances_hst.balance_rule_id%TYPE;

282: || (reverse chronological order - newest change first)
283: */
284: l_v_balance_type igs_fi_balances_hst.balance_type%TYPE;
285: l_v_balance_amount igs_fi_balances_hst.balance_amount%TYPE;
286: l_v_balance_rule_id igs_fi_balances_hst.balance_rule_id%TYPE;
287: l_record_changed BOOLEAN := FALSE;
288: l_balance_hist_id igs_fi_balances_hst.balance_hist_id%TYPE := NULL;
289:
290: BEGIN

Line 288: l_balance_hist_id igs_fi_balances_hst.balance_hist_id%TYPE := NULL;

284: l_v_balance_type igs_fi_balances_hst.balance_type%TYPE;
285: l_v_balance_amount igs_fi_balances_hst.balance_amount%TYPE;
286: l_v_balance_rule_id igs_fi_balances_hst.balance_rule_id%TYPE;
287: l_record_changed BOOLEAN := FALSE;
288: l_balance_hist_id igs_fi_balances_hst.balance_hist_id%TYPE := NULL;
289:
290: BEGIN
291:
292: l_rowid := NULL;

Line 323: IGS_FI_BALANCES_HST_PKG.INSERT_ROW ( x_rowid => l_rowid,

319: END IF;
320:
321: IF l_record_changed THEN
322:
323: IGS_FI_BALANCES_HST_PKG.INSERT_ROW ( x_rowid => l_rowid,
324: x_balance_hist_id => l_balance_hist_id,
325: x_balance_id => old_references.balance_id,
326: x_balance_type => l_v_balance_type,
327: x_balance_amount => l_v_balance_amount,

Line 483: FROM igs_fi_balances

479: standard_balance_rule_id
480: */
481: CURSOR c IS
482: SELECT rowid
483: FROM igs_fi_balances
484: WHERE balance_id = x_balance_id;
485:
486: x_last_update_date DATE;
487: x_last_updated_by NUMBER;

Line 527: SELECT igs_fi_balances_s.NEXTVAL

523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526:
527: SELECT igs_fi_balances_s.NEXTVAL
528: INTO x_balance_id
529: FROM dual;
530:
531: before_dml(

Line 549: INSERT INTO igs_fi_balances (

545: x_last_updated_by => x_last_updated_by,
546: x_last_update_login => x_last_update_login
547: );
548:
549: INSERT INTO igs_fi_balances (
550: balance_id,
551: party_id,
552: standard_balance,
553: fee_balance,

Line 633: FROM igs_fi_balances

629: holds_balance,
630: balance_date,
631: fee_balance_rule_id,
632: holds_balance_rule_id
633: FROM igs_fi_balances
634: WHERE rowid = x_rowid
635: FOR UPDATE NOWAIT;
636:
637: tlinfo c1%ROWTYPE;

Line 761: UPDATE igs_fi_balances

757: x_program_update_date := SYSDATE;
758: END IF;
759: END IF;
760:
761: UPDATE igs_fi_balances
762: SET
763: party_id = new_references.party_id,
764: standard_balance = new_references.standard_balance,
765: fee_balance = new_references.fee_balance,

Line 823: FROM igs_fi_balances

819: standard_balance_rule_id
820: */
821: CURSOR c1 IS
822: SELECT rowid
823: FROM igs_fi_balances
824: WHERE balance_id = x_balance_id;
825:
826: BEGIN
827:

Line 884: DELETE FROM igs_fi_balances

880: p_action => 'DELETE',
881: x_rowid => x_rowid
882: );
883:
884: DELETE FROM igs_fi_balances
885: WHERE rowid = x_rowid;
886:
887: IF (SQL%NOTFOUND) THEN
888: RAISE NO_DATA_FOUND;

Line 894: END igs_fi_balances_pkg;

890:
891: END delete_row;
892:
893:
894: END igs_fi_balances_pkg;