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 148: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

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,

Line 156: P_coterm_checked_yn IN Varchar2 Default OKC_API.G_FALSE,

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,

Line 191: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

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,

Line 224: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

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,

Line 238: P_init_msg_list IN Varchar2 Default OKC_API.G_FALSE,

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

Line 255: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE

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);

Line 264: ,p_init_msg_list IN Varchar2 Default OKC_API.G_FALSE

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);

Line 326: P_init_msg_list IN VARCHAR2 Default OKC_API.G_FALSE,

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,

Line 327: P_search_input IN VARCHAR2 Default OKC_API.G_MISS_CHAR,

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,