DBA Data[Home] [Help]

APPS.GMI_MO_PURGE dependencies on FND_DATE

Line 18: l_date_from DATE:= trunc(fnd_date.canonical_to_date(p_date_from));

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:

Line 19: l_date_to DATE:= trunc(fnd_date.canonical_to_date(p_date_to));

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: