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.AP_APXWTGNR_XMLP_PKG dependencies on FND_DATE

Line 290: P_DATE_FILTER := ' and d.accounting_date = to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'')';

286: ,'After Get_Base_Curr_Data')*/NULL;
287: END IF;
288: IF (P_DATE_FROM IS NOT NULL AND P_DATE_TO IS NOT NULL) THEN
289: IF P_DATE_FROM = P_DATE_TO THEN
290: P_DATE_FILTER := ' and d.accounting_date = to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
291: ELSE
292: P_DATE_FILTER := ' and d.accounting_date between to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_TO) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
293: END IF;
294: ELSIF (P_DATE_FROM IS NOT NULL AND P_DATE_TO IS NULL) THEN

Line 292: P_DATE_FILTER := ' and d.accounting_date between to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_TO) || ''', ''YYYY/MM/DD HH24:MI:SS'')';

288: IF (P_DATE_FROM IS NOT NULL AND P_DATE_TO IS NOT NULL) THEN
289: IF P_DATE_FROM = P_DATE_TO THEN
290: P_DATE_FILTER := ' and d.accounting_date = to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
291: ELSE
292: P_DATE_FILTER := ' and d.accounting_date between to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_TO) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
293: END IF;
294: ELSIF (P_DATE_FROM IS NOT NULL AND P_DATE_TO IS NULL) THEN
295: P_DATE_FILTER := ' and d.accounting_date >= to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
296: ELSIF (P_DATE_FROM IS NULL AND P_DATE_TO IS NOT NULL) THEN

Line 295: P_DATE_FILTER := ' and d.accounting_date >= to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'')';

291: ELSE
292: P_DATE_FILTER := ' and d.accounting_date between to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'') and to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_TO) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
293: END IF;
294: ELSIF (P_DATE_FROM IS NOT NULL AND P_DATE_TO IS NULL) THEN
295: P_DATE_FILTER := ' and d.accounting_date >= to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
296: ELSIF (P_DATE_FROM IS NULL AND P_DATE_TO IS NOT NULL) THEN
297: P_DATE_FILTER := ' and d.accounting_date <= to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_TO) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
298: ELSE
299: P_DATE_FILTER := ' and 1 = 1 ';

Line 297: P_DATE_FILTER := ' and d.accounting_date <= to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_TO) || ''', ''YYYY/MM/DD HH24:MI:SS'')';

293: END IF;
294: ELSIF (P_DATE_FROM IS NOT NULL AND P_DATE_TO IS NULL) THEN
295: P_DATE_FILTER := ' and d.accounting_date >= to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_FROM) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
296: ELSIF (P_DATE_FROM IS NULL AND P_DATE_TO IS NOT NULL) THEN
297: P_DATE_FILTER := ' and d.accounting_date <= to_date(''' || FND_DATE.DATE_TO_CANONICAL(P_DATE_TO) || ''', ''YYYY/MM/DD HH24:MI:SS'')';
298: ELSE
299: P_DATE_FILTER := ' and 1 = 1 ';
300: END IF;
301: IF (P_TAX_NAME IS NOT NULL AND P_TAX_NAME <> '%') THEN