[Home] [Help]
1591: (
1592: fnd_log.level_statement
1593: , L_LOG_MODULE || 'get_srtlinfo_for_audit_start'
1594: , 'Collecting information that has to be written to the '
1595: || 'CS_INCIDENTS_PURGE_AUDIT_TL table'
1596: );
1597: END IF ;
1598:
1599: -- Collect all the information from the cs_incidents_all_tl
1630: (
1631: fnd_log.level_statement
1632: , L_LOG_MODULE || 'get_srtlinfo_for_audit_end'
1633: , 'After collecting information that has to be written to the '
1634: || 'CS_INCIDENTS_PURGE_AUDIT_TL table ' || l_row_count || ' rows'
1635: );
1636: END IF ;
1637: ELSIF p_audit_required <> 'Y'
1638: THEN
3398: fnd_log.string
3399: (
3400: fnd_log.level_statement
3401: , L_LOG_MODULE || 'ins_purge_aud_tl_start'
3402: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL'
3403: );
3404: END IF ;
3405:
3406: -- Inserting translatable information relating to
3406: -- Inserting translatable information relating to
3407: -- purged SRs into the audit base table
3408:
3409: FORALL j IN p_incident_id_tl_tbl.FIRST..p_incident_id_tl_tbl.LAST
3410: INSERT INTO cs_incidents_purge_audit_tl
3411: (
3412: purge_id
3413: , incident_id
3414: , language
3441: fnd_log.string
3442: (
3443: fnd_log.level_statement
3444: , L_LOG_MODULE || 'ins_purge_aud_tl_end'
3445: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3446: || l_row_count || ' rows'
3447: );
3448: END IF ;
3449: ELSIF p_incident_id_tl_tbl.COUNT <= 0
3453: fnd_log.string
3454: (
3455: fnd_log.level_statement
3456: , L_LOG_MODULE || 'ins_purge_aud_tl_err'
3457: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3458: || 'p_incident_id_tl_tbl had ' || p_incident_id_tl_tbl.COUNT || ' rows'
3459: );
3460: END IF ;
3461: END IF;