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