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

Line 100: between nvl( fnd_date.canonical_to_date(d_date_from), wdj.scheduled_start_date - 1)

96: ,pt.start_date
97: ,pt.completion_date
98: ) <> 0
99: and wdj.scheduled_start_date
100: between nvl( fnd_date.canonical_to_date(d_date_from), wdj.scheduled_start_date - 1)
101: and nvl( fnd_date.canonical_to_date(d_date_to) , wdj.scheduled_start_date + 1)
102: ) or (
103: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(wdj.scheduled_completion_date
104: ,'BETWEEN'

Line 101: and nvl( fnd_date.canonical_to_date(d_date_to) , wdj.scheduled_start_date + 1)

97: ,pt.completion_date
98: ) <> 0
99: and wdj.scheduled_start_date
100: between nvl( fnd_date.canonical_to_date(d_date_from), wdj.scheduled_start_date - 1)
101: and nvl( fnd_date.canonical_to_date(d_date_to) , wdj.scheduled_start_date + 1)
102: ) or (
103: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(wdj.scheduled_completion_date
104: ,'BETWEEN'
105: ,n_tolerance_days

Line 112: between nvl( fnd_date.canonical_to_date(d_date_from), wdj.scheduled_completion_date - 1)

108: ,pt.start_date
109: ,pt.completion_date
110: ) <>0
111: and wdj.scheduled_completion_date
112: between nvl( fnd_date.canonical_to_date(d_date_from), wdj.scheduled_completion_date - 1)
113: and nvl( fnd_date.canonical_to_date(d_date_to) , wdj.scheduled_completion_date + 1)
114: ))
115: and pt.task_id (+) = wdj.task_id
116: and hou.organization_id = wdj.organization_id

Line 113: and nvl( fnd_date.canonical_to_date(d_date_to) , wdj.scheduled_completion_date + 1)

109: ,pt.completion_date
110: ) <>0
111: and wdj.scheduled_completion_date
112: between nvl( fnd_date.canonical_to_date(d_date_from), wdj.scheduled_completion_date - 1)
113: and nvl( fnd_date.canonical_to_date(d_date_to) , wdj.scheduled_completion_date + 1)
114: ))
115: and pt.task_id (+) = wdj.task_id
116: and hou.organization_id = wdj.organization_id
117: and hou.language = userenv('LANG')

Line 193: between nvl( fnd_date.canonical_to_date(d_date_from), ool.request_date - 1)

189: ,pt.start_date
190: ,pt.completion_date
191: ) <>0
192: and ool.request_date
193: between nvl( fnd_date.canonical_to_date(d_date_from), ool.request_date - 1)
194: and nvl( fnd_date.canonical_to_date(d_date_to) , ool.request_date + 1)
195: ) or (
196: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ool.promise_date
197: ,'BETWEEN'

Line 194: and nvl( fnd_date.canonical_to_date(d_date_to) , ool.request_date + 1)

190: ,pt.completion_date
191: ) <>0
192: and ool.request_date
193: between nvl( fnd_date.canonical_to_date(d_date_from), ool.request_date - 1)
194: and nvl( fnd_date.canonical_to_date(d_date_to) , ool.request_date + 1)
195: ) or (
196: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ool.promise_date
197: ,'BETWEEN'
198: ,n_tolerance_days

Line 205: between nvl( fnd_date.canonical_to_date(d_date_from), ool.promise_date - 1)

201: ,pt.start_date
202: ,pt.completion_date
203: ) <>0
204: and ool.promise_date
205: between nvl( fnd_date.canonical_to_date(d_date_from), ool.promise_date - 1)
206: and nvl( fnd_date.canonical_to_date(d_date_to) , ool.promise_date + 1)
207: ))
208: and pt.task_id (+) = ool.task_id
209: order by 2

Line 206: and nvl( fnd_date.canonical_to_date(d_date_to) , ool.promise_date + 1)

