1: PACKAGE JTF_DIAGNOSTIC_COREAPI AUTHID CURRENT_USER AS
2: /* $Header: jtfdiagcoreapi_s.pls 120.4 2011/05/03 10:46:54 kbnair ship $ */
3:
4: l_newline varchar2(1) := fnd_global.newline;
5: l_tab varchar2(1) := fnd_global.tab;
6: l_return varchar2(1) := fnd_global.local_chr(13);
7:
8: /* Default starting point for date searches - Date 30 years ago */
1: PACKAGE JTF_DIAGNOSTIC_COREAPI AUTHID CURRENT_USER AS
2: /* $Header: jtfdiagcoreapi_s.pls 120.4 2011/05/03 10:46:54 kbnair ship $ */
3:
4: l_newline varchar2(1) := fnd_global.newline;
5: l_tab varchar2(1) := fnd_global.tab;
6: l_return varchar2(1) := fnd_global.local_chr(13);
7:
8: /* Default starting point for date searches - Date 30 years ago */
9: olddate DATE := SYSDATE-(365*30);
2: /* $Header: jtfdiagcoreapi_s.pls 120.4 2011/05/03 10:46:54 kbnair ship $ */
3:
4: l_newline varchar2(1) := fnd_global.newline;
5: l_tab varchar2(1) := fnd_global.tab;
6: l_return varchar2(1) := fnd_global.local_chr(13);
7:
8: /* Default starting point for date searches - Date 30 years ago */
9: olddate DATE := SYSDATE-(365*30);
10: