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_HOLDS_PKG dependencies on AP_INVOICES

Line 407: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

403: X_calling_sequence IN VARCHAR2
404:
405: ) IS
406:
407: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
408: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
409: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
410: l_tax_hold_codes AP_ETAX_SERVICES_PKG.Rel_Hold_Codes_Type;
411: l_approval_status VARCHAR2(100);

Line 408: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

404:
405: ) IS
406:
407: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
408: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
409: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
410: l_tax_hold_codes AP_ETAX_SERVICES_PKG.Rel_Hold_Codes_Type;
411: l_approval_status VARCHAR2(100);
412: l_success BOOLEAN := TRUE;

Line 409: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

405: ) IS
406:
407: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
408: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
409: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
410: l_tax_hold_codes AP_ETAX_SERVICES_PKG.Rel_Hold_Codes_Type;
411: l_approval_status VARCHAR2(100);
412: l_success BOOLEAN := TRUE;
413: l_error_code VARCHAR2(4000);

Line 506: FROM ap_invoices

502: invoice_type_lookup_code
503: INTO l_invoice_amount,
504: l_payment_status_flag,
505: l_invoice_type_lookup_code
506: FROM ap_invoices
507: WHERE invoice_id = x_invoice_id;
508:
509: l_approval_status := ap_invoices_pkg.get_approval_status(x_invoice_id,
510: l_invoice_amount,

Line 509: l_approval_status := ap_invoices_pkg.get_approval_status(x_invoice_id,

505: l_invoice_type_lookup_code
506: FROM ap_invoices
507: WHERE invoice_id = x_invoice_id;
508:
509: l_approval_status := ap_invoices_pkg.get_approval_status(x_invoice_id,
510: l_invoice_amount,
511: l_payment_status_flag,
512: l_invoice_type_lookup_code);
513:

Line 609: -- the AP_HOLDS table given a record in ap_invoices.

605: END Delete_Row;
606:
607: -----------------------------------------------------------------------
608: -- PROCEDURE insert_single_hold inserts a single record into
609: -- the AP_HOLDS table given a record in ap_invoices.
610: -----------------------------------------------------------------------
611: PROCEDURE insert_single_hold (X_invoice_id IN number,
612: X_hold_lookup_code IN varchar2,
613: X_hold_type IN varchar2 DEFAULT NULL,

Line 693: FROM ap_invoices

689: FND_GLOBAL.user_id, -- 7299826
690: nvl(X_held_by,FND_GLOBAL.user_id), -- 7299826
691: l_hold_reason,
692: ORG_ID,L_HOLD_ID
693: FROM ap_invoices
694: WHERE invoice_id = X_invoice_id
695: AND not exists
696: (SELECT 'Already on this hold'
697: FROM ap_holds

Line 744: l_last_updated_by ap_invoices.last_updated_by%TYPE;

740: IS
741: current_calling_sequence VARCHAR2(2000);
742: debug_info VARCHAR2(100);
743: l_hold_reason ap_hold_codes.description%TYPE;
744: l_last_updated_by ap_invoices.last_updated_by%TYPE;
745: l_last_update_login ap_invoices.last_update_login%TYPE;
746:
747: cursor invoice_who_cursor is
748: select last_updated_by,

Line 745: l_last_update_login ap_invoices.last_update_login%TYPE;

741: current_calling_sequence VARCHAR2(2000);
742: debug_info VARCHAR2(100);
743: l_hold_reason ap_hold_codes.description%TYPE;
744: l_last_updated_by ap_invoices.last_updated_by%TYPE;
745: l_last_update_login ap_invoices.last_update_login%TYPE;
746:
747: cursor invoice_who_cursor is
748: select last_updated_by,
749: last_update_login

Line 750: from ap_invoices

746:
747: cursor invoice_who_cursor is
748: select last_updated_by,
749: last_update_login
750: from ap_invoices
751: where invoice_id = X_invoice_id;
752:
753: BEGIN
754:

Line 761: debug_info := 'Select from AP_INVOICES';

757: current_calling_sequence :=
758: 'AP_HOLDS_PKG.release_single_hold<-'||
759: X_calling_sequence;
760:
761: debug_info := 'Select from AP_INVOICES';
762:
763: open invoice_who_cursor;
764: fetch invoice_who_cursor into l_last_updated_by, l_last_update_login;
765: close invoice_who_cursor;

Line 834: select ap_invoices_pkg.get_holds_count(invoice_id),

830: current_calling_sequence VARCHAR2(2000);
831: debug_info VARCHAR2(100);
832:
833: cursor l_invoice_status_cursor is
834: select ap_invoices_pkg.get_holds_count(invoice_id),
835: ap_invoices_pkg.get_approval_status(
836: invoice_id,
837: invoice_amount,
838: payment_status_flag,

Line 835: ap_invoices_pkg.get_approval_status(

831: debug_info VARCHAR2(100);
832:
833: cursor l_invoice_status_cursor is
834: select ap_invoices_pkg.get_holds_count(invoice_id),
835: ap_invoices_pkg.get_approval_status(
836: invoice_id,
837: invoice_amount,
838: payment_status_flag,
839: invoice_type_lookup_code)

Line 840: from ap_invoices

836: invoice_id,
837: invoice_amount,
838: payment_status_flag,
839: invoice_type_lookup_code)
840: from ap_invoices
841: where invoice_id = X_invoice_id;
842:
843: cursor tax_holds_cursor is
844: select hold_lookup_code