PACKAGE: APPS.FA_JP_TAX_EXTN_PVT

Source

1 PACKAGE FA_JP_TAX_EXTN_PVT AUTHID CURRENT_USER
2 /* $Header: FAVJPEXTS.pls 120.2.12010000.1 2009/07/21 12:37:42 glchen noship $   */
3 AS
4 
5   TYPE tp_whatif IS RECORD
6 		(REQUEST_ID              NUMBER,
7 		  BOOK_TYPE_CODE          VARCHAR2(15),
8 		  ASSET_ID                NUMBER,
9 		  ASSET_NUMBER            VARCHAR2(15),
10 		  DESCRIPTION             VARCHAR2(80),
11 		  TAG_NUMBER              VARCHAR2(15),
12 		  SERIAL_NUMBER           VARCHAR2(35),
13 		  PERIOD_NAME             VARCHAR2(15),
14 		  period_counter		  NUMBER,
15 		  FISCAL_YEAR             NUMBER(4),
16 		  EXPENSE_ACCT            VARCHAR2(500),
17 		  LOCATION                VARCHAR2(500),
18 		  UNITS                   NUMBER,
19 		  EMPLOYEE_NAME           VARCHAR2(240),
20 		  EMPLOYEE_NUMBER         VARCHAR2(30),
21 		  ASSET_KEY               VARCHAR2(500),
22 		  CURRENT_COST            NUMBER,
23 		  CURRENT_PRORATE_CONV    VARCHAR2(15),
24 		  CURRENT_METHOD          VARCHAR2(15),
25 		  CURRENT_LIFE            NUMBER,
26 		  CURRENT_BASIC_RATE      NUMBER,
27 		  CURRENT_ADJUSTED_RATE   NUMBER,
28 		  CURRENT_SALVAGE_VALUE   NUMBER,
29 		  DEPRECIATION            NUMBER,
30 		  NEW_DEPRECIATION        NUMBER,
31 		  CREATED_BY              NUMBER,
32 		  CREATION_DATE           DATE,
33 		  LAST_UPDATE_DATE        DATE,
34 		  LAST_UPDATED_BY         NUMBER,
35 		  LAST_UPDATE_LOGIN       NUMBER,
36 		  DATE_PLACED_IN_SERVICE  DATE,
37 		  CATEGORY                VARCHAR2(500),
38 		  ACCUMULATED_DEPRN       NUMBER,
39 		  BONUS_DEPRECIATION      NUMBER,
40 		  NEW_BONUS_DEPRECIATION  NUMBER,
41 		  CURRENT_BONUS_RULE      VARCHAR2(30),
42 		  PERIOD_NUM              NUMBER(9),
43 		  CURRENCY_CODE           VARCHAR2(15)
44 		);
45   TYPE tp_whatitf IS TABLE OF tp_whatif
46       INDEX BY BINARY_INTEGER;
47 
48  lt_whatitf      		tp_whatitf;
49 
50  PROCEDURE deprn_main (  x_errbuf                     OUT NOCOPY VARCHAR2
51                         ,x_retcode                    OUT NOCOPY NUMBER
52                         ,p_request_id                 IN  NUMBER
53                         ,p_book_type_code             IN  fa_books.book_type_code%TYPE
54                         ,p_first_begin_period         IN  VARCHAR2
55                         ,p_number_of_periods          IN  NUMBER
56                         ,p_start_period               IN  VARCHAR2
57                         ,p_checkbox_check             IN  VARCHAR2
58                         ,p_full_rsrv_checkbox         IN  VARCHAR2
59 						,p_asset_id					  IN  NUMBER
60                         );
61 
62  PROCEDURE calc_jp250db (X_request_id NUMBER,
63 										   X_asset_id NUMBER,
64 										   X_book VARCHAR2,
65 										   X_method VARCHAR2,
66 										   X_cost NUMBER,
67 										   x_cur_cost NUMBER,
68 										   X_life NUMBER,
69 										   X_rate_in_use	NUMBER,
70 										   X_deprn_lmt	NUMBER,
71 										   X_start_prd VARCHAR2,
72 										   X_dtin_serv VARCHAR2,
73 										   X_num_per NUMBER);
74 
75  FUNCTION chk_period(X_period VARCHAR2, X_book_type VARCHAR2)
76 	RETURN NUMBER;
77 
78  FUNCTION ret_counter (X_book_typ VARCHAR2, X_periodname VARCHAR2)
79 		RETURN VARCHAR2;
80 
81 END FA_JP_TAX_EXTN_PVT;