1: PACKAGE BODY CSM_HA_AUDIT_PKG AS
2: /* $Header: csmhadtb.pls 120.0.12010000.1 2010/04/08 06:38:17 saradhak noship $*/
3:
4: FUNCTION get_listfrom_String(p_object_name IN VARCHAR2) return CSM_VARCHAR_LIST
5: IS
6: l_temp VARCHAR2(1000);
7: list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
8: l_item1 VARCHAR2(500);
3:
4: FUNCTION get_listfrom_String(p_object_name IN VARCHAR2) return CSM_VARCHAR_LIST
5: IS
6: l_temp VARCHAR2(1000);
7: list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
8: l_item1 VARCHAR2(500);
9: l_item2 VARCHAR2(500);
10: l_cnt NUMBER :=1;
11: BEGIN
56: SELECT OBJECT_NAME,PK_VALUE,DML_TYPE,MOBILE_DATA
57: FROM CSM_HA_PAYLOAD_DATA
58: WHERE HA_PAYLOAD_ID=p_ha_payload_id;
59:
60: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
61: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
62: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
63:
64: l_pk_name VARCHAR2(500);
57: FROM CSM_HA_PAYLOAD_DATA
58: WHERE HA_PAYLOAD_ID=p_ha_payload_id;
59:
60: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
61: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
62: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
63:
64: l_pk_name VARCHAR2(500);
65: l_pk_value VARCHAR2(1000);
58: WHERE HA_PAYLOAD_ID=p_ha_payload_id;
59:
60: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
61: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
62: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();
63:
64: l_pk_name VARCHAR2(500);
65: l_pk_value VARCHAR2(1000);
66: BEGIN