39: l_description_detail_id NUMBER(38);
40:
41: BEGIN
42:
43: xla_utility_pkg.trace('> xla_descript_details_pkg.delete_desc_prio_details' , 10);
44:
45: xla_utility_pkg.trace('description_prio_id = '||p_description_prio_id , 20);
46:
47: OPEN c_desc_prio_details;
41: BEGIN
42:
43: xla_utility_pkg.trace('> xla_descript_details_pkg.delete_desc_prio_details' , 10);
44:
45: xla_utility_pkg.trace('description_prio_id = '||p_description_prio_id , 20);
46:
47: OPEN c_desc_prio_details;
48: LOOP
49: FETCH c_desc_prio_details
55:
56: END LOOP;
57: CLOSE c_desc_prio_details;
58:
59: xla_utility_pkg.trace('< xla_descript_details_pkg.delete_desc_prio_details' , 10);
60:
61: EXCEPTION
62: WHEN xla_exceptions_pkg.application_exception THEN
63: IF c_desc_prio_details%ISOPEN THEN
111: l_source_id_flex_num NUMBER(15);
112:
113: BEGIN
114:
115: xla_utility_pkg.trace('> xla_descript_details_pkg.display_desc_prio_details' , 10);
116:
117: xla_utility_pkg.trace('description_prio_id = '||p_description_prio_id , 20);
118: xla_utility_pkg.trace('description_prio_id = '||p_chart_of_accounts_id , 20);
119:
113: BEGIN
114:
115: xla_utility_pkg.trace('> xla_descript_details_pkg.display_desc_prio_details' , 10);
116:
117: xla_utility_pkg.trace('description_prio_id = '||p_description_prio_id , 20);
118: xla_utility_pkg.trace('description_prio_id = '||p_chart_of_accounts_id , 20);
119:
120: OPEN c_desc_prio_details;
121: LOOP
114:
115: xla_utility_pkg.trace('> xla_descript_details_pkg.display_desc_prio_details' , 10);
116:
117: xla_utility_pkg.trace('description_prio_id = '||p_description_prio_id , 20);
118: xla_utility_pkg.trace('description_prio_id = '||p_chart_of_accounts_id , 20);
119:
120: OPEN c_desc_prio_details;
121: LOOP
122: FETCH c_desc_prio_details
184:
185: END LOOP;
186: CLOSE c_desc_prio_details;
187:
188: xla_utility_pkg.trace('< xla_descript_details_pkg.display_desc_prio_details' , 10);
189:
190: RETURN l_desc_detail_dsp;
191:
192: EXCEPTION