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 307: l_rpt_from_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));

303: -- Exception
304: acct_period_not_found_exc EXCEPTION;
305:
306: BEGIN
307: l_rpt_from_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
308: l_rpt_to_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date));
309:
310: -- Get from account period id
311: OPEN from_acct_period_cur(l_rpt_from_date);

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

304: acct_period_not_found_exc EXCEPTION;
305:
306: BEGIN
307: l_rpt_from_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
308: l_rpt_to_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date));
309:
310: -- Get from account period id
311: OPEN from_acct_period_cur(l_rpt_from_date);
312: FETCH from_acct_period_cur

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

408: -- Exception
409: acct_period_not_found_exc EXCEPTION;
410:
411: BEGIN
412: l_rpt_from_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
413: l_rpt_to_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date));
414:
415: -- Get from account period id
416: OPEN from_acct_period_cur(l_rpt_from_date);

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

409: acct_period_not_found_exc EXCEPTION;
410:
411: BEGIN
412: l_rpt_from_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
413: l_rpt_to_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date));
414:
415: -- Get from account period id
416: OPEN from_acct_period_cur(l_rpt_from_date);
417: FETCH from_acct_period_cur

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

671:
672: BEGIN
673:
674: -- The From date is at midnight for the day
675: l_per_first_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_first_txn_date));
676: -- The to date is at 23:59:59 of that date entered.
677: l_per_last_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_last_txn_date)) + (86399/86400);
678:
679: l_txn_init_qty := p_item_init_qty;

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

673:
674: -- The From date is at midnight for the day
675: l_per_first_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_first_txn_date));
676: -- The to date is at 23:59:59 of that date entered.
677: l_per_last_txn_date:=TRUNC(FND_DATE.canonical_to_date(p_per_last_txn_date)) + (86399/86400);
678:
679: l_txn_init_qty := p_item_init_qty;
680: l_txn_init_infl := p_item_init_infl;
681:

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

1024: cost_method_not_found_except EXCEPTION;
1025:
1026: BEGIN
1027: -- The From date is at midnight for the day
1028: l_rpt_from_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
1029: -- The to date is at 23:59:59 of that date entered.
1030: l_rpt_to_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date)) + (86399/86400);
1031:
1032:

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

1026: BEGIN
1027: -- The From date is at midnight for the day
1028: l_rpt_from_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_from_date));
1029: -- The to date is at 23:59:59 of that date entered.
1030: l_rpt_to_date:=TRUNC(FND_DATE.canonical_to_date(p_rpt_to_date)) + (86399/86400);
1031:
1032:
1033: -- Open Corsor for processing
1034: v_CursorID := DBMS_SQL.OPEN_CURSOR;