[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: ---
3316: fnd_log.string
3317: (
3318: fnd_log.level_statement
3319: , L_LOG_MODULE || 'ins_purge_aud_b_start'
3320: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_B'
3321: );
3322: END IF ;
3323:
3324: -- Inserting information relating to purged SRs into the audit base table
3323:
3324: -- Inserting information relating to purged SRs into the audit base table
3325:
3326: FORALL j IN p_incident_id_tbl.FIRST..p_incident_id_tbl.LAST
3327: INSERT INTO cs_incidents_purge_audit_b
3328: (
3329: purge_id
3330: , incident_id
3331: , incident_number
3372: fnd_log.string
3373: (
3374: fnd_log.level_statement
3375: , L_LOG_MODULE || 'ins_purge_aud_b_end'
3376: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3377: || l_row_count || ' rows'
3378: );
3379: END IF ;
3380: ELSIF p_incident_id_tbl.COUNT <= 0
3384: fnd_log.string
3385: (
3386: fnd_log.level_statement
3387: , L_LOG_MODULE || 'ins_purge_aud_b_err'
3388: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3389: || 'p_incident_id_tbl had ' || p_incident_id_tbl.COUNT || ' rows'
3390: );
3391: END IF ;
3392: END IF;