15:
16: -- public procedure declarations
17: procedure add_language;
18: procedure create_change_request(p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: p_crtv_rec IN crtv_rec_type,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: p_crtv_rec IN crtv_rec_type,
24: x_crtv_rec OUT NOCOPY crtv_rec_type);
25: procedure create_change_request(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_crtv_tbl IN crtv_tbl_type,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_crtv_tbl IN crtv_tbl_type,
31: x_crtv_tbl OUT NOCOPY crtv_tbl_type);
32: procedure update_change_request(p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_crtv_rec IN crtv_rec_type,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_crtv_rec IN crtv_rec_type,
38: x_crtv_rec OUT NOCOPY crtv_rec_type);
39: procedure update_change_request(p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_crtv_tbl IN crtv_tbl_type,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_crtv_tbl IN crtv_tbl_type,
45: x_crtv_tbl OUT NOCOPY crtv_tbl_type);
46: procedure delete_change_request(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_crtv_rec IN crtv_rec_type);
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: p_crtv_rec IN crtv_rec_type);
52: procedure delete_change_request(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_crtv_tbl IN crtv_tbl_type);
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_crtv_tbl IN crtv_tbl_type);
58: procedure lock_change_request(p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2,
63: p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
59: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2,
63: p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
64: p_crtv_rec IN crtv_rec_type);
65: procedure lock_change_request(p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
67: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_data OUT NOCOPY VARCHAR2,
63: p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
64: p_crtv_rec IN crtv_rec_type);
65: procedure lock_change_request(p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
66: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
71: p_crtv_tbl IN crtv_tbl_type);
72: procedure validate_change_request(p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
71: p_crtv_tbl IN crtv_tbl_type);
72: procedure validate_change_request(p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_crtv_rec IN crtv_rec_type);
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_crtv_rec IN crtv_rec_type);
78: procedure validate_change_request(p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_crtv_tbl IN crtv_tbl_type);
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_crtv_tbl IN crtv_tbl_type);
84: procedure create_change(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_corv_rec IN corv_rec_type,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_corv_rec IN corv_rec_type,
90: x_corv_rec OUT NOCOPY corv_rec_type);
91: procedure create_change(p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_corv_tbl IN corv_tbl_type,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_corv_tbl IN corv_tbl_type,
97: x_corv_tbl OUT NOCOPY corv_tbl_type);
98: procedure update_change(p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_corv_rec IN corv_rec_type,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_corv_rec IN corv_rec_type,
104: x_corv_rec OUT NOCOPY corv_rec_type);
105: procedure update_change(p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_corv_tbl IN corv_tbl_type,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_corv_tbl IN corv_tbl_type,
111: x_corv_tbl OUT NOCOPY corv_tbl_type);
112: procedure delete_change(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_corv_rec IN corv_rec_type);
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_corv_rec IN corv_rec_type);
118: procedure delete_change(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_corv_tbl IN corv_tbl_type);
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_corv_tbl IN corv_tbl_type);
124: procedure lock_change(p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_corv_rec IN corv_rec_type);
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_corv_rec IN corv_rec_type);
130: procedure lock_change(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_corv_tbl IN corv_tbl_type);
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_corv_tbl IN corv_tbl_type);
136: procedure validate_change(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_corv_rec IN corv_rec_type);
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_corv_rec IN corv_rec_type);
142: procedure validate_change(p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_corv_tbl IN corv_tbl_type);
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_corv_tbl IN corv_tbl_type);
148: procedure create_change_party_role(p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_cprv_rec IN cprv_rec_type,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_cprv_rec IN cprv_rec_type,
154: x_cprv_rec OUT NOCOPY cprv_rec_type);
155: procedure create_change_party_role(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_cprv_tbl IN cprv_tbl_type,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_cprv_tbl IN cprv_tbl_type,
161: x_cprv_tbl OUT NOCOPY cprv_tbl_type);
162: procedure update_change_party_role(p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_cprv_rec IN cprv_rec_type,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_cprv_rec IN cprv_rec_type,
168: x_cprv_rec OUT NOCOPY cprv_rec_type);
169: procedure update_change_party_role(p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_cprv_tbl IN cprv_tbl_type,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_cprv_tbl IN cprv_tbl_type,
175: x_cprv_tbl OUT NOCOPY cprv_tbl_type);
176: procedure delete_change_party_role(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_cprv_rec IN cprv_rec_type);
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_cprv_rec IN cprv_rec_type);
182: procedure delete_change_party_role(p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_cprv_tbl IN cprv_tbl_type);
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_cprv_tbl IN cprv_tbl_type);
188: procedure lock_change_party_role(p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_cprv_rec IN cprv_rec_type);
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_cprv_rec IN cprv_rec_type);
194: procedure lock_change_party_role(p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_cprv_tbl IN cprv_tbl_type);
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_cprv_tbl IN cprv_tbl_type);
200: procedure validate_change_party_role(p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_cprv_rec IN cprv_rec_type);
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_cprv_rec IN cprv_rec_type);
206: procedure validate_change_party_role(p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_cprv_tbl IN cprv_tbl_type);