eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_INS_ADJUST_PKG dependencies on FA_CACHE_PKG

Line 4: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_INS_ADJUST_PKG as
2: /* $Header: FAXIAJ2B.pls 120.27.12020000.4 2012/11/14 10:05:51 rmandali ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: -----------------------------------------------------------------------
7: -- adj_ptr is the parameter in the original C-Code. Here adj_ptr is
8: -- global to this package and hence not required to be passed

Line 64: if not fa_cache_pkg.fazccb

60:
61: -- replace direct fetch with call to cache
62: -- for reducing db hits
63:
64: if not fa_cache_pkg.fazccb
65: (X_book => X_book_type_code,
66: X_cat_id => X_cat_id, p_log_level_rec => p_log_level_rec) then
67: FA_SRVR_MSG.ADD_MESSAGE
68: (NAME => 'FA_GET_CAT_ID',

Line 74: h_account_ccid := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;

70: return FALSE;
71: end if;
72:
73: if (X_account_type='ASSET_COST_ACCT') then
74: h_account_ccid := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
75: elsif (X_account_type='ASSET_CLEARING_ACCT') then
76: h_account_ccid := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
77: elsif (X_account_type='CIP_COST_ACCT') then
78: h_account_ccid := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;

Line 76: h_account_ccid := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;

72:
73: if (X_account_type='ASSET_COST_ACCT') then
74: h_account_ccid := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
75: elsif (X_account_type='ASSET_CLEARING_ACCT') then
76: h_account_ccid := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
77: elsif (X_account_type='CIP_COST_ACCT') then
78: h_account_ccid := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
79: elsif (X_account_type='CIP_CLEARING_ACCT') then
80: h_account_ccid := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;

Line 78: h_account_ccid := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;

74: h_account_ccid := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
75: elsif (X_account_type='ASSET_CLEARING_ACCT') then
76: h_account_ccid := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
77: elsif (X_account_type='CIP_COST_ACCT') then
78: h_account_ccid := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
79: elsif (X_account_type='CIP_CLEARING_ACCT') then
80: h_account_ccid := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
81: elsif (X_account_type='REVAL_RESERVE_ACCT') then
82: h_account_ccid := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;

Line 80: h_account_ccid := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;

76: h_account_ccid := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
77: elsif (X_account_type='CIP_COST_ACCT') then
78: h_account_ccid := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
79: elsif (X_account_type='CIP_CLEARING_ACCT') then
80: h_account_ccid := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
81: elsif (X_account_type='REVAL_RESERVE_ACCT') then
82: h_account_ccid := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
83: elsif (X_account_type='REVAL_AMORTIZATION_ACCT') then
84: h_account_ccid := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;

Line 82: h_account_ccid := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;

78: h_account_ccid := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
79: elsif (X_account_type='CIP_CLEARING_ACCT') then
80: h_account_ccid := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
81: elsif (X_account_type='REVAL_RESERVE_ACCT') then
82: h_account_ccid := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
83: elsif (X_account_type='REVAL_AMORTIZATION_ACCT') then
84: h_account_ccid := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
85: elsif (X_account_type='DEPRN_RESERVE_ACCT') then
86: h_account_ccid := fa_cache_pkg.fazccb_record.reserve_account_ccid;

Line 84: h_account_ccid := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;

80: h_account_ccid := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
81: elsif (X_account_type='REVAL_RESERVE_ACCT') then
82: h_account_ccid := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
83: elsif (X_account_type='REVAL_AMORTIZATION_ACCT') then
84: h_account_ccid := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
85: elsif (X_account_type='DEPRN_RESERVE_ACCT') then
86: h_account_ccid := fa_cache_pkg.fazccb_record.reserve_account_ccid;
87: elsif (X_account_type='BONUS_DEPRN_RESERVE_ACCT') then
88: h_account_ccid := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;

Line 86: h_account_ccid := fa_cache_pkg.fazccb_record.reserve_account_ccid;

82: h_account_ccid := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
83: elsif (X_account_type='REVAL_AMORTIZATION_ACCT') then
84: h_account_ccid := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
85: elsif (X_account_type='DEPRN_RESERVE_ACCT') then
86: h_account_ccid := fa_cache_pkg.fazccb_record.reserve_account_ccid;
87: elsif (X_account_type='BONUS_DEPRN_RESERVE_ACCT') then
88: h_account_ccid := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
89: elsif (X_account_type='IMPAIR_EXPENSE_ACCT') then
90: h_account_ccid := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;

Line 88: h_account_ccid := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;

84: h_account_ccid := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
85: elsif (X_account_type='DEPRN_RESERVE_ACCT') then
86: h_account_ccid := fa_cache_pkg.fazccb_record.reserve_account_ccid;
87: elsif (X_account_type='BONUS_DEPRN_RESERVE_ACCT') then
88: h_account_ccid := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
89: elsif (X_account_type='IMPAIR_EXPENSE_ACCT') then
90: h_account_ccid := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
91: elsif (X_account_type='IMPAIR_RESERVE_ACCT') then
92: h_account_ccid := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;

Line 90: h_account_ccid := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;

86: h_account_ccid := fa_cache_pkg.fazccb_record.reserve_account_ccid;
87: elsif (X_account_type='BONUS_DEPRN_RESERVE_ACCT') then
88: h_account_ccid := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
89: elsif (X_account_type='IMPAIR_EXPENSE_ACCT') then
90: h_account_ccid := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
91: elsif (X_account_type='IMPAIR_RESERVE_ACCT') then
92: h_account_ccid := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
93: elsif (X_account_type='REVAL_LOSS_ACCT') then
94: h_account_ccid := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;

Line 92: h_account_ccid := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;

88: h_account_ccid := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
89: elsif (X_account_type='IMPAIR_EXPENSE_ACCT') then
90: h_account_ccid := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
91: elsif (X_account_type='IMPAIR_RESERVE_ACCT') then
92: h_account_ccid := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
93: elsif (X_account_type='REVAL_LOSS_ACCT') then
94: h_account_ccid := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;
95: else
96: h_account_ccid := 0;

Line 94: h_account_ccid := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;

90: h_account_ccid := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
91: elsif (X_account_type='IMPAIR_RESERVE_ACCT') then
92: h_account_ccid := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
93: elsif (X_account_type='REVAL_LOSS_ACCT') then
94: h_account_ccid := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;
95: else
96: h_account_ccid := 0;
97: end if;
98:

Line 932: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;

928: p_log_level_rec => p_log_level_rec);
929: end if;
930:
931: -- no need to call the book controls cache here - it shoudl already be loaded
932: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
933:
934: h_mesg_name:='FA_INS_ADJ_CNT_ACTIVE';
935:
936: if (adj_ptr.selection_mode <> FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_PARTIAL) then

Line 1378: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;

1374: return FALSE;
1375: end if;
1376:
1377: -- no need to call book controls cache here - it should already be loaded
1378: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1379: if (p_log_level_rec.statement_level) then
1380: FA_DEBUG_PKG.ADD
1381: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1382: element => 'Dist Ccid in fadoclr is',

Line 1822: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;

1818: return FALSE;
1819: end if;
1820:
1821: -- no need t call book controls cache here should already be loaded
1822: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1823: h_mesg_name:='FA_INS_ADJ_CNT_ACTIVE';
1824: SELECT COUNT(*)
1825: INTO h_distribution_lines
1826: FROM FA_DISTRIBUTION_HISTORY