APPS.CSM_HA_AUDIT_PKG dependencies on CSM_HA_AUDIT

Line 1: PACKAGE BODY CSM_HA_AUDIT_PKG AS

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

Line 68: select CSM_HA_AUDIT_S.nextval INTO l_audit_id from dual;

64: l_pk_name VARCHAR2(500);
65: l_pk_value VARCHAR2(1000);
66: BEGIN
67:
68: select CSM_HA_AUDIT_S.nextval INTO l_audit_id from dual;
69:
70: IF p_audit_type='APPLY' THEN
71: OPEN c_get_sess;
72: FETCH c_get_sess INTO l_session_id;

Line 92: , 'CSM_HA_AUDIT_PKG.AUDIT_RECORD', FND_LOG.LEVEL_PROCEDURE);

88: END LOOP;
89:
90: IF l_pk_name_list.COUNT =0 THEN
91: CSM_UTIL_PKG.log('COULD NOT EXTRACT OLD PAYLOAD as no PK column name found for ' || l_tab_name
92: , 'CSM_HA_AUDIT_PKG.AUDIT_RECORD', FND_LOG.LEVEL_PROCEDURE);
93: ELSE
94: CSM_HA_EVENT_PKG.GET_XML_PAYLOAD(l_tab_name,l_PK_NAME_LIST,l_PK_TYPE_LIST,l_PK_VALUE_LIST,
95: l_XML_PAYLOAD,l_XML_CONTEXT,l_RETURN_STATUS,l_ERROR_MESSAGE);
96: END IF;

Line 103: INSERT INTO CSM_HA_AUDIT(HA_AUDIT_ID,SESSION_ID,HA_PAYLOAD_ID, AUDIT_TYPE, AUDIT_TIMESTAMP,OLD_PAYLOAD,

99: ELSE
100: l_session_id:=CSM_HA_EVENT_PKG.G_HA_SESSION_SEQUENCE;
101: END IF;
102:
103: INSERT INTO CSM_HA_AUDIT(HA_AUDIT_ID,SESSION_ID,HA_PAYLOAD_ID, AUDIT_TYPE, AUDIT_TIMESTAMP,OLD_PAYLOAD,
104: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
105: VALUES(l_audit_id,l_session_id,p_ha_payload_id,p_audit_type,systimestamp,DECODE(p_audit_type,'APPLY',xmltype(l_xml_payload)),sysdate,1,sysdate,1,1);
106:
107: COMMIT;

Line 117: END CSM_HA_AUDIT_PKG;

113: COMMIT;
114: RAISE;
115: END AUDIT_RECORD;
116:
117: END CSM_HA_AUDIT_PKG;
118: