APPS.CSM_HA_AUDIT_PKG dependencies on CSM_HA_EVENT_PKG

Line 80: l_pk_name:=CSM_HA_EVENT_PKG.GET_PK_COLUMN_NAME(l_tab_name);

76: FETCH c_get_details INTO l_tab_name,l_pk_value,l_dml,l_mobile_data;
77: CLOSE c_get_details;
78:
79: IF l_dml='U' AND l_mobile_data='N' THEN
80: l_pk_name:=CSM_HA_EVENT_PKG.GET_PK_COLUMN_NAME(l_tab_name);
81: l_pk_name_list := get_listfrom_String(l_pk_name);
82: l_pk_value_list:= get_listfrom_String(l_pk_value);
83: l_pk_type_list.extend(l_pk_name_list.COUNT);
84:

Line 94: CSM_HA_EVENT_PKG.GET_XML_PAYLOAD(l_tab_name,l_PK_NAME_LIST,l_PK_TYPE_LIST,l_PK_VALUE_LIST,

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;
97: END IF;
98:

Line 100: l_session_id:=CSM_HA_EVENT_PKG.G_HA_SESSION_SEQUENCE;

96: END IF;
97: END IF;
98:
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)

Line 112: 'CSM_HA_EVENT_PKG.AUDIT_RECORD',FND_LOG.LEVEL_EXCEPTION);

108: EXCEPTION
109: WHEN OTHERS THEN
110: l_ERROR_MESSAGE :=SUBSTR(SQLERRM,1,3000)||SUBSTR(l_ERROR_MESSAGE,1,999);
111: CSM_UTIL_PKG.LOG('Exception occurred in AUDIT_RECORD -' ||l_ERROR_MESSAGE ,
112: 'CSM_HA_EVENT_PKG.AUDIT_RECORD',FND_LOG.LEVEL_EXCEPTION);
113: COMMIT;
114: RAISE;
115: END AUDIT_RECORD;
116: