9:
10: ------------------------------------------------------------------------------
11: -- Global Variables
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_Extrn_PVT';
13: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'Okl_CONTRACTS_UNEXPECTED_ERROR';
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
16: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17: ------------------------------------------------------------------------------
25:
26: --Object type procedure for insert
27: PROCEDURE create_ext_csh_txns(
28: p_api_version IN NUMBER
29: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_rec IN xcrv_rec_type
38:
39: --Object type procedure for update
40: PROCEDURE update_ext_csh_txns(
41: p_api_version IN NUMBER
42: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
43: ,x_return_status OUT NOCOPY VARCHAR2
44: ,x_msg_count OUT NOCOPY NUMBER
45: ,x_msg_data OUT NOCOPY VARCHAR2
46: ,p_xcrv_rec IN xcrv_rec_type
51:
52: --Object type procedure for update
53: PROCEDURE delete_ext_csh_txns(
54: p_api_version IN NUMBER
55: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
56: ,x_return_status OUT NOCOPY VARCHAR2
57: ,x_msg_count OUT NOCOPY NUMBER
58: ,x_msg_data OUT NOCOPY VARCHAR2
59: ,p_xcrv_rec IN xcrv_rec_type
64:
65: --Object type procedure for validate
66: PROCEDURE validate_ext_csh_txns(
67: p_api_version IN NUMBER
68: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
69: ,x_return_status OUT NOCOPY VARCHAR2
70: ,x_msg_count OUT NOCOPY NUMBER
71: ,x_msg_data OUT NOCOPY VARCHAR2
72: ,p_xcrv_rec IN xcrv_rec_type
74: );
75:
76: PROCEDURE create_ext_csh_txns(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_xcrv_tbl IN xcrv_tbl_type,
83: x_xcrv_tbl OUT NOCOPY xcrv_tbl_type);
84:
85: PROCEDURE create_ext_csh_txns(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_xcrv_rec IN xcrv_rec_type,
92: x_xcrv_rec OUT NOCOPY xcrv_rec_type);
93:
94: PROCEDURE lock_ext_csh_txns(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_tbl IN xcrv_tbl_type);
100: p_xcrv_tbl IN xcrv_tbl_type);
101:
102: PROCEDURE lock_ext_csh_txns(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcrv_rec IN xcrv_rec_type);
108: p_xcrv_rec IN xcrv_rec_type);
109:
110: PROCEDURE update_ext_csh_txns(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_xcrv_tbl IN xcrv_tbl_type,
117: x_xcrv_tbl OUT NOCOPY xcrv_tbl_type);
118:
119: PROCEDURE update_ext_csh_txns(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_xcrv_rec IN xcrv_rec_type,
126: x_xcrv_rec OUT NOCOPY xcrv_rec_type);
127:
128: PROCEDURE delete_ext_csh_txns(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_xcrv_tbl IN xcrv_tbl_type);
134: p_xcrv_tbl IN xcrv_tbl_type);
135:
136: PROCEDURE delete_ext_csh_txns(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_xcrv_rec IN xcrv_rec_type);
142: p_xcrv_rec IN xcrv_rec_type);
143:
144: PROCEDURE validate_ext_csh_txns(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_xcrv_tbl IN xcrv_tbl_type);
150: p_xcrv_tbl IN xcrv_tbl_type);
151:
152: PROCEDURE validate_ext_csh_txns(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_xcrv_rec IN xcrv_rec_type);
159:
160:
161: PROCEDURE create_ext_csh_txns(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcav_tbl IN xcav_tbl_type,
168: x_xcav_tbl OUT NOCOPY xcav_tbl_type);
169:
170: PROCEDURE create_ext_csh_txns(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcav_rec IN xcav_rec_type,
177: x_xcav_rec OUT NOCOPY xcav_rec_type);
178:
179: PROCEDURE lock_ext_csh_txns(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_xcav_tbl IN xcav_tbl_type);
185: p_xcav_tbl IN xcav_tbl_type);
186:
187: PROCEDURE lock_ext_csh_txns(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xcav_rec IN xcav_rec_type);
193: p_xcav_rec IN xcav_rec_type);
194:
195: PROCEDURE update_ext_csh_txns(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_xcav_tbl IN xcav_tbl_type,
202: x_xcav_tbl OUT NOCOPY xcav_tbl_type);
203:
204: PROCEDURE update_ext_csh_txns(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_xcav_rec IN xcav_rec_type,
211: x_xcav_rec OUT NOCOPY xcav_rec_type);
212:
213: PROCEDURE delete_ext_csh_txns(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_xcav_tbl IN xcav_tbl_type);
219: p_xcav_tbl IN xcav_tbl_type);
220:
221: PROCEDURE delete_ext_csh_txns(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_xcav_rec IN xcav_rec_type);
227: p_xcav_rec IN xcav_rec_type);
228:
229: PROCEDURE validate_ext_csh_txns(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_xcav_tbl IN xcav_tbl_type);
235: p_xcav_tbl IN xcav_tbl_type);
236:
237: PROCEDURE validate_ext_csh_txns(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_xcav_rec IN xcav_rec_type);