DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on OKC_API

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

14:
15: ---------------------------------------------------------------------------
16: -- GLOBAL MESSAGE CONSTANTS
17: ---------------------------------------------------------------------------
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

15: ---------------------------------------------------------------------------
16: -- GLOBAL MESSAGE CONSTANTS
17: ---------------------------------------------------------------------------
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

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

16: -- GLOBAL MESSAGE CONSTANTS
17: ---------------------------------------------------------------------------
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

17: ---------------------------------------------------------------------------
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';

Line 150: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

146:
147: Procedure Get_Duration
148: (
149: P_Api_Version IN Number,
150: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
151: X_msg_Count OUT NOCOPY Number,
152: X_msg_Data OUT NOCOPY Varchar2,
153: X_Return_Status OUT NOCOPY Varchar2,
154: P_customer_id IN Number,

Line 158: P_coterm_checked_yn IN Varchar2 Default OKC_API.G_FALSE,

154: P_customer_id IN Number,
155: P_system_id IN Number,
156: P_Service_Duration IN Number,
157: P_service_period IN Varchar2,
158: P_coterm_checked_yn IN Varchar2 Default OKC_API.G_FALSE,
159: P_start_date IN Date,
160: P_end_date IN Date,
161: X_service_duration OUT NOCOPY Number,
162: X_service_period OUT NOCOPY Varchar2,

Line 193: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

189:
190: Procedure Is_Service_Available
191: (
192: P_Api_Version IN Number,
193: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
194: X_msg_Count OUT NOCOPY Number,
195: X_msg_Data OUT NOCOPY Varchar2,
196: X_Return_Status OUT NOCOPY Varchar2,
197: p_check_service_rec IN CHECK_SERVICE_REC_TYPE,

Line 226: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

222:
223: Procedure Available_Services
224: (
225: P_Api_Version IN Number,
226: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
227: X_msg_Count OUT NOCOPY Number,
228: X_msg_Data OUT NOCOPY Varchar2,
229: X_Return_Status OUT NOCOPY Varchar2,
230: p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,

Line 240: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

236:
237: Procedure OKS_Available_Services
238: (
239: P_Api_Version IN Number,
240: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
241: X_msg_Count OUT NOCOPY Number,
242: X_msg_Data OUT NOCOPY Varchar2,
243: X_Return_Status OUT NOCOPY Varchar2,
244: p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,--ADDED FOR OKS REQ

Line 257: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE

253: (p_api_version IN Number
254: ,p_party_id IN Number
255: ,p_service_id IN Number
256: ,p_request_date IN Date Default sysdate
257: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE
258: ,x_available_yn OUT NOCOPY Varchar2
259: ,x_msg_Count OUT NOCOPY Number
260: ,x_msg_Data OUT NOCOPY Varchar2
261: ,x_return_status OUT NOCOPY Varchar2);

Line 266: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE

262:
263:
264: Procedure Delete_Contract_details
265: ( p_api_version IN Number
266: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE
267: ,p_order_line_id IN Number
268: ,x_msg_Count OUT NOCOPY Number
269: ,x_msg_Data OUT NOCOPY Varchar2
270: ,x_return_status OUT NOCOPY Varchar2);

Line 328: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,

324: */
325: PROCEDURE Available_Services
326: (
327: P_Api_Version IN NUMBER,
328: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,
329: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,
330: P_MAX_ROWS_RETURNED IN NUMBER Default 200,
331: X_msg_Count OUT NOCOPY NUMBER,
332: X_msg_Data OUT NOCOPY VARCHAR2,

Line 329: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,

325: PROCEDURE Available_Services
326: (
327: P_Api_Version IN NUMBER,
328: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,
329: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,
330: P_MAX_ROWS_RETURNED IN NUMBER Default 200,
331: X_msg_Count OUT NOCOPY NUMBER,
332: X_msg_Data OUT NOCOPY VARCHAR2,
333: X_Return_Status OUT NOCOPY VARCHAR2,