PACKAGE: APPS.PA_RBS_MAPPING

Source

1 PACKAGE PA_RBS_MAPPING AUTHID CURRENT_USER AS
2 /* $Header: PARBSMPS.pls 120.2.12020000.2 2013/03/07 23:20:41 sachandr ship $ */
3 
4 /* Added for bug 9099240 */
5 g_max_rbs_id1   number;
6 g_max_rbs_id2   number;
7 
8 -- OLAP CHANGE START
9 
10  PROCEDURE map_rbs_actuals_new (
11       p_worker_id      IN NUMBER DEFAULT NULL,
12           p_calling_mode   IN VARCHAR2 ,
13           p_project_id     IN NUMBER ,
14           p_rbs_version_id  IN NUMBER ,
15           p_event_type     IN varchar2 ,
16         x_return_status  OUT NOCOPY VARCHAR2,
17         x_msg_count      OUT NOCOPY NUMBER,
18         x_msg_data       OUT NOCOPY VARCHAR2
19   ) ;
20 
21 -- OLAP CHANGE END
22 
23   PROCEDURE map_rbs_actuals (
24       p_worker_id      IN NUMBER DEFAULT NULL,
25 	x_return_status  OUT NOCOPY VARCHAR2,
26 	x_msg_count      OUT NOCOPY NUMBER,
27 	x_msg_data       OUT NOCOPY VARCHAR2
28   ) ;
29 
30   PROCEDURE map_rbs_plans (
31         p_rbs_version_id IN NUMBER DEFAULT NULL,
32         x_return_status  OUT NOCOPY VARCHAR2,
33         x_msg_count      OUT NOCOPY NUMBER,
34         x_msg_data       OUT NOCOPY VARCHAR2
35   ) ;
36 
37   PROCEDURE create_res_type_numeric_id (
38         p_resource_name      IN VARCHAR2,
39         p_resource_type_id   IN NUMBER,
40         x_resource_id    OUT NOCOPY /* file.sql.39 change */ NUMBER,
41         x_return_status  OUT NOCOPY VARCHAR2,
42         x_msg_data       OUT NOCOPY VARCHAR2
43   ) ;
44 
45 
46   FUNCTION get_res_token (
47         p_res_type_code VARCHAR2,
48 	p_elem_version_id NUMBER
49   ) RETURN VARCHAR2 ;
50 PRAGMA RESTRICT_REFERENCES(get_res_token,WNDS);
51 
52 FUNCTION	get_res_type_numeric_id
53 		(
54 		p_resource_name		IN VARCHAR2,
55 		p_resource_type_id	IN NUMBER
56 		) RETURN NUMBER ;
57 PRAGMA RESTRICT_REFERENCES(get_res_type_numeric_id,WNDS);
58 
59   PROCEDURE create_mapping_rules (
60         p_rbs_version_id   IN  NUMBER,
61 	x_return_status  OUT NOCOPY VARCHAR2,
62 	x_msg_count      OUT NOCOPY NUMBER,
63 	x_msg_data       OUT NOCOPY VARCHAR2
64   ) ;
65 
66 
67 --bug#3940722
68 FUNCTION	get_resource_type_cols
69 		(
70 		p_resource_type_token	VARCHAR2
71 		) RETURN VARCHAR2 ;
72 PRAGMA RESTRICT_REFERENCES(get_resource_type_cols,WNDS);
73 
74 --bug#3940722
75 FUNCTION	get_res_type_id
76 		(
77 		p_resource_type_token	VARCHAR2
78 		) RETURN NUMBER ;
79 PRAGMA RESTRICT_REFERENCES(get_res_type_id,WNDS);
80 
81 END; --end package pa_rbs_mapping