eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OC_INT_QTK_PVT dependencies on OKC_API

Line 35: g_invalid_value CONSTANT VARCHAR2(200):= OKC_API.G_INVALID_VALUE ;

31: g_entered CONSTANT VARCHAR2(30) := 'ENTERED' ;
32: g_approved CONSTANT VARCHAR2(30) := 'CONTRACT_APPROVED';----'APPROVED';
33: g_cancelled CONSTANT VARCHAR2(30) := 'CONTRACT_CANCELED';-----'CANCELLED';
34: g_rejected CONSTANT VARCHAR2(30) := 'CONTRACT_REJECTED';----'REJECTED';
35: g_invalid_value CONSTANT VARCHAR2(200):= OKC_API.G_INVALID_VALUE ;
36: g_col_name_token CONSTANT VARCHAR2(200):= OKC_API.G_COL_NAME_TOKEN ;
37:
38: g_aso_model_item CONSTANT VARCHAR2(30) := 'MDL';
39: g_aso_config_item CONSTANT VARCHAR2(30) := 'CFG';

Line 36: g_col_name_token CONSTANT VARCHAR2(200):= OKC_API.G_COL_NAME_TOKEN ;

32: g_approved CONSTANT VARCHAR2(30) := 'CONTRACT_APPROVED';----'APPROVED';
33: g_cancelled CONSTANT VARCHAR2(30) := 'CONTRACT_CANCELED';-----'CANCELLED';
34: g_rejected CONSTANT VARCHAR2(30) := 'CONTRACT_REJECTED';----'REJECTED';
35: g_invalid_value CONSTANT VARCHAR2(200):= OKC_API.G_INVALID_VALUE ;
36: g_col_name_token CONSTANT VARCHAR2(200):= OKC_API.G_COL_NAME_TOKEN ;
37:
38: g_aso_model_item CONSTANT VARCHAR2(30) := 'MDL';
39: g_aso_config_item CONSTANT VARCHAR2(30) := 'CFG';
40: --added for configuration

Line 143: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

139: -- x_contract_number Number of created contract
140: -------------------------------------------------------------------------------
141:
142: -- Bug : 1686001 Changed references aso_quote_headers_v.quote_header_id to okx_quote_headers_v.id1
143: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
144: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
145: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
146: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

Line 144: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

140: -------------------------------------------------------------------------------
141:
142: -- Bug : 1686001 Changed references aso_quote_headers_v.quote_header_id to okx_quote_headers_v.id1
143: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
144: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
145: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
146: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
148: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE

Line 147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

143: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
144: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
145: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
146: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
148: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
149: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
150: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
151: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

Line 149: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE

145: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
146: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
148: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
149: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
150: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
151: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER

