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,
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);
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:
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,
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:
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