APPS.ISC_FS_TASK_ETL_PKG dependencies on ISC_FS_PARTY_MERGE_EVENTS

Line 324: , 'ISC_FS_PARTY_MERGE_EVENTS'

320: -- truncate the party merge events table
321: l_stmt_id := 50;
322: if truncate_table
323: ( l_isc_schema
324: , 'ISC_FS_PARTY_MERGE_EVENTS'
325: , l_error_message ) <> 0 then
326: logger( l_proc_name, l_stmt_id, l_error_message );
327: raise l_exception;
328: end if;

Line 1523: isc_fs_party_merge_events;

1519: , task_id
1520: , source_object_type_code
1521: , source_object_id
1522: from
1523: isc_fs_party_merge_events;
1524:
1525: l_rowcount := sql%rowcount;
1526: commit;
1527:

Line 2630: delete from isc_fs_party_merge_events

2626: bis_collection_utilities_log( l_temp_rowcount || ' rows deleted from events table', 1 );
2627:
2628: -- delete processed rows from party merge events table
2629: l_stmt_id := 110;
2630: delete from isc_fs_party_merge_events
2631: where rowid in ( select event_rowid from isc_fs_events_stg where source = 2 );
2632:
2633: l_temp_rowcount := sql%rowcount;
2634:

Line 2645: lock table isc_fs_party_merge_events in exclusive mode nowait;

2641: -- attempt (no fail) to truncate party merge events table is zero rows
2642: l_stmt_id := 120;
2643: begin
2644:
2645: lock table isc_fs_party_merge_events in exclusive mode nowait;
2646:
2647: select count(*)
2648: into l_temp_rowcount
2649: from isc_fs_party_merge_events;

Line 2649: from isc_fs_party_merge_events;

2645: lock table isc_fs_party_merge_events in exclusive mode nowait;
2646:
2647: select count(*)
2648: into l_temp_rowcount
2649: from isc_fs_party_merge_events;
2650:
2651: if l_temp_rowcount = 0 then
2652: if truncate_table
2653: ( l_isc_schema

Line 2654: , 'ISC_FS_PARTY_MERGE_EVENTS'

2650:
2651: if l_temp_rowcount = 0 then
2652: if truncate_table
2653: ( l_isc_schema
2654: , 'ISC_FS_PARTY_MERGE_EVENTS'
2655: , l_error_message ) <> 0 then
2656: logger( l_proc_name, l_stmt_id, l_error_message );
2657: raise l_exception;
2658: end if;