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

Line 365: l_rpt_from_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_from_date));

361: -- Exception
362: acct_period_not_found_exc EXCEPTION;
363:
364: BEGIN
365: l_rpt_from_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_from_date));
366: l_rpt_to_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_to_date));
367:
368: -- Get from account period id
369: OPEN from_acct_period_cur (TO_DATE (p_date_from, 'YYYY/MM/DD HH24:MI:SS'));

Line 366: l_rpt_to_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_to_date));

362: acct_period_not_found_exc EXCEPTION;
363:
364: BEGIN
365: l_rpt_from_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_from_date));
366: l_rpt_to_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_to_date));
367:
368: -- Get from account period id
369: OPEN from_acct_period_cur (TO_DATE (p_date_from, 'YYYY/MM/DD HH24:MI:SS'));
370: FETCH from_acct_period_cur

Line 462: GD_RPT_DATE_FROM := TRUNC(FND_DATE.canonical_to_date(p_date_from));

458: FROM mtl_secondary_inventories MSI
459: WHERE MSI.organization_id = ln_org;
460: BEGIN
461: -- P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
462: GD_RPT_DATE_FROM := TRUNC(FND_DATE.canonical_to_date(p_date_from));
463: GD_RPT_DATE_TO := TRUNC(FND_DATE.canonical_to_date(p_date_to)) + (86399 / 86400);
464:
465: IF GD_RPT_DATE_FROM > GD_RPT_DATE_TO THEN
466: FND_MESSAGE.SET_NAME('FND', 'INVALID DATE RANGE');

Line 463: GD_RPT_DATE_TO := TRUNC(FND_DATE.canonical_to_date(p_date_to)) + (86399 / 86400);

459: WHERE MSI.organization_id = ln_org;
460: BEGIN
461: -- P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
462: GD_RPT_DATE_FROM := TRUNC(FND_DATE.canonical_to_date(p_date_from));
463: GD_RPT_DATE_TO := TRUNC(FND_DATE.canonical_to_date(p_date_to)) + (86399 / 86400);
464:
465: IF GD_RPT_DATE_FROM > GD_RPT_DATE_TO THEN
466: FND_MESSAGE.SET_NAME('FND', 'INVALID DATE RANGE');
467: G_MSG := FND_MESSAGE.GET;

Line 556: SELECT FND_DATE.date_to_chardate (TRUNC (FND_DATE.canonical_to_date (p_date_from)))

552: END;
553:
554: -- Commented by ppandit
555: /* BEGIN
556: SELECT FND_DATE.date_to_chardate (TRUNC (FND_DATE.canonical_to_date (p_date_from)))
557: INTO p_date_from_formatting
558: FROM DUAL;
559: END;
560:

Line 562: SELECT FND_DATE.date_to_chardate (TRUNC (FND_DATE.canonical_to_date (p_date_to)))

558: FROM DUAL;
559: END;
560:
561: BEGIN
562: SELECT FND_DATE.date_to_chardate (TRUNC (FND_DATE.canonical_to_date (p_date_to)))
563: INTO p_date_to_formatting
564: FROM DUAL;
565: END; */
566:

Line 584: FND_DATE.DATE_TO_CHARDT(FCR.REQUEST_DATE),

580: END;
581: /*
582: BEGIN
583: SELECT FRV.RESPONSIBILITY_NAME,
584: FND_DATE.DATE_TO_CHARDT(FCR.REQUEST_DATE),
585: FAV.APPLICATION_NAME,
586: FU.USER_NAME
587: INTO GC_RESPONSIBILITY
588: ,GC_REQUEST_TIME

Line 2028: l_rpt_from_date := TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));

2024: -- Exception
2025: acct_period_not_found_exc EXCEPTION;
2026:
2027: BEGIN
2028: l_rpt_from_date := TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
2029: l_rpt_to_date := TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date));
2030:
2031: -- Get from account period id
2032: OPEN from_acct_period_cur(TO_DATE(p_date_from, 'YYYY/MM/DD HH24:MI:SS'));

Line 2029: l_rpt_to_date := TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date));

2025: acct_period_not_found_exc EXCEPTION;
2026:
2027: BEGIN
2028: l_rpt_from_date := TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
2029: l_rpt_to_date := TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date));
2030:
2031: -- Get from account period id
2032: OPEN from_acct_period_cur(TO_DATE(p_date_from, 'YYYY/MM/DD HH24:MI:SS'));
2033: FETCH from_acct_period_cur

Line 2287: l_per_first_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_first_txn_date));

2283:
2284: BEGIN
2285:
2286: -- The From date is at midnight for the day
2287: l_per_first_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_first_txn_date));
2288: -- The to date is at 23:59:59 of that date entered.
2289: l_per_last_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_last_txn_date)) + (86399 / 86400);
2290:
2291: l_txn_init_qty := p_item_init_qty;

Line 2289: l_per_last_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_last_txn_date)) + (86399 / 86400);

2285:
2286: -- The From date is at midnight for the day
2287: l_per_first_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_first_txn_date));
2288: -- The to date is at 23:59:59 of that date entered.
2289: l_per_last_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_last_txn_date)) + (86399 / 86400);
2290:
2291: l_txn_init_qty := p_item_init_qty;
2292: l_txn_init_infl := p_item_init_infl;
2293:

Line 2656: l_rpt_from_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_from_date));

2652: cost_method_not_found_except EXCEPTION;
2653:
2654: BEGIN
2655: -- The From date is at midnight for the day
2656: l_rpt_from_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_from_date));
2657: -- The to date is at 23:59:59 of that date entered.
2658: l_rpt_to_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_to_date)) + (86399 / 86400);
2659:
2660: ---- Open Corsor for processing

Line 2658: l_rpt_to_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_to_date)) + (86399 / 86400);

2654: BEGIN
2655: -- The From date is at midnight for the day
2656: l_rpt_from_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_from_date));
2657: -- The to date is at 23:59:59 of that date entered.
2658: l_rpt_to_date := TRUNC (FND_DATE.canonical_to_date (p_rpt_to_date)) + (86399 / 86400);
2659:
2660: ---- Open Corsor for processing
2661: --v_CursorID := DBMS_SQL.OPEN_CURSOR;
2662: