DBA Data[Home] [Help]

APPS.OKL_EXTRN_PVT dependencies on OKL_API

Line 13: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

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: ------------------------------------------------------------------------------

Line 29: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

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

Line 42: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

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

Line 55: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

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

Line 68: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

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

Line 78: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 130: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 181: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 189: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 239: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);