DBA Data[Home] [Help]

APPS.CSM_HA_AUDIT_PKG dependencies on CSM_VARCHAR_LIST

Line 4: FUNCTION get_listfrom_String(p_object_name IN VARCHAR2) return CSM_VARCHAR_LIST

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

Line 7: list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

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

Line 60: l_PK_NAME_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

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

Line 61: l_PK_TYPE_LIST CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

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

Line 62: l_pk_value_list CSM_VARCHAR_LIST:=CSM_VARCHAR_LIST();

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