PACKAGE: APPS.CSM_HA_PROCESS_PKG

Source

1 PACKAGE CSM_HA_PROCESS_PKG AUTHID CURRENT_USER  AS
2 /* $Header: csmhaps.pls 120.1 2011/01/10 10:24:16 saradhak noship $*/
3 
4 G_HA_START_TIME TIMESTAMP;
5 G_HA_END_TIME  TIMESTAMP;
6 G_HA_PAYLOAD_SEQUENCE_START NUMBER;
7 G_HA_PAYLOAD_SEQUENCE_END NUMBER;
8 G_HA_SESSION_SEQUENCE NUMBER;
9 G_CON_REQUEST_ID      NUMBER;
10 G_HTML5_CLIENT_DATE_FORMAT      VARCHAR2(50);
11 
12 PROCEDURE PARSE_XML(p_HA_PAYLOAD_ID    IN NUMBER,
13                     x_COL_NAME_LIST  OUT NOCOPY  CSM_VARCHAR_LIST,
14                     X_COL_VALUE_LIST OUT NOCOPY  CSM_VARCHAR_LIST,
15                     X_CON_NAME_LIST  OUT NOCOPY  CSM_VARCHAR_LIST,
16                     X_CON_VALUE_LIST OUT NOCOPY  CSM_VARCHAR_LIST,
17                     x_RETURN_STATUS OUT NOCOPY VARCHAR2,
18                     x_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
19 
20 PROCEDURE PROCESS_HA(X_RETURN_STATUS OUT NOCOPY VARCHAR2,
21                      x_ERROR_MESSAGE OUT NOCOPY VARCHAR2,
22                      P_SESSION_ID IN NUMBER DEFAULT NULL);
23 
24 FUNCTION PROCESS_HA RETURN NUMBER;
25 
26 PROCEDURE SET_CONTEXT(  P_CON_NAME_LIST  CSM_VARCHAR_LIST,
27                         p_CON_VALUE_LIST CSM_VARCHAR_LIST,
28                         X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29                         X_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
30 
31 PROCEDURE PROCESS_DIRECT_DML(P_PAYLOAD_ID IN NUMBER
32                             ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
33                 					  ,X_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
34 
35 PROCEDURE SET_HA_PROFILE(P_VALUE IN VARCHAR2);
36 
37 FUNCTION CLOB_TO_BLOB( P_CLOB_DATA IN CLOB ) RETURN BLOB;
38 
39 procedure PROCESS_HTML5(X_RETURN_STATUS OUT NOCOPY varchar2,
40                         X_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
41 
42 PROCEDURE UPLOAD_SYNC_DATA(P_SYNC_ID   IN NUMBER,
43                             P_USER_NAME IN VARCHAR2,
44                             P_SYNC_DATA IN CLOB,
45                             X_RETURN_STATUS OUT NOCOPY varchar2,
46                             X_ERROR_MESSAGE OUT NOCOPY varchar2);
47 
48 PROCEDURE HTML5_PARSE_XML(p_SYNC_ID    IN NUMBER,
49                     X_RETURN_STATUS  OUT  NOCOPY VARCHAR2,
50                     x_ERROR_MESSAGE  OUT  NOCOPY VARCHAR2);
51 
52 PROCEDURE HTML5_SESSION(p_sync_id IN NUMBER,p_status IN VARCHAR2);
53 
54 PROCEDURE HTML5_DISCARD(p_SYNC_ID    IN NUMBER,
55                         P_PAYLOAD_ID IN NUMBER DEFAULT NULL,
56                         X_RETURN_STATUS  OUT  NOCOPY VARCHAR2,
57                         x_ERROR_MESSAGE  OUT  NOCOPY VARCHAR2);
58 
59 PROCEDURE PROCESS_HTML5_SELECT(p_SYNC_ID    IN NUMBER,
60                                P_PAYLOAD_ID IN NUMBER DEFAULT NULL,
61                                X_RETURN_STATUS  OUT  NOCOPY VARCHAR2,
62                                x_ERROR_MESSAGE  OUT  NOCOPY VARCHAR2);
63 
64 END CSM_HA_PROCESS_PKG; -- Package spec