Line 271: c_end_of_time CONSTANT DATE := fnd_date.canonical_to_date('4712/12/31 00:00:00');
267: p_category IN VARCHAR2,
268: p_bg_id IN NUMBER,
269: p_ele_eff_start_date IN DATE) RETURN NUMBER IS
270: 271: c_end_of_time CONSTANT DATE := fnd_date.canonical_to_date('4712/12/31 00:00:00'); 272:
273: TYPE text_table IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
274: TYPE num_table IS TABLE OF NUMBER(9) INDEX BY BINARY_INTEGER;
275: