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;
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';
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';
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';
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';
144:
145: Procedure Get_Duration
146: (
147: P_Api_Version IN Number,
148: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
149: X_msg_Count OUT NOCOPY Number,
150: X_msg_Data OUT NOCOPY Varchar2,
151: X_Return_Status OUT NOCOPY Varchar2,
152: P_customer_id IN Number,
152: P_customer_id IN Number,
153: P_system_id IN Number,
154: P_Service_Duration IN Number,
155: P_service_period IN Varchar2,
156: P_coterm_checked_yn IN Varchar2 Default OKC_API.G_FALSE,
157: P_start_date IN Date,
158: P_end_date IN Date,
159: X_service_duration OUT NOCOPY Number,
160: X_service_period OUT NOCOPY Varchar2,
187:
188: Procedure Is_Service_Available
189: (
190: P_Api_Version IN Number,
191: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
192: X_msg_Count OUT NOCOPY Number,
193: X_msg_Data OUT NOCOPY Varchar2,
194: X_Return_Status OUT NOCOPY Varchar2,
195: p_check_service_rec IN CHECK_SERVICE_REC_TYPE,
220:
221: Procedure Available_Services
222: (
223: P_Api_Version IN Number,
224: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
225: X_msg_Count OUT NOCOPY Number,
226: X_msg_Data OUT NOCOPY Varchar2,
227: X_Return_Status OUT NOCOPY Varchar2,
228: p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,
234:
235: Procedure OKS_Available_Services
236: (
237: P_Api_Version IN Number,
238: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,
239: X_msg_Count OUT NOCOPY Number,
240: X_msg_Data OUT NOCOPY Varchar2,
241: X_Return_Status OUT NOCOPY Varchar2,
242: p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,--ADDED FOR OKS REQ
251: (p_api_version IN Number
252: ,p_party_id IN Number
253: ,p_service_id IN Number
254: ,p_request_date IN Date Default sysdate
255: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE
256: ,x_available_yn OUT NOCOPY Varchar2
257: ,x_msg_Count OUT NOCOPY Number
258: ,x_msg_Data OUT NOCOPY Varchar2
259: ,x_return_status OUT NOCOPY Varchar2);
260:
261:
262: Procedure Delete_Contract_details
263: ( p_api_version IN Number
264: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE
265: ,p_order_line_id IN Number
266: ,x_msg_Count OUT NOCOPY Number
267: ,x_msg_Data OUT NOCOPY Varchar2
268: ,x_return_status OUT NOCOPY Varchar2);
322: */
323: PROCEDURE Available_Services
324: (
325: P_Api_Version IN NUMBER,
326: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,
327: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,
328: P_MAX_ROWS_RETURNED IN NUMBER Default 200,
329: X_msg_Count OUT NOCOPY NUMBER,
330: X_msg_Data OUT NOCOPY VARCHAR2,
323: PROCEDURE Available_Services
324: (
325: P_Api_Version IN NUMBER,
326: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,
327: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,
328: P_MAX_ROWS_RETURNED IN NUMBER Default 200,
329: X_msg_Count OUT NOCOPY NUMBER,
330: X_msg_Data OUT NOCOPY VARCHAR2,
331: X_Return_Status OUT NOCOPY VARCHAR2,