PACKAGE: APPS.PO_PROJECT_DETAILS_SV

Source

1 PACKAGE PO_PROJECT_DETAILS_SV AS
2 /* $Header: POXPROJS.pls 120.1 2005/11/09 12:43:44 vinokris noship $ */
3 
4 --< Bug 3265539 Start > Changed signature
5 PROCEDURE get_project_task_num
6 (
7     x_return_status OUT NOCOPY NUMBER,
8     p_project_id    IN NUMBER,
9     p_task_id       IN NUMBER,
10     x_project_num   OUT NOCOPY VARCHAR2,
11     x_task_num      OUT NOCOPY VARCHAR2
12 );
13 --< Bug 3265539 End >
14 
15 procedure get_project_details(
16 		p_receipt_source_code in varchar2,
17 		p_po_distribution_id  in number,
18 		p_req_distribution_id in number,
19 	    p_oe_order_line_id    in number,
20 		p_project_id in out NOCOPY number,
21 		p_task_id    in out NOCOPY number,
22 		p_project_num in out NOCOPY varchar2,
23 		p_task_num   in out NOCOPY varchar2
24 );
25 
26 --< Bug 3265539 Start >
27 PROCEDURE all_proj_idtonum_wpr
28 (
29     x_return_status  OUT NOCOPY VARCHAR2,
30     p_project_id     IN NUMBER,
31     x_project_number OUT NOCOPY VARCHAR2
32 );
33 
34 PROCEDURE validate_proj_references_wpr
35 (
36     p_inventory_org_id  IN NUMBER,
37     p_operating_unit    IN NUMBER,
38     p_project_id        IN NUMBER,
39     p_task_id           IN NUMBER,
40     p_date1             IN DATE,
41     p_date2             IN DATE,
42     p_calling_function  IN VARCHAR2,
43     x_error_code        OUT NOCOPY VARCHAR2,
44     x_return_code       OUT NOCOPY VARCHAR2
45 );
46 
47 FUNCTION pjm_validate_success RETURN VARCHAR2;
48 
49 FUNCTION pjm_validate_warning RETURN VARCHAR2;
50 
51 FUNCTION pjm_validate_failure RETURN VARCHAR2;
52 --< Bug 3265539 End >
53 
54 --< Bug 4338241 Start >
55 --Adding these 2 functions for Unit Number
56 FUNCTION pjm_unit_eff_enabled RETURN VARCHAR2;
57 
58 FUNCTION pjm_unit_eff_item
59 (
60     p_item_id IN NUMBER,
61     p_org_id  IN NUMBER
62 ) RETURN VARCHAR2;
63 --< Bug 4338241 END >
64 
65 END PO_PROJECT_DETAILS_SV ;