DBA Data[Home] [Help]

APPS.IGS_FI_BALANCES_PKG dependencies on IGS_FI_BALANCES_HST

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 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,