[Home] [Help]
PACKAGE: APPS.IBE_PROD_RELATION_GRP
Source
1 PACKAGE IBE_Prod_Relation_GRP AUTHID CURRENT_USER AS
2 /* $Header: IBEGCRLS.pls 120.0 2005/05/30 02:28:21 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Prod_Relation_GRP';
5
6 -- Start of comments
7 -- API name : Get_Related_Items
8 -- Type : Public or Group or Private.
9 -- Function :
10 -- Pre-reqs : None.
11 -- Parameters :
12 -- IN : p_api_version IN NUMBER Required
13 -- p_init_msg_list IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_item_id IN NUMBER
16 -- p_rel_type_code IN VARCHAR2
17 -- p_max_ret_num IN NUMBER
18 -- Default = NULL (Return all)
19 -- p_order_by_col IN VARCHAR2
20 -- Default = NULL (No order)
21 -- p_order_by_order IN VARCHAR2
22 -- Default = G_ASCEND_ORDER (Ascending order)
23 -- p_include_self_ref IN VARCHAR2
24 -- Default = FND_API.G_FALSE (Don't include self-referrals)
25 -- p_bind_varN IN VARCHAR2
26 -- Default = NULL (Bind variables for relationship rule defined by manual SQL)
27 -- OUT : x_return_status OUT VARCHAR2(1)
28 -- x_msg_count OUT NUMBER
29 -- x_msg_data OUT VARCHAR2(2000)
30 -- x_items_tbl OUT JTF_Number_Table
31 -- Version : Current version 1.0
32 --
33 -- previous version None
34 --
35 -- Initial version 1.0
36 --
37 -- Notes : Note text
38 --
39 -- End of comments
40 PROCEDURE Get_Related_Items
41 (
42 p_api_version IN NUMBER ,
43 p_init_msg_list IN VARCHAR2 := NULL ,
44 x_return_status OUT NOCOPY VARCHAR2 ,
45 x_msg_count OUT NOCOPY NUMBER ,
46 x_msg_data OUT NOCOPY VARCHAR2 ,
47 p_item_id IN NUMBER ,
48 p_rel_type_code IN VARCHAR2 ,
49 p_org_id IN NUMBER ,
50 p_max_ret_num IN NUMBER := NULL ,
51 p_order_by_clause IN VARCHAR2 := NULL ,
52 p_include_self_ref IN VARCHAR2 := NULL ,
53 p_rule_type IN VARCHAR2 := NULL ,
54 p_bind_arg1 IN VARCHAR2 := NULL ,
55 p_bind_arg2 IN VARCHAR2 := NULL ,
56 p_bind_arg3 IN VARCHAR2 := NULL ,
57 p_bind_arg4 IN VARCHAR2 := NULL ,
58 p_bind_arg5 IN VARCHAR2 := NULL ,
59 p_bind_arg6 IN VARCHAR2 := NULL ,
60 p_bind_arg7 IN VARCHAR2 := NULL ,
61 p_bind_arg8 IN VARCHAR2 := NULL ,
62 p_bind_arg9 IN VARCHAR2 := NULL ,
63 p_bind_arg10 IN VARCHAR2 := NULL ,
64 x_items_tbl OUT NOCOPY JTF_Number_Table
65 );
66
67 -- Start of comments
68 -- API name : Get_Related_Items
69 -- Type : Public or Group or Private.
70 -- Function : If p_preview_flag = 'T' returns items whose
71 -- web_status is 'PUBLISHED' or 'UNPUBLISHED'.
72 -- Otherwise, only returns items whose web_status
73 -- is 'PUBLISHED'.
74 -- Pre-reqs : None.
75 -- Parameters :
76 -- IN : p_api_version IN NUMBER Required
77 -- p_init_msg_list IN VARCHAR2 Optional
78 -- Default = FND_API.G_FALSE
79 -- p_msite_id IN NUMBER
80 -- p_preview_flag IN VARCHAR2
81 -- p_item_id IN NUMBER
82 -- p_rel_type_code IN VARCHAR2
83 -- p_max_ret_num IN NUMBER
84 -- Default = NULL (Return all)
85 -- p_order_by_col IN VARCHAR2
86 -- Default = NULL (No order)
87 -- p_order_by_order IN VARCHAR2
88 -- Default = G_ASCEND_ORDER (Ascending order)
89 -- p_include_self_ref IN VARCHAR2
90 -- Default = FND_API.G_FALSE (Don't include self-referrals)
91 -- p_bind_varN IN VARCHAR2
92 -- Default = NULL (Bind variables for relationship rule defined by manual SQL)
93 -- OUT : x_return_status OUT VARCHAR2(1)
94 -- x_msg_count OUT NUMBER
95 -- x_msg_data OUT VARCHAR2(2000)
96 -- x_items_tbl OUT JTF_Number_Table
97 -- Version : Current version 1.0
98 --
99 -- previous version None
100 --
101 -- Initial version 1.0
102 --
103 -- Notes : Note text
104 --
105 -- End of comments
106 PROCEDURE Get_Related_Items
107 (
108 p_api_version IN NUMBER ,
109 p_init_msg_list IN VARCHAR2 := NULL ,
110 x_return_status OUT NOCOPY VARCHAR2 ,
111 x_msg_count OUT NOCOPY NUMBER ,
112 x_msg_data OUT NOCOPY VARCHAR2 ,
113 p_msite_id IN NUMBER ,
114 p_preview_flag IN VARCHAR2 := NULL ,
115 p_item_id IN NUMBER ,
116 p_rel_type_code IN VARCHAR2 ,
117 p_org_id IN NUMBER ,
118 p_max_ret_num IN NUMBER := NULL ,
119 p_order_by_clause IN VARCHAR2 := NULL ,
120 p_include_self_ref IN VARCHAR2 := NULL ,
121 p_rule_type IN VARCHAR2 := NULL ,
122 p_bind_arg1 IN VARCHAR2 := NULL ,
123 p_bind_arg2 IN VARCHAR2 := NULL ,
124 p_bind_arg3 IN VARCHAR2 := NULL ,
125 p_bind_arg4 IN VARCHAR2 := NULL ,
126 p_bind_arg5 IN VARCHAR2 := NULL ,
127 p_bind_arg6 IN VARCHAR2 := NULL ,
128 p_bind_arg7 IN VARCHAR2 := NULL ,
129 p_bind_arg8 IN VARCHAR2 := NULL ,
130 p_bind_arg9 IN VARCHAR2 := NULL ,
131 p_bind_arg10 IN VARCHAR2 := NULL ,
132 x_items_tbl OUT NOCOPY JTF_Number_Table
133 );
134
135
136 -- Start of comments
137 -- API name : Get_Related_Items
138 -- Type : Public or Group or Private.
139 -- Function : If p_preview_flag = 'T' returns items whose
140 -- web_status is 'PUBLISHED' or 'UNPUBLISHED'.
141 -- Otherwise, only returns items whose web_status
142 -- is 'PUBLISHED'.
143 -- Pre-reqs : None.
144 -- Parameters :
145 -- IN : p_api_version IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional
147 -- Default = FND_API.G_FALSE
148 -- p_msite_id IN NUMBER
149 -- p_preview_flag IN VARCHAR2
150 -- p_item_id IN NUMBER
151 -- p_rel_type_code IN VARCHAR2
152 -- p_max_ret_num IN NUMBER
153 -- Default = NULL (Return all)
154 -- p_order_by_col IN VARCHAR2
155 -- Default = NULL (No order)
156 -- p_order_by_order IN VARCHAR2
157 -- Default = G_ASCEND_ORDER (Ascending order)
158 -- p_include_self_ref IN VARCHAR2
159 -- Default = FND_API.G_FALSE (Don't include self-referrals)
160 -- p_bind_varN IN VARCHAR2
161 -- Default = NULL (Bind variables for relationship rule defined by manual SQL)
162 -- OUT : x_return_status OUT VARCHAR2(1)
163 -- x_msg_count OUT NUMBER
164 -- x_msg_data OUT VARCHAR2(2000)
165 -- x_items_tbl OUT JTF_Number_Table
166 -- Version : Current version 1.0
167 --
168 -- previous version None
169 --
170 -- Initial version 1.0
171 --
172 -- Notes : Note text
173 --
174 -- End of comments
175 PROCEDURE Get_Related_Items
176 (
177 p_api_version IN NUMBER ,
178 p_init_msg_list IN VARCHAR2 := NULL ,
179 x_return_status OUT NOCOPY VARCHAR2 ,
180 x_msg_count OUT NOCOPY NUMBER ,
181 x_msg_data OUT NOCOPY VARCHAR2 ,
182 p_msite_id IN NUMBER ,
183 p_preview_flag IN VARCHAR2 := NULL ,
184 p_item_ids IN JTF_Number_Table ,
185 p_rel_type_code IN VARCHAR2 ,
186 p_org_id IN NUMBER ,
187 p_max_ret_num IN NUMBER := NULL ,
188 p_order_by_clause IN VARCHAR2 := NULL ,
189 p_include_self_ref IN VARCHAR2 := NULL ,
190 p_rule_type IN VARCHAR2 := NULL ,
191 p_bind_arg1 IN VARCHAR2 := NULL ,
192 p_bind_arg2 IN VARCHAR2 := NULL ,
193 p_bind_arg3 IN VARCHAR2 := NULL ,
194 p_bind_arg4 IN VARCHAR2 := NULL ,
195 p_bind_arg5 IN VARCHAR2 := NULL ,
196 p_bind_arg6 IN VARCHAR2 := NULL ,
197 p_bind_arg7 IN VARCHAR2 := NULL ,
198 p_bind_arg8 IN VARCHAR2 := NULL ,
199 p_bind_arg9 IN VARCHAR2 := NULL ,
200 p_bind_arg10 IN VARCHAR2 := NULL ,
201 x_items_tbl OUT NOCOPY JTF_Number_Table
202 );
203
204
205 END IBE_Prod_Relation_GRP;