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

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 697: FROM ap_invoices_all

693: RELATIONSHIP_ID,
694: /* Bug 7831073 */
695: original_invoice_amount,
696: dispute_reason
697: FROM ap_invoices_all
698: WHERE rowid = X_Rowid
699: FOR UPDATE of Invoice_Id NOWAIT;
700:
701: Recinfo C%ROWTYPE;

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 1362: FROM ap_invoices_all

1358: RELATIONSHIP_ID,
1359: /* Bug 7831073 */
1360: original_invoice_amount,
1361: dispute_reason
1362: FROM ap_invoices_all
1363: WHERE invoice_id = X_Invoice_id
1364: FOR UPDATE of Invoice_Id NOWAIT;
1365:
1366: Recinfo C%ROWTYPE;

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 1579: debug_info := 'Update ap_invoices';

1575:
1576: current_calling_sequence := 'AP_INVOICES_PKG.UPDATE_ROW<-'||
1577: X_calling_sequence;
1578:
1579: debug_info := 'Update ap_invoices';
1580:
1581: AP_AI_TABLE_HANDLER_PKG.Update_Row
1582: (X_Rowid,
1583: X_Invoice_Id,

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

1786: debug_info := 'Get the invoice_id';
1787:
1788: SELECT invoice_id
1789: INTO l_invoice_id
1790: FROM ap_invoices
1791: WHERE rowid = X_rowid;
1792:
1793: -- Verify that the record being deleted meets the requirements
1794: -- for deletion

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

1813: l_po_number,
1814: l_prepay_amount_applied,
1815: l_approval_status,
1816: l_invoice_type
1817: FROM ap_invoices
1818: WHERE rowid = X_Rowid;
1819:
1820: IF (l_prepayments_applied_flag = 'Y') THEN
1821: l_message_name := 'AP_INV_DEL_INV_PREPAYS';

Line 1886: -- Date for AP Invoices'

1882:
1883: -----------------------------------------------------------------------
1884: -- FUNCTION get_expenditure_item_date RETURNs the expenditure item date
1885: -- to be used given PA's profile option: 'PA: Default Expenditure Item
1886: -- Date for AP Invoices'
1887: -----------------------------------------------------------------------
1888:
1889: FUNCTION Get_Expenditure_Item_Date(
1890: X_invoice_id IN NUMBER,

Line 2007: -- The following functions have been mapped to AP_INVOICES_UTILITY_PKG

2003:
2004: END get_expenditure_item_date;
2005:
2006: --=========================================================================
2007: -- The following functions have been mapped to AP_INVOICES_UTILITY_PKG
2008: -- (apinvuts.pls apinvutb.pls)
2009: --
2010: --=========================================================================
2011: FUNCTION get_distribution_total(l_invoice_id IN NUMBER)

Line 2017: l_distribution_total := AP_INVOICES_UTILITY_PKG.get_distribution_total(

2013: IS
2014: l_distribution_total NUMBER := 0;
2015:
2016: BEGIN
2017: l_distribution_total := AP_INVOICES_UTILITY_PKG.get_distribution_total(
2018: l_invoice_id);
2019:
2020: RETURN(l_distribution_total);
2021:

Line 2032: l_invoice_posting_flag := AP_INVOICES_UTILITY_PKG.get_posting_status(

2028: IS
2029: l_invoice_posting_flag VARCHAR2(1);
2030:
2031: BEGIN
2032: l_invoice_posting_flag := AP_INVOICES_UTILITY_PKG.get_posting_status(
2033: l_invoice_id);
2034:
2035: RETURN(l_invoice_posting_flag);
2036:

Line 2047: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE (

2043: X_ORG_ID NUMBER, /* Bug 5407785 */
2044: X_calling_sequence IN VARCHAR2) IS
2045: BEGIN
2046:
2047: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE (
2048: X_ROWID,
2049: X_INVOICE_NUM,
2050: X_VENDOR_ID,
2051: X_ORG_ID, /* Bug 5407785 */

Line 2067: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE_VOUCHER_NUM (

2063: X_VOUCHER_NUM VARCHAR2,
2064: X_calling_sequence IN VARCHAR2) IS
2065: BEGIN
2066:
2067: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE_VOUCHER_NUM (
2068: X_ROWID,
2069: X_VOUCHER_NUM,
2070: X_calling_sequence);
2071:

Line 2088: l_invoice_approval_status := AP_INVOICES_UTILITY_PKG.get_approval_status(

2084: IS
2085: l_invoice_approval_status VARCHAR2(25);
2086: BEGIN
2087:
2088: l_invoice_approval_status := AP_INVOICES_UTILITY_PKG.get_approval_status(
2089: l_invoice_id,
2090: l_invoice_amount,
2091: l_payment_status_flag,
2092: l_invoice_type_lookup_code);

Line 2103: l_po_number := AP_INVOICES_UTILITY_PKG.get_po_number(l_invoice_id);

2099: RETURN VARCHAR2
2100: IS
2101: l_po_number VARCHAR2(25);
2102: BEGIN
2103: l_po_number := AP_INVOICES_UTILITY_PKG.get_po_number(l_invoice_id);
2104:
2105: RETURN(l_po_number);
2106:
2107: END get_po_number;

Line 2114: l_release_number := AP_INVOICES_UTILITY_PKG.get_release_number(l_invoice_id);

2110: RETURN VARCHAR2
2111: IS
2112: l_release_number VARCHAR2(25);
2113: BEGIN
2114: l_release_number := AP_INVOICES_UTILITY_PKG.get_release_number(l_invoice_id);
2115:
2116: RETURN(l_release_number);
2117:
2118: END get_release_number;

Line 2126: l_receipt_number := AP_INVOICES_UTILITY_PKG.get_receipt_number(l_invoice_id);

2122: RETURN VARCHAR2
2123: IS
2124: l_receipt_number VARCHAR2(25);
2125: BEGIN
2126: l_receipt_number := AP_INVOICES_UTILITY_PKG.get_receipt_number(l_invoice_id);
2127:
2128: RETURN(l_receipt_number);
2129:
2130: END get_receipt_number;

Line 2138: l_po_number_list := AP_INVOICES_UTILITY_PKG.get_po_number_list(l_invoice_id);

2134: IS
2135: l_po_number_list VARCHAR2(2000) := NULL;
2136: BEGIN
2137:
2138: l_po_number_list := AP_INVOICES_UTILITY_PKG.get_po_number_list(l_invoice_id);
2139:
2140: RETURN(l_po_number_list);
2141:
2142: END get_po_number_list;

Line 2149: l_amount_withheld := AP_INVOICES_UTILITY_PKG.get_amount_withheld(

2145: RETURN NUMBER
2146: IS
2147: l_amount_withheld NUMBER := 0;
2148: BEGIN
2149: l_amount_withheld := AP_INVOICES_UTILITY_PKG.get_amount_withheld(
2150: l_invoice_id);
2151:
2152: RETURN(l_amount_withheld);
2153:

Line 2161: l_prepaid_amount := AP_INVOICES_UTILITY_PKG.get_prepaid_amount(l_invoice_id);

2157: RETURN NUMBER
2158: IS
2159: l_prepaid_amount NUMBER := 0;
2160: BEGIN
2161: l_prepaid_amount := AP_INVOICES_UTILITY_PKG.get_prepaid_amount(l_invoice_id);
2162:
2163: RETURN(l_prepaid_amount);
2164:
2165: END get_prepaid_amount;

Line 2172: l_notes_count := AP_INVOICES_UTILITY_PKG.get_notes_count(l_invoice_id);

2168: RETURN NUMBER
2169: IS
2170: l_notes_count NUMBER := 0;
2171: BEGIN
2172: l_notes_count := AP_INVOICES_UTILITY_PKG.get_notes_count(l_invoice_id);
2173: RETURN(l_notes_count);
2174:
2175: END get_notes_count;
2176:

Line 2182: l_holds_count := AP_INVOICES_UTILITY_PKG.get_holds_count(l_invoice_id);

2178: RETURN NUMBER
2179: IS
2180: l_holds_count NUMBER := 0;
2181: BEGIN
2182: l_holds_count := AP_INVOICES_UTILITY_PKG.get_holds_count(l_invoice_id);
2183:
2184: RETURN(l_holds_count);
2185:
2186: END get_holds_count;

Line 2194: l_holds_count := AP_INVOICES_UTILITY_PKG.get_sched_holds_count(l_invoice_id);

2190: RETURN NUMBER
2191: IS
2192: l_holds_count NUMBER := 0;
2193: BEGIN
2194: l_holds_count := AP_INVOICES_UTILITY_PKG.get_sched_holds_count(l_invoice_id);
2195:
2196: RETURN(l_holds_count);
2197:
2198: END get_sched_holds_count;

Line 2209: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_total_prepays(

2205: IS
2206: l_prepay_count NUMBER := 0;
2207: BEGIN
2208: -- MOAC. Added org_id parameter to FUNCTION and to call
2209: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_total_prepays(
2210: l_vendor_id,
2211: l_org_id);
2212: RETURN(l_prepay_count);
2213:

Line 2224: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_available_prepays(

2220: IS
2221: l_prepay_count NUMBER := 0;
2222: BEGIN
2223: -- MOAC. Added org_id parameter to FUNCTION and to call
2224: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_available_prepays(
2225: l_vendor_id,
2226: l_org_id);
2227:
2228: RETURN(l_prepay_count);

Line 2237: l_encumbered_flag := AP_INVOICES_UTILITY_PKG.get_encumbered_flag(

2233: IS
2234: l_encumbered_flag VARCHAR2(1);
2235:
2236: BEGIN
2237: l_encumbered_flag := AP_INVOICES_UTILITY_PKG.get_encumbered_flag(
2238: l_invoice_id);
2239:
2240: RETURN(l_encumbered_flag);
2241:

Line 2249: l_amount_hold_flag := AP_INVOICES_UTILITY_PKG.get_amount_hold_flag(

2245: RETURN VARCHAR2
2246: IS
2247: l_amount_hold_flag VARCHAR2(1) := 'N';
2248: BEGIN
2249: l_amount_hold_flag := AP_INVOICES_UTILITY_PKG.get_amount_hold_flag(
2250: l_invoice_id);
2251:
2252: RETURN(L_amount_hold_flag);
2253:

Line 2261: l_vendor_hold_flag := AP_INVOICES_UTILITY_PKG.get_vendor_hold_flag(

2257: RETURN VARCHAR2
2258: IS
2259: l_vendor_hold_flag VARCHAR2(1) := 'N';
2260: BEGIN
2261: l_vendor_hold_flag := AP_INVOICES_UTILITY_PKG.get_vendor_hold_flag(
2262: l_invoice_id);
2263:
2264: RETURN(l_vendor_hold_flag);
2265:

Line 2272: -- ap_invoices. You needn't pass a parent date, however, to determine

2268: -- --------------------------------------------------------------------------
2269: -- Procedure get_gl_date_and_period() can be used to determine the
2270: -- open period given a date. This PROCEDURE will also allow you to
2271: -- compare with a parent GL date, such as that of ap_batches for
2272: -- ap_invoices. You needn't pass a parent date, however, to determine
2273: -- the next open period. The GL date and period name are written to
2274: -- IN OUT NOCOPY parameters, P_GL_Date and P_Period_Name, passed to the
2275: -- procedure. If there is no open period, the PROCEDURE RETURNs
2276: -- null in the IN OUT NOCOPY parameters.

Line 2277: -- Instead of Calling the AP_INVOICES_UTILITY_PKG.get_gl_date_and_period,

2273: -- the next open period. The GL date and period name are written to
2274: -- IN OUT NOCOPY parameters, P_GL_Date and P_Period_Name, passed to the
2275: -- procedure. If there is no open period, the PROCEDURE RETURNs
2276: -- null in the IN OUT NOCOPY parameters.
2277: -- Instead of Calling the AP_INVOICES_UTILITY_PKG.get_gl_date_and_period,
2278: -- the code has been SHIFTED into this PROCEDURE as a part of clean-up and
2279: -- PROCEDURE get_gl_date_and_period is REMOVED from AP_INVOICE_UTILITY_PKG.
2280: -- -------------------------------------------------------------------------
2281:

Line 2370: -- ap_invoices_utiliy_pkg; Done as a part of clean-up act

2366: l_period_name gl_period_statuses.period_name%TYPE := ''; -- Not used
2367: BEGIN
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,

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 2393: -- ap_invoices_utiliy_pkg; Done as a part of clean-up act

2389: l_period_name gl_period_statuses.period_name%TYPE := '';
2390: BEGIN
2391:
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,

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 2414: l_invoice_num ap_invoices.invoice_num%TYPE;

2410: P_invoice_type_lookup_code IN VARCHAR2,
2411: P_invoice_currency_code IN VARCHAR2,
2412: P_calling_sequence IN VARCHAR2) RETURN VARCHAR2
2413: IS
2414: l_invoice_num ap_invoices.invoice_num%TYPE;
2415:
2416: BEGIN
2417: l_invoice_num := AP_INVOICES_UTILITY_PKG.get_similar_drcr_memo(
2418: P_vendor_id,

Line 2417: l_invoice_num := AP_INVOICES_UTILITY_PKG.get_similar_drcr_memo(

2413: IS
2414: l_invoice_num ap_invoices.invoice_num%TYPE;
2415:
2416: BEGIN
2417: l_invoice_num := AP_INVOICES_UTILITY_PKG.get_similar_drcr_memo(
2418: P_vendor_id,
2419: P_vendor_site_id,
2420: P_invoice_amount,
2421: P_invoice_type_lookup_code,

Line 2434: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_details_exist (

2430: P_calling_sequence IN VARCHAR2) RETURN BOOLEAN
2431: IS
2432: l_flag boolean;
2433: BEGIN
2434: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_details_exist (
2435: P_vendor_site_id,
2436: P_calling_sequence);
2437:
2438: RETURN(l_flag);

Line 2448: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_curr_details_exist (

2444: P_calling_sequence IN VARCHAR2) RETURN boolean
2445: IS
2446: l_flag boolean;
2447: BEGIN
2448: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_curr_details_exist (
2449: P_vendor_site_id,
2450: P_currency_code,
2451: P_calling_sequence);
2452:

Line 2462: l_flag := AP_INVOICES_UTILITY_PKG.selected_for_payment_flag (P_invoice_id);

2458: P_invoice_id IN NUMBER) RETURN VARCHAR2
2459: IS
2460: l_flag VARCHAR2(1) := 'N';
2461: BEGIN
2462: l_flag := AP_INVOICES_UTILITY_PKG.selected_for_payment_flag (P_invoice_id);
2463:
2464: RETURN(l_flag);
2465:
2466: END selected_for_payment_flag;

Line 2473: l_flag := AP_INVOICES_UTILITY_PKG.get_discount_pay_dists_flag (P_invoice_id);

2469: RETURN VARCHAR2
2470: IS
2471: l_flag VARCHAR2(1) := 'N';
2472: BEGIN
2473: l_flag := AP_INVOICES_UTILITY_PKG.get_discount_pay_dists_flag (P_invoice_id);
2474:
2475: RETURN(l_flag);
2476:
2477: END get_discount_pay_dists_flag;

Line 2486: l_flag := AP_INVOICES_UTILITY_PKG.get_unposted_void_payment (P_invoice_id);

2482: RETURN VARCHAR2
2483: IS
2484: l_flag VARCHAR2(1) := 'N';
2485: BEGIN
2486: l_flag := AP_INVOICES_UTILITY_PKG.get_unposted_void_payment (P_invoice_id);
2487:
2488: RETURN(l_flag);
2489:
2490: END get_unposted_void_payment;

Line 2498: l_flag := AP_INVOICES_UTILITY_PKG.get_prepayments_applied_flag (P_invoice_id);

2494: RETURN VARCHAR2
2495: IS
2496: l_flag VARCHAR2(1) := 'N';
2497: BEGIN
2498: l_flag := AP_INVOICES_UTILITY_PKG.get_prepayments_applied_flag (P_invoice_id);
2499: RETURN(l_flag);
2500:
2501: END get_prepayments_applied_flag;
2502:

Line 2509: l_flag := AP_INVOICES_UTILITY_PKG.get_payments_exist_flag (P_invoice_id);

2505: RETURN VARCHAR2
2506: IS
2507: l_flag VARCHAR2(1) := 'N';
2508: BEGIN
2509: l_flag := AP_INVOICES_UTILITY_PKG.get_payments_exist_flag (P_invoice_id);
2510:
2511: RETURN(l_flag);
2512:
2513: END get_payments_exist_flag;

Line 2521: l_prepay_amount := AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied (

2517: IS
2518: l_prepay_amount NUMBER := 0;
2519:
2520: BEGIN
2521: l_prepay_amount := AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied (
2522: P_invoice_id);
2523:
2524: RETURN(l_prepay_amount);
2525:

Line 2533: l_packet_id := AP_INVOICES_UTILITY_PKG.get_packet_id (P_invoice_id);

2529: RETURN NUMBER
2530: IS
2531: l_packet_id NUMBER := '';
2532: BEGIN
2533: l_packet_id := AP_INVOICES_UTILITY_PKG.get_packet_id (P_invoice_id);
2534:
2535: RETURN(l_packet_id);
2536:
2537: END get_packet_id;

Line 2540: -- The functions above have been mapped to AP_INVOICES_UTILITY_PKG

2536:
2537: END get_packet_id;
2538:
2539: --=========================================================================
2540: -- The functions above have been mapped to AP_INVOICES_UTILITY_PKG
2541: -- (apinvuts.pls apinvutb.pls)
2542: --=========================================================================
2543:
2544: --=========================================================================

Line 2545: -- The Following functions have been mapped to AP_INVOICES_POST_PROCESS_PKG

2541: -- (apinvuts.pls apinvutb.pls)
2542: --=========================================================================
2543:
2544: --=========================================================================
2545: -- The Following functions have been mapped to AP_INVOICES_POST_PROCESS_PKG
2546: -- (apinvpps.pls apinvppb.pls)
2547: --
2548: --=========================================================================
2549:

Line 2568: AP_INVOICES_POST_PROCESS_PKG.insert_children (

2564: X_Sched_Hold_count IN OUT NOCOPY NUMBER) -- bug 5334577
2565:
2566: IS
2567: BEGIN
2568: AP_INVOICES_POST_PROCESS_PKG.insert_children (
2569: X_invoice_id,
2570: X_Payment_Priority,
2571: X_Hold_count,
2572: X_Line_count,

Line 2596: AP_INVOICES_POST_PROCESS_PKG.create_holds (

2592: X_vendor_changed_flag IN VARCHAR2 DEFAULT 'N',
2593: X_calling_sequence IN VARCHAR2)
2594: IS
2595: BEGIN
2596: AP_INVOICES_POST_PROCESS_PKG.create_holds (
2597: X_invoice_id,
2598: X_event,
2599: X_update_base,
2600: X_vendor_changed_flag,

Line 2644: AP_INVOICES_POST_PROCESS_PKG.invoice_pre_update (

2640: X_calling_sequence IN VARCHAR2,
2641: X_revalidate_ps IN OUT NOCOPY VARCHAR2)
2642: IS
2643: BEGIN
2644: AP_INVOICES_POST_PROCESS_PKG.invoice_pre_update (
2645: X_invoice_id,
2646: X_invoice_amount,
2647: X_payment_status_flag,
2648: X_invoice_type_lookup_code,

Line 2693: AP_INVOICES_POST_PROCESS_PKG.invoice_post_update (

2689: X_calling_sequence IN VARCHAR2,
2690: X_Sched_Hold_count IN OUT NOCOPY NUMBER) -- bug 5334577
2691: IS
2692: BEGIN
2693: AP_INVOICES_POST_PROCESS_PKG.invoice_post_update (
2694: X_invoice_id,
2695: X_payment_priority,
2696: X_recalc_pay_sched,
2697: X_Hold_count,

Line 2744: AP_INVOICES_POST_PROCESS_PKG.post_forms_commit (

2740: X_sched_holds_count IN OUT NOCOPY NUMBER) IS --bug 5334577
2741:
2742: BEGIN
2743:
2744: AP_INVOICES_POST_PROCESS_PKG.post_forms_commit (
2745: X_invoice_id,
2746: NULL,
2747: X_type_1099,
2748: X_income_tax_region,

Line 2784: AP_INVOICES_POST_PROCESS_PKG.Select_Summary(

2780: X_Total_Rtot_DB IN OUT NOCOPY NUMBER,
2781: X_Calling_Sequence IN VARCHAR2)
2782: IS
2783: BEGIN
2784: AP_INVOICES_POST_PROCESS_PKG.Select_Summary(
2785: X_Batch_ID,
2786: X_Total,
2787: X_Total_Rtot_DB,
2788: X_Calling_Sequence);

Line 2796: -- The Functions above have been mapped to AP_INVOICES_POST_PROCESS_PKG

2792: APP_EXCEPTION.RAISE_EXCEPTION;
2793: END Select_Summary;
2794:
2795: --=========================================================================
2796: -- The Functions above have been mapped to AP_INVOICES_POST_PROCESS_PKG
2797: -- (apinvpps.pls apinvppb.pls)
2798: --=========================================================================
2799:
2800: --bug4299234

Line 2833: from ap_invoices_all

2829: If l_reapprove>0 then return('REAPPROVE'); end if;
2830:
2831: select wfapproval_status
2832: into header_approval_status
2833: from ap_invoices_all
2834: where invoice_id=p_invoice_id
2835: and org_id=p_org_id;
2836:
2837: IF (l_approved > 0 and header_approval_status = 'NOT REQUIRED') THEN

Line 2998: from ap_invoices_all ai,

2994: sysdate,
2995: 1,
2996: aps.iby_hold_reason,
2997: aps.hold_flag
2998: from ap_invoices_all ai,
2999: ap_payment_schedules_all aps,
3000: ap_suppliers pv,
3001: ap_supplier_sites_all pvs
3002: where ai.invoice_id = p_invoice_id

Line 3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;

3012: l_DOCUMENT_PAYABLE_ID number;
3013: l_CALLING_APP_ID number;
3014: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3015: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;

Line 3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;

3013: l_CALLING_APP_ID number;
3014: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3015: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;

Line 3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;

3014: l_CALLING_APP_DOC_UNIQUE_REF1 number;
3015: l_CALLING_APP_DOC_UNIQUE_REF2 number;
3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;

Line 3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;

3016: -- l_CALLING_APP_DOC_REF_NUMBER ap_invoices_all.invoice_num%type;
3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;

Line 3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;

3017: l_PAY_PROC_TRXN_TYPE_CODE ap_invoices_all.pay_proc_trxn_type_code%type;
3018: l_PAYMENT_METHOD_CODE ap_invoices_all.payment_method_code%type;
3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3025: l_DOCUMENT_AMOUNT number;

Line 3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;

3019: l_PAYMENT_AMOUNT number;
3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3025: l_DOCUMENT_AMOUNT number;
3026: l_EXTERNAL_BANK_ACCOUNT_ID number;
3027: l_PAYEE_PARTY_ID number;

Line 3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;

3020: l_EXCLUSIVE_PAYMENT_FLAG ap_invoices_all.exclusive_payment_flag%type;
3021: l_PAYMENT_FUNCTION ap_invoices_all.payment_function%type;
3022: l_DOCUMENT_DATE date;
3023: l_DOCUMENT_TYPE ap_invoices_all.invoice_type_lookup_code%type;
3024: l_DOCUMENT_DESCRIPTION ap_invoices_all.description%type;
3025: l_DOCUMENT_AMOUNT number;
3026: l_EXTERNAL_BANK_ACCOUNT_ID number;
3027: l_PAYEE_PARTY_ID number;
3028: l_PAYEE_PARTY_SITE_ID number;

Line 3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;

3029: l_SUPPLIER_SITE_ID number;
3030: l_LEGAL_ENTITY_ID number;
3031: l_ORG_ID number;
3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;

Line 3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;

3030: l_LEGAL_ENTITY_ID number;
3031: l_ORG_ID number;
3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;

Line 3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;

3031: l_ORG_ID number;
3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;

Line 3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;

3032: l_ORG_TYPE varchar2(30);
3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;

Line 3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;

3033: l_DOCUMENT_CURRENCY_CODE ap_invoices_all.invoice_currency_code%type;
3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;

Line 3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;

3034: l_PAYMENT_CURRENCY_CODE ap_invoices_all.payment_currency_code%type;
3035: l_BANK_CHARGE_BEARER ap_invoices_all.bank_charge_bearer%type;
3036: l_PAYMENT_REASON_CODE ap_invoices_all.payment_reason_code%type;
3037: l_PAYMENT_REASON_COMMENTS ap_invoices_all.payment_reason_comments%type;
3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;

Line 3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;

3038: l_SETTLEMENT_PRIORITY ap_invoices_all.settlement_priority%type;
3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3045: l_DISCOUNT_DATE date;
3046: l_CREATED_BY number;

Line 3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;

3039: l_REMITTANCE_MESSAGE1 ap_payment_schedules_all.remittance_message1%type;
3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3045: l_DISCOUNT_DATE date;
3046: l_CREATED_BY number;
3047: l_CREATION_DATE date;

Line 3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;

3040: l_REMITTANCE_MESSAGE2 ap_payment_schedules_all.remittance_message2%type;
3041: l_REMITTANCE_MESSAGE3 ap_payment_schedules_all.remittance_message3%type;
3042: l_UNIQUE_REMITTANCE_IDENTIFIER ap_invoices_all.unique_remittance_identifier%type;
3043: l_URI_CHECK_DIGIT ap_invoices_all.uri_check_digit%type;
3044: l_DELIVERY_CHANNEL_CODE ap_invoices_all.delivery_channel_code%type;
3045: l_DISCOUNT_DATE date;
3046: l_CREATED_BY number;
3047: l_CREATION_DATE date;
3048: l_LAST_UPDATED_BY number;

Line 3267: END AP_INVOICES_PKG;

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