DBA Data[Home] [Help]

APPS.FA_CIP_PVT dependencies on FA_ADJUSTMENTS

Line 57: l_adj_row_rec FA_ADJUSTMENTS%rowtype;

53: l_security_context XLA_EVENTS_PUB_PKG.t_security;
54:
55: cap_rev_err exception;
56:
57: l_adj_row_rec FA_ADJUSTMENTS%rowtype;
58:
59: CURSOR c_mrc_adjustments (p_thid number) IS
60: SELECT code_combination_id ,
61: distribution_id ,

Line 65: FROM fa_adjustments_mrc_v

61: distribution_id ,
62: debit_credit_flag ,
63: adjustment_amount ,
64: adjustment_type
65: FROM fa_adjustments_mrc_v
66: WHERE transaction_header_id = p_thid;
67:
68: CURSOR c_adjustments (p_thid number) IS
69: SELECT code_combination_id ,

Line 74: FROM fa_adjustments

70: distribution_id ,
71: debit_credit_flag ,
72: adjustment_amount ,
73: adjustment_type
74: FROM fa_adjustments
75: WHERE transaction_header_id = p_thid;
76:
77: BEGIN
78:

Line 668: 'from fa_adjustments'

664:
665: if (p_log_level_rec.statement_level) then
666: fa_debug_pkg.add(l_calling_fn,
667: 'reversing accounting impacts for cap',
668: 'from fa_adjustments'
669: ,p_log_level_rec => p_log_level_rec);
670: end if;
671:
672: if (p_mrc_sob_type_code = 'R') then

Line 795: delete from fa_adjustments

791: end if;
792:
793: if (p_mrc_sob_type_code <> 'R') then
794:
795: delete from fa_adjustments
796: where transaction_header_id = g_cap_thid;
797:
798: else
799:

Line 800: delete from fa_adjustments_mrc_v

796: where transaction_header_id = g_cap_thid;
797:
798: else
799:
800: delete from fa_adjustments_mrc_v
801: where transaction_header_id = g_cap_thid;
802:
803: end if;
804: