1 PACKAGE CS_TZ_GET_DETAILS_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvtzgds.pls 120.2 2011/02/07 09:18:51 shramana ship $ */
3
4
5 /****************************************************************************
6 -- GLOBAL VARIABLES
7 ****************************************************************************/
8
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_TZ_GET_DETAILS_PVT';
10 G_APP_NAME CONSTANT VARCHAR2(3) := 'CS';
11 G_API_VERSION CONSTANT NUMBER := 1.0;
12
13 /****************************************************************************
14 -- DATA STRUCTURES
15 *****************************************************************************/
16
17
18 /*****************************************************************************
19 -- Procedures and Functions
20 *****************************************************************************/
21
22 PROCEDURE GET_GMT_DEVIATION(P_API_VERSION IN NUMBER,
23 P_INIT_MSG_LIST IN VARCHAR2,
24 P_START_TZ_ID IN NUMBER,
25 P_END_TZ_ID IN NUMBER,
26 P_TIME_LAG IN NUMBER,
27 X_GMT_DEV OUT NOCOPY NUMBER,
28 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29 X_MSG_COUNT OUT NOCOPY NUMBER,
30 X_MSG_DATA OUT NOCOPY VARCHAR2);
31
32
33 PROCEDURE GET_LEADTIME(P_API_VERSION IN NUMBER,
34 P_INIT_MSG_LIST IN VARCHAR2,
35 P_START_TZ_ID IN NUMBER,
36 P_END_TZ_ID IN NUMBER,
37 X_LEADTIME OUT NOCOPY NUMBER,
38 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39 X_MSG_COUNT OUT NOCOPY NUMBER,
40 X_MSG_DATA OUT NOCOPY VARCHAR2);
41
42 PROCEDURE GET_LEADTIME (P_API_VERSION IN NUMBER,
43 P_INIT_MSG_LIST IN VARCHAR2,
44 P_START_TZ_ID IN NUMBER,
45 P_END_ZIP_CODE IN VARCHAR2,
46 P_END_CITY IN VARCHAR2,
47 P_END_STATE IN VARCHAR2,
48 P_END_COUNTRY IN VARCHAR2,
49 X_LEADTIME OUT NOCOPY NUMBER,
50 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
51 X_MSG_COUNT OUT NOCOPY NUMBER,
52 X_MSG_DATA OUT NOCOPY VARCHAR2);
53
54 PROCEDURE CUSTOMER_PREFERRED_TIME_ZONE
55 ( p_incident_id IN NUMBER
56 , p_task_id IN NUMBER
57 , p_resource_id IN NUMBER
58 , p_cont_pref_time_zone_id IN NUMBER DEFAULT NULL
59 , p_incident_location_id IN NUMBER DEFAULT NULL
60 , p_incident_location_type IN VARCHAR2 DEFAULT NULL
61 , p_contact_party_id IN NUMBER DEFAULT NULL
62 , p_contact_phone_id IN NUMBER DEFAULT NULL
63 , p_contact_address_id IN NUMBER DEFAULT NULL
64 , p_customer_id IN NUMBER DEFAULT NULL
65 , p_customer_phone_id IN NUMBER DEFAULT NULL
66 , p_customer_address_id IN NUMBER DEFAULT NULL
67 , x_timezone_id OUT NOCOPY NUMBER
68 , x_timezone_name OUT NOCOPY VARCHAR2
69 ) ;
70
71 PROCEDURE CUSTOMER_PREFERRED_TIME_ZONE
72 ( p_incident_id IN NUMBER
73 , p_task_id IN NUMBER
74 , p_resource_id IN NUMBER
75 , p_cont_pref_time_zone_id IN NUMBER DEFAULT NULL
76 , p_incident_location_id IN NUMBER DEFAULT NULL
77 , p_incident_location_type IN VARCHAR2 DEFAULT NULL
78 , p_contact_party_id IN NUMBER DEFAULT NULL
79 , p_contact_phone_id IN NUMBER DEFAULT NULL
80 , p_contact_address_id IN NUMBER DEFAULT NULL
81 , p_customer_id IN NUMBER DEFAULT NULL
82 , p_customer_phone_id IN NUMBER DEFAULT NULL
83 , p_customer_address_id IN NUMBER DEFAULT NULL
84 , x_timezone_id OUT NOCOPY NUMBER
85 , x_timezone_name OUT NOCOPY VARCHAR2
86 , x_timezone_code OUT NOCOPY VARCHAR2
87 ) ;
88
89 END CS_TZ_GET_DETAILS_PVT;