202: ,pt.completion_date
203: ) <>0
204: and ool.promise_date
205: between nvl( fnd_date.canonical_to_date(d_date_from), ool.promise_date - 1)
206: and nvl( fnd_date.canonical_to_date(d_date_to) , ool.promise_date + 1)
207: ))
208: and pt.task_id (+) = ool.task_id
209: order by 2
210: ;

Line 275: between nvl( fnd_date.canonical_to_date(d_date_from), mfd.forecast_date - 1)

271: ,pt.start_date
272: ,pt.completion_date
273: ) <>0
274: and mfd.forecast_date
275: between nvl( fnd_date.canonical_to_date(d_date_from), mfd.forecast_date - 1)
276: and nvl( fnd_date.canonical_to_date(d_date_to) , mfd.forecast_date + 1)
277: ) or (
278: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(mfd.rate_end_date
279: ,'BETWEEN'

Line 276: and nvl( fnd_date.canonical_to_date(d_date_to) , mfd.forecast_date + 1)

272: ,pt.completion_date
273: ) <>0
274: and mfd.forecast_date
275: between nvl( fnd_date.canonical_to_date(d_date_from), mfd.forecast_date - 1)
276: and nvl( fnd_date.canonical_to_date(d_date_to) , mfd.forecast_date + 1)
277: ) or (
278: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(mfd.rate_end_date
279: ,'BETWEEN'
280: ,n_tolerance_days

Line 287: between nvl( fnd_date.canonical_to_date(d_date_from), mfd.rate_end_date - 1)

283: ,pt.start_date
284: ,pt.completion_date
285: ) <>0
286: and mfd.rate_end_date
287: between nvl( fnd_date.canonical_to_date(d_date_from), mfd.rate_end_date - 1)
288: and nvl( fnd_date.canonical_to_date(d_date_to) , mfd.rate_end_date + 1)
289: ))
290: and pt.task_id (+) = mfd.task_id
291: and hou.organization_id = mfd.organization_id

Line 288: and nvl( fnd_date.canonical_to_date(d_date_to) , mfd.rate_end_date + 1)

284: ,pt.completion_date
285: ) <>0
286: and mfd.rate_end_date
287: between nvl( fnd_date.canonical_to_date(d_date_from), mfd.rate_end_date - 1)
288: and nvl( fnd_date.canonical_to_date(d_date_to) , mfd.rate_end_date + 1)
289: ))
290: and pt.task_id (+) = mfd.task_id
291: and hou.organization_id = mfd.organization_id
292: and hou.language = userenv('LANG')

Line 356: between nvl( fnd_date.canonical_to_date(d_date_from), prl.need_by_date - 1)

352: ,pt.start_date
353: ,pt.completion_date
354: ) <>0
355: and prl.need_by_date
356: between nvl( fnd_date.canonical_to_date(d_date_from), prl.need_by_date - 1)
357: and nvl( fnd_date.canonical_to_date(d_date_to) , prl.need_by_date + 1)
358: and pt.task_id (+) = prd.task_id
359: and hou.organization_id (+) = prl.destination_organization_id
360: and hou.language (+) = userenv('LANG')

Line 357: and nvl( fnd_date.canonical_to_date(d_date_to) , prl.need_by_date + 1)

353: ,pt.completion_date
354: ) <>0
355: and prl.need_by_date
356: between nvl( fnd_date.canonical_to_date(d_date_from), prl.need_by_date - 1)
357: and nvl( fnd_date.canonical_to_date(d_date_to) , prl.need_by_date + 1)
358: and pt.task_id (+) = prd.task_id
359: and hou.organization_id (+) = prl.destination_organization_id
360: and hou.language (+) = userenv('LANG')
361: and fsp.org_id = prh.org_id

Line 425: between nvl( fnd_date.canonical_to_date(d_date_from), ph.reply_date - 1)

421: ,pt.start_date
422: ,pt.completion_date
423: ) <>0
424: and ph.reply_date
425: between nvl( fnd_date.canonical_to_date(d_date_from), ph.reply_date - 1)
426: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.reply_date + 1)
427: and pt.task_id (+) = pl.task_id
428: and pl.org_id = ph.org_id
429: and fsp.org_id = pl.org_id

Line 426: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.reply_date + 1)

