APPS.AP_CANCEL_PKG dependencies on AP_INVOICE_LINES

Line 366: FROM ap_invoice_lines AIL,

362:
363:
364: SELECT count(*)
365: INTO l_final_close_count
366: FROM ap_invoice_lines AIL,
367: po_line_locations_ALL PL
368: WHERE AIL.invoice_id = P_invoice_id
369: AND AIL.po_line_location_id = PL.line_location_id
370: AND AIL.org_id = PL.org_id

Line 567: FROM ap_invoice_lines

563: IS
564:
565: CURSOR Invoice_Lines_cur IS
566: SELECT *
567: FROM ap_invoice_lines
568: WHERE invoice_id = P_invoice_id
569: AND (NVL(discarded_flag, 'N' ) <> 'Y'
570: AND NVL(cancelled_flag, 'N') <> 'Y') -- Bug 6669048
571: ORDER BY line_type_lookup_code;

Line 791: l_discard_line_ok := AP_INVOICE_LINES_PKG.Discard_Inv_Line(

787: -- Bug 5584997
788: l_inv_line_rec_list(i).accounting_date :=
789: nvl(p_accounting_date,l_inv_line_rec_list(i).accounting_date);
790:
791: l_discard_line_ok := AP_INVOICE_LINES_PKG.Discard_Inv_Line(
792: P_line_rec => l_inv_line_rec_list(i),
793: P_calling_mode => 'CANCEL',
794: P_inv_cancellable => 'Y',
795: P_last_updated_by => p_last_updated_by,

Line 829: FROM ap_invoice_lines

825:
826: -- Bug 6669048. Get the count of tax lines that have not been cancelled.
827: SELECT count(*)
828: INTO l_tax_lines_count
829: FROM ap_invoice_lines
830: WHERE invoice_id = p_invoice_id
831: AND line_type_lookup_code = 'TAX'
832: AND NVL(cancelled_flag,'N') <> 'Y'
833: AND rownum =1;

Line 867: UPDATE ap_invoice_lines

863: -- cancelled_flag needs to be set prior to calling the tax api as
864: -- the line_level_action needs to be sent as DISCARD. This was
865: -- a regression from bug 6669048.
866:
867: UPDATE ap_invoice_lines
868: SET cancelled_flag = 'Y'
869: WHERE invoice_id = P_invoice_id
870: AND NVL(discarded_flag, 'N' ) <> 'Y';
871:

Line 915: UPDATE ap_invoice_lines

911:
912: -- Bug 6669048. Update the cancelled_flag for all the lines to 'Y' since
913: -- at this point all the invoice lines have been discarded including the
914: -- tax lines and AWT lines
915: UPDATE ap_invoice_lines
916: SET cancelled_flag = 'Y'
917: WHERE invoice_id = P_invoice_id
918: AND NVL(discarded_flag, 'N' ) <> 'Y';
919: