DBA Data[Home] [Help]

PACKAGE: APPS.OKC_SECTIONS_PVT

Source


1 PACKAGE OKC_SECTIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCCSCNS.pls 120.0 2005/05/26 09:45:34 appldev noship $ */
3 
4   subtype scnv_rec_type is okc_scn_pvt.scnv_rec_type;
5   subtype scnv_tbl_type is okc_scn_pvt.scnv_tbl_type;
6   subtype sccv_rec_type is okc_scc_pvt.sccv_rec_type;
7   subtype sccv_tbl_type is okc_scc_pvt.sccv_tbl_type;
8 
9   ---------------------------------------------------------------------------
10   -- GLOBAL VARIABLES
11   ---------------------------------------------------------------------------
12   G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKC_SECTIONS_PVT';
13   ---------------------------------------------------------------------------
14 
15   PROCEDURE create_section(
16     p_api_version                  IN NUMBER,
17     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
18     x_return_status                OUT NOCOPY VARCHAR2,
19     x_msg_count                    OUT NOCOPY NUMBER,
20     x_msg_data                     OUT NOCOPY VARCHAR2,
21     p_scnv_rec                     IN  OKC_SCN_PVT.scnv_rec_type,
22     x_scnv_rec                     OUT NOCOPY  OKC_SCN_PVT.scnv_rec_type);
23 
24   PROCEDURE create_section(
25     p_api_version                  IN NUMBER,
26     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27     x_return_status                OUT NOCOPY VARCHAR2,
28     x_msg_count                    OUT NOCOPY NUMBER,
29     x_msg_data                     OUT NOCOPY VARCHAR2,
30     p_scnv_tbl                     IN OKC_SCN_PVT.scnv_tbl_type,
31     x_scnv_tbl                     OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type);
32 
33   PROCEDURE update_section(
34     p_api_version                  IN NUMBER,
35     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36     x_return_status                OUT NOCOPY VARCHAR2,
37     x_msg_count                    OUT NOCOPY NUMBER,
38     x_msg_data                     OUT NOCOPY VARCHAR2,
39     p_scnv_rec                     IN OKC_SCN_PVT.scnv_rec_type,
40     x_scnv_rec                     OUT NOCOPY OKC_SCN_PVT.scnv_rec_type);
41 
42   PROCEDURE update_section(
43     p_api_version                  IN NUMBER,
44     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45     x_return_status                OUT NOCOPY VARCHAR2,
46     x_msg_count                    OUT NOCOPY NUMBER,
47     x_msg_data                     OUT NOCOPY VARCHAR2,
48     p_scnv_tbl                     IN OKC_SCN_PVT.scnv_tbl_type,
49     x_scnv_tbl                     OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type);
50 
51   PROCEDURE delete_section(
52     p_api_version                  IN NUMBER,
53     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54     x_return_status                OUT NOCOPY VARCHAR2,
55     x_msg_count                    OUT NOCOPY NUMBER,
56     x_msg_data                     OUT NOCOPY VARCHAR2,
57     p_scnv_rec                     IN OKC_SCN_PVT.scnv_rec_type);
58 
59   PROCEDURE delete_section(
60     p_api_version                  IN NUMBER,
61     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62     x_return_status                OUT NOCOPY VARCHAR2,
63     x_msg_count                    OUT NOCOPY NUMBER,
64     x_msg_data                     OUT NOCOPY VARCHAR2,
65     p_scnv_tbl                     IN OKC_SCN_PVT.scnv_tbl_type);
66 
67   PROCEDURE lock_section(
68     p_api_version                  IN NUMBER,
69     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70     x_return_status                OUT NOCOPY VARCHAR2,
71     x_msg_count                    OUT NOCOPY NUMBER,
72     x_msg_data                     OUT NOCOPY VARCHAR2,
73     p_scnv_rec                     IN OKC_SCN_PVT.scnv_rec_type);
74 
75   PROCEDURE lock_section(
76     p_api_version                  IN NUMBER,
77     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78     x_return_status                OUT NOCOPY VARCHAR2,
79     x_msg_count                    OUT NOCOPY NUMBER,
80     x_msg_data                     OUT NOCOPY VARCHAR2,
81     p_scnv_tbl                     IN OKC_SCN_PVT.scnv_tbl_type);
82 
83   PROCEDURE validate_section(
84     p_api_version                  IN NUMBER,
85     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86     x_return_status                OUT NOCOPY VARCHAR2,
87     x_msg_count                    OUT NOCOPY NUMBER,
88     x_msg_data                     OUT NOCOPY VARCHAR2,
89     p_scnv_rec                     IN OKC_SCN_PVT.scnv_rec_type);
90 
91   PROCEDURE validate_section(
92     p_api_version                  IN NUMBER,
93     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94     x_return_status                OUT NOCOPY VARCHAR2,
95     x_msg_count                    OUT NOCOPY NUMBER,
96     x_msg_data                     OUT NOCOPY VARCHAR2,
97     p_scnv_tbl                     IN OKC_SCN_PVT.scnv_tbl_type);
98 
99   PROCEDURE create_section_content(
100     p_api_version                  IN NUMBER,
101     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102     x_return_status                OUT NOCOPY VARCHAR2,
103     x_msg_count                    OUT NOCOPY NUMBER,
104     x_msg_data                     OUT NOCOPY VARCHAR2,
105     p_sccv_rec                     IN  OKC_SCC_PVT.sccv_rec_type,
106     x_sccv_rec                     OUT NOCOPY  OKC_SCC_PVT.sccv_rec_type);
107 
108   PROCEDURE create_section_content(
109     p_api_version                  IN NUMBER,
110     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111     x_return_status                OUT NOCOPY VARCHAR2,
112     x_msg_count                    OUT NOCOPY NUMBER,
113     x_msg_data                     OUT NOCOPY VARCHAR2,
114     p_sccv_tbl                     IN OKC_SCC_PVT.sccv_tbl_type,
115     x_sccv_tbl                     OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type);
116 
117   PROCEDURE update_section_content(
118     p_api_version                  IN NUMBER,
119     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120     x_return_status                OUT NOCOPY VARCHAR2,
121     x_msg_count                    OUT NOCOPY NUMBER,
122     x_msg_data                     OUT NOCOPY VARCHAR2,
123     p_sccv_rec                     IN OKC_SCC_PVT.sccv_rec_type,
124     x_sccv_rec                     OUT NOCOPY OKC_SCC_PVT.sccv_rec_type);
125 
126   PROCEDURE update_section_content(
127     p_api_version                  IN NUMBER,
128     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129     x_return_status                OUT NOCOPY VARCHAR2,
130     x_msg_count                    OUT NOCOPY NUMBER,
131     x_msg_data                     OUT NOCOPY VARCHAR2,
132     p_sccv_tbl                     IN OKC_SCC_PVT.sccv_tbl_type,
133     x_sccv_tbl                     OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type);
134 
135   PROCEDURE delete_section_content(
136     p_api_version                  IN NUMBER,
137     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138     x_return_status                OUT NOCOPY VARCHAR2,
139     x_msg_count                    OUT NOCOPY NUMBER,
140     x_msg_data                     OUT NOCOPY VARCHAR2,
141     p_sccv_rec                     IN OKC_SCC_PVT.sccv_rec_type);
142 
143   PROCEDURE delete_section_content(
144     p_api_version                  IN NUMBER,
145     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146     x_return_status                OUT NOCOPY VARCHAR2,
147     x_msg_count                    OUT NOCOPY NUMBER,
148     x_msg_data                     OUT NOCOPY VARCHAR2,
149     p_sccv_tbl                     IN OKC_SCC_PVT.sccv_tbl_type);
150 
151   PROCEDURE lock_section_content(
152     p_api_version                  IN NUMBER,
153     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154     x_return_status                OUT NOCOPY VARCHAR2,
155     x_msg_count                    OUT NOCOPY NUMBER,
156     x_msg_data                     OUT NOCOPY VARCHAR2,
157     p_sccv_rec                     IN OKC_SCC_PVT.sccv_rec_type);
158 
159   PROCEDURE lock_section_content(
160     p_api_version                  IN NUMBER,
161     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162     x_return_status                OUT NOCOPY VARCHAR2,
163     x_msg_count                    OUT NOCOPY NUMBER,
164     x_msg_data                     OUT NOCOPY VARCHAR2,
165     p_sccv_tbl                     IN OKC_SCC_PVT.sccv_tbl_type);
166 
167   PROCEDURE validate_section_content(
168     p_api_version                  IN NUMBER,
169     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170     x_return_status                OUT NOCOPY VARCHAR2,
171     x_msg_count                    OUT NOCOPY NUMBER,
172     x_msg_data                     OUT NOCOPY VARCHAR2,
173     p_sccv_rec                     IN OKC_SCC_PVT.sccv_rec_type);
174 
175   PROCEDURE validate_section_content(
176     p_api_version                  IN NUMBER,
177     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178     x_return_status                OUT NOCOPY VARCHAR2,
179     x_msg_count                    OUT NOCOPY NUMBER,
180     x_msg_data                     OUT NOCOPY VARCHAR2,
181     p_sccv_tbl                     IN OKC_SCC_PVT.sccv_tbl_type);
182 
183   PROCEDURE add_language;
184 
185 END OKC_SECTIONS_PVT;