PACKAGE: APPS.PJI_PJP_FP_CURR_WRAP

Source

1 PACKAGE PJI_PJP_FP_CURR_WRAP AS
2 /* $Header: PJIPUT2S.pls 120.2 2006/03/08 00:16:15 appldev noship $ */
3 
4 
5 -----------------------------------------------------------------
6 ----- Misc apis.. wrappers for apis provided by Shane -----------
7 -----------------------------------------------------------------
8 
9 function GET_GLOBAL1_CURR_CODE RETURN VARCHAR2;
10 
11 function GET_GLOBAL2_CURR_CODE RETURN VARCHAR2;
12 
13 function GET_GLOBAL_RATE_PRIMARY
14 (p_FROM_currency_code varchar2,
15 p_exchange_date date)
16 return number;
17 
18 function GET_MAU_PRIMARY return number;
19 
20 function GET_GLOBAL_RATE_SECONDARY
21 (p_FROM_currency_code VARCHAR2,
22 p_exchange_date DATE)
23 return number;
24 
25 function GET_MAU_SECONDARY return number;
26 
27 function GET_RATE
28 (p_FROM_currency_code varchar2,
29  p_to_currency_code varchar2,
30  p_exchange_date date) return number;
31 
32 function GET_MAU (
33 p_currency_code varchar2)
34 return number;
35 
36 FUNCTION GET_WORKER_ID RETURN NUMBER;
37 
38 PROCEDURE get_ent_dates_info (
39    x_global_start_date      OUT NOCOPY  DATE
40  , x_ent_start_period_id    OUT NOCOPY  NUMBER
41  , x_ent_start_period_name  OUT NOCOPY  VARCHAR2
42  , x_ent_start_date         OUT NOCOPY  DATE
43  , x_ent_END_date           OUT NOCOPY  DATE
44  , x_global_start_J         OUT NOCOPY  VARCHAR2
45  , x_ent_start_J            OUT NOCOPY  VARCHAR2
46  , x_ent_END_J              OUT NOCOPY  VARCHAR2
47 );
48 
49 PROCEDURE get_global_currency_info (
50    x_currency_conversion_rule OUT NOCOPY  VARCHAR2
51  , x_prorating_format         OUT NOCOPY  VARCHAR2
52  , x_global1_currency_code    OUT NOCOPY  VARCHAR2
53  , x_global2_currency_code    OUT NOCOPY  VARCHAR2
54  , x_global1_currency_mau     OUT NOCOPY  NUMBER
55  , x_global2_currency_mau     OUT NOCOPY  NUMBER
56 );
57 
58 
59 PROCEDURE PRINT_TIME(p_tag IN VARCHAR2);
60 
61 
62 PROCEDURE EXCP_HANDLER
63 ( p_context        IN  VARCHAR2 := 'ERR'
64 , p_package_name   IN  VARCHAR2 := NULL
65 , p_procedure_name IN  VARCHAR2 := NULL
66 , x_return_status  OUT NOCOPY  VARCHAR2) ;
67 
68 
69 PROCEDURE INIT_ERR_STACK
70 ( p_package_name   IN  VARCHAR2 := NULL
71 , x_return_status  OUT NOCOPY  VARCHAR2) ;
72 
73 
74 PROCEDURE SET_TABLE_STATS(
75   p_own_name  IN VARCHAR2
76 , p_tab_name  IN VARCHAR2
77 , p_num_rows  IN NUMBER
78 , p_num_blks  IN NUMBER
79 , p_avg_r_len IN NUMBER
80 );
81 
82 
83 END PJI_PJP_FP_CURR_WRAP;