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 258: FROM ap_invoices

254: l_debug_info := 'Check if invoice is already cancelled';
255:
256: SELECT count(*)
257: INTO l_cancel_count
258: FROM ap_invoices
259: WHERE invoice_id = P_invoice_id
260: AND cancelled_date IS NOT NULL;
261:
262: IF (l_cancel_count > 0) THEN

Line 273: l_credited_inv_flag := AP_INVOICES_UTILITY_PKG.Is_Inv_Credit_Referenced(

269: | Step 4. If invoice is a credited invoice return FALSE |
270: +-----------------------------------------------------------------*/
271: l_debug_info := 'Check if invoice is a credited invoice';
272:
273: l_credited_inv_flag := AP_INVOICES_UTILITY_PKG.Is_Inv_Credit_Referenced(
274: P_invoice_id);
275:
276: IF (l_credited_inv_flag <> FALSE ) THEN
277: P_error_code := 'AP_INV_IS_CREDITED_INV';

Line 290: AP_INVOICES_UTILITY_PKG.get_prepayments_applied_flag(P_invoice_id);

286:
287: l_debug_info := 'Check if invoices have been applied against this invoice';
288:
289: l_prepay_applied_flag :=
290: AP_INVOICES_UTILITY_PKG.get_prepayments_applied_flag(P_invoice_id);
291:
292: IF (nvl(l_prepay_applied_flag,'N') = 'Y') THEN
293: P_error_code := 'AP_INV_PP_NO_CANCEL';
294: P_debug_info := l_debug_info;

Line 402: FROM ap_invoices AI

398: --
399:
400: /* SELECT count(*)
401: INTO l_project_related_count
402: FROM ap_invoices AI
403: WHERE AI.invoice_id = P_invoice_id
404: AND (AI.project_id is not null OR
405: exists (select 'X'
406: from ap_invoice_distributions AIL

Line 467: ap_invoices AI

463: into l_po_not_approved
464: from po_headers POH,
465: po_distributions POD,
466: ap_invoice_distributions AID,
467: ap_invoices AI
468: where AI.invoice_id = AID.invoice_id
469: and AI.invoice_id = P_invoice_id
470: and AID.po_distribution_id = POD.po_distribution_id
471: and POD.po_header_id = POH.po_header_id

Line 600: FROM AP_Invoices_All AI,

596: -- notifying the calling product.
597:
598: CURSOR c_reg_products IS
599: SELECT Reg_Application_ID
600: FROM AP_Invoices_All AI,
601: AP_Product_Registrations APR
602: WHERE AI.Invoice_ID = P_Invoice_ID
603: AND AI.Application_ID = APR.Reg_Application_ID
604: AND APR.Registration_Event_Type = 'INVOICE_CANCELLED';

Line 628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

624: i BINARY_INTEGER := 1;
625: l_tax_holds_count NUMBER := 0;
626: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
627: l_token VARCHAR2(4000);
628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
629: l_invoice_validation_status VARCHAR2(100);
630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
632: Tax_Exception EXCEPTION;

Line 630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

626: l_hold_code_tab AP_ETAX_SERVICES_PKG.REL_HOLD_CODES_TYPE;
627: l_token VARCHAR2(4000);
628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
629: l_invoice_validation_status VARCHAR2(100);
630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
632: Tax_Exception EXCEPTION;
633: --Bug 4539462 DBI logging
634: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

Line 631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

627: l_token VARCHAR2(4000);
628: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
629: l_invoice_validation_status VARCHAR2(100);
630: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
631: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
632: Tax_Exception EXCEPTION;
633: --Bug 4539462 DBI logging
634: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
635:

Line 644: l_open_gl_date AP_INVOICES_ALL.gl_date%type;

640:
641: -- Bug 4748638
642: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;
643: l_cancel_dist_exists NUMBER := 0;
644: l_open_gl_date AP_INVOICES_ALL.gl_date%type;
645: l_funds_return_code VARCHAR2(30); -- 4276409 (3462325)
646:
647: -- Payment request Cancellation Subscription
648: l_return_status varchar2(1);

Line 672: l_inv_num AP_INVOICES.invoice_num%TYPE ; -- Bug 9362054

668: l_accounting_date DATE ;
669: -- Bug 9497953 : End
670:
671: l_unsuccessful_cancel NUMBER := 0 ; -- Bug 9362054
672: l_inv_num AP_INVOICES.invoice_num%TYPE ; -- Bug 9362054
673: BEGIN
674: l_curr_calling_sequence := 'AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE<-' ||
675: P_calling_sequence;
676:

Line 707: FROM ap_invoices

703: WHERE AIP.invoice_id = P_invoice_id ;
704:
705: SELECT org_id
706: INTO l_org_id
707: FROM ap_invoices
708: WHERE invoice_id = P_invoice_id ;
709:
710: IF l_max_pmt_acc_date > l_max_inv_dist_acc_date THEN
711: l_accounting_date := l_max_pmt_acc_date ;

Line 844: FROM ap_invoices

840: invoice_amount
841: INTO l_invoice_type_lookup_code,
842: l_payment_status_flag,
843: l_invoice_amount
844: FROM ap_invoices
845: WHERE invoice_id =p_invoice_id;
846:
847: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(
848: l_invoice_id => p_invoice_id,

Line 847: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(

843: l_invoice_amount
844: FROM ap_invoices
845: WHERE invoice_id =p_invoice_id;
846:
847: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(
848: l_invoice_id => p_invoice_id,
849: l_invoice_amount => l_invoice_amount,
850: l_payment_status_flag => l_payment_status_flag,
851: l_invoice_type_lookup_code => l_invoice_type_lookup_code );

Line 969: and zls.entity_code = 'AP_INVOICES'

965: INTO l_tax_lines_count
966: FROM zx_lines_summary zls
967: WHERE zls.trx_id = p_invoice_id
968: and zls.application_id = 200
969: and zls.entity_code = 'AP_INVOICES'
970: and zls.event_class_code In ('STANDARD INVOICES',
971: 'PREPAYMENT INVOICES',
972: 'EXPENSE REPORTS')
973: and NVL(zls.reporting_only_flag, 'N') = 'N'

Line 1076: UPDATE ap_invoices

1072:
1073: IF ( l_discard_line_ok ) and prob_dist_count =0 THEN --9100425
1074: l_debug_info := 'Zero out the invoice';
1075:
1076: UPDATE ap_invoices
1077: SET invoice_amount = 0
1078: ,base_amount = 0
1079: ,temp_cancelled_amount = DECODE(temp_cancelled_amount, NULL,
1080: invoice_amount,

Line 1099: (p_table_name => 'AP_INVOICES',

1095: AND NVL(discarded_flag, 'N' ) <> 'Y';
1096:
1097: --Bug 4539462 DBI logginG
1098: AP_DBI_PKG.Maintain_DBI_Summary
1099: (p_table_name => 'AP_INVOICES',
1100: p_operation => 'U',
1101: p_key_value1 => P_Invoice_Id,
1102: p_calling_sequence => l_curr_calling_sequence);
1103:

Line 1261: UPDATE ap_invoices

1257:
1258:
1259: l_debug_info := 'Cancelling the invoice if no postable holds';
1260:
1261: UPDATE ap_invoices
1262: SET cancelled_by = P_last_updated_by
1263: ,cancelled_amount = temp_cancelled_amount
1264: ,cancelled_date = sysdate
1265: ,last_updated_by = P_last_updated_by

Line 1289: FROM ap_invoices

1285:
1286: IF l_unsuccessful_cancel <> 0 THEN
1287: SELECT invoice_num
1288: INTO P_Token
1289: FROM ap_invoices
1290: WHERE invoice_id = p_invoice_id ;
1291:
1292: ROLLBACK TO SAVEPOINT CANCEL_CHECK_1 ;
1293: P_message_name := 'AP_UNSUCCESSFUL_CANCELLATION' ;

Line 1330: (p_table_name => 'AP_INVOICES',

1326: l_success := TRUE;
1327:
1328: --Bug 4539462 DBI logging
1329: AP_DBI_PKG.Maintain_DBI_Summary
1330: (p_table_name => 'AP_INVOICES',
1331: p_operation => 'U',
1332: p_key_value1 => P_Invoice_id,
1333: p_calling_sequence => l_curr_calling_sequence);
1334:

Line 1433: FROM ap_invoices

1429: ,P_cancelled_date
1430: ,P_last_update_date
1431: ,P_original_prepayment_amount
1432: ,P_pay_curr_invoice_amount
1433: FROM ap_invoices
1434: WHERE invoice_id = P_invoice_id;
1435:
1436: RETURN l_success;
1437:

Line 1545: FROM ap_invoice_payments aip,ap_invoices ai

1541: -- Bug 8257752. Commented out the reversal_flag condition.
1542:
1543: CURSOR invoices_cursor IS
1544: SELECT DISTINCT aip.invoice_id
1545: FROM ap_invoice_payments aip,ap_invoices ai
1546: WHERE aip.check_id = P_check_id
1547: --AND nvl(aip.reversal_flag, 'N') <> 'Y'
1548: AND ai.invoice_id=aip.invoice_id
1549: AND ai.cancelled_date is null;

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

1547: --AND nvl(aip.reversal_flag, 'N') <> 'Y'
1548: AND ai.invoice_id=aip.invoice_id
1549: AND ai.cancelled_date is null;
1550:
1551: TYPE inv_ib_tab_Type IS TABLE OF ap_invoices.invoice_id%TYPE;
1552:
1553: l_invoice_id_list inv_ib_tab_Type;
1554: i BINARY_INTEGER :=1;
1555:

Line 1576: FROM ap_invoices ai

1572: -- bug 6883407
1573: l_debug_info := 'Fetch Invoice GL Date.';
1574: SELECT ai.gl_date
1575: INTO l_invoice_gl_date
1576: FROM ap_invoices ai
1577: WHERE ai.invoice_id = l_invoice_id_list(i); */
1578:
1579:
1580: l_success := AP_Cancel_Single_Invoice(