1 PACKAGE PO_PA_INTEGRATION_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGPAVS.pls 120.2 2008/04/28 08:35:13 adbharga ship $ */
3
4 PROCEDURE validate_temp_labor_po(p_api_version IN NUMBER,
5 p_project_id IN NUMBER,
6 p_task_id IN NUMBER,
7 p_po_number IN VARCHAR2,--bug 7003781
8 p_po_line_num IN NUMBER,
9 p_price_type IN VARCHAR2,
10 p_org_id IN NUMBER,
11 p_person_id IN NUMBER,
12 p_po_header_id IN OUT NOCOPY NUMBER,
13 p_po_line_id IN OUT NOCOPY NUMBER,
14 x_po_line_amt OUT NOCOPY NUMBER,
15 x_po_rate OUT NOCOPY NUMBER,
16 x_currency_code OUT NOCOPY VARCHAR2,
17 x_curr_rate_type OUT NOCOPY VARCHAR2,
18 x_curr_rate_date OUT NOCOPY DATE,
19 x_currency_rate OUT NOCOPY NUMBER,
20 x_vendor_id OUT NOCOPY NUMBER,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_message_code OUT NOCOPY VARCHAR2,
23 p_effective_date IN DATE DEFAULT NULL
24 );
25
26 FUNCTION is_rate_based_line (p_po_line_id IN NUMBER,
27 p_po_distribution_id IN NUMBER)
28 RETURN BOOLEAN;
29
30 PROCEDURE get_line_rate_info (p_api_version IN NUMBER,
31 p_price_type IN VARCHAR2,
32 p_po_line_id IN NUMBER,
33 p_project_id IN NUMBER,
34 p_task_id IN NUMBER,
35 x_po_rate OUT NOCOPY NUMBER,
36 x_currency_code OUT NOCOPY VARCHAR2,
37 x_curr_rate_type OUT NOCOPY VARCHAR2,
38 x_curr_rate_date OUT NOCOPY DATE,
39 x_currency_rate OUT NOCOPY NUMBER,
40 x_vendor_id OUT NOCOPY NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_message_code OUT NOCOPY VARCHAR2
43 );
44
45 FUNCTION is_PO_active
46 (p_person_id IN NUMBER
47 ,p_effective_date IN DATE
48 ,p_po_header_id IN NUMBER
49 ,p_po_line_id IN NUMBER
50 )
51 RETURN BOOLEAN;
52
53 END PO_PA_INTEGRATION_GRP;