[Home] [Help]
PACKAGE: APPS.FA_MC_UPG1_PKG
Source
1 PACKAGE FA_MC_UPG1_PKG AS
2 /* $Header: faxmcu1s.pls 120.2 2005/10/07 14:03:36 bridgway ship $ */
3
4 FUNCTION lock_book (
5 p_book_type_code IN VARCHAR2,
6 p_rsob_id IN NUMBER)
7 RETURN BOOLEAN;
8
9 PROCEDURE validate_setup(
10 p_book_type_code IN VARCHAR2,
11 p_reporting_book IN VARCHAR2,
12 X_from_currency OUT NOCOPY VARCHAR2,
13 X_to_currency OUT NOCOPY VARCHAR2,
14 X_rsob_id OUT NOCOPY NUMBER,
15 X_psob_id OUT NOCOPY NUMBER);
16
17 PROCEDURE validate_rate (
18 p_book_type_code IN VARCHAR2,
19 p_rsob_id IN NUMBER,
20 p_fixed_rate IN VARCHAR2,
21 X_fixed_conversion OUT NOCOPY VARCHAR2);
22
23 PROCEDURE set_conversion_status(
24 p_book_type_code IN VARCHAR2,
25 p_rsob_id IN NUMBER,
26 p_start_pc IN NUMBER,
27 p_end_pc IN NUMBER,
28 p_fixed_conversion IN VARCHAR2,
29 p_mode IN VARCHAR2);
30
31 PROCEDURE get_conversion_info(
32 p_book_type_code IN VARCHAR2,
33 p_psob_id IN NUMBER,
34 p_rsob_id IN NUMBER,
35 X_start_pc OUT NOCOPY NUMBER,
36 X_end_pc OUT NOCOPY NUMBER,
37 X_conv_date OUT NOCOPY DATE,
38 X_conv_type OUT NOCOPY VARCHAR2,
39 X_accounting_date OUT NOCOPY DATE);
40
41 PROCEDURE get_candidate_assets(
42 p_book_type_code IN VARCHAR2,
43 p_rsob_id IN NUMBER,
44 p_start_pc IN NUMBER,
45 p_end_pc IN NUMBER,
46 p_exchange_rate IN NUMBER,
47 p_fixed_rate IN VARCHAR2,
48 X_total_assets OUT NOCOPY NUMBER);
49
50 PROCEDURE check_preview_status(
51 p_book_type_code IN VARCHAR2,
52 p_rsob_id IN NUMBER,
53 p_end_pc IN NUMBER);
54
55 PROCEDURE get_currency_precision(
56 p_to_currency IN VARCHAR2,
57 X_precision OUT NOCOPY NUMBER,
58 X_mau OUT NOCOPY NUMBER);
59
60 PROCEDURE get_rate_info(
61 p_from_currency IN VARCHAR2,
62 p_to_currency IN VARCHAR2,
63 p_conv_date IN DATE,
64 p_conv_type IN VARCHAR2,
65 X_denominator_rate OUT NOCOPY NUMBER,
66 X_numerator_rate OUT NOCOPY NUMBER,
67 X_rate OUT NOCOPY NUMBER,
68 X_relation OUT NOCOPY VARCHAR2,
69 X_fixed_rate OUT NOCOPY VARCHAR2);
70
71
72 PROCEDURE convert_reporting_book(
73 p_book_type_code IN VARCHAR2,
74 p_reporting_book IN VARCHAR2,
75 p_fixed_rate IN VARCHAR2);
76
77
78 PROCEDURE convert_assets(
79 p_rsob_id IN NUMBER,
80 p_book_type_code IN VARCHAR2,
81 p_start_pc IN NUMBER,
82 p_end_pc IN NUMBER,
83 p_numerator_rate IN NUMBER,
84 p_denominator_rate IN NUMBER,
85 p_mau IN NUMBER,
86 p_precision IN NUMBER,
87 p_fixed_conversion IN VARCHAR2);
88
89 PROCEDURE create_drop_indexes(
90 p_mode IN VARCHAR2);
91
92
93 PROCEDURE Write_ErrMsg_Log(
94 msg_count IN NUMBER);
95
96 PROCEDURE Write_DebugMsg_Log(
97 p_msg_count IN NUMBER);
98
99
100 END FA_MC_UPG1_PKG;