DBA Data[Home] [Help]

APPS.AP_INVOICES_PKG dependencies on AP_INVOICES_PKG

Line 1: PACKAGE BODY AP_INVOICES_PKG AS

1: PACKAGE BODY AP_INVOICES_PKG AS
2: /* $Header: apiinceb.pls 120.49.12010000.4 2009/02/04 05:57:29 ctetala ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Invoice_Id IN OUT NOCOPY NUMBER,

Line 175: 'AP_INVOICES_PKG.INSERT_ROW<-'||X_calling_sequence;

171: BEGIN
172: -- Update the calling sequence
173: --
174: current_calling_sequence :=
175: 'AP_INVOICES_PKG.INSERT_ROW<-'||X_calling_sequence;
176:
177: -- Get LE Information
178: --
179: IF x_legal_entity_id IS NULL THEN

Line 598: AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID) POSTING_FLAG,

594: ATTRIBUTE_CATEGORY,
595: APPROVAL_STATUS,
596: APPROVAL_DESCRIPTION,
597: POSTING_STATUS,
598: AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID) POSTING_FLAG,
599: AUTHORIZED_BY,
600: CANCELLED_DATE,
601: CANCELLED_BY,
602: CANCELLED_AMOUNT,

Line 711: 'AP_INVOICES_PKG.LOCK_ROW<-'||X_calling_sequence;

707: BEGIN
708: -- Update the calling sequence
709:
710: current_calling_sequence :=
711: 'AP_INVOICES_PKG.LOCK_ROW<-'||X_calling_sequence;
712:
713: debug_info := 'Open cursor C';
714: OPEN C;
715: debug_info := 'Fetch cursor C';

Line 1373: current_calling_sequence := 'AP_INVOICES_PKG.LOCK_ROW(Invoice_id)<-'||

1369:
1370: BEGIN
1371: -- Update the calling sequence
1372:
1373: current_calling_sequence := 'AP_INVOICES_PKG.LOCK_ROW(Invoice_id)<-'||
1374: X_calling_sequence;
1375:
1376: debug_info := 'Open cursor C';
1377: OPEN C;

Line 1576: current_calling_sequence := 'AP_INVOICES_PKG.UPDATE_ROW<-'||

1572: BEGIN
1573:
1574: -- Update the calling sequence
1575:
1576: current_calling_sequence := 'AP_INVOICES_PKG.UPDATE_ROW<-'||
1577: X_calling_sequence;
1578:
1579: debug_info := 'Update ap_invoices';
1580:

Line 1782: current_calling_sequence := 'AP_INVOICES_PKG.DELETE_ROW<-'||

1778: BEGIN
1779:
1780: -- Update the calling sequence
1781: --
1782: current_calling_sequence := 'AP_INVOICES_PKG.DELETE_ROW<-'||
1783: X_calling_sequence;
1784:
1785: -- Get the invoice_id
1786: debug_info := 'Get the invoice_id';

Line 1797: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),

1793: -- Verify that the record being deleted meets the requirements
1794: -- for deletion
1795: debug_info := 'Get parameter values to check requirements for deletion';
1796: SELECT
1797: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1798: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),

Line 1798: ap_invoices_pkg.get_encumbered_flag(invoice_id),

1794: -- for deletion
1795: debug_info := 'Get parameter values to check requirements for deletion';
1796: SELECT
1797: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1798: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),
1802: ap_invoices_pkg.get_po_number(invoice_id),

Line 1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),

1795: debug_info := 'Get parameter values to check requirements for deletion';
1796: SELECT
1797: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1798: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),
1802: ap_invoices_pkg.get_po_number(invoice_id),
1803: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),

Line 1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),

1796: SELECT
1797: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1798: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),
1802: ap_invoices_pkg.get_po_number(invoice_id),
1803: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1804: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,

Line 1801: ap_invoices_pkg.get_posting_status(invoice_id),

1797: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1798: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),
1802: ap_invoices_pkg.get_po_number(invoice_id),
1803: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1804: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1805: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262

Line 1802: ap_invoices_pkg.get_po_number(invoice_id),

1798: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),
1802: ap_invoices_pkg.get_po_number(invoice_id),
1803: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1804: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1805: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262
1806: invoice_type_lookup_code

Line 1803: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),

1799: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),
1802: ap_invoices_pkg.get_po_number(invoice_id),
1803: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1804: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1805: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262
1806: invoice_type_lookup_code
1807: INTO

Line 1804: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,

1800: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1801: ap_invoices_pkg.get_posting_status(invoice_id),
1802: ap_invoices_pkg.get_po_number(invoice_id),
1803: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1804: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1805: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262
1806: invoice_type_lookup_code
1807: INTO
1808: l_prepayments_applied_flag,

Line 2372: ap_invoices_pkg.get_gl_date_and_period( -- get_gl_date

2368:
2369: -- Call get_gl_date_and_period from ap_invoice_pkg instead of
2370: -- ap_invoices_utiliy_pkg; Done as a part of clean-up act
2371:
2372: ap_invoices_pkg.get_gl_date_and_period( -- get_gl_date
2373: l_invoice_date,
2374: l_receipt_date,
2375: l_period_name,
2376: l_GL_Date);

Line 2396: ap_invoices_pkg.get_gl_date_and_period(

2392: -- Call get_gl_date_and_period from ap_invoice_pkg instead of
2393: -- ap_invoices_utiliy_pkg; Done as a part of clean-up act
2394: -- MOAC. Added org_id parameter to FUNCTION and call
2395:
2396: ap_invoices_pkg.get_gl_date_and_period(
2397: P_date => l_invoice_date,
2398: P_Receipt_Date => l_receipt_date,
2399: P_Period_Name => l_period_name,
2400: P_GL_Date => l_GL_Date,

Line 3267: END AP_INVOICES_PKG;

3263:
3264: end;
3265:
3266:
3267: END AP_INVOICES_PKG;