1 PACKAGE CS_CONT_GET_DETAILS_PVT AUTHID CURRENT_USER AS
2 /* $Header: csvscgds.pls 120.0.12010000.3 2010/04/14 06:21:57 bkanimoz ship $ */
3
4 /****************************************************************************
5 -- GLOBAL VARIABLES
6 ****************************************************************************/
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONT_GET_DETAILS_PVT';
9 G_APP_NAME CONSTANT VARCHAR2(3) := 'CS';
10 G_API_VERSION CONSTANT NUMBER := 1;
11
12 /****************************************************************************
13 -- DATA STRUCTURES
14 *****************************************************************************/
15 -- SUBTYPE Ent_contract_tab IS OKS_ENTITLEMENTS_PUB.ENT_CONT_TBL;
16 SUBTYPE Ent_contract_tab IS OKS_ENTITLEMENTS_PUB.GET_CONTOP_TBL;
17 SUBTYPE Ent_contact_tab IS OKS_ENTITLEMENTS_PUB.ENT_CONTACT_TBL;
18
19 TYPE inc_contact_rec IS RECORD
20 (contact_id Number,
21 valid_contact Varchar2(1));
22 TYPE inc_contact_tab IS TABLE OF inc_contact_rec INDEX BY BINARY_INTEGER;
23
24 /*****************************************************************************/
25
26 PROCEDURE GET_CONTRACT_LINES( P_API_VERSION IN NUMBER ,
27 P_INIT_MSG_LIST IN VARCHAR2,
28 P_CONTRACT_NUMBER IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE,
29 P_SERVICE_LINE_ID IN NUMBER,
30 P_CUSTOMER_ID IN NUMBER,
31 P_SITE_ID IN NUMBER,
32 P_CUSTOMER_ACCOUNT_ID IN NUMBER,
33 P_SYSTEM_ID IN NUMBER,
34 P_INVENTORY_ITEM_ID IN NUMBER,
35 P_CUSTOMER_PRODUCT_ID IN NUMBER,
36 P_REQUEST_DATE IN DATE,
37 P_BUSINESS_PROCESS_ID IN NUMBER DEFAULT NULL,
38 P_SEVERITY_ID IN NUMBER DEFAULT NULL,
39 P_TIME_ZONE_ID IN NUMBER DEFAULT NULL,
40 P_CALC_RESPTIME_FLAG IN VARCHAR2 DEFAULT NULL,
41 P_VALIDATE_FLAG IN VARCHAR2,
42 P_DATES_IN_INPUT_TZ IN VARCHAR2 DEFAULT 'N',
43 P_INCIDENT_DATE IN DATE DEFAULT NULL,
44 P_CUST_SITE_ID IN NUMBER DEFAULT NULL,--added for Access Hour project
45 P_CUST_LOC_ID IN NUMBER DEFAULT NULL,--added for Access Hour project
46 X_ENT_CONTRACTS OUT NOCOPY ENT_CONTRACT_TAB,
47 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48 X_MSG_COUNT OUT NOCOPY NUMBER,
49 X_MSG_DATA OUT NOCOPY VARCHAR2);
50
51
52
53 PROCEDURE GET_REACTION_TIME( P_API_VERSION IN NUMBER ,
54 P_INIT_MSG_LIST IN VARCHAR2,
55 P_START_TZ_ID IN NUMBER,
56 P_SR_SEVERITY IN NUMBER,
57 P_BUSINESS_PROCESS_ID IN NUMBER,
58 P_REQUEST_DATE IN DATE,
59 P_DATES_IN_INPUT_TZ IN VARCHAR2 DEFAULT 'N',
60 P_SERVICE_LINE_ID IN NUMBER,
61 P_CUST_ID IN NUMBER,
62 P_CUST_SITE_ID IN NUMBER,
63 P_CUST_LOC_ID IN NUMBER,
64 X_REACT_BY_DATE OUT NOCOPY DATE,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 X_MSG_COUNT OUT NOCOPY NUMBER,
67 X_MSG_DATA OUT NOCOPY VARCHAR2);
68
69
70 PROCEDURE VALIDATE_CONTACT( P_API_VERSION IN NUMBER,
71 P_INIT_MSG_LIST IN VARCHAR2,
72 P_CONTACT_ID IN NUMBER,
73 P_CONTRACT_ID IN NUMBER,
74 P_SERVICE_LINE_ID IN NUMBER,
75 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76 X_MSG_COUNT OUT NOCOPY NUMBER,
77 X_MSG_DATA OUT NOCOPY VARCHAR2,
78 X_VALID_CONTACT OUT NOCOPY VARCHAR2);
79
80 PROCEDURE VALIDATE_CONTACT ( P_API_VERSION IN NUMBER,
81 P_INIT_MSG_LIST IN VARCHAR2,
82 P_CONTACT_TAB IN OUT NOCOPY INC_CONTACT_TAB,
83 P_CONTRACT_ID IN NUMBER,
84 P_SERVICE_LINE_ID IN NUMBER,
85 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
86 X_MSG_COUNT OUT NOCOPY NUMBER,
87 X_MSG_DATA OUT NOCOPY VARCHAR2);
88
89
90 END CS_CONT_GET_DETAILS_PVT;