[Home] [Help]
1462: -- to be purged.
1463: -- p_purge_batch_size : Number of SRs that need to be processed in one
1464: -- call to the SR Delete API. At any point in time, a
1465: -- maximum of batch_size number of rows will be inserted
1466: -- into the table JTF_OBJECT_PURGE_PARAM_TMP, which will
1467: -- be picked up by the SR Delete API to purge SRs.
1468: -- p_purge_source_with_open_task :
1469: -- This signifies if the Tasks Validation API can delete
1470: -- tasks that are open. If this is N, only SRs linked to
1481: -- purge_servicerequests as child concurrent requests using an API
1482: -- fnd_request.submit_request. It reads the staging table filled by
1483: -- purge_servicerequests with the purge_set_id and worker_id
1484: -- in batches of size purge_batch_size through a cursor and bulk
1485: -- inserts these rows into the global temp table JTF_OBJECT_PURGE_PARAM_TMP
1486: -- and calls the SR Delete API. At any point in time, several copies of
1487: -- this procedure may be running in parallel since the Purge Concurrent
1488: -- Program will generate multiple Worker Concurrent Programs
1489: -- based on its parameter no_of_workers.
1501: * purge_servicerequests as child concurrent requests using an API
1502: * fnd_request.submit_request. It reads the staging table filled by
1503: * purge_servicerequests with the purge_set_id and worker_id
1504: * in batches of size purge_batch_size through a cursor and bulk inserts
1505: * these rows into the global temp table JTF_OBJECT_PURGE_PARAM_TMP and calls
1506: * the SR Delete API. At any point in time, several copies of this procedure
1507: * may be running in parallel since the Purge Concurrent Program will generate
1508: * multiple Worker Concurrent Programs based on its parameter no_of_workers.
1509: * @param errbuf This parameter is not used but is a standard parameter for
1520: * in the staging table that need to be purged.
1521: * @param p_purge_batch_size Number of SRs that need to be processed in
1522: * one call to the SR Delete API. At any point in time, a maximum of
1523: * batch_size number of rows will be inserted into the table
1524: * JTF_OBJECT_PURGE_PARAM_TMP, which will be picked up by the SR Delete
1525: * API to purge SRs.
1526: * @param p_purge_source_with_open_task This signifies if the Tasks
1527: * Validation API can delete tasks that are open. If this is N, only SRs
1528: * linked to closed Tasks are allowed to be purged. If this is
1924: (
1925: FND_LOG.level_statement
1926: , L_LOG_MODULE || 'insert_temp_start'
1927: , 'inserting incident ids into global temp table '
1928: || 'JTF_OBJECT_PURGE_PARAM_TMP'
1929: );
1930: END IF ;
1931:
1932: -- Inserting the current batch of incident_ids
1932: -- Inserting the current batch of incident_ids
1933: -- into the global temp table for purging
1934:
1935: FORALL j IN 1..l_incident_id_tbl.COUNT
1936: INSERT INTO jtf_object_purge_param_tmp
1937: (
1938: object_id
1939: , object_type
1940: , processing_set_id
1954: (
1955: FND_LOG.level_statement
1956: , L_LOG_MODULE || 'insert_temp_end'
1957: , 'after inserting incident ids into global temp table '
1958: || 'JTF_OBJECT_PURGE_PARAM_TMP ' || l_row_count
1959: );
1960: END IF ;
1961:
1962: ---
2063: BULK COLLECT INTO
2064: l_err_incident_id_tbl
2065: , l_purge_error_message_tbl
2066: FROM
2067: jtf_object_purge_param_tmp
2068: WHERE
2069: processing_set_id = l_processing_set_id
2070: AND object_type = 'SR'
2071: AND NVL(purge_status, 'S') = 'E';