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

Line 547: l_start_date_low := FND_DATE.CANONICAL_TO_DATE( p_start_date_low );

543: log_msg(FND_FILE.LOG, 'Returning Out Successfully !' );
544: RETURN;
545: ELSE
546: log_msg(FND_FILE.LOG, 'MOAC Org Context : ' || mo_global.get_current_org_id );
547: l_start_date_low := FND_DATE.CANONICAL_TO_DATE( p_start_date_low );
548: l_start_date_high := FND_DATE.CANONICAL_TO_DATE( p_start_date_high );
549: l_end_date_low := FND_DATE.CANONICAL_TO_DATE( p_end_date_low );
550: l_end_date_high := FND_DATE.CANONICAL_TO_DATE( p_end_date_high );
551:

Line 548: l_start_date_high := FND_DATE.CANONICAL_TO_DATE( p_start_date_high );

544: RETURN;
545: ELSE
546: log_msg(FND_FILE.LOG, 'MOAC Org Context : ' || mo_global.get_current_org_id );
547: l_start_date_low := FND_DATE.CANONICAL_TO_DATE( p_start_date_low );
548: l_start_date_high := FND_DATE.CANONICAL_TO_DATE( p_start_date_high );
549: l_end_date_low := FND_DATE.CANONICAL_TO_DATE( p_end_date_low );
550: l_end_date_high := FND_DATE.CANONICAL_TO_DATE( p_end_date_high );
551:
552: FOR t_rec IN get_params_def_csr

Line 549: l_end_date_low := FND_DATE.CANONICAL_TO_DATE( p_end_date_low );

545: ELSE
546: log_msg(FND_FILE.LOG, 'MOAC Org Context : ' || mo_global.get_current_org_id );
547: l_start_date_low := FND_DATE.CANONICAL_TO_DATE( p_start_date_low );
548: l_start_date_high := FND_DATE.CANONICAL_TO_DATE( p_start_date_high );
549: l_end_date_low := FND_DATE.CANONICAL_TO_DATE( p_end_date_low );
550: l_end_date_high := FND_DATE.CANONICAL_TO_DATE( p_end_date_high );
551:
552: FOR t_rec IN get_params_def_csr
553: LOOP

Line 550: l_end_date_high := FND_DATE.CANONICAL_TO_DATE( p_end_date_high );

546: log_msg(FND_FILE.LOG, 'MOAC Org Context : ' || mo_global.get_current_org_id );
547: l_start_date_low := FND_DATE.CANONICAL_TO_DATE( p_start_date_low );
548: l_start_date_high := FND_DATE.CANONICAL_TO_DATE( p_start_date_high );
549: l_end_date_low := FND_DATE.CANONICAL_TO_DATE( p_end_date_low );
550: l_end_date_high := FND_DATE.CANONICAL_TO_DATE( p_end_date_high );
551:
552: FOR t_rec IN get_params_def_csr
553: LOOP
554: -- Formatting output specific to the Reamort Upgrade Run

Line 562: log_n_print_msg( ' Date : ' || FND_DATE.DATE_TO_CANONICAL(SYSDATE));

558: log_n_print_msg( ' ------------------------------------------------------------ ' );
559: log_n_print_msg( ' ' );
560: log_n_print_msg( ' ' );
561: log_n_print_msg( ' Request ID : ' || Fnd_Global.CONC_REQUEST_ID );
562: log_n_print_msg( ' Date : ' || FND_DATE.DATE_TO_CANONICAL(SYSDATE));
563: log_n_print_msg( ' ' );
564: log_n_print_msg( ' ' );
565: log_n_print_msg( ' ' );
566: END IF;

Line 698: || ' AND chr.start_date >= FND_DATE.CANONICAL_TO_DATE(''' ||p_start_date_low || ''') ';

694: END IF;
695: log_msg(FND_FILE.LOG,'Handling the Date Criteria: Start ');
696: IF p_start_date_low IS NOT NULL THEN
697: l_query_string := l_query_string
698: || ' AND chr.start_date >= FND_DATE.CANONICAL_TO_DATE(''' ||p_start_date_low || ''') ';
699: END IF;
700: IF p_start_date_high IS NOT NULL THEN
701: l_query_string := l_query_string
702: || ' AND chr.start_date <= FND_DATE.CANONICAL_TO_DATE(''' ||p_start_date_high || ''') ';

Line 702: || ' AND chr.start_date <= FND_DATE.CANONICAL_TO_DATE(''' ||p_start_date_high || ''') ';

698: || ' AND chr.start_date >= FND_DATE.CANONICAL_TO_DATE(''' ||p_start_date_low || ''') ';
699: END IF;
700: IF p_start_date_high IS NOT NULL THEN
701: l_query_string := l_query_string
702: || ' AND chr.start_date <= FND_DATE.CANONICAL_TO_DATE(''' ||p_start_date_high || ''') ';
703: END IF;
704: IF p_end_date_low IS NOT NULL THEN
705: l_query_string := l_query_string
706: || ' AND chr.end_date >= FND_DATE.CANONICAL_TO_DATE(''' ||p_end_date_low || ''') ';

Line 706: || ' AND chr.end_date >= FND_DATE.CANONICAL_TO_DATE(''' ||p_end_date_low || ''') ';

702: || ' AND chr.start_date <= FND_DATE.CANONICAL_TO_DATE(''' ||p_start_date_high || ''') ';
703: END IF;
704: IF p_end_date_low IS NOT NULL THEN
705: l_query_string := l_query_string
706: || ' AND chr.end_date >= FND_DATE.CANONICAL_TO_DATE(''' ||p_end_date_low || ''') ';
707: END IF;
708: IF p_end_date_high IS NOT NULL THEN
709: l_query_string := l_query_string
710: || ' AND chr.end_date <= FND_DATE.CANONICAL_TO_DATE(''' ||p_end_date_high || ''') ';

Line 710: || ' AND chr.end_date <= FND_DATE.CANONICAL_TO_DATE(''' ||p_end_date_high || ''') ';

706: || ' AND chr.end_date >= FND_DATE.CANONICAL_TO_DATE(''' ||p_end_date_low || ''') ';
707: END IF;
708: IF p_end_date_high IS NOT NULL THEN
709: l_query_string := l_query_string
710: || ' AND chr.end_date <= FND_DATE.CANONICAL_TO_DATE(''' ||p_end_date_high || ''') ';
711: END IF;
712: log_msg(FND_FILE.LOG,'Handling the Date Criteria: End ');
713: IF p_pdt_id IS NOT NULL
714: THEN