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

Line 539: elsif ( FND_DATE.STRING_TO_DATE(l_due_date, 'dd-mon-yyyy hh24:mi:ss') >

535: l_nw_item_list(i+1).priority_level := l_priority_level;
536: l_nw_item_list(i+1).due_date := l_due_date;
537: l_nw_item_list(i+1).workitem_obj_code := l_workitem_obj_code;
538:
539: elsif ( FND_DATE.STRING_TO_DATE(l_due_date, 'dd-mon-yyyy hh24:mi:ss') >
540: FND_DATE.STRING_TO_DATE(l_nw_item_list(i+1).due_date, 'dd-mon-yyyy hh24:mi:ss') ) then
541:
542: ----move second to first
543: l_nw_item_list(i).work_item_id := l_nw_item_list(i+1).work_item_id;

Line 540: FND_DATE.STRING_TO_DATE(l_nw_item_list(i+1).due_date, 'dd-mon-yyyy hh24:mi:ss') ) then

536: l_nw_item_list(i+1).due_date := l_due_date;
537: l_nw_item_list(i+1).workitem_obj_code := l_workitem_obj_code;
538:
539: elsif ( FND_DATE.STRING_TO_DATE(l_due_date, 'dd-mon-yyyy hh24:mi:ss') >
540: FND_DATE.STRING_TO_DATE(l_nw_item_list(i+1).due_date, 'dd-mon-yyyy hh24:mi:ss') ) then
541:
542: ----move second to first
543: l_nw_item_list(i).work_item_id := l_nw_item_list(i+1).work_item_id;
544: l_nw_item_list(i).priority_level := l_nw_item_list(i+1).priority_level;

Line 565: if ( FND_DATE.STRING_TO_DATE(l_due_date_1, 'dd-mon-yyyy hh24:mi:ss') >

561: l_workitem_obj_code_1 := l_nw_item_list(k).workitem_obj_code;
562:
563: if ( l_priority_level_1 = l_nw_item_list(k+1).priority_level) then
564:
565: if ( FND_DATE.STRING_TO_DATE(l_due_date_1, 'dd-mon-yyyy hh24:mi:ss') >
566: FND_DATE.STRING_TO_DATE(l_nw_item_list(k+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then
567:
568: ----move second to first
569: l_nw_item_list(k).work_item_id := l_nw_item_list(k+1).work_item_id;

Line 566: FND_DATE.STRING_TO_DATE(l_nw_item_list(k+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then

562:
563: if ( l_priority_level_1 = l_nw_item_list(k+1).priority_level) then
564:
565: if ( FND_DATE.STRING_TO_DATE(l_due_date_1, 'dd-mon-yyyy hh24:mi:ss') >
566: FND_DATE.STRING_TO_DATE(l_nw_item_list(k+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then
567:
568: ----move second to first
569: l_nw_item_list(k).work_item_id := l_nw_item_list(k+1).work_item_id;
570: l_nw_item_list(k).priority_level := l_nw_item_list(k+1).priority_level;

Line 580: elsif ( FND_DATE.STRING_TO_DATE(l_due_date_1, 'dd-mon-yyyy hh24:mi:ss') <

576: l_nw_item_list(k+1).priority_level := l_priority_level_1;
577: l_nw_item_list(k+1).due_date := l_due_date_1;
578: l_nw_item_list(k+1).workitem_obj_code := l_workitem_obj_code_1;
579:
580: elsif ( FND_DATE.STRING_TO_DATE(l_due_date_1, 'dd-mon-yyyy hh24:mi:ss') <
581: FND_DATE.STRING_TO_DATE(l_nw_item_list(k+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then
582: l_work_item_id_1 := l_nw_item_list(k+1).work_item_id;
583: l_priority_level_1 := l_nw_item_list(k+1).priority_level;
584: l_due_date_1 := l_nw_item_list(k+1).due_date;

Line 581: FND_DATE.STRING_TO_DATE(l_nw_item_list(k+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then

577: l_nw_item_list(k+1).due_date := l_due_date_1;
578: l_nw_item_list(k+1).workitem_obj_code := l_workitem_obj_code_1;
579:
580: elsif ( FND_DATE.STRING_TO_DATE(l_due_date_1, 'dd-mon-yyyy hh24:mi:ss') <
581: FND_DATE.STRING_TO_DATE(l_nw_item_list(k+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then
582: l_work_item_id_1 := l_nw_item_list(k+1).work_item_id;
583: l_priority_level_1 := l_nw_item_list(k+1).priority_level;
584: l_due_date_1 := l_nw_item_list(k+1).due_date;
585: l_workitem_obj_code_1 := l_nw_item_list(k+1).workitem_obj_code;

Line 592: elsif ( FND_DATE.STRING_TO_DATE(l_due_date, 'dd-mon-yyyy hh24:mi:ss') <

588: end if;
589:
590: end loop; -- for k loop
591:
592: elsif ( FND_DATE.STRING_TO_DATE(l_due_date, 'dd-mon-yyyy hh24:mi:ss') <
593: FND_DATE.STRING_TO_DATE(l_nw_item_list(i+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then
594:
595: l_work_item_id := l_nw_item_list(i+1).work_item_id;
596: l_priority_level := l_nw_item_list(i+1).priority_level;

Line 593: FND_DATE.STRING_TO_DATE(l_nw_item_list(i+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then

589:
590: end loop; -- for k loop
591:
592: elsif ( FND_DATE.STRING_TO_DATE(l_due_date, 'dd-mon-yyyy hh24:mi:ss') <
593: FND_DATE.STRING_TO_DATE(l_nw_item_list(i+1).due_date, 'dd-mon-yyyy hh24:mi:ss')) then
594:
595: l_work_item_id := l_nw_item_list(i+1).work_item_id;
596: l_priority_level := l_nw_item_list(i+1).priority_level;
597: l_due_date := l_nw_item_list(i+1).due_date;

Line 708: x_uwqm_workitem_data(l_ctr).due_date := FND_DATE.STRING_TO_DATE(l_nw_item_list(i).due_date, 'dd-mon-yyyy hh24:mi:ss');

704: for i in l_nw_item_list.first..l_nw_item_list.last loop
705: if nvl(l_nw_item_list(i).work_item_id,0) > 0 then
706: x_uwqm_workitem_data(l_ctr).work_item_id := l_nw_item_list(i).work_item_id;
707: x_uwqm_workitem_data(l_ctr).priority_level := l_nw_item_list(i).priority_level;
708: x_uwqm_workitem_data(l_ctr).due_date := FND_DATE.STRING_TO_DATE(l_nw_item_list(i).due_date, 'dd-mon-yyyy hh24:mi:ss');
709: x_uwqm_workitem_data(l_ctr).workitem_obj_code := l_nw_item_list(i).workitem_obj_code;
710: l_ctr := l_ctr + 1;
711: end if;
712: end loop;