1 PACKAGE PO_SERVICES_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVSVCS.pls 115.9 2004/04/07 23:09:48 pthapliy noship $ */
3
4
5 FUNCTION allow_price_override ( p_po_line_id NUMBER ) RETURN BOOLEAN;
6
7 FUNCTION get_ap_compatibility_flag RETURN VARCHAR2; -- <BUG 3248161>
8
9 FUNCTION get_contractor_status ( p_req_line_id IN NUMBER ) RETURN VARCHAR2;
10
11 PROCEDURE get_expense_line ( p_parent_line_id IN NUMBER
12 , x_expense_line_id OUT NOCOPY NUMBER
13 , x_expense_line_num OUT NOCOPY NUMBER
14 );
15
16 FUNCTION get_job_long_description ( p_req_line_id IN NUMBER ) RETURN VARCHAR2;
17
18 FUNCTION get_job_name ( p_job_id IN NUMBER ) RETURN VARCHAR2;
19
20
21 PROCEDURE get_labor_req_line ( p_expense_line_id IN NUMBER
22 , x_parent_line_id OUT NOCOPY NUMBER
23 , x_parent_line_num OUT NOCOPY NUMBER
24 );
25
26 FUNCTION is_expense_line ( p_req_line_id IN NUMBER ) RETURN BOOLEAN;
27
28 FUNCTION is_rate_based_line ( p_po_line_id IN NUMBER ) RETURN BOOLEAN;
29
30 PROCEDURE validate_ship_to_org
31 (
32 x_return_status OUT NOCOPY VARCHAR2,
33 p_job_id IN NUMBER,
34 p_ship_to_org_id IN NUMBER,
35 x_is_valid OUT NOCOPY BOOLEAN
36 );
37
38 PROCEDURE get_po_amounts
39 ( p_po_line_id IN NUMBER
40 , x_amount_received OUT NOCOPY NUMBER
41 , x_amount_billed OUT NOCOPY NUMBER
42 );
43
44 -- Bug# 3465756: Added the following two new functions
45 FUNCTION check_po_has_svc_line_with_req
46 (
47 p_po_header_id IN NUMBER
48 ) RETURN BOOLEAN;
49
50 FUNCTION is_FPS_po_line_with_req
51 (
52 p_po_line_id IN NUMBER
53 ) RETURN BOOLEAN;
54
55
56 FUNCTION is_FPS_po_shipment_with_req
57 (
58 p_po_line_location_id IN NUMBER
59 ) RETURN BOOLEAN;
60 -- Bug# 3465756: End
61
62 END PO_SERVICES_PVT;