1 PACKAGE CS_CONT_GET_DETAILS_PVT AS
2 /* $Header: csvscgds.pls 120.0 2005/08/01 10:48:47 pnkalari noship $ */
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 X_ENT_CONTRACTS OUT NOCOPY ENT_CONTRACT_TAB,
45 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46 X_MSG_COUNT OUT NOCOPY NUMBER,
47 X_MSG_DATA OUT NOCOPY VARCHAR2);
48
49
50
51 PROCEDURE GET_REACTION_TIME( P_API_VERSION IN NUMBER ,
52 P_INIT_MSG_LIST IN VARCHAR2,
53 P_START_TZ_ID IN NUMBER,
54 P_SR_SEVERITY IN NUMBER,
55 P_BUSINESS_PROCESS_ID IN NUMBER,
56 P_REQUEST_DATE IN DATE,
57 P_DATES_IN_INPUT_TZ IN VARCHAR2 DEFAULT 'N',
58 P_SERVICE_LINE_ID IN NUMBER,
59 X_REACT_BY_DATE OUT NOCOPY DATE,
60 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61 X_MSG_COUNT OUT NOCOPY NUMBER,
62 X_MSG_DATA OUT NOCOPY VARCHAR2);
63
64
65 PROCEDURE VALIDATE_CONTACT( P_API_VERSION IN NUMBER,
66 P_INIT_MSG_LIST IN VARCHAR2,
67 P_CONTACT_ID IN NUMBER,
68 P_CONTRACT_ID IN NUMBER,
69 P_SERVICE_LINE_ID IN NUMBER,
70 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
71 X_MSG_COUNT OUT NOCOPY NUMBER,
72 X_MSG_DATA OUT NOCOPY VARCHAR2,
73 X_VALID_CONTACT OUT NOCOPY VARCHAR2);
74
75 PROCEDURE VALIDATE_CONTACT ( P_API_VERSION IN NUMBER,
76 P_INIT_MSG_LIST IN VARCHAR2,
77 P_CONTACT_TAB IN OUT NOCOPY INC_CONTACT_TAB,
78 P_CONTRACT_ID IN NUMBER,
79 P_SERVICE_LINE_ID IN NUMBER,
80 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
81 X_MSG_COUNT OUT NOCOPY NUMBER,
82 X_MSG_DATA OUT NOCOPY VARCHAR2);
83
84
85 END CS_CONT_GET_DETAILS_PVT;
[Home] [Help]