[Home] [Help]
PACKAGE: APPS.FA_QUERY_BALANCES_PKG
Source
1 PACKAGE FA_QUERY_BALANCES_PKG as
2 /* $Header: faxqbals.pls 120.1 2005/06/24 15:14:52 msiddiqu noship $ */
3
4 PROCEDURE QUERY_BALANCES
5 (X_ASSET_ID NUMBER,
6 X_BOOK VARCHAR2,
7 X_PERIOD_CTR NUMBER DEFAULT 0,
8 X_DIST_ID NUMBER DEFAULT 0,
9 X_RUN_MODE VARCHAR2 DEFAULT 'STANDARD',
10 X_COST OUT NOCOPY NUMBER,
11 X_DEPRN_RSV OUT NOCOPY NUMBER,
12 X_REVAL_RSV OUT NOCOPY NUMBER,
13 X_YTD_DEPRN OUT NOCOPY NUMBER,
14 X_YTD_REVAL_EXP OUT NOCOPY NUMBER,
15 X_REVAL_DEPRN_EXP OUT NOCOPY NUMBER,
16 X_DEPRN_EXP OUT NOCOPY NUMBER,
17 X_REVAL_AMO OUT NOCOPY NUMBER,
18 X_PROD OUT NOCOPY NUMBER,
19 X_YTD_PROD OUT NOCOPY NUMBER,
20 X_LTD_PROD OUT NOCOPY NUMBER,
21 X_ADJ_COST OUT NOCOPY NUMBER,
22 X_REVAL_AMO_BASIS OUT NOCOPY NUMBER,
23 X_BONUS_RATE OUT NOCOPY NUMBER,
24 X_DEPRN_SOURCE_CODE OUT NOCOPY VARCHAR2,
25 X_ADJUSTED_FLAG OUT NOCOPY BOOLEAN,
26 X_TRANSACTION_HEADER_ID IN NUMBER DEFAULT -1,
27 X_BONUS_DEPRN_RSV OUT NOCOPY NUMBER,
28 X_BONUS_YTD_DEPRN OUT NOCOPY NUMBER,
29 X_BONUS_DEPRN_AMOUNT OUT NOCOPY NUMBER,
30 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
31
32
33 PROCEDURE ADD_ADJ_TO_DEPRN
34 (X_ADJ_DRS IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,
35 X_DEST_DRS IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,
36 X_MRC_SOB_TYPE_CODE VARCHAR2,
37 X_SUCCESS OUT NOCOPY BOOLEAN,
38 X_CALLING_FN VARCHAR2,
39 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
40
41 PROCEDURE QUERY_BALANCES_INT
42 (X_DPR_ROW IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,
43 X_RUN_MODE VARCHAR2,
44 X_DEBUG BOOLEAN,
45 X_SUCCESS OUT NOCOPY BOOLEAN,
46 X_CALLING_FN VARCHAR2,
47 X_TRANSACTION_HEADER_ID IN NUMBER DEFAULT -1,
48 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
49
50 PROCEDURE GET_PERIOD_INFO
51 (X_BOOK VARCHAR2,
52 X_CUR_PER_CTR IN OUT NOCOPY NUMBER,
53 X_CUR_FY IN OUT NOCOPY NUMBER,
54 X_NUM_PERS_FY IN OUT NOCOPY NUMBER,
55 X_SUCCESS OUT NOCOPY BOOLEAN,
56 X_CALLING_FN VARCHAR2,
57 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
58
59
60 PROCEDURE QUERY_DEPRN_SUMMARY
61 (X_DPR_ROW IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,
62 X_FOUND_PER_CTR IN OUT NOCOPY NUMBER,
63 X_RUN_MODE VARCHAR2,
64 X_MRC_SOB_TYPE_CODE VARCHAR2,
65 X_SUCCESS OUT NOCOPY BOOLEAN,
66 X_CALLING_FN VARCHAR2,
67 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
68
69 PROCEDURE QUERY_DEPRN_DETAIL
70 (X_DPR_ROW IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,
71 X_FOUND_PER_CTR IN OUT NOCOPY NUMBER,
72 X_IS_ACC_NULL IN OUT NOCOPY BOOLEAN,
73 X_RUN_MODE VARCHAR2,
74 X_MRC_SOB_TYPE_CODE VARCHAR2,
75 X_SUCCESS OUT NOCOPY BOOLEAN,
76 X_CALLING_FN VARCHAR2,
77 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
78
79 PROCEDURE GET_ADJUSTMENTS_INFO
80 (X_ADJ_ROW IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,
81 X_FOUND_PER_CTR IN OUT NOCOPY NUMBER,
82 X_RUN_MODE VARCHAR2,
83 X_TRANSACTION_HEADER_ID NUMBER,
84 X_MRC_SOB_TYPE_CODE VARCHAR2,
85 X_SUCCESS OUT NOCOPY BOOLEAN,
86 X_CALLING_FN VARCHAR2,
87 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
88
89 END FA_QUERY_BALANCES_PKG;