PACKAGE: APPS.CSM_HA_EVENT_PKG

Source

1 PACKAGE CSM_HA_EVENT_PKG AUTHID CURRENT_USER  AS
2 /* $Header: csmehas.pls 120.0.12010000.2 2010/04/16 08:44:56 saradhak noship $*/
3 
4 G_HA_SESSION_SEQUENCE NUMBER := NULL;
5 G_HA_START_TIME TIMESTAMP;
6 G_HA_PAYLOAD_SEQUENCE_START NUMBER;
7 
8 G_HA_END_TIME  TIMESTAMP;
9 G_HA_PAYLOAD_SEQUENCE_END NUMBER;
10 G_CURRENT_PAYLOAD_ID NUMBER;
11 
12 PROCEDURE BEGIN_HA_TRACKING(x_RETURN_STATUS OUT NOCOPY VARCHAR2,
13                             x_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
14 
15 PROCEDURE END_HA_TRACKING(x_RETURN_STATUS OUT NOCOPY VARCHAR2,
16                           x_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
17 
18 PROCEDURE SAVE_SEQUENCE(p_session_id   IN NUMBER, p_action IN VARCHAR2,
19                         p_payload_start IN NUMBER DEFAULT NULL,p_payload_end IN NUMBER DEFAULT NULL);
20 
21 PROCEDURE GET_XML_PAYLOAD(p_TABLE_NAME    IN VARCHAR2,
22                           p_PK_NAME_LIST  IN  CSM_VARCHAR_LIST,
23                           p_PK_TYPE_LIST  IN  CSM_VARCHAR_LIST,
24                           p_PK_CHAR_LIST  IN  CSM_VARCHAR_LIST,
25                           x_XML_PAYLOAD   OUT NOCOPY CLOB,
26                           x_XML_CONTEXT   OUT NOCOPY CLOB,
27                           x_RETURN_STATUS OUT NOCOPY VARCHAR2,
28                           x_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
29 
30 PROCEDURE TRACK_HA_RECORD(p_TABLE_NAME VARCHAR2,p_PK_NAME_LIST CSM_VARCHAR_LIST, p_PK_TYPE_LIST CSM_VARCHAR_LIST,p_PK_VALUE_LIST CSM_VARCHAR_LIST,
31                           p_dml_type VARCHAR2,p_mobile_data VARCHAR2:='N',p_parent_payload_id IN NUMBER:=NULL);
32 
33 PROCEDURE TRACK_HA_ATTACHMENTS;
34 
35 FUNCTION get_pk_column_name(p_object_name IN VARCHAR2) return VARCHAR2;
36 
37 FUNCTION GET_HA_PROFILE_VALUE return VARCHAR2;
38 
39 FUNCTION get_predicate_clause(p_cols IN VARCHAR2,p_values IN VARCHAR2) return VARCHAR2;
40 
41 FUNCTION get_listfrom_String(p_object_name IN VARCHAR2) return CSM_VARCHAR_LIST;
42 
43 END CSM_HA_EVENT_PKG; -- Package spec