14: l_line_id NUMBER;
15: l_header_id NUMBER;
16: v_sql_stmt VARCHAR2(300);
17: v_object_name VARCHAR2(200);
18: l_date_from DATE:= trunc(fnd_date.canonical_to_date(p_date_from));
19: l_date_to DATE:= trunc(fnd_date.canonical_to_date(p_date_to));
20: table_already_exists EXCEPTION;
21: PRAGMA EXCEPTION_INIT (table_already_exists,-955);
22:
15: l_header_id NUMBER;
16: v_sql_stmt VARCHAR2(300);
17: v_object_name VARCHAR2(200);
18: l_date_from DATE:= trunc(fnd_date.canonical_to_date(p_date_from));
19: l_date_to DATE:= trunc(fnd_date.canonical_to_date(p_date_to));
20: table_already_exists EXCEPTION;
21: PRAGMA EXCEPTION_INIT (table_already_exists,-955);
22:
23: