eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_REPORT_UTIL dependencies on ICX_SEC

Line 11: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));

7: BEGIN
8: p_param(p_index).Label :=
9: FND_MESSAGE.get_string('PO', 'POA_ORDER_DATES');
10: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
11: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
12: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
13: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
14: icx_sec.g_date_format));
15: END Build_OrderDates;

Line 14: icx_sec.g_date_format));

10: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
11: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
12: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
13: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
14: icx_sec.g_date_format));
15: END Build_OrderDates;
16:
17: PROCEDURE Build_ReportingDates(
18: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 24: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));

20: BEGIN
21: p_param(p_index).Label :=
22: FND_MESSAGE.get_string('PO', 'POA_REPORTING_DATES');
23: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
24: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
25: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
26: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
27: icx_sec.g_date_format));
28: END Build_ReportingDates;

Line 27: icx_sec.g_date_format));

23: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
24: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
25: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
26: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),
27: icx_sec.g_date_format));
28: END Build_ReportingDates;
29:
30: PROCEDURE Build_SupplierItem(
31: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,

Line 509: SELECT to_char(add_months(sysdate, -12)+1, icx_sec.g_date_format)

505: FUNCTION Validate_OrderDates(p_fdate IN OUT NOCOPY VARCHAR2,
506: p_tdate IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
507: BEGIN
508: IF (p_fdate IS NULL) THEN
509: SELECT to_char(add_months(sysdate, -12)+1, icx_sec.g_date_format)
510: INTO p_fdate
511: FROM SYS.DUAL;
512: END IF;
513:

Line 515: SELECT to_char(sysdate, icx_sec.g_date_format)

511: FROM SYS.DUAL;
512: END IF;
513:
514: IF (p_tdate IS NULL) THEN
515: SELECT to_char(sysdate, icx_sec.g_date_format)
516: INTO p_tdate
517: FROM SYS.DUAL;
518: END IF;
519:

Line 521: SELECT to_char(to_date(p_fdate, icx_sec.g_date_format), 'DD-MON-YYYY')

517: FROM SYS.DUAL;
518: END IF;
519:
520: -- Convert date to DD-MON-YYYY format as thats the format reports expect
521: SELECT to_char(to_date(p_fdate, icx_sec.g_date_format), 'DD-MON-YYYY')
522: INTO p_fdate
523: FROM SYS.DUAL;
524:
525: SELECT to_char(to_date(p_tdate, icx_sec.g_date_format), 'DD-MON-YYYY')

Line 525: SELECT to_char(to_date(p_tdate, icx_sec.g_date_format), 'DD-MON-YYYY')

521: SELECT to_char(to_date(p_fdate, icx_sec.g_date_format), 'DD-MON-YYYY')
522: INTO p_fdate
523: FROM SYS.DUAL;
524:
525: SELECT to_char(to_date(p_tdate, icx_sec.g_date_format), 'DD-MON-YYYY')
526: INTO p_tdate
527: FROM SYS.DUAL;
528:
529: RETURN TRUE;