DBA Data[Home] [Help]

PACKAGE: APPS.QP_CURRENCY_PVT

Source


1 PACKAGE QP_Currency_PVT AS
2 /* $Header: QPXVCURS.pls 120.1 2005/06/14 21:55:49 appldev  $ */
3 
4 --  Start of Comments
5 --  API name    Process_Currency
6 --  Type        Private
7 --  Function
8 --
9 --  Pre-reqs
10 --
11 --  Parameters
12 --
13 --  Version     Current version = 1.0
14 --              Initial version = 1.0
15 --
16 --  Notes
17 --
18 --  End of Comments
19 
20 PROCEDURE Process_Currency
21 (   p_api_version_number            IN  NUMBER
22 ,   p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE
23 ,   p_commit                        IN  VARCHAR2 := FND_API.G_FALSE
24 ,   p_validation_level              IN  NUMBER := FND_API.G_VALID_LEVEL_FULL
25 ,   p_control_rec                   IN  QP_GLOBALS.Control_Rec_Type :=
26                                         QP_GLOBALS.G_MISS_CONTROL_REC
27 ,   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
29 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 ,   p_CURR_LISTS_rec                IN  QP_Currency_PUB.Curr_Lists_Rec_Type :=
31                                         QP_Currency_PUB.G_MISS_CURR_LISTS_REC
32 ,   p_old_CURR_LISTS_rec            IN  QP_Currency_PUB.Curr_Lists_Rec_Type :=
33                                         QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34 ,   p_CURR_DETAILS_tbl              IN  QP_Currency_PUB.Curr_Details_Tbl_Type :=
35                                         QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36 ,   p_old_CURR_DETAILS_tbl          IN  QP_Currency_PUB.Curr_Details_Tbl_Type :=
37                                         QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
38 ,   x_CURR_LISTS_rec                OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
39 ,   x_CURR_DETAILS_tbl              OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
40 );
41 
42 --  Start of Comments
43 --  API name    Lock_Currency
44 --  Type        Private
45 --  Function
46 --
47 --  Pre-reqs
48 --
49 --  Parameters
50 --
51 --  Version     Current version = 1.0
52 --              Initial version = 1.0
53 --
54 --  Notes
55 --
56 --  End of Comments
57 
58 PROCEDURE Lock_Currency
59 (   p_api_version_number            IN  NUMBER
60 ,   p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE
61 ,   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
63 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 ,   p_CURR_LISTS_rec                IN  QP_Currency_PUB.Curr_Lists_Rec_Type :=
65                                         QP_Currency_PUB.G_MISS_CURR_LISTS_REC
66 ,   p_CURR_DETAILS_tbl              IN  QP_Currency_PUB.Curr_Details_Tbl_Type :=
67                                         QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
68 ,   x_CURR_LISTS_rec                OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
69 ,   x_CURR_DETAILS_tbl              OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
70 );
71 
72 --  Start of Comments
73 --  API name    Get_Currency
74 --  Type        Private
75 --  Function
76 --
77 --  Pre-reqs
78 --
79 --  Parameters
80 --
81 --  Version     Current version = 1.0
82 --              Initial version = 1.0
83 --
84 --  Notes
85 --
86 --  End of Comments
87 
88 PROCEDURE Get_Currency
89 (   p_api_version_number            IN  NUMBER
90 ,   p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE
91 ,   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
93 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 ,   p_currency_header_id            IN  NUMBER
95 ,   x_CURR_LISTS_rec                OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
96 ,   x_CURR_DETAILS_tbl              OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
97 );
98 
99 END QP_Currency_PVT;