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 207: /* wip_ws_util.retrieve_first_shift(

203: -- x_shift_end_date date;
204: -- x_shift_string varchar2(100);
205: begin
206:
207: /* wip_ws_util.retrieve_first_shift(
208: p_org_id,
209: p_dept_id,
210: p_resource_id,
211: p_date,

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

574: ) is
575: select
576: bsd.seq_num || '.' || bsd.shift_num as shift_id,
577: to_char(
578: wip_ws_util.get_appended_date(bsd.shift_date, t.from_time),
579: 'DD-MON-YYYY HH24:MI:SS'
580: ) as from_date_char,
581: to_char(
582: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),

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

578: wip_ws_util.get_appended_date(bsd.shift_date, t.from_time),
579: 'DD-MON-YYYY HH24:MI:SS'
580: ) as from_date_char,
581: to_char(
582: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),
583: 'DD-MON-YYYY HH24:MI:SS'
584: ) as to_date_char,
585: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
586: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,

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

581: to_char(
582: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),
583: 'DD-MON-YYYY HH24:MI:SS'
584: ) as to_date_char,
585: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
586: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,
587: t.shift_num as shift_num,
588: bsd.seq_num as seq_num,
589: wip_ws_util.get_shift_info_for_display(

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

582: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time),
583: 'DD-MON-YYYY HH24:MI:SS'
584: ) as to_date_char,
585: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
586: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,
587: t.shift_num as shift_num,
588: bsd.seq_num as seq_num,
589: wip_ws_util.get_shift_info_for_display(
590: p_organization_id, bsd.seq_num, t.shift_num

Line 589: wip_ws_util.get_shift_info_for_display(

585: wip_ws_util.get_appended_date( bsd.shift_date, t.from_time) as from_date,
586: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) as to_date,
587: t.shift_num as shift_num,
588: bsd.seq_num as seq_num,
589: wip_ws_util.get_shift_info_for_display(
590: p_organization_id, bsd.seq_num, t.shift_num
591: ) as display
592: from
593: bom_shift_dates bsd,