1 Package CSM_SR_ATTRIBUTES_PKG AUTHID CURRENT_USER As
2 /* $Header: csmusras.pls 120.0.12010000.1 2010/04/21 04:23:24 trajasek noship $ */
3
4
5 /*
6 * The function to be called by HA Procedure, for upward sync of
7 * publication item APPLY_SR_LINK_INSERT
8 */
9
10 -- Purpose: Update SR Links changes on Handheld to Enterprise database
11 -- --------- ------------------- ------------------------------------------
12 -- Enter package declarations as shown below
13
14 PROCEDURE APPLY_HA_ATTR_CHANGES
15 (p_HA_PAYLOAD_ID IN NUMBER,
16 p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
17 p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
18 p_dml_type IN VARCHAR2,
19 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
20 X_ERROR_MESSAGE OUT NOCOPY VARCHAR2
21 );
22 PROCEDURE APPLY_HA_LINK_CHANGES
23 (p_HA_PAYLOAD_ID IN NUMBER,
24 p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
25 p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
26 p_dml_type IN VARCHAR2,
27 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
28 X_ERROR_MESSAGE OUT NOCOPY VARCHAR2
29 );
30 END CSM_SR_ATTRIBUTES_PKG; -- Package spec