Line 187: PROCEDURE get_k_number (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

183: -- Procedure: get_k_number
184: -- ...
185: -- ----------------------------------------------------------------------------
186:
187: PROCEDURE get_k_number (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
189: ,p_contract_id IN NUMBER
190: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
191: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE

Line 188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

184: -- ...
185: -- ----------------------------------------------------------------------------
186:
187: PROCEDURE get_k_number (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
189: ,p_contract_id IN NUMBER
190: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
191: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
192: ,x_return_status OUT NOCOPY VARCHAR2

Line 204: PROCEDURE set_notification_msg (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

200: -- Version: 1.0
201: -- ...
202: -------------------------------------------------------------------------------
203:
204: PROCEDURE set_notification_msg (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
206: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
207: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
208: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR

Line 205: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

201: -- ...
202: -------------------------------------------------------------------------------
203:
204: PROCEDURE set_notification_msg (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
206: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
207: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
208: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
209: ,p_message_body_token1 IN VARCHAR2 DEFAULT NULL

Line 206: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

202: -------------------------------------------------------------------------------
203:
204: PROCEDURE set_notification_msg (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
206: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
207: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
208: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
209: ,p_message_body_token1 IN VARCHAR2 DEFAULT NULL
210: ,p_message_body_token1_value IN VARCHAR2 DEFAULT NULL

Line 207: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR

203:
204: PROCEDURE set_notification_msg (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
206: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
207: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
208: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
209: ,p_message_body_token1 IN VARCHAR2 DEFAULT NULL
210: ,p_message_body_token1_value IN VARCHAR2 DEFAULT NULL
211: ,p_message_body_token2 IN VARCHAR2 DEFAULT NULL

Line 208: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR

204: PROCEDURE set_notification_msg (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
206: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
207: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
208: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
209: ,p_message_body_token1 IN VARCHAR2 DEFAULT NULL
210: ,p_message_body_token1_value IN VARCHAR2 DEFAULT NULL
211: ,p_message_body_token2 IN VARCHAR2 DEFAULT NULL
212: ,p_message_body_token2_value IN VARCHAR2 DEFAULT NULL

Line 229: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

225: -- Problem : Notifications in Launchpad's Inbox don't show KNUMBER in subject
226: -- and 'Contract Number' column
227: -- Fix: p_contract_id was added into parameter list of notify_k_adm procedure
228:
229: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR

Line 230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

226: -- and 'Contract Number' column
227: -- Fix: p_contract_id was added into parameter list of notify_k_adm procedure
228:
229: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

227: -- Fix: p_contract_id was added into parameter list of notify_k_adm procedure
228:
229: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR

228:
229: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR

229: PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

231: ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
239: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

232: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
239: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
240: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL

Line 237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

233: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
239: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
240: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
241: ,x_k_admin_user_name OUT NOCOPY VARCHAR2

Line 238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

234: ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
239: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
240: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
241: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
242: ,x_return_status OUT NOCOPY VARCHAR2

Line 239: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

235: ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
239: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
240: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
241: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
242: ,x_return_status OUT NOCOPY VARCHAR2
243: ,x_msg_count OUT NOCOPY NUMBER

Line 282: -- -OKC_API.G_RET_STS_SUCCESS

278: -- trace file
279: --
280: -- Out Parameters: x_return_status Final status of notification
281: -- sending API:
282: -- -OKC_API.G_RET_STS_SUCCESS
283: -- -OKC_API.G_RET_STS_ERROR
284: -- -OKC_API.G_RET_STS_UNEXP_ERROR
285: -- x_msg_count Number of messages set on the stack
286: -- x_msg_data Message info id x_msg_count = 1

Line 283: -- -OKC_API.G_RET_STS_ERROR

279: --
280: -- Out Parameters: x_return_status Final status of notification
281: -- sending API:
282: -- -OKC_API.G_RET_STS_SUCCESS
283: -- -OKC_API.G_RET_STS_ERROR
284: -- -OKC_API.G_RET_STS_UNEXP_ERROR
285: -- x_msg_count Number of messages set on the stack
286: -- x_msg_data Message info id x_msg_count = 1
287: -------------------------------------------------------------------------------

Line 284: -- -OKC_API.G_RET_STS_UNEXP_ERROR

280: -- Out Parameters: x_return_status Final status of notification
281: -- sending API:
282: -- -OKC_API.G_RET_STS_SUCCESS
283: -- -OKC_API.G_RET_STS_ERROR
284: -- -OKC_API.G_RET_STS_UNEXP_ERROR
285: -- x_msg_count Number of messages set on the stack
286: -- x_msg_data Message info id x_msg_count = 1
287: -------------------------------------------------------------------------------
288:

Line 289: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

285: -- x_msg_count Number of messages set on the stack
286: -- x_msg_data Message info id x_msg_count = 1
287: -------------------------------------------------------------------------------
288:
289: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
290: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
291: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
292: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
293: ,p_interaction_subject IN VARCHAR2

Line 290: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

286: -- x_msg_data Message info id x_msg_count = 1
287: -------------------------------------------------------------------------------
288:
289: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
290: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
291: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
292: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
293: ,p_interaction_subject IN VARCHAR2
294: ,p_interaction_body IN VARCHAR2

Line 291: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM

287: -------------------------------------------------------------------------------
288:
289: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
290: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
291: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
292: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
293: ,p_interaction_subject IN VARCHAR2
294: ,p_interaction_body IN VARCHAR2
295: ,x_return_status OUT NOCOPY VARCHAR2

Line 292: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM

288:
289: PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
290: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
291: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
292: ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
293: ,p_interaction_subject IN VARCHAR2
294: ,p_interaction_body IN VARCHAR2
295: ,x_return_status OUT NOCOPY VARCHAR2
296: ,x_msg_count OUT NOCOPY NUMBER

Line 310: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

306: --
307: -- OUT Parameters : x_articles
308: -------------------------------------------------------------------------------
309:
310: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
311: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
312: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
313: ,p_release_id IN NUMBER DEFAULT NULL
314: ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE

Line 311: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

307: -- OUT Parameters : x_articles
308: -------------------------------------------------------------------------------
309:
310: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
311: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
312: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
313: ,p_release_id IN NUMBER DEFAULT NULL
314: ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE
315: ,x_return_status OUT NOCOPY VARCHAR2

Line 312: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM

308: -------------------------------------------------------------------------------
309:
310: PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
311: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
312: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
313: ,p_release_id IN NUMBER DEFAULT NULL
314: ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE
315: ,x_return_status OUT NOCOPY VARCHAR2
316: ,x_msg_count OUT NOCOPY NUMBER

Line 326: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

322: -- Version: 1.0
323: -- ...
324: -------------------------------------------------------------------------------
325:
326: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
327: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
328: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
329: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
330: ,x_return_status OUT NOCOPY VARCHAR2

Line 327: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

323: -- ...
324: -------------------------------------------------------------------------------
325:
326: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
327: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
328: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
329: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER

Line 328: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM

324: -------------------------------------------------------------------------------
325:
326: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
327: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
328: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
329: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER
332: ,x_msg_data OUT NOCOPY VARCHAR2);

Line 329: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

325:
326: PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
327: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
328: ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
329: ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER
332: ,x_msg_data OUT NOCOPY VARCHAR2);
333: