[Home] [Help]
1531: (
1532: fnd_log.level_statement
1533: , L_LOG_MODULE || 'get_srbinfo_for_audit_start'
1534: , 'Collecting information that has to be written to the '
1535: || 'CS_INCIDENTS_PURGE_AUDIT_B table'
1536: );
1537: END IF ;
1538:
1539: -- Collect all the information from the cs_incidents_all_b
1578: (
1579: fnd_log.level_statement
1580: , L_LOG_MODULE || 'get_srbinfo_for_audit_end'
1581: , 'After collecting information that has to be written to the '
1582: || 'CS_INCIDENTS_PURGE_AUDIT_B table ' || l_row_count || ' rows'
1583: );
1584: END IF ;
1585:
1586: ---
3320: fnd_log.string
3321: (
3322: fnd_log.level_statement
3323: , L_LOG_MODULE || 'ins_purge_aud_b_start'
3324: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_B'
3325: );
3326: END IF ;
3327:
3328: -- Inserting information relating to purged SRs into the audit base table
3327:
3328: -- Inserting information relating to purged SRs into the audit base table
3329:
3330: FORALL j IN p_incident_id_tbl.FIRST..p_incident_id_tbl.LAST
3331: INSERT INTO cs_incidents_purge_audit_b
3332: (
3333: purge_id
3334: , incident_id
3335: , incident_number
3376: fnd_log.string
3377: (
3378: fnd_log.level_statement
3379: , L_LOG_MODULE || 'ins_purge_aud_b_end'
3380: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3381: || l_row_count || ' rows'
3382: );
3383: END IF ;
3384: ELSIF p_incident_id_tbl.COUNT <= 0
3388: fnd_log.string
3389: (
3390: fnd_log.level_statement
3391: , L_LOG_MODULE || 'ins_purge_aud_b_err'
3392: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3393: || 'p_incident_id_tbl had ' || p_incident_id_tbl.COUNT || ' rows'
3394: );
3395: END IF ;
3396: END IF;