[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
1770: fnd_log.string
1771: (
1772: fnd_log.level_statement
1773: , L_LOG_MODULE || 'del_srb_start'
1774: , 'Deleting rows from table CS_INCIDENTS_ALL_B'
1775: );
1776: END IF ;
1777:
1778: -- Delete all the attributes of the
1778: -- Delete all the attributes of the
1779: -- service request from the table
1780: -- Bug 10090362: Changed the hint in the sub query
1781:
1782: DELETE /*+ index(b) */ cs_incidents_all_b b
1783: WHERE
1784: incident_id IN
1785: (
1786: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
1804: fnd_log.string
1805: (
1806: fnd_log.level_statement
1807: , L_LOG_MODULE || 'del_srb_end'
1808: , 'After deleting rows from table CS_INCIDENTS_ALL_B ' || l_row_count
1809: || ' rows'
1810: );
1811: END IF ;
1812: END IF;