1 PACKAGE BSC_PERIODICITIES_PVT AS
2 /* $Header: BSCVPERS.pls 120.0 2005/07/21 23:35:23 appldev noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BSCVPERS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: PRIVATE specification to manage periodicities |
13 REM | NOTES |
14 REM | 14-JUL-2005 Aditya Rao Created. |
15 REM +=======================================================================+
16 */
17
18 G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_PERIODICITIES_PVT';
19
20 /*
21 Procedure Name
22 Parameters
23
24 */
25
26 PROCEDURE Create_Periodicity (
27 p_Api_Version IN NUMBER
28 ,p_Commit IN VARCHAR2
29 ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
30 ,x_Return_Status OUT NOCOPY VARCHAR2
31 ,x_Msg_Count OUT NOCOPY NUMBER
32 ,x_Msg_Data OUT NOCOPY VARCHAR2
33 );
34
35
36 PROCEDURE Retrieve_Periodicity (
37 p_Api_Version IN NUMBER
38 ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
39 ,x_Periodicities_Rec_Type OUT NOCOPY BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
40 ,x_Return_Status OUT NOCOPY VARCHAR2
41 ,x_Msg_Count OUT NOCOPY NUMBER
42 ,x_Msg_Data OUT NOCOPY VARCHAR2
43 );
44
45
46 PROCEDURE Update_Periodicity (
47 p_Api_Version IN NUMBER
48 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
49 ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
50 ,x_Structural_Flag OUT NOCOPY VARCHAR2
51 ,x_Return_Status OUT NOCOPY VARCHAR2
52 ,x_Msg_Count OUT NOCOPY NUMBER
53 ,x_Msg_Data OUT NOCOPY VARCHAR2
54 );
55
56
57 PROCEDURE Incr_Refresh_Objectives(
58 p_Commit IN VARCHAR2
59 ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
60 ,x_Return_Status OUT NOCOPY VARCHAR2
61 ,x_Msg_Count OUT NOCOPY NUMBER
62 ,x_Msg_Data OUT NOCOPY VARCHAR2
63 );
64
65 --PROCEDURE Delete_Periodicity
66 PROCEDURE Delete_Periodicity (
67 p_Api_Version IN NUMBER
68 ,p_Commit IN VARCHAR2
69 ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
70 ,x_Return_Status OUT NOCOPY VARCHAR2
71 ,x_Msg_Count OUT NOCOPY NUMBER
72 ,x_Msg_Data OUT NOCOPY VARCHAR2
73 );
74
75
76 END BSC_PERIODICITIES_PVT;