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_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.62.12020000.2 2013/03/11 05:51:42 harsanan ship $ */
3:
4: -- Bug 10103631 - Start
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICES_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICES_PKG';

1: PACKAGE BODY AP_INVOICES_PKG AS
2: /* $Header: apiinceb.pls 120.62.12020000.2 2013/03/11 05:51:42 harsanan ship $ */
3:
4: -- Bug 10103631 - Start
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_INVOICES_PKG';
6: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
7: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
8: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
9: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 21: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICES_PKG.';

17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICES_PKG.';
22: -- Bug 10103631 - End
23:
24: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
25: X_Invoice_Id IN OUT NOCOPY NUMBER,

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

191: BEGIN
192: -- Update the calling sequence
193: --
194: current_calling_sequence :=
195: 'AP_INVOICES_PKG.INSERT_ROW<-'||X_calling_sequence;
196:
197: -- Get LE Information
198: --
199: IF x_legal_entity_id IS NULL THEN

Line 622: AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID) POSTING_FLAG,

618: rtrim(ATTRIBUTE_CATEGORY) ATTRIBUTE_CATEGORY,
619: rtrim(APPROVAL_STATUS) APPROVAL_STATUS,
620: rtrim(APPROVAL_DESCRIPTION) APPROVAL_DESCRIPTION,
621: POSTING_STATUS,
622: AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID) POSTING_FLAG,
623: AUTHORIZED_BY,
624: CANCELLED_DATE,
625: CANCELLED_BY,
626: CANCELLED_AMOUNT,

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

731: BEGIN
732: -- Update the calling sequence
733:
734: current_calling_sequence :=
735: 'AP_INVOICES_PKG.LOCK_ROW<-'||X_calling_sequence;
736:
737: debug_info := 'Open cursor C';
738: OPEN C;
739: debug_info := 'Fetch cursor C';

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

1393:
1394: BEGIN
1395: -- Update the calling sequence
1396:
1397: current_calling_sequence := 'AP_INVOICES_PKG.LOCK_ROW(Invoice_id)<-'||
1398: X_calling_sequence;
1399:
1400: debug_info := 'Open cursor C';
1401: OPEN C;

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

1604: BEGIN
1605:
1606: -- Update the calling sequence
1607:
1608: current_calling_sequence := 'AP_INVOICES_PKG.UPDATE_ROW<-'||
1609: X_calling_sequence;
1610:
1611: -- Bug 10103631
1612: SELECT CASE WHEN NULLIF(X_Invoice_Num,ai.invoice_num) IS NOT NULL

Line 1794: /* IF (AP_INVOICES_PKG.get_approval_status(

1790:
1791: -- Bug 7570234 Start
1792: -- Bug 13402071: Calling AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq regardless of
1793: -- the invoice status
1794: /* IF (AP_INVOICES_PKG.get_approval_status(
1795: X_Invoice_Id,
1796: X_Invoice_Amount ,
1797: X_Payment_Status_Flag ,
1798: X_Invoice_Type_Lookup_Code)

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

1901: BEGIN
1902:
1903: -- Update the calling sequence
1904: --
1905: current_calling_sequence := 'AP_INVOICES_PKG.DELETE_ROW<-'||
1906: X_calling_sequence;
1907:
1908: -- Get the invoice_id
1909: debug_info := 'Get the invoice_id';

Line 1920: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),

1916: -- Verify that the record being deleted meets the requirements
1917: -- for deletion
1918: debug_info := 'Get parameter values to check requirements for deletion';
1919: SELECT
1920: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1921: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),

Line 1921: ap_invoices_pkg.get_encumbered_flag(invoice_id),

1917: -- for deletion
1918: debug_info := 'Get parameter values to check requirements for deletion';
1919: SELECT
1920: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1921: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),
1925: ap_invoices_pkg.get_po_number(invoice_id),

Line 1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),

1918: debug_info := 'Get parameter values to check requirements for deletion';
1919: SELECT
1920: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1921: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),
1925: ap_invoices_pkg.get_po_number(invoice_id),
1926: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),

Line 1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),

1919: SELECT
1920: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1921: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),
1925: ap_invoices_pkg.get_po_number(invoice_id),
1926: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1927: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,

Line 1924: ap_invoices_pkg.get_posting_status(invoice_id),

1920: ap_invoices_pkg.get_prepayments_applied_flag(invoice_id),
1921: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),
1925: ap_invoices_pkg.get_po_number(invoice_id),
1926: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1927: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1928: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262

Line 1925: ap_invoices_pkg.get_po_number(invoice_id),

1921: ap_invoices_pkg.get_encumbered_flag(invoice_id),
1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),
1925: ap_invoices_pkg.get_po_number(invoice_id),
1926: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1927: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1928: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262
1929: invoice_type_lookup_code

Line 1926: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),

1922: ap_invoices_pkg.get_payments_exist_flag(invoice_id),
1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),
1925: ap_invoices_pkg.get_po_number(invoice_id),
1926: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1927: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1928: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262
1929: invoice_type_lookup_code
1930: INTO

Line 1927: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,

1923: ap_invoices_pkg.selected_for_payment_flag(invoice_id),
1924: ap_invoices_pkg.get_posting_status(invoice_id),
1925: ap_invoices_pkg.get_po_number(invoice_id),
1926: ap_invoices_pkg.get_prepay_amount_applied(invoice_id),
1927: ap_invoices_pkg.get_approval_status(invoice_id, invoice_amount,
1928: payment_status_flag, invoice_type_lookup_code), -- Bug 5497262
1929: invoice_type_lookup_code
1930: INTO
1931: l_prepayments_applied_flag,

Line 2499: ap_invoices_pkg.get_gl_date_and_period( -- get_gl_date

2495:
2496: -- Call get_gl_date_and_period from ap_invoice_pkg instead of
2497: -- ap_invoices_utiliy_pkg; Done as a part of clean-up act
2498:
2499: ap_invoices_pkg.get_gl_date_and_period( -- get_gl_date
2500: l_invoice_date,
2501: l_receipt_date,
2502: l_period_name,
2503: l_GL_Date);

Line 2523: ap_invoices_pkg.get_gl_date_and_period(

2519: -- Call get_gl_date_and_period from ap_invoice_pkg instead of
2520: -- ap_invoices_utiliy_pkg; Done as a part of clean-up act
2521: -- MOAC. Added org_id parameter to FUNCTION and call
2522:
2523: ap_invoices_pkg.get_gl_date_and_period(
2524: P_date => l_invoice_date,
2525: P_Receipt_Date => l_receipt_date,
2526: P_Period_Name => l_period_name,
2527: P_GL_Date => l_GL_Date,

Line 3513: END AP_INVOICES_PKG;

3509:
3510: END Get_Force_Revalidation_Flag;
3511:
3512:
3513: END AP_INVOICES_PKG;