DBA Data[Home] [Help]

APPS.IBC_CTYPE_PVT dependencies on FND_API

Line 99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

95: -- Pre-Req :
96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
102: -- P_Attribute_Type_Tbl IN Attribute_Type_Tbl_Type Required
103: --

Line 100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
102: -- P_Attribute_Type_Tbl IN Attribute_Type_Tbl_Type Required
103: --
104: -- OUT:

Line 113: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,

109: -- End of Comments
110: --
111: PROCEDURE Create_Content_Type(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
114: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
115: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
116: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
117: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,

Line 114: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,

110: --
111: PROCEDURE Create_Content_Type(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
114: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
115: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
116: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
117: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
118: X_Return_Status OUT NOCOPY VARCHAR2,

Line 115: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

111: PROCEDURE Create_Content_Type(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
114: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
115: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
116: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
117: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
118: X_Return_Status OUT NOCOPY VARCHAR2,
119: X_Msg_Count OUT NOCOPY NUMBER,

Line 133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

129: -- Pre-Req :
130: -- Parameters:
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
136: -- P_Attribute_Type_Tbl IN Attribute_Type_Tbl_Type Required
137: --

Line 134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

130: -- Parameters:
131: -- IN
132: -- p_api_version_number IN NUMBER Required
133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135: -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
136: -- P_Attribute_Type_Tbl IN Attribute_Type_Tbl_Type Required
137: --
138: -- OUT:

Line 149: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,

145:
146:
147: PROCEDURE Update_Content_Type(
148: P_Api_Version_Number IN NUMBER,
149: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
150: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
151: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
152: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
153: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,

Line 150: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,

146:
147: PROCEDURE Update_Content_Type(
148: P_Api_Version_Number IN NUMBER,
149: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
150: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
151: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
152: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
153: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
154: x_Content_Type_Rec OUT NOCOPY Ibc_Ctype_Pvt.Content_Type_Rec_Type,

Line 151: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

147: PROCEDURE Update_Content_Type(
148: P_Api_Version_Number IN NUMBER,
149: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
150: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
151: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
152: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type := Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
153: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type := Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
154: x_Content_Type_Rec OUT NOCOPY Ibc_Ctype_Pvt.Content_Type_Rec_Type,
155: x_Attribute_Type_Tbl OUT NOCOPY Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type,

Line 170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

166: -- Pre-Req :
167: -- Parameters:
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- P_Content_Type_Code IN VARCHAR2 Required
173: --
174: -- OUT:

Line 171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

167: -- Parameters:
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- P_Content_Type_Code IN VARCHAR2 Required
173: --
174: -- OUT:
175: -- x_return_status OUT NOCOPY VARCHAR2

Line 184: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,

180: --
181:
182: PROCEDURE delete_Content_Type(
183: P_Api_Version_Number IN NUMBER,
184: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
185: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
186: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
187: P_Content_Type_Code IN VARCHAR2,
188: X_Return_Status OUT NOCOPY VARCHAR2,

Line 185: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,

181:
182: PROCEDURE delete_Content_Type(
183: P_Api_Version_Number IN NUMBER,
184: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
185: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
186: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
187: P_Content_Type_Code IN VARCHAR2,
188: X_Return_Status OUT NOCOPY VARCHAR2,
189: X_Msg_Count OUT NOCOPY NUMBER,

Line 186: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

182: PROCEDURE delete_Content_Type(
183: P_Api_Version_Number IN NUMBER,
184: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
185: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
186: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
187: P_Content_Type_Code IN VARCHAR2,
188: X_Return_Status OUT NOCOPY VARCHAR2,
189: X_Msg_Count OUT NOCOPY NUMBER,
190: X_Msg_Data OUT NOCOPY VARCHAR2

Line 204: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

200: -- Pre-Req :
201: -- Parameters:
202: -- IN
203: -- p_api_version_number IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
205: -- P_Content_Type_Rec IN Content_Type_Rec_Type Required
206: -- p_rec_requested IN NUMBER Optional Default = 30
207: -- p_start_rec_ptr IN NUMBER Optional Default = 1
208: --

Line 212: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

208: --
209: -- Return Total Records Count Flag. This flag controls whether the total record count
210: -- and total record amount is returned.
211: --
212: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: --
214: -- OUT:
215: -- X_Content_Type_Tbl OUT NOCOPY Content_Type_Tbl_Type
216: -- x_returned_rec_count OUT NOCOPY NUMBER

Line 228: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

224:
225:
226: -- PROCEDURE Get_Content_type(
227: -- P_Api_Version_Number IN NUMBER,
228: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
229: -- P_Content_Type_Rec IN Content_Type_Rec_Type,
230: -- p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
231: -- p_start_rec_prt IN NUMBER := 1,
232: -- p_return_tot_count IN NUMBER := FND_API.G_FALSE,

Line 232: -- p_return_tot_count IN NUMBER := FND_API.G_FALSE,

228: -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
229: -- P_Content_Type_Rec IN Content_Type_Rec_Type,
230: -- p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
231: -- p_start_rec_prt IN NUMBER := 1,
232: -- p_return_tot_count IN NUMBER := FND_API.G_FALSE,
233: -- X_Content_Type_Tbl OUT NOCOPY Content_Type_Tbl_Type,
234: -- x_returned_rec_count OUT NOCOPY NUMBER,
235: -- x_next_rec_ptr OUT NOCOPY NUMBER,
236: -- x_tot_rec_count OUT NOCOPY NUMBER,

Line 247: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,

243:
244:
245: PROCEDURE Create_Attribute_Type(
246: P_Api_Version_Number IN NUMBER,
247: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
248: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
249: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
250: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
251: X_Return_Status OUT NOCOPY VARCHAR2,

Line 248: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,

244:
245: PROCEDURE Create_Attribute_Type(
246: P_Api_Version_Number IN NUMBER,
247: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
248: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
249: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
250: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
251: X_Return_Status OUT NOCOPY VARCHAR2,
252: X_Msg_Count OUT NOCOPY NUMBER,

Line 249: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

245: PROCEDURE Create_Attribute_Type(
246: P_Api_Version_Number IN NUMBER,
247: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
248: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
249: P_Validation_Level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
250: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
251: X_Return_Status OUT NOCOPY VARCHAR2,
252: X_Msg_Count OUT NOCOPY NUMBER,
253: X_Msg_Data OUT NOCOPY VARCHAR2

Line 258: ,P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE

254: );
255:
256: PROCEDURE get_Attribute_Type_LOV(
257: P_Api_Version_Number IN NUMBER
258: ,P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE
259: ,p_content_type_code IN VARCHAR2 --1
260: ,p_attribute_type_code IN VARCHAR2 --2
261: ,x_code OUT NOCOPY JTF_VARCHAR2_TABLE_100 --4
262: ,x_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 5

Line 271: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false

267: );
268:
269: PROCEDURE get_Content_Type(
270: p_api_version_number IN NUMBER DEFAULT 1.0
271: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false
272: ,p_content_type_code IN VARCHAR2 -- 1
273: ,x_content_type_name OUT NOCOPY VARCHAR2 -- 2
274: ,x_content_type_description OUT NOCOPY VARCHAR2 -- 3
275: ,x_content_type_status OUT NOCOPY VARCHAR2 -- 4

Line 318: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false

314: -- the SQL corresponding to Flex Value set
315: --
316: PROCEDURE get_sql_from_flex(
317: p_api_version_number IN NUMBER DEFAULT 1.0
318: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.g_false
319: ,p_flex_value_set_id IN NUMBER --1
320: ,x_select OUT NOCOPY VARCHAR2 --4
321: ,X_Return_Status OUT NOCOPY VARCHAR2 --6
322: ,X_Msg_Count OUT NOCOPY NUMBER -- 7