[Home] [Help]
266: END UPDATE_BIS_BUCKET_WRAPPER;
267:
268: PROCEDURE UPDATE_CUST_BUCKET (
269: p_commit IN VARCHAR2 := FND_API.G_FALSE
270: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
271: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
267:
268: PROCEDURE UPDATE_CUST_BUCKET (
269: p_commit IN VARCHAR2 := FND_API.G_FALSE
270: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
271: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
268: PROCEDURE UPDATE_CUST_BUCKET (
269: p_commit IN VARCHAR2 := FND_API.G_FALSE
270: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
271: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
269: p_commit IN VARCHAR2 := FND_API.G_FALSE
270: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
271: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
270: , p_id IN BIS_BUCKET_CUSTOMIZATIONS.id%TYPE
271: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
271: , p_bucket_id IN BIS_BUCKET_CUSTOMIZATIONS.bucket_id%TYPE
272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
272: , p_user_id IN BIS_BUCKET_CUSTOMIZATIONS.user_id%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
273: , p_responsibility_id IN BIS_BUCKET_CUSTOMIZATIONS.responsibility_id%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
274: , p_application_id IN BIS_BUCKET_CUSTOMIZATIONS.application_id%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
275: , p_org_id IN BIS_BUCKET_CUSTOMIZATIONS.org_id%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
276: , p_site_id IN BIS_BUCKET_CUSTOMIZATIONS.site_id%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
277: , p_page_id IN BIS_BUCKET_CUSTOMIZATIONS.page_id%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
278: , p_function_id IN BIS_BUCKET_CUSTOMIZATIONS.function_id%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
279: , p_range1_low IN BIS_BUCKET_CUSTOMIZATIONS.range1_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
280: , p_range1_high IN BIS_BUCKET_CUSTOMIZATIONS.range1_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
281: , p_range2_low IN BIS_BUCKET_CUSTOMIZATIONS.range2_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
282: , p_range2_high IN BIS_BUCKET_CUSTOMIZATIONS.range2_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
283: , p_range3_low IN BIS_BUCKET_CUSTOMIZATIONS.range3_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
284: , p_range3_high IN BIS_BUCKET_CUSTOMIZATIONS.range3_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
285: , p_range4_low IN BIS_BUCKET_CUSTOMIZATIONS.range4_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
286: , p_range4_high IN BIS_BUCKET_CUSTOMIZATIONS.range4_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
287: , p_range5_low IN BIS_BUCKET_CUSTOMIZATIONS.range5_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
288: , p_range5_high IN BIS_BUCKET_CUSTOMIZATIONS.range5_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
289: , p_range6_low IN BIS_BUCKET_CUSTOMIZATIONS.range6_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
290: , p_range6_high IN BIS_BUCKET_CUSTOMIZATIONS.range6_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
291: , p_range7_low IN BIS_BUCKET_CUSTOMIZATIONS.range7_low%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
292: , p_range7_high IN BIS_BUCKET_CUSTOMIZATIONS.range7_high%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
293: , p_range8_low IN BIS_BUCKET_CUSTOMIZATIONS.range8_low%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
294: , p_range8_high IN BIS_BUCKET_CUSTOMIZATIONS.range8_high%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
310: , p_deleted_ranges IN VARCHAR2
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
310: , p_deleted_ranges IN VARCHAR2
311: , p_new_ranges IN VARCHAR2
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
310: , p_deleted_ranges IN VARCHAR2
311: , p_new_ranges IN VARCHAR2
312: , x_return_status OUT NOCOPY VARCHAR2
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
310: , p_deleted_ranges IN VARCHAR2
311: , p_new_ranges IN VARCHAR2
312: , x_return_status OUT NOCOPY VARCHAR2
313: , x_msg_count OUT NOCOPY NUMBER
320:
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: FND_MSG_PUB.initialize;
323:
324: UPDATE bis_bucket_customizations SET
325: bucket_id = p_bucket_id,
326: user_id = p_user_id,
327: responsibility_id = p_responsibility_id,
328: application_id = p_application_id,
355: last_updated_by = FND_GLOBAL.USER_ID,
356: last_update_login = FND_GLOBAL.LOGIN_ID
357: WHERE id = p_id;
358:
359: UPDATE bis_bucket_customizations_tl SET
360: range1_name = p_range1_name,
361: range2_name = p_range2_name,
362: range3_name = p_range3_name,
363: range4_name = p_range4_name,
444:
445: CURSOR c_bucket(p_lang_code VARCHAR2) IS
446: SELECT range1_name, range2_name, range3_name, range4_name,
447: range5_name, range6_name, range7_name, range8_name, range9_name, range10_name
448: FROM bis_bucket_customizations_tl
449: WHERE id = p_id
450: AND language = source_lang
451: AND source_lang = p_lang_code;
452: l_bucket_rec c_bucket%ROWTYPE;
561: OPEN c_bucket(userenv('LANG'));
562: FETCH c_bucket INTO l_bucket_rec;
563:
564: IF (c_bucket%FOUND) THEN
565: UPDATE bis_bucket_customizations_tl
566: SET range1_name = NVL(l_range_labels(1), l_bucket_rec.range1_name),
567: range2_name = NVL(l_range_labels(2), l_bucket_rec.range2_name),
568: range3_name = NVL(l_range_labels(3), l_bucket_rec.range3_name),
569: range4_name = NVL(l_range_labels(4), l_bucket_rec.range4_name),
639: END IF;
640: OPEN c_base_bucket;
641: FETCH c_base_bucket INTO l_base_bucket_rec;
642: IF(c_base_bucket%FOUND) THEN
643: UPDATE bis_bucket_customizations SET
644: user_id = NULL,
645: responsibility_id = NULL,
646: application_id = NULL,
647: org_id = NULL,
685: OPEN c_base_bucket_tl(l_lang_rec.language_code);
686: FETCH c_base_bucket_tl INTO l_base_bucket_tl_rec;
687: IF(c_base_bucket_tl%FOUND) THEN
688:
689: UPDATE bis_bucket_customizations_tl SET
690: range1_name = l_base_bucket_tl_rec.range1_name,
691: range2_name = l_base_bucket_tl_rec.range2_name,
692: range3_name = l_base_bucket_tl_rec.range3_name,
693: range4_name = l_base_bucket_tl_rec.range4_name,
699: range10_name = l_base_bucket_tl_rec.range10_name,
700: last_update_date = SYSDATE,
701: last_updated_by = FND_GLOBAL.USER_ID,
702: last_update_login = FND_GLOBAL.LOGIN_ID
703: WHERE id IN (SELECT id FROM bis_bucket_customizations WHERE bucket_id = p_bucket_id)
704: AND language = l_lang_rec.language_code;
705:
706: END IF;
707:
1066: WHERE B.BUCKET_ID = l_bucket_id
1067: AND B.LANGUAGE = L.LANGUAGE_CODE
1068: );
1069:
1070: SELECT bis_bucket_customizations_s.nextval
1071: INTO l_id
1072: FROM DUAL;
1073:
1074: INSERT INTO bis_bucket_customizations
1070: SELECT bis_bucket_customizations_s.nextval
1071: INTO l_id
1072: FROM DUAL;
1073:
1074: INSERT INTO bis_bucket_customizations
1075: (ID,
1076: BUCKET_ID,
1077: RANGE1_LOW,
1078: RANGE1_HIGH,
1129: SYSDATE,
1130: l_login_id,
1131: 'F');
1132:
1133: INSERT INTO bis_bucket_customizations_tl
1134: (ID,
1135: RANGE1_NAME,
1136: RANGE2_NAME,
1137: RANGE3_NAME,
1173: from FND_LANGUAGES L
1174: where L.INSTALLED_FLAG in ('I', 'B')
1175: and not exists
1176: (select NULL
1177: from BIS_BUCKET_CUSTOMIZATIONS_TL T
1178: where T.ID = l_id
1179: and T.LANGUAGE = L.LANGUAGE_CODE);
1180:
1181: COMMIT;
1361: WHERE BUCKET_ID = l_bucket_Id
1362: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1363:
1364: SELECT ID, CUSTOMIZED INTO l_id, l_custom
1365: FROM bis_bucket_customizations
1366: WHERE bucket_id = l_bucket_Id AND rownum < 2;
1367:
1368: IF (l_custom = 'F') THEN --update cust tables
1369:
1366: WHERE bucket_id = l_bucket_Id AND rownum < 2;
1367:
1368: IF (l_custom = 'F') THEN --update cust tables
1369:
1370: update BIS_BUCKET_CUSTOMIZATIONS set
1371: RANGE1_LOW = l_bis_bucket_rec.range1_low
1372: ,RANGE1_HIGH = l_bis_bucket_rec.range1_high
1373: ,RANGE2_LOW = l_bis_bucket_rec.range2_low
1374: ,RANGE2_HIGH = l_bis_bucket_rec.range2_high
1392: ,LAST_UPDATED_BY = l_user_id
1393: ,LAST_UPDATE_LOGIN = l_login_id
1394: where BUCKET_ID = l_bucket_Id;
1395:
1396: update BIS_BUCKET_CUSTOMIZATIONS_TL set
1397: RANGE1_NAME = l_bis_bucket_rec.range1_name
1398: ,RANGE2_NAME = l_bis_bucket_rec.range2_name
1399: ,RANGE3_NAME = l_bis_bucket_rec.range3_name
1400: ,RANGE4_NAME = l_bis_bucket_rec.range4_name
1451:
1452:
1453: --This API should delete a row from the tables BIS_BUCKET and BIS_BUCKET_TL
1454: --using the short name or the bucket id as the where clause value
1455: --It should also delete the rows from BIS_BUCKET_CUSTOMIZATIONS and
1456: --BIS_BUCKET_CUSTOMIZATIONS_TL tables.
1457: PROCEDURE DELETE_BIS_BUCKET (
1458: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1452:
1453: --This API should delete a row from the tables BIS_BUCKET and BIS_BUCKET_TL
1454: --using the short name or the bucket id as the where clause value
1455: --It should also delete the rows from BIS_BUCKET_CUSTOMIZATIONS and
1456: --BIS_BUCKET_CUSTOMIZATIONS_TL tables.
1457: PROCEDURE DELETE_BIS_BUCKET (
1458: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1460: ,x_return_status OUT NOCOPY VARCHAR2
1477: IF (l_ret_name = FND_API.G_FALSE) THEN
1478: SELECT bucket_id INTO l_bucket_id FROM BIS_BUCKET
1479: WHERE SHORT_NAME = p_short_name;
1480:
1481: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL
1482: WHERE id in (
1483: SELECT id
1484: FROM BIS_BUCKET_CUSTOMIZATIONS
1485: WHERE bucket_id = l_bucket_id);
1480:
1481: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL
1482: WHERE id in (
1483: SELECT id
1484: FROM BIS_BUCKET_CUSTOMIZATIONS
1485: WHERE bucket_id = l_bucket_id);
1486:
1487: DELETE from BIS_BUCKET_CUSTOMIZATIONS
1488: WHERE bucket_id = l_bucket_id;
1483: SELECT id
1484: FROM BIS_BUCKET_CUSTOMIZATIONS
1485: WHERE bucket_id = l_bucket_id);
1486:
1487: DELETE from BIS_BUCKET_CUSTOMIZATIONS
1488: WHERE bucket_id = l_bucket_id;
1489:
1490: DELETE from BIS_BUCKET_TL
1491: WHERE bucket_id = l_bucket_id;
1508: ,x_error_table => x_error_tbl
1509: );
1510: RAISE FND_API.G_EXC_ERROR;
1511: ELSE
1512: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL
1513: WHERE id in (
1514: SELECT id
1515: FROM BIS_BUCKET_CUSTOMIZATIONS
1516: WHERE bucket_id = p_bucket_id);
1511: ELSE
1512: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL
1513: WHERE id in (
1514: SELECT id
1515: FROM BIS_BUCKET_CUSTOMIZATIONS
1516: WHERE bucket_id = p_bucket_id);
1517:
1518: DELETE from BIS_BUCKET_CUSTOMIZATIONS
1519: WHERE bucket_id = p_bucket_id;
1514: SELECT id
1515: FROM BIS_BUCKET_CUSTOMIZATIONS
1516: WHERE bucket_id = p_bucket_id);
1517:
1518: DELETE from BIS_BUCKET_CUSTOMIZATIONS
1519: WHERE bucket_id = p_bucket_id;
1520:
1521: DELETE from BIS_BUCKET_TL
1522: WHERE bucket_id = p_bucket_id;
1633: B.EXPANDABLE,
1634: B.DISCONTINUOUS,
1635: B.OVERLAPPING,
1636: B.UOM
1637: FROM BIS_BUCKET_CUSTOMIZATIONS_VL BC,BIS_BUCKET_VL B
1638: WHERE B.SHORT_NAME = p_short_name
1639: AND B.BUCKET_ID=BC.BUCKET_ID;
1640:
1641:
1796: ,SOURCE_LANG = userenv('LANG')
1797: WHERE BUCKET_ID = l_bis_bucket_rec.bucket_id
1798: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1799:
1800: UPDATE BIS_BUCKET_CUSTOMIZATIONS_TL
1801: SET
1802: RANGE1_NAME = l_bis_bucket_rec.range1_name
1803: ,RANGE2_NAME = l_bis_bucket_rec.range2_name
1804: ,RANGE3_NAME = l_bis_bucket_rec.range3_name
1814: ,LAST_UPDATE_LOGIN = l_login_id
1815: ,SOURCE_LANG = userenv('LANG')
1816: WHERE id in (
1817: SELECT id
1818: FROM BIS_BUCKET_CUSTOMIZATIONS
1819: WHERE bucket_id = l_bis_bucket_rec.bucket_id)
1820: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1821:
1822: COMMIT;