[Home] [Help]
PACKAGE: APPS.CS_COVERAGE_SERVICE_PUB
Source
1 PACKAGE CS_COVERAGE_SERVICE_PUB AUTHID CURRENT_USER AS
2 /* $Header: csctcsos.pls 115.0 99/07/16 08:51:19 porting ship $ */
3
4 /*******************************************************************************
5 -- GLOBAL VARIABLES
6 *******************************************************************************/
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_COVERAGE_SERVICE_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := 'CS';
10
11 /*******************************************************************************
12 -- Procedures and Functions
13 *******************************************************************************/
14
15 PROCEDURE Check_Service_Overlap (
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18 p_commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_service_inv_item_id IN NUMBER,
20 p_organization_id IN NUMBER,
21 p_customer_product_id IN NUMBER,
22 p_coverage_level_code IN VARCHAR2,
23 p_coverage_level_value IN NUMBER,
24 p_coverage_level_id IN NUMBER,
25 p_start_date_active IN DATE,
26 p_end_date_active IN DATE,
27 x_Overlap_flag OUT VARCHAR2,
28 x_return_status OUT VARCHAR2,
29 x_msg_count OUT NUMBER,
30 x_msg_data OUT VARCHAR2 );
31
32 PROCEDURE Check_Other_Overlap (
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_service_inv_item_id IN NUMBER,
37 p_organization_id IN NUMBER,
38 p_customer_product_id IN NUMBER,
39 p_coverage_level_code IN VARCHAR2,
40 p_coverage_level_value IN NUMBER,
41 p_start_date_active IN DATE,
42 p_end_date_active IN DATE,
43 x_Overlap_flag OUT VARCHAR2,
44 x_return_status OUT VARCHAR2,
45 x_msg_count OUT NUMBER,
46 x_msg_data OUT VARCHAR2 );
47
48 PROCEDURE Validate_Coverage_Times (
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE,
52 p_coverage_id IN NUMBER,
53 p_business_process_id IN NUMBER,
54 p_call_date_time IN DATE,
55 p_time_zone_id IN NUMBER,
56 p_exception_coverage_flag IN VARCHAR2,
57 x_covered_yes_no OUT VARCHAR2,
58 x_return_status OUT VARCHAR2,
59 x_msg_count OUT NUMBER,
60 x_msg_data OUT VARCHAR2 );
61
62 END CS_COVERAGE_SERVICE_PUB;