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.12020000.7 2013/02/12 15:20:19 sisankar ship $ */
3:
4: /* To Get Calendar Code for an organization */
5: function get_calendar_code(p_organization_id number)

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

281: and bdri.department_id = bdr.department_id
282: and bdri.resource_id = bdr.resource_id
283: and bdr.resource_id = br.resource_id
284: and bdr.available_24_hours_flag = 2
285: and wip_ws_labor_metric_pub.is_time_uom(br.unit_of_measure) = 1
286: and bre.organization_id = org_id
287: order by bdri.department_id,
288: bdri.resource_id;
289:

Line 530: and WIP_WS_LABOR_METRIC_PUB.is_time_uom(wor.uom_code) = 1

526: from wip_operation_resources wor,bom_resources br
527: where wor.organization_id= org_id
528: and wor.wip_entity_id= we_ent_id
529: and wor.operation_seq_num= op_seq_num
530: and WIP_WS_LABOR_METRIC_PUB.is_time_uom(wor.uom_code) = 1
531: and nvl(wor.basis_type,1) <> 2
532: and wor.organization_id = br.organization_id
533: and wor.resource_id = br.resource_id
534: and br.resource_type = 2)

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

586: l_shift_start_date date := null;
587: l_shift_end_date date := null;
588:
589: l_stmt_num number := null;
590: l_proc_name varchar2(50) := 'WIP_WS_LABOR_METRIC_PUB.CALCULATE_METRICS';
591:
592: l_org_code varchar2(3);
593: l_pgm_count number :=0;
594:

Line 1513: END WIP_WS_LABOR_METRIC_PUB;

1509:
1510: return l_converted_date;
1511: end get_client_date;
1512:
1513: END WIP_WS_LABOR_METRIC_PUB;