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,
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,
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,
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,
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,
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,