13: *******************************************************************************/
14:
15: PROCEDURE Get_Bill_Rates (
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_coverage_id IN NUMBER,
20: p_exception_coverage_flag IN VARCHAR2,
21: p_business_process_id IN NUMBER,
14:
15: PROCEDURE Get_Bill_Rates (
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_coverage_id IN NUMBER,
20: p_exception_coverage_flag IN VARCHAR2,
21: p_business_process_id IN NUMBER,
22: p_bill_rate_code IN VARCHAR2,
30: x_msg_data OUT VARCHAR2 );
31:
32: PROCEDURE Get_Preferred_Engineer (
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_coverage_id IN NUMBER,
37: p_business_process_id IN VARCHAR2,
38: p_exception_coverage_flag IN VARCHAR2,
31:
32: PROCEDURE Get_Preferred_Engineer (
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_coverage_id IN NUMBER,
37: p_business_process_id IN VARCHAR2,
38: p_exception_coverage_flag IN VARCHAR2,
39: x_preferred_engineer1 OUT VARCHAR2,
43: x_msg_data OUT VARCHAR2 );
44:
45: PROCEDURE Get_Exception_coverage (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_coverage_id IN NUMBER,
50: x_exception_coverage_id OUT NUMBER,
51: x_return_status OUT VARCHAR2,
44:
45: PROCEDURE Get_Exception_coverage (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_coverage_id IN NUMBER,
50: x_exception_coverage_id OUT NUMBER,
51: x_return_status OUT VARCHAR2,
52: x_msg_count OUT NUMBER,