DBA Data[Home] [Help]

APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FA_CATEGORY_BOOKS

Line 88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;

84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;
91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;
92: x_recovery_account fa_category_books.global_attribute15%TYPE := 0;

Line 89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;

85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;
91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;
92: x_recovery_account fa_category_books.global_attribute15%TYPE := 0;
93: x_asset_cost_account_ccid fa_category_books.asset_cost_account_ccid%TYPE;

Line 90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;

86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;
91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;
92: x_recovery_account fa_category_books.global_attribute15%TYPE := 0;
93: x_asset_cost_account_ccid fa_category_books.asset_cost_account_ccid%TYPE;
94: x_book varchar2(15);

Line 91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;

87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;
91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;
92: x_recovery_account fa_category_books.global_attribute15%TYPE := 0;
93: x_asset_cost_account_ccid fa_category_books.asset_cost_account_ccid%TYPE;
94: x_book varchar2(15);
95: x_actual_cost_acct_ccid NUMBER(15);

Line 92: x_recovery_account fa_category_books.global_attribute15%TYPE := 0;

88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;
91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;
92: x_recovery_account fa_category_books.global_attribute15%TYPE := 0;
93: x_asset_cost_account_ccid fa_category_books.asset_cost_account_ccid%TYPE;
94: x_book varchar2(15);
95: x_actual_cost_acct_ccid NUMBER(15);
96: x_cost_account_code VARCHAR2(30);

Line 93: x_asset_cost_account_ccid fa_category_books.asset_cost_account_ccid%TYPE;

89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;
91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;
92: x_recovery_account fa_category_books.global_attribute15%TYPE := 0;
93: x_asset_cost_account_ccid fa_category_books.asset_cost_account_ccid%TYPE;
94: x_book varchar2(15);
95: x_actual_cost_acct_ccid NUMBER(15);
96: x_cost_account_code VARCHAR2(30);
97: x_rtn_value NUMBER;

Line 98: x_asset_cost_acct_segval fa_category_books.asset_cost_acct%TYPE;

94: x_book varchar2(15);
95: x_actual_cost_acct_ccid NUMBER(15);
96: x_cost_account_code VARCHAR2(30);
97: x_rtn_value NUMBER;
98: x_asset_cost_acct_segval fa_category_books.asset_cost_acct%TYPE;
99: x_ccid NUMBER(15);
100: x_appl_id NUMBER := 101;
101: x_apps_short_name VARCHAR2(15) := 'SQLGL';
102: x_key_flex_code VARCHAR2(15) := 'GL#';

Line 531: -- from FA_CATEGORY_BOOKS --

527: END IF;
528:
529: ---------------------------------------------------------
530: -- Find accounts and natural account segment values --
531: -- from FA_CATEGORY_BOOKS --
532: ---------------------------------------------------------
533:
534: IF (x_category_id <> rec_asset.asset_category_id) THEN
535: x_category_id := rec_asset.asset_category_id;

Line 551: FROM fa_category_books

547: x_surplus_account,
548: x_reserve_account,
549: x_expense_account,
550: x_recovery_account
551: FROM fa_category_books
552: WHERE category_id = x_category_id
553: AND book_type_code = p_book;
554:
555: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN