386: l_debug_info := 'Fundscheck failed, updating audit table - packet id';
387: -------------------------------------------------------------------------
388: null;
389: /*
390: Update igi_itr_charge_lines_audit
391: Set packet_id = l_packet_id
392: Where it_header_id = l_it_header_id
393: And it_service_line_id = l_it_service_line_id
394: And reversal_flag = 'N';
402: packet_id = l_packet_id
403: Where it_header_id = l_it_header_id
404: And it_service_line_id = l_it_service_line_id;
405:
406: Update igi_itr_charge_lines_audit
407: Set unencumbered_amount = l_amount,
408: packet_id = l_packet_id
409: Where it_header_id = l_it_header_id
410: And it_service_line_id = l_it_service_line_id
477: Set posting_flag = 'Y'
478: Where it_header_id = l_it_header_id
479: And it_service_line_id = l_it_service_line_id;
480:
481: Update igi_itr_charge_lines_audit
482: Set posting_flag = 'Y'
483: Where it_header_id = l_it_header_id
484: And reversal_flag = 'N';
485: End If;
572: Set posting_flag = 'Y'
573: Where it_header_id = l_it_header_id
574: And it_service_line_id = l_it_service_line_id;
575:
576: Update igi_itr_charge_lines_audit
577: Set posting_flag = 'Y'
578: Where it_header_id = l_it_header_id
579: And it_service_line_id = l_it_service_line_id
580: And reversal_flag = 'N';