15: -- and no output parameters needed or useful
16: -- In Parameters: p_contract_id Contract for which to create quote
17: -- Out Parameters: None
18:
19: PROCEDURE create_quote_for_renewal(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_contract_id IN OKC_K_HEADERS_B.ID%TYPE
20: ,x_return_status OUT NOCOPY VARCHAR2
21: ,x_msg_count OUT NOCOPY NUMBER
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
24: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
25: );
26:
27:
28: -------------------------------------------------------------------------------
43: -- Out Parameters: x_quote_id Id of created quote
44:
45: PROCEDURE create_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
46: ,RETCODE OUT NOCOPY NUMBER
47: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
48: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
49: --p_contract_number is in fact equal to contract ID
50: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
51: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
46: ,RETCODE OUT NOCOPY NUMBER
47: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
48: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
49: --p_contract_number is in fact equal to contract ID
50: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
51: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
52: );
53:
54:
47: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
48: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
49: --p_contract_number is in fact equal to contract ID
50: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
51: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
52: );
53:
54:
55: PROCEDURE create_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
52: );
53:
54:
55: PROCEDURE create_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
56: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
52: );
53:
54:
55: PROCEDURE create_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
56: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
53:
54:
55: PROCEDURE create_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
56: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
57: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
62: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
63: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
64: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE
65: );
66:
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
62: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
63: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
64: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE
65: );
66:
67: -------------------------------------------------------------------------------
86: --
87: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
88: -- p_contract_number is in fact equal to contract ID
89: --
90: ,p_quote_number IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
91: -- p_quote_number is in fact equal to quote ID
92: --
93: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
94: );
89: --
90: ,p_quote_number IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
91: -- p_quote_number is in fact equal to quote ID
92: --
93: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
94: );
95:
96:
97: PROCEDURE update_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
93: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
94: );
95:
96:
97: PROCEDURE update_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
100: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.G_MISS_NUM
101: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
94: );
95:
96:
97: PROCEDURE update_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
100: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.G_MISS_NUM
101: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
102: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
95:
96:
97: PROCEDURE update_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
100: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.G_MISS_NUM
101: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
102: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
103: ,x_return_status OUT NOCOPY VARCHAR2
96:
97: PROCEDURE update_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
100: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.G_MISS_NUM
101: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
102: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
100: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.G_MISS_NUM
101: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
102: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2
106: );
130: -------------------------------------------------------------------------------
131:
132: PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
133: ,RETCODE OUT NOCOPY NUMBER
134: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
135: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
136: --
137: -- p_contract_number is in fact equal to contract ID
138: --
135: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
136: --
137: -- p_contract_number is in fact equal to contract ID
138: --
139: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
140: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
141: );
142:
143:
136: --
137: -- p_contract_number is in fact equal to contract ID
138: --
139: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
140: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
141: );
142:
143:
144: PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
140: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
141: );
142:
143:
144: PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
145: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
146: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
147: ,x_return_status OUT NOCOPY VARCHAR2
148: ,x_msg_count OUT NOCOPY NUMBER
141: );
142:
143:
144: PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
145: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
146: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
147: ,x_return_status OUT NOCOPY VARCHAR2
148: ,x_msg_count OUT NOCOPY NUMBER
149: ,x_msg_data OUT NOCOPY VARCHAR2
142:
143:
144: PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
145: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
146: ,p_commit IN VARCHAR2 DEFAULT OKC_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_contract_id IN OKC_K_HEADERS_B.ID%TYPE
147: ,x_return_status OUT NOCOPY VARCHAR2
148: ,x_msg_count OUT NOCOPY NUMBER
149: ,x_msg_data OUT NOCOPY VARCHAR2
150: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
151: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
152: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
153: ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
154: );
155:
148: ,x_msg_count OUT NOCOPY NUMBER
149: ,x_msg_data OUT NOCOPY VARCHAR2
150: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
151: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
152: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
153: ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
154: );
155:
156: -------------------------------------------------------------------------------
187: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
188: PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
189: ,RETCODE OUT NOCOPY NUMBER
190: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
191: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
192: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
193: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
194: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
195: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
189: ,RETCODE OUT NOCOPY NUMBER
190: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
191: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
192: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
193: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
194: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
195: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
196: );
197:
190: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
191: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
192: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
193: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
194: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
195: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
196: );
197:
198:
191: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
192: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
193: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
194: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
195: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
196: );
197:
198:
199: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
195: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
196: );
197:
198:
199: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
200: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
201: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
196: );
197:
198:
199: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
200: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
201: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
197:
198:
199: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
200: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
201: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
199: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
200: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
201: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
200: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
201: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
208: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
201: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
208: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
209: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
208: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
209: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
210: ,x_return_status OUT NOCOPY VARCHAR2
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
208: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
209: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
210: ,x_return_status OUT NOCOPY VARCHAR2
211: ,x_msg_count OUT NOCOPY NUMBER
228: -- p_template_previous_version Template contract previous version to use in creating
229: -- contract
230: -- Out Parameters: x_contract_id Id of created contract
231:
232: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
229: -- contract
230: -- Out Parameters: x_contract_id Id of created contract
231:
232: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
230: -- Out Parameters: x_contract_id Id of created contract
231:
232: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
232: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
239: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
240: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
239: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
240: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
241: ,x_return_status OUT NOCOPY VARCHAR2
234: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
239: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
240: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_msg_count OUT NOCOPY NUMBER
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
239: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
240: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_msg_count OUT NOCOPY NUMBER
243: ,x_msg_data OUT NOCOPY VARCHAR2
270: -- a trace file
271: --
272: -- Out Parameters: x_return_status Final status of the O-K relationship
273: -- creation API:
274: -- -OKC_API.G_RET_STS_SUCCESS
275: -- -OKC_API.G_RET_STS_ERROR
276: -- -OKC_API.G_RET_STS_UNEXP_ERROR
277: -- THIS IS A WRAPPER FOR OKC_OC_INT_KTO_PVT.create_k_relationships
278:
271: --
272: -- Out Parameters: x_return_status Final status of the O-K relationship
273: -- creation API:
274: -- -OKC_API.G_RET_STS_SUCCESS
275: -- -OKC_API.G_RET_STS_ERROR
276: -- -OKC_API.G_RET_STS_UNEXP_ERROR
277: -- THIS IS A WRAPPER FOR OKC_OC_INT_KTO_PVT.create_k_relationships
278:
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
272: -- Out Parameters: x_return_status Final status of the O-K relationship
273: -- creation API:
274: -- -OKC_API.G_RET_STS_SUCCESS
275: -- -OKC_API.G_RET_STS_ERROR
276: -- -OKC_API.G_RET_STS_UNEXP_ERROR
277: -- THIS IS A WRAPPER FOR OKC_OC_INT_KTO_PVT.create_k_relationships
278:
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
275: -- -OKC_API.G_RET_STS_ERROR
276: -- -OKC_API.G_RET_STS_UNEXP_ERROR
277: -- THIS IS A WRAPPER FOR OKC_OC_INT_KTO_PVT.create_k_relationships
278:
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
276: -- -OKC_API.G_RET_STS_UNEXP_ERROR
277: -- THIS IS A WRAPPER FOR OKC_OC_INT_KTO_PVT.create_k_relationships
278:
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
277: -- THIS IS A WRAPPER FOR OKC_OC_INT_KTO_PVT.create_k_relationships
278:
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
278:
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
287: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
287: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
288: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
287: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
288: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
289: ,x_return_status OUT NOCOPY VARCHAR2
290: ,x_msg_count OUT NOCOPY NUMBER
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
287: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
288: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
289: ,x_return_status OUT NOCOPY VARCHAR2
290: ,x_msg_count OUT NOCOPY NUMBER
291: ,x_msg_data OUT NOCOPY VARCHAR2);
292:
324: -- trace file
325: --
326: -- Out Parameters: x_return_status Final status of notification
327: -- sending API:
328: -- -OKC_API.G_RET_STS_SUCCESS
329: -- -OKC_API.G_RET_STS_ERROR
330: -- -OKC_API.G_RET_STS_UNEXP_ERROR
331: -- x_msg_count Number of messages set on the stack
332: -- x_msg_data Message info id x_msg_count = 1
325: --
326: -- Out Parameters: x_return_status Final status of notification
327: -- sending API:
328: -- -OKC_API.G_RET_STS_SUCCESS
329: -- -OKC_API.G_RET_STS_ERROR
330: -- -OKC_API.G_RET_STS_UNEXP_ERROR
331: -- x_msg_count Number of messages set on the stack
332: -- x_msg_data Message info id x_msg_count = 1
333: -- THIS IS A WRAPPER FOR OKC_OC_INT_QTK_PVT.create_interaction_history
326: -- Out Parameters: x_return_status Final status of notification
327: -- sending API:
328: -- -OKC_API.G_RET_STS_SUCCESS
329: -- -OKC_API.G_RET_STS_ERROR
330: -- -OKC_API.G_RET_STS_UNEXP_ERROR
331: -- x_msg_count Number of messages set on the stack
332: -- x_msg_data Message info id x_msg_count = 1
333: -- THIS IS A WRAPPER FOR OKC_OC_INT_QTK_PVT.create_interaction_history
334:
331: -- x_msg_count Number of messages set on the stack
332: -- x_msg_data Message info id x_msg_count = 1
333: -- THIS IS A WRAPPER FOR OKC_OC_INT_QTK_PVT.create_interaction_history
334:
335: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
337: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
338: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
339: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
332: -- x_msg_data Message info id x_msg_count = 1
333: -- THIS IS A WRAPPER FOR OKC_OC_INT_QTK_PVT.create_interaction_history
334:
335: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
337: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
338: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
339: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
340: ,p_interaction_subject IN VARCHAR2
333: -- THIS IS A WRAPPER FOR OKC_OC_INT_QTK_PVT.create_interaction_history
334:
335: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
337: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
338: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
339: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
340: ,p_interaction_subject IN VARCHAR2
341: ,p_interaction_body IN VARCHAR2
334:
335: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
337: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
338: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
339: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
340: ,p_interaction_subject IN VARCHAR2
341: ,p_interaction_body IN VARCHAR2
342: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
335: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
337: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
338: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
339: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
340: ,p_interaction_subject IN VARCHAR2
341: ,p_interaction_body IN VARCHAR2
342: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
343: ,x_return_status OUT NOCOPY VARCHAR2
338: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
339: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
340: ,p_interaction_subject IN VARCHAR2
341: ,p_interaction_body IN VARCHAR2
342: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
343: ,x_return_status OUT NOCOPY VARCHAR2
344: ,x_msg_count OUT NOCOPY NUMBER
345: ,x_msg_data OUT NOCOPY VARCHAR2);
346:
354: -- Problem : Notifications in Launchpad's Inbox don't show KNUMBER in subject
355: -- and 'Contract Number' column
356: -- Fix: p_contract_id was added into parameter list of notify_k_adm procedure
357:
358: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
360: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
355: -- and 'Contract Number' column
356: -- Fix: p_contract_id was added into parameter list of notify_k_adm procedure
357:
358: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
360: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
356: -- Fix: p_contract_id was added into parameter list of notify_k_adm procedure
357:
358: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
360: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
357:
358: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
360: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
358: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
360: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
360: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
360: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
361: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
370: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
363: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
370: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
371: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
364: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
370: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
371: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
372: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
365: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
370: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
371: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
372: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
373: ,x_return_status OUT NOCOPY VARCHAR2
366: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
370: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
371: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
372: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER
388: --
389: -- OUT Parameters : x_return_status
390: -------------------------------------------------------------------------------
391:
392: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
393: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
394: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
395: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
396: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
389: -- OUT Parameters : x_return_status
390: -------------------------------------------------------------------------------
391:
392: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
393: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
394: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
395: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
396: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
397: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
390: -------------------------------------------------------------------------------
391:
392: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
393: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
394: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
395: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
396: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
397: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
398: ,x_return_status OUT NOCOPY VARCHAR2
391:
392: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
393: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
394: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
395: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
396: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
397: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
398: ,x_return_status OUT NOCOPY VARCHAR2
399: ,x_msg_count OUT NOCOPY NUMBER
392: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
393: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
394: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
395: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
396: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
397: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
398: ,x_return_status OUT NOCOPY VARCHAR2
399: ,x_msg_count OUT NOCOPY NUMBER
400: ,x_msg_data OUT NOCOPY VARCHAR2
393: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
394: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
395: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
396: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
397: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
398: ,x_return_status OUT NOCOPY VARCHAR2
399: ,x_msg_count OUT NOCOPY NUMBER
400: ,x_msg_data OUT NOCOPY VARCHAR2
401: );
403: -- Procedure: get_k_number
404: -- Version: 1.0
405: -- ...
406:
407: PROCEDURE get_k_number(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
408: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
409: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
410: ,p_contract_id IN NUMBER
411: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
404: -- Version: 1.0
405: -- ...
406:
407: PROCEDURE get_k_number(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
408: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
409: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
410: ,p_contract_id IN NUMBER
411: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
412: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
405: -- ...
406:
407: PROCEDURE get_k_number(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
408: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
409: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
410: ,p_contract_id IN NUMBER
411: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
412: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
413: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
407: PROCEDURE get_k_number(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
408: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
409: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
410: ,p_contract_id IN NUMBER
411: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
412: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
413: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
414: ,x_return_status OUT NOCOPY VARCHAR2
415: ,x_msg_count OUT NOCOPY NUMBER
435: -- In Parameters: p_party_id Contract header id
436: -- p_date_signed Signing date of the contract
437: --
438: -- Out Parameters: x_return_status Final status of the contract status update
439: -- -OKC_API.G_RET_STS_SUCCESS
440: -- -OKC_API.G_RET_STS_ERROR
441: -- -OKC_API.G_RET_STS_UNEXP_ERROR
442: -- THIS IS A PLAIN BARE-BONES WRAPPER FOR OKC_CONTRACT_APPROVAL_PUB.k_signed
443:
436: -- p_date_signed Signing date of the contract
437: --
438: -- Out Parameters: x_return_status Final status of the contract status update
439: -- -OKC_API.G_RET_STS_SUCCESS
440: -- -OKC_API.G_RET_STS_ERROR
441: -- -OKC_API.G_RET_STS_UNEXP_ERROR
442: -- THIS IS A PLAIN BARE-BONES WRAPPER FOR OKC_CONTRACT_APPROVAL_PUB.k_signed
443:
444: PROCEDURE k_signed(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
437: --
438: -- Out Parameters: x_return_status Final status of the contract status update
439: -- -OKC_API.G_RET_STS_SUCCESS
440: -- -OKC_API.G_RET_STS_ERROR
441: -- -OKC_API.G_RET_STS_UNEXP_ERROR
442: -- THIS IS A PLAIN BARE-BONES WRAPPER FOR OKC_CONTRACT_APPROVAL_PUB.k_signed
443:
444: PROCEDURE k_signed(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
445: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
440: -- -OKC_API.G_RET_STS_ERROR
441: -- -OKC_API.G_RET_STS_UNEXP_ERROR
442: -- THIS IS A PLAIN BARE-BONES WRAPPER FOR OKC_CONTRACT_APPROVAL_PUB.k_signed
443:
444: PROCEDURE k_signed(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
445: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
446: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
447: ,p_contract_id IN NUMBER
448: ,p_date_signed IN DATE DEFAULT SYSDATE
441: -- -OKC_API.G_RET_STS_UNEXP_ERROR
442: -- THIS IS A PLAIN BARE-BONES WRAPPER FOR OKC_CONTRACT_APPROVAL_PUB.k_signed
443:
444: PROCEDURE k_signed(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
445: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
446: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
447: ,p_contract_id IN NUMBER
448: ,p_date_signed IN DATE DEFAULT SYSDATE
449: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
442: -- THIS IS A PLAIN BARE-BONES WRAPPER FOR OKC_CONTRACT_APPROVAL_PUB.k_signed
443:
444: PROCEDURE k_signed(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
445: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
446: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
447: ,p_contract_id IN NUMBER
448: ,p_date_signed IN DATE DEFAULT SYSDATE
449: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
450: ,x_return_status OUT NOCOPY VARCHAR2
445: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
446: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
447: ,p_contract_id IN NUMBER
448: ,p_date_signed IN DATE DEFAULT SYSDATE
449: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
450: ,x_return_status OUT NOCOPY VARCHAR2
451: ,x_msg_count OUT NOCOPY NUMBER
452: ,x_msg_data OUT NOCOPY VARCHAR2);
453:
455: -- Procedure: k_erase_approved
456: -- Version: 1.0
457: -- ...
458:
459: PROCEDURE k_erase_approved(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
460: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
461: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
462: ,p_contract_id IN NUMBER
463: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
456: -- Version: 1.0
457: -- ...
458:
459: PROCEDURE k_erase_approved(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
460: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
461: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
462: ,p_contract_id IN NUMBER
463: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
464: ,x_return_status OUT NOCOPY VARCHAR2
457: -- ...
458:
459: PROCEDURE k_erase_approved(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
460: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
461: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
462: ,p_contract_id IN NUMBER
463: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
464: ,x_return_status OUT NOCOPY VARCHAR2
465: ,x_msg_count OUT NOCOPY NUMBER
459: PROCEDURE k_erase_approved(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
460: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
461: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
462: ,p_contract_id IN NUMBER
463: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
464: ,x_return_status OUT NOCOPY VARCHAR2
465: ,x_msg_count OUT NOCOPY NUMBER
466: ,x_msg_data OUT NOCOPY VARCHAR2);
467:
472: -- to select all articles for the contract.
473: -- In Parameters : P_contract_id Id of the contract
474: -- Out Parameters: x_articles contract articles (clob datatype)
475:
476: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
477: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
478: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
479: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
480: ,p_release_id IN NUMBER DEFAULT NULL
473: -- In Parameters : P_contract_id Id of the contract
474: -- Out Parameters: x_articles contract articles (clob datatype)
475:
476: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
477: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
478: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
479: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
480: ,p_release_id IN NUMBER DEFAULT NULL
481: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
474: -- Out Parameters: x_articles contract articles (clob datatype)
475:
476: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
477: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
478: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
479: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
480: ,p_release_id IN NUMBER DEFAULT NULL
481: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
482: ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE
475:
476: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
477: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
478: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
479: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
480: ,p_release_id IN NUMBER DEFAULT NULL
481: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
482: ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE
483: ,x_return_status OUT NOCOPY VARCHAR2
477: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
478: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
479: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
480: ,p_release_id IN NUMBER DEFAULT NULL
481: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
482: ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE
483: ,x_return_status OUT NOCOPY VARCHAR2
484: ,x_msg_count OUT NOCOPY NUMBER
485: ,x_msg_data OUT NOCOPY VARCHAR2);
508: program IN varchar2 default NULL,
509: description IN varchar2 default NULL,
510: start_time IN varchar2 default NULL,
511: sub_request IN boolean default FALSE,
512: argument1 IN varchar2 default OKC_API.G_MISS_CHAR,
513: argument2 IN varchar2 default OKC_API.G_MISS_CHAR,
514: argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
509: description IN varchar2 default NULL,
510: start_time IN varchar2 default NULL,
511: sub_request IN boolean default FALSE,
512: argument1 IN varchar2 default OKC_API.G_MISS_CHAR,
513: argument2 IN varchar2 default OKC_API.G_MISS_CHAR,
514: argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
510: start_time IN varchar2 default NULL,
511: sub_request IN boolean default FALSE,
512: argument1 IN varchar2 default OKC_API.G_MISS_CHAR,
513: argument2 IN varchar2 default OKC_API.G_MISS_CHAR,
514: argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
511: sub_request IN boolean default FALSE,
512: argument1 IN varchar2 default OKC_API.G_MISS_CHAR,
513: argument2 IN varchar2 default OKC_API.G_MISS_CHAR,
514: argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
512: argument1 IN varchar2 default OKC_API.G_MISS_CHAR,
513: argument2 IN varchar2 default OKC_API.G_MISS_CHAR,
514: argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
513: argument2 IN varchar2 default OKC_API.G_MISS_CHAR,
514: argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
514: argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
515: argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
516: argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
517: argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
518: argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
519: argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
520: argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
521: argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
522: argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
523: argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
524: argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
525: argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
526: argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
527: argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
528: argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
529: argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
530: argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
531: argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
532: argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
533: argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
534: argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
535: argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
536: argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
537: argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
538: argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
539: argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
540: argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
541: argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
542: argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
543: argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
544: argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
545: argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
546: argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
547: argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
548: argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
549: argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
550: argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
551: argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
552: argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
553: argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
554: argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
555: argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
556: argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
557: argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
558: argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
559: argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
560: argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
561: argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
562: argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
563: argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
564: argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
565: argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
566: argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
567: argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
568: argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
569: argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
570: argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
571: argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
572: argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
573: argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
574: argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
575: argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
576: argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
577: argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
578: argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
579: argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
580: argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
581: argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
582: argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
583: argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
584: argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
585: argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
586: argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
587: argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
588: argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
589: argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
590: argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
591: argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
592: argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
593: argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
594: argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
595: argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
596: argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
597: argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
598: argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
599: argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
600: argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
601: argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
602: argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610: argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
603: argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610: argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
611: argument100 IN varchar2 default OKC_API.G_MISS_CHAR,
604: argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610: argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
611: argument100 IN varchar2 default OKC_API.G_MISS_CHAR,
612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
605: argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610: argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
611: argument100 IN varchar2 default OKC_API.G_MISS_CHAR,
612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
613: ,x_return_status OUT NOCOPY VARCHAR2
606: argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610: argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
611: argument100 IN varchar2 default OKC_API.G_MISS_CHAR,
612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
613: ,x_return_status OUT NOCOPY VARCHAR2
614: ,x_msg_count OUT NOCOPY NUMBER
607: argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610: argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
611: argument100 IN varchar2 default OKC_API.G_MISS_CHAR,
612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
613: ,x_return_status OUT NOCOPY VARCHAR2
614: ,x_msg_count OUT NOCOPY NUMBER
615: ,x_msg_data OUT NOCOPY VARCHAR2);
608: argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609: argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610: argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
611: argument100 IN varchar2 default OKC_API.G_MISS_CHAR,
612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
613: ,x_return_status OUT NOCOPY VARCHAR2
614: ,x_msg_count OUT NOCOPY NUMBER
615: ,x_msg_data OUT NOCOPY VARCHAR2);
616: END OKC_OC_INT_PUB;