APPS.WIP_WS_PTPKPI_UTIL dependencies on WIP_WS_UTIL

Line 174: shift definition as defined in the wip_ws_util package.

170: /*
171: Description:
172: Given the organization, department, resource, and a timestamp,
173: find out which shift the timestamp belongs to. It uses the existing
174: shift definition as defined in the wip_ws_util package.
175: Parameters:
176: p_org_id - the organization id
177: p_dept_id - the department id
178: p_resource_id - the resource id

Line 202: wip_ws_util.retrieve_first_shift(

198: x_shift_start_date date;
199: x_shift_end_date date;
200: x_shift_string varchar2(100);
201: begin
202: wip_ws_util.retrieve_first_shift(
203: p_org_id,
204: p_dept_id,
205: p_resource_id,
206: p_date,

Line 488: wip_ws_util.get_appended_date(bsd.shift_date, t.from_time),

484: ) is
485: select
486: bsd.seq_num || '.' || bsd.shift_num as shift_id,
487: to_char(
488: wip_ws_util.get_appended_date(bsd.shift_date, t.from_time),
489: 'DD-MON-YYYY HH24:MI:SS'
490: ) as from_date_char,
491: to_char(
492: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),

Line 492: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),

488: wip_ws_util.get_appended_date(bsd.shift_date, t.from_time),
489: 'DD-MON-YYYY HH24:MI:SS'
490: ) as from_date_char,
491: to_char(
492: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),
493: 'DD-MON-YYYY HH24:MI:SS'
494: ) as to_date_char,
495: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
496: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,

Line 495: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,

491: to_char(
492: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),
493: 'DD-MON-YYYY HH24:MI:SS'
494: ) as to_date_char,
495: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
496: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,
497: t.shift_num as shift_num,
498: bsd.seq_num as seq_num,
499: wip_ws_util.get_shift_info_for_display(

Line 496: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,

492: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),
493: 'DD-MON-YYYY HH24:MI:SS'
494: ) as to_date_char,
495: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
496: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,
497: t.shift_num as shift_num,
498: bsd.seq_num as seq_num,
499: wip_ws_util.get_shift_info_for_display(
500: p_organization_id, bsd.seq_num, t.shift_num

Line 499: wip_ws_util.get_shift_info_for_display(

495: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
496: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,
497: t.shift_num as shift_num,
498: bsd.seq_num as seq_num,
499: wip_ws_util.get_shift_info_for_display(
500: p_organization_id, bsd.seq_num, t.shift_num
501: ) as display
502: from
503: bom_shift_dates bsd,