422: ,pt.completion_date
423: ) <>0
424: and ph.reply_date
425: between nvl( fnd_date.canonical_to_date(d_date_from), ph.reply_date - 1)
426: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.reply_date + 1)
427: and pt.task_id (+) = pl.task_id
428: and pl.org_id = ph.org_id
429: and fsp.org_id = pl.org_id
430: order by ph.segment1

Line 503: between nvl( fnd_date.canonical_to_date(d_date_from), ph.start_date - 1)

499: ,pt.start_date
500: ,pt.completion_date
501: ) <>0
502: and ph.start_date
503: between nvl( fnd_date.canonical_to_date(d_date_from), ph.start_date - 1)
504: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.start_date + 1)
505: ) or (
506: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.end_date
507: ,'AFTER_END'

Line 504: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.start_date + 1)

500: ,pt.completion_date
501: ) <>0
502: and ph.start_date
503: between nvl( fnd_date.canonical_to_date(d_date_from), ph.start_date - 1)
504: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.start_date + 1)
505: ) or (
506: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(ph.end_date
507: ,'AFTER_END'
508: ,n_tolerance_days

Line 515: between nvl( fnd_date.canonical_to_date(d_date_from), ph.end_date - 1)

511: ,pt.start_date
512: ,pt.completion_date
513: ) <>0
514: and ph.end_date
515: between nvl( fnd_date.canonical_to_date(d_date_from), ph.end_date - 1)
516: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.end_date + 1)
517: ))
518: and pt.task_id (+) = pl.task_id
519: and pl.org_id = ph.org_id

Line 516: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.end_date + 1)

512: ,pt.completion_date
513: ) <>0
514: and ph.end_date
515: between nvl( fnd_date.canonical_to_date(d_date_from), ph.end_date - 1)
516: and nvl( fnd_date.canonical_to_date(d_date_to) , ph.end_date + 1)
517: ))
518: and pt.task_id (+) = pl.task_id
519: and pl.org_id = ph.org_id
520: and fsp.org_id = pl.org_id

Line 593: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)

589: ,pt.start_date
590: ,pt.completion_date
591: ) <>0
592: and msd.schedule_date
593: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)
594: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)
595: ) or (
596: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
597: ,'BETWEEN'

Line 594: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)

590: ,pt.completion_date
591: ) <>0
592: and msd.schedule_date
593: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)
594: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)
595: ) or (
596: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
597: ,'BETWEEN'
598: ,n_tolerance_days

Line 605: between nvl( fnd_date.canonical_to_date(d_date_from), msd.rate_end_date - 1)

601: ,pt.start_date
602: ,pt.completion_date
603: ) <>0
604: and msd.rate_end_date
605: between nvl( fnd_date.canonical_to_date(d_date_from), msd.rate_end_date - 1)
606: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.rate_end_date + 1)
607: ))
608: and pt.task_id (+) = msd.task_id
609: order by msd.schedule_designator

Line 606: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.rate_end_date + 1)

602: ,pt.completion_date
603: ) <>0
604: and msd.rate_end_date
605: between nvl( fnd_date.canonical_to_date(d_date_from), msd.rate_end_date - 1)
606: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.rate_end_date + 1)
607: ))
608: and pt.task_id (+) = msd.task_id
609: order by msd.schedule_designator
610: ;

Line 680: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)

676: ,pt.start_date
677: ,pt.completion_date
678: ) <>0
679: and msd.schedule_date
680: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)
681: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)
682: ) or (
683: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
684: ,'BETWEEN'

Line 681: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)

677: ,pt.completion_date
678: ) <>0
679: and msd.schedule_date
680: between nvl( fnd_date.canonical_to_date(d_date_from), msd.schedule_date - 1)
681: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.schedule_date + 1)
682: ) or (
683: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(msd.rate_end_date
684: ,'BETWEEN'
685: ,n_tolerance_days

Line 692: between nvl( fnd_date.canonical_to_date(d_date_from), msd.rate_end_date - 1)

688: ,pt.start_date
689: ,pt.completion_date
690: ) <>0
691: and msd.rate_end_date
692: between nvl( fnd_date.canonical_to_date(d_date_from), msd.rate_end_date - 1)
693: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.rate_end_date + 1)
694: ))
695: and pt.task_id (+) = msd.task_id
696: order by msd.schedule_designator

