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