[Home] [Help]
534: -- Description
535: -- This API physically removes the SRs and all its child objects after
536: -- performing validations wherever required. This procedure calls the
537: -- delete APIs for deleting child objects and directly deletes the rows
538: -- in the tables cs_incidents_all_b and tl.
539: -- This procedure also updates the staging table with the errors generated
540: -- while performing validations on SRs with all child objects so that
541: -- a log of these errors can be generated at the end of the purge process.
542: --
551: /*#
552: * This API physically removes the SRs and all its child objects after
553: * performing validations wherever required. This procedure calls the delete
554: * APIs for deleting child objects and directly deletes the rows in the tables
555: * cs_incidents_all_b and tl. This procedure also updates the staging table
556: * with the errors generated while performing validations on SRs with all child
557: * objects so that a log of these errors can be generated at the end of the
558: * purge process.
559: * @param p_object_type Type of object for which this procedure is being
1535: || 'CS_INCIDENTS_PURGE_AUDIT_B table'
1536: );
1537: END IF ;
1538:
1539: -- Collect all the information from the cs_incidents_all_b
1540: -- table that needs to be entered in the purge audit table
1541:
1542: SELECT
1543: incident_number
1557: , l_customer_product_id_tbl
1558: , l_inc_creation_date_tbl
1559: , l_inc_last_update_date_tbl
1560: FROM
1561: cs_incidents_all_b c
1562: , jtf_object_purge_param_tmp j
1563: WHERE
1564: j.object_type = 'SR'
1565: AND j.object_id = c.incident_id
1769: fnd_log.string
1770: (
1771: fnd_log.level_statement
1772: , L_LOG_MODULE || 'del_srb_start'
1773: , 'Deleting rows from table CS_INCIDENTS_ALL_B'
1774: );
1775: END IF ;
1776:
1777: -- Delete all the attributes of the
1776:
1777: -- Delete all the attributes of the
1778: -- service request from the table
1779:
1780: DELETE /*+ index(b) */ cs_incidents_all_b b
1781: WHERE
1782: incident_id IN
1783: (
1784: SELECT /*+ no_unnest no_semijoin cardinality(10) */
1802: fnd_log.string
1803: (
1804: fnd_log.level_statement
1805: , L_LOG_MODULE || 'del_srb_end'
1806: , 'After deleting rows from table CS_INCIDENTS_ALL_B ' || l_row_count
1807: || ' rows'
1808: );
1809: END IF ;
1810: END IF;