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_UTILITY_PKG

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

2126:
2127: END get_expenditure_item_date;
2128:
2129: --=========================================================================
2130: -- The following functions have been mapped to AP_INVOICES_UTILITY_PKG
2131: -- (apinvuts.pls apinvutb.pls)
2132: --
2133: --=========================================================================
2134: FUNCTION get_distribution_total(l_invoice_id IN NUMBER)

Line 2140: l_distribution_total := AP_INVOICES_UTILITY_PKG.get_distribution_total(

2136: IS
2137: l_distribution_total NUMBER := 0;
2138:
2139: BEGIN
2140: l_distribution_total := AP_INVOICES_UTILITY_PKG.get_distribution_total(
2141: l_invoice_id);
2142:
2143: RETURN(l_distribution_total);
2144:

Line 2155: l_invoice_posting_flag := AP_INVOICES_UTILITY_PKG.get_posting_status(

2151: IS
2152: l_invoice_posting_flag VARCHAR2(1);
2153:
2154: BEGIN
2155: l_invoice_posting_flag := AP_INVOICES_UTILITY_PKG.get_posting_status(
2156: l_invoice_id);
2157:
2158: RETURN(l_invoice_posting_flag);
2159:

Line 2172: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE (

2168: X_VENDOR_SITE_ID NUMBER, /*Bug9105666*/
2169: X_calling_sequence IN VARCHAR2) IS
2170: BEGIN
2171:
2172: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE (
2173: X_ROWID,
2174: X_INVOICE_NUM,
2175: X_VENDOR_ID,
2176: X_ORG_ID, /* Bug 5407785 */

Line 2194: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE_VOUCHER_NUM (

2190: X_VOUCHER_NUM VARCHAR2,
2191: X_calling_sequence IN VARCHAR2) IS
2192: BEGIN
2193:
2194: AP_INVOICES_UTILITY_PKG.CHECK_UNIQUE_VOUCHER_NUM (
2195: X_ROWID,
2196: X_VOUCHER_NUM,
2197: X_calling_sequence);
2198:

Line 2215: l_invoice_approval_status := AP_INVOICES_UTILITY_PKG.get_approval_status(

2211: IS
2212: l_invoice_approval_status VARCHAR2(25);
2213: BEGIN
2214:
2215: l_invoice_approval_status := AP_INVOICES_UTILITY_PKG.get_approval_status(
2216: l_invoice_id,
2217: l_invoice_amount,
2218: l_payment_status_flag,
2219: l_invoice_type_lookup_code);

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

2226: RETURN VARCHAR2
2227: IS
2228: l_po_number VARCHAR2(50); -- for CLM Bug 9503239
2229: BEGIN
2230: l_po_number := AP_INVOICES_UTILITY_PKG.get_po_number(l_invoice_id);
2231:
2232: RETURN(l_po_number);
2233:
2234: END get_po_number;

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

2237: RETURN VARCHAR2
2238: IS
2239: l_release_number VARCHAR2(25);
2240: BEGIN
2241: l_release_number := AP_INVOICES_UTILITY_PKG.get_release_number(l_invoice_id);
2242:
2243: RETURN(l_release_number);
2244:
2245: END get_release_number;

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

2249: RETURN VARCHAR2
2250: IS
2251: l_receipt_number RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE; --Bug 16413390
2252: BEGIN
2253: l_receipt_number := AP_INVOICES_UTILITY_PKG.get_receipt_number(l_invoice_id);
2254:
2255: RETURN(l_receipt_number);
2256:
2257: END get_receipt_number;

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

2261: IS
2262: l_po_number_list VARCHAR2(5000) := NULL; -- for CLM Bug 9503239
2263: BEGIN
2264:
2265: l_po_number_list := AP_INVOICES_UTILITY_PKG.get_po_number_list(l_invoice_id);
2266:
2267: RETURN(l_po_number_list);
2268:
2269: END get_po_number_list;

Line 2276: l_amount_withheld := AP_INVOICES_UTILITY_PKG.get_amount_withheld(

2272: RETURN NUMBER
2273: IS
2274: l_amount_withheld NUMBER := 0;
2275: BEGIN
2276: l_amount_withheld := AP_INVOICES_UTILITY_PKG.get_amount_withheld(
2277: l_invoice_id);
2278:
2279: RETURN(l_amount_withheld);
2280:

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

2284: RETURN NUMBER
2285: IS
2286: l_prepaid_amount NUMBER := 0;
2287: BEGIN
2288: l_prepaid_amount := AP_INVOICES_UTILITY_PKG.get_prepaid_amount(l_invoice_id);
2289:
2290: RETURN(l_prepaid_amount);
2291:
2292: END get_prepaid_amount;

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

2295: RETURN NUMBER
2296: IS
2297: l_notes_count NUMBER := 0;
2298: BEGIN
2299: l_notes_count := AP_INVOICES_UTILITY_PKG.get_notes_count(l_invoice_id);
2300: RETURN(l_notes_count);
2301:
2302: END get_notes_count;
2303:

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

2305: RETURN NUMBER
2306: IS
2307: l_holds_count NUMBER := 0;
2308: BEGIN
2309: l_holds_count := AP_INVOICES_UTILITY_PKG.get_holds_count(l_invoice_id);
2310:
2311: RETURN(l_holds_count);
2312:
2313: END get_holds_count;

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

2317: RETURN NUMBER
2318: IS
2319: l_holds_count NUMBER := 0;
2320: BEGIN
2321: l_holds_count := AP_INVOICES_UTILITY_PKG.get_sched_holds_count(l_invoice_id);
2322:
2323: RETURN(l_holds_count);
2324:
2325: END get_sched_holds_count;

Line 2336: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_total_prepays(

2332: IS
2333: l_prepay_count NUMBER := 0;
2334: BEGIN
2335: -- MOAC. Added org_id parameter to FUNCTION and to call
2336: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_total_prepays(
2337: l_vendor_id,
2338: l_org_id);
2339: RETURN(l_prepay_count);
2340:

Line 2351: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_available_prepays(

2347: IS
2348: l_prepay_count NUMBER := 0;
2349: BEGIN
2350: -- MOAC. Added org_id parameter to FUNCTION and to call
2351: l_prepay_count := AP_INVOICES_UTILITY_PKG.get_available_prepays(
2352: l_vendor_id,
2353: l_org_id);
2354:
2355: RETURN(l_prepay_count);

Line 2364: l_encumbered_flag := AP_INVOICES_UTILITY_PKG.get_encumbered_flag(

2360: IS
2361: l_encumbered_flag VARCHAR2(1);
2362:
2363: BEGIN
2364: l_encumbered_flag := AP_INVOICES_UTILITY_PKG.get_encumbered_flag(
2365: l_invoice_id);
2366:
2367: RETURN(l_encumbered_flag);
2368:

Line 2376: l_amount_hold_flag := AP_INVOICES_UTILITY_PKG.get_amount_hold_flag(

2372: RETURN VARCHAR2
2373: IS
2374: l_amount_hold_flag VARCHAR2(1) := 'N';
2375: BEGIN
2376: l_amount_hold_flag := AP_INVOICES_UTILITY_PKG.get_amount_hold_flag(
2377: l_invoice_id);
2378:
2379: RETURN(L_amount_hold_flag);
2380:

Line 2388: l_vendor_hold_flag := AP_INVOICES_UTILITY_PKG.get_vendor_hold_flag(

2384: RETURN VARCHAR2
2385: IS
2386: l_vendor_hold_flag VARCHAR2(1) := 'N';
2387: BEGIN
2388: l_vendor_hold_flag := AP_INVOICES_UTILITY_PKG.get_vendor_hold_flag(
2389: l_invoice_id);
2390:
2391: RETURN(l_vendor_hold_flag);
2392:

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

2400: -- the next open period. The GL date and period name are written to
2401: -- IN OUT NOCOPY parameters, P_GL_Date and P_Period_Name, passed to the
2402: -- procedure. If there is no open period, the PROCEDURE RETURNs
2403: -- null in the IN OUT NOCOPY parameters.
2404: -- Instead of Calling the AP_INVOICES_UTILITY_PKG.get_gl_date_and_period,
2405: -- the code has been SHIFTED into this PROCEDURE as a part of clean-up and
2406: -- PROCEDURE get_gl_date_and_period is REMOVED from AP_INVOICE_UTILITY_PKG.
2407: -- -------------------------------------------------------------------------
2408:

Line 2544: l_invoice_num := AP_INVOICES_UTILITY_PKG.get_similar_drcr_memo(

2540: IS
2541: l_invoice_num ap_invoices.invoice_num%TYPE;
2542:
2543: BEGIN
2544: l_invoice_num := AP_INVOICES_UTILITY_PKG.get_similar_drcr_memo(
2545: P_vendor_id,
2546: P_vendor_site_id,
2547: P_invoice_amount,
2548: P_invoice_type_lookup_code,

Line 2561: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_details_exist (

2557: P_calling_sequence IN VARCHAR2) RETURN BOOLEAN
2558: IS
2559: l_flag boolean;
2560: BEGIN
2561: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_details_exist (
2562: P_vendor_site_id,
2563: P_calling_sequence);
2564:
2565: RETURN(l_flag);

Line 2575: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_curr_details_exist (

2571: P_calling_sequence IN VARCHAR2) RETURN boolean
2572: IS
2573: l_flag boolean;
2574: BEGIN
2575: l_flag := AP_INVOICES_UTILITY_PKG.eft_bank_curr_details_exist (
2576: P_vendor_site_id,
2577: P_currency_code,
2578: P_calling_sequence);
2579:

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

2585: P_invoice_id IN NUMBER) RETURN VARCHAR2
2586: IS
2587: l_flag VARCHAR2(1) := 'N';
2588: BEGIN
2589: l_flag := AP_INVOICES_UTILITY_PKG.selected_for_payment_flag (P_invoice_id);
2590:
2591: RETURN(l_flag);
2592:
2593: END selected_for_payment_flag;

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

2596: RETURN VARCHAR2
2597: IS
2598: l_flag VARCHAR2(1) := 'N';
2599: BEGIN
2600: l_flag := AP_INVOICES_UTILITY_PKG.get_discount_pay_dists_flag (P_invoice_id);
2601:
2602: RETURN(l_flag);
2603:
2604: END get_discount_pay_dists_flag;

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

2609: RETURN VARCHAR2
2610: IS
2611: l_flag VARCHAR2(1) := 'N';
2612: BEGIN
2613: l_flag := AP_INVOICES_UTILITY_PKG.get_unposted_void_payment (P_invoice_id);
2614:
2615: RETURN(l_flag);
2616:
2617: END get_unposted_void_payment;

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

2621: RETURN VARCHAR2
2622: IS
2623: l_flag VARCHAR2(1) := 'N';
2624: BEGIN
2625: l_flag := AP_INVOICES_UTILITY_PKG.get_prepayments_applied_flag (P_invoice_id);
2626: RETURN(l_flag);
2627:
2628: END get_prepayments_applied_flag;
2629:

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

2632: RETURN VARCHAR2
2633: IS
2634: l_flag VARCHAR2(1) := 'N';
2635: BEGIN
2636: l_flag := AP_INVOICES_UTILITY_PKG.get_payments_exist_flag (P_invoice_id);
2637:
2638: RETURN(l_flag);
2639:
2640: END get_payments_exist_flag;

Line 2648: l_prepay_amount := AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied (

2644: IS
2645: l_prepay_amount NUMBER := 0;
2646:
2647: BEGIN
2648: l_prepay_amount := AP_INVOICES_UTILITY_PKG.get_prepay_amount_applied (
2649: P_invoice_id);
2650:
2651: RETURN(l_prepay_amount);
2652:

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

2656: RETURN NUMBER
2657: IS
2658: l_packet_id NUMBER := '';
2659: BEGIN
2660: l_packet_id := AP_INVOICES_UTILITY_PKG.get_packet_id (P_invoice_id);
2661:
2662: RETURN(l_packet_id);
2663:
2664: END get_packet_id;

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

2663:
2664: END get_packet_id;
2665:
2666: --=========================================================================
2667: -- The functions above have been mapped to AP_INVOICES_UTILITY_PKG
2668: -- (apinvuts.pls apinvutb.pls)
2669: --=========================================================================
2670:
2671: --=========================================================================