PACKAGE: APPS.MRP_GET_PROJECT

Source

1 PACKAGE MRP_GET_PROJECT AS
2 	/* $Header: MRPGPRJS.pls 120.0 2005/05/24 17:36:20 appldev noship $ */
3 
4 	FUNCTION project(arg_project_id IN NUMBER) return varchar2;
5 
6 	FUNCTION task(arg_task_id IN NUMBER) return varchar2;
7 
8 	FUNCTION planning_group(arg_project_id IN NUMBER) return varchar2;
9 
10         FUNCTION lookup_fnd(arg_lookup_type IN varchar2,
11                             arg_lookup_code IN varchar2) return fnd_lookups.meaning%type;
12 
13         FUNCTION lookup_meaning(arg_lookup_type IN varchar2,
14                         arg_lookup_code IN NUMBER) return varchar2;
15 
16         FUNCTION org_code(arg_org_id IN NUMBER) return varchar2;
17 
18         FUNCTION item_name(arg_org_id IN NUMBER,
19                        arg_item_id IN NUMBER) return varchar2;
20 
21         FUNCTION item_desc(arg_org_id IN NUMBER,
22                        arg_item_id IN NUMBER) return varchar2;
23 
24         FUNCTION category_desc(arg_cat_set_id IN NUMBER,
25                        arg_cat_id IN NUMBER) return varchar2;
26 
27         FUNCTION category_name(arg_cat_id IN NUMBER) return varchar2;
28 
29         FUNCTION customer_name(arg_cust_id IN NUMBER) return varchar2;
30 
31         FUNCTION ship_to_address(arg_site_id IN NUMBER) return varchar2;
32 
33         FUNCTION vendor_site_code(arg_org_id IN NUMBER,
34                                   arg_vendor_site_id IN NUMBER) return varchar2;
35 
36 	PRAGMA RESTRICT_REFERENCES (project, WNDS,WNPS);
37   	PRAGMA RESTRICT_REFERENCES (task, WNDS,WNPS);
38   	PRAGMA RESTRICT_REFERENCES (planning_group, WNDS,WNPS);
39 end MRP_GET_PROJECT;