DBA Data[Home] [Help]

APPS.IGI_ITR_GL_INTERFACE_PKG dependencies on IGI_ITR_CHARGE_LINES_AUDIT

Line 390: Update igi_itr_charge_lines_audit

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';

Line 406: Update igi_itr_charge_lines_audit

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

Line 481: Update igi_itr_charge_lines_audit

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;

Line 576: Update igi_itr_charge_lines_audit

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';