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.

[Home] [Help]

APPS.AP_INVOICES_PKG dependencies on AP_INVOICES_UTILITY_PKG

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 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 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: --=========================================================================