[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
3402: fnd_log.string
3403: (
3404: fnd_log.level_statement
3405: , L_LOG_MODULE || 'ins_purge_aud_tl_start'
3406: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL'
3407: );
3408: END IF ;
3409:
3410: -- Inserting translatable information relating to
3410: -- Inserting translatable information relating to
3411: -- purged SRs into the audit base table
3412:
3413: FORALL j IN p_incident_id_tl_tbl.FIRST..p_incident_id_tl_tbl.LAST
3414: INSERT INTO cs_incidents_purge_audit_tl
3415: (
3416: purge_id
3417: , incident_id
3418: , language
3445: fnd_log.string
3446: (
3447: fnd_log.level_statement
3448: , L_LOG_MODULE || 'ins_purge_aud_tl_end'
3449: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3450: || l_row_count || ' rows'
3451: );
3452: END IF ;
3453: ELSIF p_incident_id_tl_tbl.COUNT <= 0
3457: fnd_log.string
3458: (
3459: fnd_log.level_statement
3460: , L_LOG_MODULE || 'ins_purge_aud_tl_err'
3461: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3462: || 'p_incident_id_tl_tbl had ' || p_incident_id_tl_tbl.COUNT || ' rows'
3463: );
3464: END IF ;
3465: END IF;