1 PACKAGE GMD_FETCH_OPRN AUTHID CURRENT_USER AS
2 /* $Header: GMDPOPNS.pls 115.11 2002/10/24 19:41:49 santunes noship $ */
3
4 -- Start of commments
5 -- API name : get_oprn_act
6 -- Type : Public
7 -- Function :
8 -- Paramaters :
9 -- IN : p_api_version IN NUMBER Required
10 -- p_init_msg_list IN Varchar2 Optional
11 -- p_oprn_id IN Number Required
12 -- x_return_status OUT NOCOPY varchar2(1)
13 -- x_msg_count OUT NOCOPY Number
14 -- x_msg_data OUT NOCOPY varchar2(2000)
15 -- x_return_code OUT NOCOPY Number
16 -- X_oprn_act_tbl OUT NOCOPY oprn_act_out
17 -- Version : Current Version 1.0
18 --
19 -- Notes :
20 -- End of comments
21
22 PROCEDURE get_oprn_act
23 ( p_api_version IN NUMBER ,
24 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
25 p_oprn_id IN NUMBER ,
26 x_return_status OUT NOCOPY VARCHAR2 ,
27 x_msg_count OUT NOCOPY NUMBER ,
28 x_msg_data OUT NOCOPY VARCHAR2 ,
29 x_return_code OUT NOCOPY NUMBER ,
30 x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl
31 );
32
33
34 -- Start of commments
35 -- API name : get_oprn_resc
36 -- Type : Public
37 -- Function :
38 -- Paramaters :
39 -- IN : p_api_version IN NUMBER Required
40 -- p_init_msg_list IN Varchar2 Optional
41 -- p_oprn_id IN Number
42 -- x_return_status OUT NOCOPY varchar2(1)
43 -- x_msg_count OUT NOCOPY Number
44 -- x_msg_data OUT NOCOPY varchar2(2000)
45 -- x_return_code OUT NOCOPY NUMBER
46 -- x_oprn_resc_tbl OUT NOCOPY oprn_resc_out
47 -- x_oprn_resc_proc_param_tbl OUT NOCOPY recp_resc_proc_param_rec
48 -- Version : Current Version 1.0
49 --
50 -- Notes :
51 -- End of comments
52
53 PROCEDURE get_oprn_resc
54 ( p_api_version IN NUMBER ,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
56 p_oprn_id IN NUMBER ,
57 p_orgn_code IN VARCHAR2 ,
58 x_return_status OUT NOCOPY VARCHAR2 ,
59 x_msg_count OUT NOCOPY NUMBER ,
60 x_msg_data OUT NOCOPY VARCHAR2 ,
61 x_return_code OUT NOCOPY NUMBER ,
62 X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,
63 X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
64 );
65
66 -- Start of commments
67 -- API name : fetch_oprn
68 -- Type : Public
69 -- Function :
70 -- Paramaters :
71 -- IN : p_api_version IN NUMBER Required
72 -- p_init_msg_list IN Varchar2 Optional
73 -- p_oprn_id IN Number Required
74 -- x_return_status OUT NOCOPY Varchar2(1)
75 -- x_msg_count OUT NOCOPY Number
76 -- x_msg_data OUT NOCOPY Varchar2(2000)
77 -- x_return_code OUT NOCOPY Number
78 -- X_oprn_act_tbl OUT NOCOPY oprn_act_out
79 -- x_oprn_resc_tbl OUT NOCOPY oprn_resc_out
80 -- x_oprn_resc_proc_param_tbl OUT NOCOPY recp_resc_proc_param_rec
81 -- Version : Current Version 1.0
82 --
83 -- Notes :
84 -- End of comments
85
86
87
88 PROCEDURE fetch_oprn
89 ( p_api_version IN NUMBER ,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
91 p_oprn_id IN NUMBER ,
92 p_orgn_code IN VARCHAR2 ,
93 x_return_status OUT NOCOPY VARCHAR2 ,
94 x_msg_count OUT NOCOPY NUMBER ,
95 x_msg_data OUT NOCOPY VARCHAR2 ,
96 x_return_code OUT NOCOPY NUMBER ,
97 X_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
98 X_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl,
99 X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl);
100
101 -- Start of commments
102 -- API name : get_oprn_process_param_detl
103 -- Type : Public
104 -- Function :
105 -- Paramaters :
106 -- IN : p_api_version IN NUMBER Required
107 -- p_init_msg_list IN Varchar2 Optional
108 -- p_oprn_id IN Number Required
109 -- x_return_status OUT NOCOPY Varchar2(1)
110 -- x_msg_count OUT NOCOPY Number
111 -- x_msg_data OUT NOCOPY Varchar2(2000)
112 -- x_return_code OUT NOCOPY Number
113 -- x_oprn_resc_proc_param_tbl OUT NOCOPY recp_resc_proc_param_rec
114 -- Version : Current Version 1.0
115 --
116 -- Notes :
117 -- End of comments
118
119 PROCEDURE get_oprn_process_param_detl
120 ( p_api_version IN NUMBER ,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
122 p_oprn_line_id IN NUMBER ,
123 p_resources IN VARCHAR2 ,
124 x_return_status OUT NOCOPY VARCHAR2 ,
125 x_msg_count OUT NOCOPY NUMBER ,
126 x_msg_data OUT NOCOPY VARCHAR2 ,
127 X_oprn_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
128 );
129
130
131
132 END GMD_FETCH_OPRN;