APPS.AP_CANCEL_PKG dependencies on AP_INVOICE_LINES

Line 379: FROM ap_invoice_lines AIL,

375:
376:
377: SELECT count(*)
378: INTO l_final_close_count
379: FROM ap_invoice_lines AIL,
380: po_line_locations_ALL PL
381: WHERE AIL.invoice_id = P_invoice_id
382: AND AIL.po_line_location_id = PL.line_location_id
383: AND AIL.org_id = PL.org_id

Line 580: FROM ap_invoice_lines

576: IS
577:
578: CURSOR Invoice_Lines_cur IS
579: SELECT *
580: FROM ap_invoice_lines
581: WHERE invoice_id = P_invoice_id
582: AND (NVL(discarded_flag, 'N' ) <> 'Y'
583: AND NVL(cancelled_flag, 'N') <> 'Y') -- Bug 6669048
584: ORDER BY line_type_lookup_code;

Line 888: l_discard_line_ok := AP_INVOICE_LINES_PKG.Discard_Inv_Line(

884: -- Bug 5584997
885: l_inv_line_rec_list(i).accounting_date :=
886: nvl(l_accounting_date,l_inv_line_rec_list(i).accounting_date); -- Bug 9497953
887:
888: l_discard_line_ok := AP_INVOICE_LINES_PKG.Discard_Inv_Line(
889: P_line_rec => l_inv_line_rec_list(i),
890: P_calling_mode => 'CANCEL',
891: P_inv_cancellable => 'Y',
892: P_last_updated_by => p_last_updated_by,

Line 930: FROM ap_invoice_lines

926: /*
927: -- Bug 6669048. Get the count of tax lines that have not been cancelled.
928: SELECT count(*)
929: INTO l_tax_lines_count
930: FROM ap_invoice_lines
931: WHERE invoice_id = p_invoice_id
932: AND line_type_lookup_code = 'TAX'
933: AND NVL(cancelled_flag,'N') <> 'Y'
934: AND rownum =1;

Line 985: UPDATE ap_invoice_lines

981: -- cancelled_flag needs to be set prior to calling the tax api as
982: -- the line_level_action needs to be sent as DISCARD. This was
983: -- a regression from bug 6669048.
984:
985: UPDATE ap_invoice_lines
986: SET cancelled_flag = 'Y'
987: WHERE invoice_id = P_invoice_id
988: AND NVL(discarded_flag, 'N' ) <> 'Y';
989:

Line 1092: UPDATE ap_invoice_lines

1088:
1089: -- Bug 6669048. Update the cancelled_flag for all the lines to 'Y' since
1090: -- at this point all the invoice lines have been discarded including the
1091: -- tax lines and AWT lines
1092: UPDATE ap_invoice_lines
1093: SET cancelled_flag = 'Y'
1094: WHERE invoice_id = P_invoice_id
1095: AND NVL(discarded_flag, 'N' ) <> 'Y';
1096: