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.AHL_AVF_PRIM_VSTS_PVT dependencies on AHL_VWP_TIMES_PVT

Line 1330: l_start_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id,0);

1326: END IF;
1327: -- PRAKKUM :: Bug 13589168 :: 01/16/2012 :: END
1328:
1329: -- Calculate visits start and end date and time based on department shift and UE due date
1330: l_start_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id,0);
1331:
1332: --PRAKKUM :: 09/03/2012 :: Bug 13797431
1333: l_start_date_ts := cast(l_start_date as timestamp);
1334: --l_start_hour := (l_start_date - trunc(l_start_date) )*24;

Line 1339: l_end_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id, l_primary_ue_rec.estimated_duration);

1335: --l_start_min := (l_start_hour - trunc (l_start_hour))*60;
1336: l_start_hour := (extract(HOUR from l_start_date_ts));
1337: l_start_min := (extract(MINUTE from l_start_date_ts));
1338:
1339: l_end_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id, l_primary_ue_rec.estimated_duration);
1340:
1341: --PRAKKUM :: 09/03/2012 :: Bug 13797431
1342: l_end_date_ts := cast(l_end_date as timestamp);
1343: --l_end_hour := (l_end_date - trunc(l_end_date) )*24;

Line 1604: l_start_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id,0);

1600: -- PRAKKUM :: Bug 13589168 :: 01/16/2012 :: END
1601:
1602: -- Calculate visits start and end date and time based on department shift and UE due date
1603:
1604: l_start_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id,0);
1605: --PRAKKUM :: 09/03/2012 :: Bug 13797431
1606: l_start_date_ts := cast(l_start_date as timestamp);
1607: --l_start_hour := (l_start_date - trunc(l_start_date) )*24;
1608: --l_start_min := (l_start_hour - trunc (l_start_hour))*60;

Line 1612: l_end_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id, l_primary_ue_rec.estimated_duration);

1608: --l_start_min := (l_start_hour - trunc (l_start_hour))*60;
1609: l_start_hour := (extract(HOUR from l_start_date_ts));
1610: l_start_min := (extract(MINUTE from l_start_date_ts));
1611:
1612: l_end_date := AHL_VWP_TIMES_PVT.Compute_Date(l_primary_ue_rec.due_date, l_maintenance_dept_id, l_primary_ue_rec.estimated_duration);
1613: --PRAKKUM :: 09/03/2012 :: Bug 13797431
1614: l_end_date_ts := cast(l_end_date as timestamp);
1615: --l_end_hour := (l_end_date - trunc(l_end_date) )*24;
1616: --l_end_min := (l_end_hour - trunc (l_end_hour))*60;