1 PACKAGE CS_GET_REACTION_TIMES_PUB AUTHID CURRENT_USER AS
2 /* $Header: csctrtms.pls 115.0 99/07/16 08:54:11 porting ship $ */
3
4 /*******************************************************************************
5 -- GLOBAL VARIABLES
6 *******************************************************************************/
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_GET_REACTION_TIMES_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := 'CS';
10
11 /*******************************************************************************
12 -- Procedures and Functions
13 *******************************************************************************/
14
15 PROCEDURE Convert_To_Mts (
16 p_hours IN NUMBER,
17 p_minutes IN NUMBER,
18 x_all_minutes OUT NUMBER );
19
20 PROCEDURE Convert_To_GMT(
21 p_time_zone_id IN NUMBER,
22 p_time_mts IN OUT NUMBER,
23 p_date IN OUT DATE,
24 x_return_status OUT VARCHAR2,
25 x_msg_count OUT NUMBER,
26 x_msg_data OUT VARCHAR2);
27
28 PROCEDURE Convert_FROM_GMT(
29 p_time_zone_id IN NUMBER,
30 p_time_mts IN OUT NUMBER,
31 p_date IN OUT DATE,
32 x_return_status OUT VARCHAR2,
33 x_msg_count OUT NUMBER,
34 x_msg_data OUT VARCHAR2);
35
36 PROCEDURE Convert_To_Hours_Mts (
37 p_end_time_all_mts IN NUMBER,
38 x_end_time_hours OUT NUMBER,
39 x_end_time_mts OUT NUMBER );
40
41 PROCEDURE Get_Next_Days_Coverage_Time(
42 p_coverage_txn_group_id IN NUMBER,
43 p_coverage_day IN OUT NUMBER,
44 x_cov_start_time_hours OUT NUMBER,
45 x_cov_start_time_mts OUT NUMBER,
46 x_cov_end_time_hours OUT NUMBER,
47 x_cov_end_time_mts OUT NUMBER,
48 x_return_status OUT VARCHAR2,
49 x_msg_count OUT NUMBER,
50 x_msg_data OUT VARCHAR2);
51
52 PROCEDURE Get_Reaction_Times (
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE,
56 p_coverage_id IN NUMBER,
57 p_business_process_id IN NUMBER,
58 p_start_date_time IN DATE,
59 p_call_time_zone_id IN NUMBER,
60 p_incident_severity_id IN NUMBER,
61 p_exception_coverage_flag IN VARCHAR2,
62 p_Reaction_time_id IN OUT NUMBER,
63 x_Reaction_time OUT VARCHAR2,
64 x_Reaction_time_Sunday OUT NUMBER,
65 x_Reaction_time_Monday OUT NUMBER,
66 x_Reaction_time_Tuesday OUT NUMBER,
67 x_Reaction_time_Wednesday OUT NUMBER,
68 x_Reaction_time_Thursday OUT NUMBER,
69 x_Reaction_time_Friday OUT NUMBER,
70 x_Reaction_time_Saturday OUT NUMBER,
71 x_Workflow OUT VARCHAR2,
72 x_always_covered OUT VARCHAR2,
73 x_incident_severity OUT VARCHAR2,
74 x_Expected_End_Date_Time OUT DATE,
75 x_Use_for_SR_Date_Calc OUT VARCHAR2,
76 x_return_status OUT VARCHAR2,
77 x_msg_count OUT NUMBER,
78 x_msg_data OUT VARCHAR2 );
79
80 END CS_GET_REACTION_TIMES_PUB;