eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_CANCEL_PKG dependencies on AP_INVOICES

Line 69: ap_invoices AIV

65: FROM ap_invoice_distributions AID,
66: po_distributions_ap_v POD,
67: po_line_locations PLL,
68: po_lines PL,
69: ap_invoices AIV
70: WHERE POD.po_distribution_id = AID.po_distribution_id
71: AND POD.line_location_id = PLL.line_location_id
72: AND PLL.po_line_id = PL.po_line_id
73: AND AIV.invoice_id=AID.invoice_id

Line 145: FROM ap_invoices_all

141: l_debug_info := 'Get the org_id for the invoice';
142:
143: SELECT org_id
144: INTO l_org_id
145: FROM ap_invoices_all
146: WHERE invoice_id = p_invoice_id;
147:
148: l_debug_info := 'Check if inv distribution has open period';
149:

Line 245: FROM ap_invoices

241: l_debug_info := 'Check if invoice is already cancelled';
242:
243: SELECT count(*)
244: INTO l_cancel_count
245: FROM ap_invoices
246: WHERE invoice_id = P_invoice_id
247: AND cancelled_date IS NOT NULL;
248:
249: IF (l_cancel_count > 0) THEN

Line 260: l_credited_inv_flag := AP_INVOICES_UTILITY_PKG.Is_Inv_Credit_Referenced(

256: | Step 4. If invoice is a credited invoice return FALSE |
257: +-----------------------------------------------------------------*/
258: l_debug_info := 'Check if invoice is a credited invoice';
259:
260: l_credited_inv_flag := AP_INVOICES_UTILITY_PKG.Is_Inv_Credit_Referenced(
261: P_invoice_id);
262:
263: IF (l_credited_inv_flag <> FALSE ) THEN
264: P_error_code := 'AP_INV_IS_CREDITED_INV';

Line 277: AP_INVOICES_UTILITY_PKG.get_prepayments_applied_flag(P_invoice_id);

273:
274: l_debug_info := 'Check if invoices have been applied against this invoice';
275:
276: l_prepay_applied_flag :=
277: AP_INVOICES_UTILITY_PKG.get_prepayments_applied_flag(P_invoice_id);
278:
279: IF (nvl(l_prepay_applied_flag,'N') = 'Y') THEN
280: P_error_code := 'AP_INV_PP_NO_CANCEL';
281: P_debug_info := l_debug_info;

Line 389: FROM ap_invoices AI

385: --
386:
387: /* SELECT count(*)
388: INTO l_project_related_count
389: FROM ap_invoices AI
390: WHERE AI.invoice_id = P_invoice_id
391: AND (AI.project_id is not null OR
392: exists (select 'X'
393: from ap_invoice_distributions AIL

Line 454: ap_invoices AI

450: into l_po_not_approved
451: from po_headers POH,
452: po_distributions POD,
453: ap_invoice_distributions AID,
454: ap_invoices AI
455: where AI.invoice_id = AID.invoice_id
456: and AI.invoice_id = P_invoice_id
457: and AID.po_distribution_id = POD.po_distribution_id
458: and POD.po_header_id = POH.po_header_id

Line 587: FROM AP_Invoices_All AI,

583: -- notifying the calling product.
584:
585: CURSOR c_reg_products IS
586: SELECT Reg_Application_ID
587: FROM AP_Invoices_All AI,
588: AP_Product_Registrations APR
589: WHERE AI.Invoice_ID = P_Invoice_ID
590: AND AI.Application_ID = APR.Reg_Application_ID
591: AND APR.Registration_Event_Type = 'INVOICE_CANCELLED';

Line 615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

611: i BINARY_INTEGER := 1;
612: l_tax_holds_count NUMBER := 0;
613: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
614: l_token VARCHAR2(4000);
615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
616: l_invoice_validation_status VARCHAR2(100);
617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
619: Tax_Exception EXCEPTION;

Line 617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

613: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
614: l_token VARCHAR2(4000);
615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
616: l_invoice_validation_status VARCHAR2(100);
617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
619: Tax_Exception EXCEPTION;
620: --Bug 4539462 DBI logging
621: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

Line 618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

614: l_token VARCHAR2(4000);
615: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
616: l_invoice_validation_status VARCHAR2(100);
617: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
618: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
619: Tax_Exception EXCEPTION;
620: --Bug 4539462 DBI logging
621: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
622:

Line 631: l_open_gl_date AP_INVOICES_ALL.gl_date%type;

627:
628: -- Bug 4748638
629: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;
630: l_cancel_dist_exists NUMBER := 0;
631: l_open_gl_date AP_INVOICES_ALL.gl_date%type;
632: l_funds_return_code VARCHAR2(30); -- 4276409 (3462325)
633:
634: -- Payment request Cancellation Subscription
635: l_return_status varchar2(1);

Line 676: FROM ap_invoices

672: l_debug_info := 'Check if AWT has been performed by AutoApproval';
673:
674: SELECT count(*)
675: INTO l_count
676: FROM ap_invoices
677: WHERE invoice_id = P_invoice_id
678: AND NVL(awt_flag,'N') = 'Y';
679:
680: IF (l_count > 0) THEN

Line 747: FROM ap_invoices

743: invoice_amount
744: INTO l_invoice_type_lookup_code,
745: l_payment_status_flag,
746: l_invoice_amount
747: FROM ap_invoices
748: WHERE invoice_id =p_invoice_id;
749:
750: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(
751: l_invoice_id => p_invoice_id,

Line 750: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(

746: l_invoice_amount
747: FROM ap_invoices
748: WHERE invoice_id =p_invoice_id;
749:
750: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(
751: l_invoice_id => p_invoice_id,
752: l_invoice_amount => l_invoice_amount,
753: l_payment_status_flag => l_payment_status_flag,
754: l_invoice_type_lookup_code => l_invoice_type_lookup_code );

Line 899: UPDATE ap_invoices

895:
896: IF ( l_discard_line_ok ) THEN
897: l_debug_info := 'Zero out the invoice';
898:
899: UPDATE ap_invoices
900: SET invoice_amount = 0
901: ,base_amount = 0
902: ,temp_cancelled_amount = DECODE(temp_cancelled_amount, NULL,
903: invoice_amount,

Line 922: (p_table_name => 'AP_INVOICES',

918: AND NVL(discarded_flag, 'N' ) <> 'Y';
919:
920: --Bug 4539462 DBI logginG
921: AP_DBI_PKG.Maintain_DBI_Summary
922: (p_table_name => 'AP_INVOICES',
923: p_operation => 'U',
924: p_key_value1 => P_Invoice_Id,
925: p_calling_sequence => l_curr_calling_sequence);
926:

Line 1147: UPDATE ap_invoices

1143:
1144:
1145: l_debug_info := 'Cancelling the invoice if no postable holds';
1146:
1147: UPDATE ap_invoices
1148: SET cancelled_by = P_last_updated_by
1149: ,cancelled_amount = temp_cancelled_amount
1150: ,cancelled_date = sysdate
1151: ,last_updated_by = P_last_updated_by

Line 1170: (p_table_name => 'AP_INVOICES',

1166: l_success := TRUE;
1167:
1168: --Bug 4539462 DBI logging
1169: AP_DBI_PKG.Maintain_DBI_Summary
1170: (p_table_name => 'AP_INVOICES',
1171: p_operation => 'U',
1172: p_key_value1 => P_Invoice_id,
1173: p_calling_sequence => l_curr_calling_sequence);
1174:

Line 1273: FROM ap_invoices

1269: ,P_cancelled_date
1270: ,P_last_update_date
1271: ,P_original_prepayment_amount
1272: ,P_pay_curr_invoice_amount
1273: FROM ap_invoices
1274: WHERE invoice_id = P_invoice_id;
1275:
1276: RETURN l_success;
1277:

Line 1385: FROM ap_invoice_payments aip,ap_invoices ai

1381: -- Bug 8257752. Commented out the reversal_flag condition.
1382:
1383: CURSOR invoices_cursor IS
1384: SELECT DISTINCT aip.invoice_id
1385: FROM ap_invoice_payments aip,ap_invoices ai
1386: WHERE aip.check_id = P_check_id
1387: --AND nvl(aip.reversal_flag, 'N') <> 'Y'
1388: AND ai.invoice_id=aip.invoice_id
1389: AND ai.cancelled_date is null;

Line 1391: TYPE inv_ib_tab_Type IS TABLE OF ap_invoices.invoice_id%TYPE;

1387: --AND nvl(aip.reversal_flag, 'N') <> 'Y'
1388: AND ai.invoice_id=aip.invoice_id
1389: AND ai.cancelled_date is null;
1390:
1391: TYPE inv_ib_tab_Type IS TABLE OF ap_invoices.invoice_id%TYPE;
1392:
1393: l_invoice_id_list inv_ib_tab_Type;
1394: i BINARY_INTEGER :=1;
1395:

Line 1414: FROM ap_invoices ai

1410: -- bug 6883407
1411: l_debug_info := 'Fetch Invoice GL Date.';
1412: SELECT ai.gl_date
1413: INTO l_invoice_gl_date
1414: FROM ap_invoices ai
1415: WHERE ai.invoice_id = l_invoice_id_list(i);
1416:
1417:
1418: l_success := AP_Cancel_Single_Invoice(