DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKC_API

Line 54: G_APP2_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

50: -- GLOBAL MESSAGE CONSTANTS FOR ERROR HANDLING
51: ---------------------------------------------------------------------------
52:
53: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
54: G_APP2_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
55: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_UTIL_PVT';
56: G_API_VERSION CONSTANT NUMBER := 1;
57: G_API_NAME CONSTANT VARCHAR2(30) := 'OKL_AM_UTIL_PVT';
58: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';

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

57: G_API_NAME CONSTANT VARCHAR2(30) := 'OKL_AM_UTIL_PVT';
58: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
60: G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
61: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
62: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
64: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
65: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

Line 67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

63: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
64: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
65: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
66: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
67: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
68: G_LEN_CHK CONSTANT VARCHAR2(200) := 'OKC_LENGTH_EXCEEDS';
69: G_NOTFOUND CONSTANT VARCHAR2(200) := 'OKC_VIEW_NOT_FOUND';
70: G_VIEW_TOKEN CONSTANT VARCHAR2(200) := 'G_VIEW_TOKEN';
71: G_EXCEPTION_HALT_PROCESS EXCEPTION;

Line 72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;

68: G_LEN_CHK CONSTANT VARCHAR2(200) := 'OKC_LENGTH_EXCEEDS';
69: G_NOTFOUND CONSTANT VARCHAR2(200) := 'OKC_VIEW_NOT_FOUND';
70: G_VIEW_TOKEN CONSTANT VARCHAR2(200) := 'G_VIEW_TOKEN';
71: G_EXCEPTION_HALT_PROCESS EXCEPTION;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
73: ---------------------------------------------------------------------------
74: -- Procedures and Functions
75: ---------------------------------------------------------------------------
76:

Line 251: , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

247:
248: -- Execute a fulfillment request
249: PROCEDURE EXECUTE_FULFILLMENT_REQUEST(
250: p_api_version IN NUMBER
251: , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
252: , x_return_status OUT NOCOPY VARCHAR2
253: , x_msg_count OUT NOCOPY NUMBER
254: , x_msg_data OUT NOCOPY VARCHAR2
255: , p_ptm_code IN VARCHAR2

Line 258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

254: , x_msg_data OUT NOCOPY VARCHAR2
255: , p_ptm_code IN VARCHAR2
256: , p_agent_id IN NUMBER
257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

255: , p_ptm_code IN VARCHAR2
256: , p_agent_id IN NUMBER
257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

256: , p_agent_id IN NUMBER
257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl

Line 261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

257: , p_transaction_id IN NUMBER
258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl
265: , p_pt_bind_values IN p_bind_val_tbl

Line 262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

258: , p_recipient_type IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl
265: , p_pt_bind_values IN p_bind_val_tbl
266: , p_pt_bind_types IN p_bind_type_tbl

Line 263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

259: , p_recipient_id IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
260: , p_expand_roles IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
261: , p_subject_line IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
262: , p_sender_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
263: , p_recipient_email IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
264: , p_pt_bind_names IN p_bind_var_tbl
265: , p_pt_bind_values IN p_bind_val_tbl
266: , p_pt_bind_types IN p_bind_type_tbl
267: ) ;