PACKAGE: APPS.FA_MC_UPG1_PKG

Source

1 PACKAGE FA_MC_UPG1_PKG AUTHID CURRENT_USER AS
2 /* $Header: faxmcu1s.pls 120.3 2009/03/27 10:25:46 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;