APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_WS_LABOR_METRIC_PUB

Line 1: PACKAGE BODY WIP_WS_LABOR_METRIC_PUB AS

1: PACKAGE BODY WIP_WS_LABOR_METRIC_PUB AS
2: /* $Header: wipwslmb.pls 120.9 2008/06/12 11:24:27 sisankar noship $ */
3:
4: /* To Get Calendar Code for an organization */
5: function get_calendar_code(p_organization_id number)

Line 279: and wip_ws_labor_metric_pub.is_time_uom(br.unit_of_measure) = 1

275: and bdri.department_id = bdr.department_id
276: and bdri.resource_id = bdr.resource_id
277: and bdr.resource_id = br.resource_id
278: and bdr.available_24_hours_flag = 2
279: and wip_ws_labor_metric_pub.is_time_uom(br.unit_of_measure) = 1
280: and bre.organization_id = org_id
281: order by bdri.department_id,
282: bdri.resource_id;
283:

Line 566: l_proc_name varchar2(50) := 'WIP_WS_LABOR_METRIC_PUB.CALCULATE_METRICS';

562: l_shift_start_date date := null;
563: l_shift_end_date date := null;
564:
565: l_stmt_num number := null;
566: l_proc_name varchar2(50) := 'WIP_WS_LABOR_METRIC_PUB.CALCULATE_METRICS';
567:
568: l_org_code varchar2(3);
569: l_pgm_count number :=0;
570:

Line 1415: END WIP_WS_LABOR_METRIC_PUB;

1411:
1412: return l_converted_date;
1413: end get_client_date;
1414:
1415: END WIP_WS_LABOR_METRIC_PUB;