APPS.CSM_HA_EVENT_PKG dependencies on CSM_AUTO_SYNC_NFN

Line 161: /**************CSM_AUTO_SYNC_NFN *************/

157: type t_curs is ref cursor;
158: cur t_curs;
159: BEGIN
160:
161: /**************CSM_AUTO_SYNC_NFN *************/
162: CSM_UTIL_PKG.LOG
163: ( 'Record CSM_AUTO_SYNC_NFN' , 'CSM_HA_EVENT_PKG.RECORD_CSM_TABLES', FND_LOG.LEVEL_PROCEDURE);
164:
165: l_pk_name_list(1):= 'NOTIFICATION_ID'; l_pk_type_list(1):= 'NUMBER';

Line 163: ( 'Record CSM_AUTO_SYNC_NFN' , 'CSM_HA_EVENT_PKG.RECORD_CSM_TABLES', FND_LOG.LEVEL_PROCEDURE);

159: BEGIN
160:
161: /**************CSM_AUTO_SYNC_NFN *************/
162: CSM_UTIL_PKG.LOG
163: ( 'Record CSM_AUTO_SYNC_NFN' , 'CSM_HA_EVENT_PKG.RECORD_CSM_TABLES', FND_LOG.LEVEL_PROCEDURE);
164:
165: l_pk_name_list(1):= 'NOTIFICATION_ID'; l_pk_type_list(1):= 'NUMBER';
166:
167: FOR rec IN (SELECT NOTIFICATION_ID FROM CSM_AUTO_SYNC_NFN

Line 167: FOR rec IN (SELECT NOTIFICATION_ID FROM CSM_AUTO_SYNC_NFN

163: ( 'Record CSM_AUTO_SYNC_NFN' , 'CSM_HA_EVENT_PKG.RECORD_CSM_TABLES', FND_LOG.LEVEL_PROCEDURE);
164:
165: l_pk_name_list(1):= 'NOTIFICATION_ID'; l_pk_type_list(1):= 'NUMBER';
166:
167: FOR rec IN (SELECT NOTIFICATION_ID FROM CSM_AUTO_SYNC_NFN
168: WHERE CREATION_DATE >= G_HA_START_TIME)
169: LOOP
170: l_pk_value_list(1):=rec.NOTIFICATION_ID;
171: TRACK_HA_RECORD('CSM_AUTO_SYNC_NFN',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');

Line 171: TRACK_HA_RECORD('CSM_AUTO_SYNC_NFN',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');

167: FOR rec IN (SELECT NOTIFICATION_ID FROM CSM_AUTO_SYNC_NFN
168: WHERE CREATION_DATE >= G_HA_START_TIME)
169: LOOP
170: l_pk_value_list(1):=rec.NOTIFICATION_ID;
171: TRACK_HA_RECORD('CSM_AUTO_SYNC_NFN',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');
172: END LOOP;
173:
174:
175: /**************CSM_DEFERRED_NFN_INFO *************/

Line 1246: ELSIF p_object_name='CSM_AUTO_SYNC_NFN' THEN

1242: END IF;
1243:
1244: IF SUBSTR(p_object_name,-4)='_INQ' THEN
1245: RETURN 'CLID$$CS,TRANID$$,SEQNO$$';
1246: ELSIF p_object_name='CSM_AUTO_SYNC_NFN' THEN
1247: RETURN 'NOTIFICATION_ID';
1248: ELSIF p_object_name='CSM_DEFERRED_NFN_INFO' THEN
1249: RETURN 'TRACKING_ID';
1250: ELSIF p_object_name='CSM_SYNC_ERROR_NFN_INFO' THEN