Line 693: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.rate_end_date + 1)

689: ,pt.completion_date
690: ) <>0
691: and msd.rate_end_date
692: between nvl( fnd_date.canonical_to_date(d_date_from), msd.rate_end_date - 1)
693: and nvl( fnd_date.canonical_to_date(d_date_to) , msd.rate_end_date + 1)
694: ))
695: and pt.task_id (+) = msd.task_id
696: order by msd.schedule_designator
697: ;

Line 772: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)

768: ,pt.start_date
769: ,pt.completion_date
770: ) <>0
771: and pll.promised_date
772: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)
773: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)
774: ) or (
775: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
776: ,'BETWEEN'

Line 773: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)

769: ,pt.completion_date
770: ) <>0
771: and pll.promised_date
772: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)
773: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)
774: ) or (
775: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
776: ,'BETWEEN'
777: ,n_tolerance_days

Line 784: between nvl( fnd_date.canonical_to_date(d_date_from), pll.need_by_date - 1)

780: ,pt.start_date
781: ,pt.completion_date
782: ) <>0
783: and pll.need_by_date
784: between nvl( fnd_date.canonical_to_date(d_date_from), pll.need_by_date - 1)
785: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.need_by_date + 1)
786: ))
787: and pt.task_id (+) = pd.task_id
788: and hou.organization_id (+) = pd.destination_organization_id

Line 785: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.need_by_date + 1)

781: ,pt.completion_date
782: ) <>0
783: and pll.need_by_date
784: between nvl( fnd_date.canonical_to_date(d_date_from), pll.need_by_date - 1)
785: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.need_by_date + 1)
786: ))
787: and pt.task_id (+) = pd.task_id
788: and hou.organization_id (+) = pd.destination_organization_id
789: and hou.language (+) = userenv('LANG')

Line 875: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)

871: ,pt.start_date
872: ,pt.completion_date
873: ) <>0
874: and pll.promised_date
875: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)
876: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)
877: ) or (
878: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
879: ,'BETWEEN'

Line 876: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)

872: ,pt.completion_date
873: ) <>0
874: and pll.promised_date
875: between nvl( fnd_date.canonical_to_date(d_date_from), pll.promised_date - 1)
876: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.promised_date + 1)
877: ) or (
878: PJM_INTEGRATION_PROJ_MFG.PJM_EXCEPTION_DAYS(pll.need_by_date
879: ,'BETWEEN'
880: ,n_tolerance_days

Line 887: between nvl( fnd_date.canonical_to_date(d_date_from), pll.need_by_date - 1)

883: ,pt.start_date
884: ,pt.completion_date
885: ) <>0
886: and pll.need_by_date
887: between nvl( fnd_date.canonical_to_date(d_date_from), pll.need_by_date - 1)
888: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.need_by_date + 1)
889: ))
890: and pt.task_id (+) = pd.task_id
891: and hou.organization_id (+) = pd.destination_organization_id

Line 888: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.need_by_date + 1)

884: ,pt.completion_date
885: ) <>0
886: and pll.need_by_date
887: between nvl( fnd_date.canonical_to_date(d_date_from), pll.need_by_date - 1)
888: and nvl( fnd_date.canonical_to_date(d_date_to) , pll.need_by_date + 1)
889: ))
890: and pt.task_id (+) = pd.task_id
891: and hou.organization_id (+) = pd.destination_organization_id
892: and hou.language (+) = userenv('LANG')

Line 905: fnd_date.date_to_displaydt(sysdate) );

901:
902: procedure timestamp ( mesg varchar2 ) is
903: begin
904: PJM_CONC.put_line( rpad( mesg || ' ' , 50 , '.' ) || ' ' ||
905: fnd_date.date_to_displaydt(sysdate) );
906: end timestamp;
907:
908: BEGIN
909: