APPS.WIP_WS_DL_UTIL dependencies on WIP_WS_DL_UTIL

Line 1: package body WIP_WS_DL_UTIL as

1: package body WIP_WS_DL_UTIL as
2: /* $Header: wipwsdlb.pls 120.21.12010000.4 2008/11/21 22:30:42 ntangjee ship $ */
3:
4: procedure get_first_calendar_date
5: (

Line 1706: wip_ws_dl_util.build_dispatch_list_sql(p_resp_key => p_resp_key,

1702: l_list_mode := wip_ws_util.get_preference_value_code(WIP_WS_DEFAULT_DL_TYPE, p_resp_key, p_org_id, p_department_id);
1703:
1704: l_bind_num := 3;
1705:
1706: wip_ws_dl_util.build_dispatch_list_sql(p_resp_key => p_resp_key,
1707: p_org_id => p_org_id,
1708: p_dept_id => p_department_id,
1709: p_resource_id => p_resource_id,
1710: p_instance_option => 1, /* all */

Line 1852: wip_ws_dl_util.build_dispatch_list_sql(p_resp_key => p_resp_key,

1848: l_list_mode := wip_ws_util.get_preference_value_code(WIP_WS_DEFAULT_DL_TYPE, p_resp_key, p_org_id, p_department_id);
1849:
1850: l_bind_num := 3;
1851:
1852: wip_ws_dl_util.build_dispatch_list_sql(p_resp_key => p_resp_key,
1853: p_org_id => p_org_id,
1854: p_dept_id => p_department_id,
1855: p_resource_id => p_resource_id,
1856: p_instance_option => 1, /* all */

Line 1872: l_sql := 'select sum( nvl(wip_ws_dl_util.get_col_res_usage_req(wip_entity_id, operation_seq_num, :1, :2, null), 0) ) ';

1868: x_order_by_clause => x_order_by_clause,
1869: x_required =>x_required --Bug -7364131
1870: );
1871:
1872: l_sql := 'select sum( nvl(wip_ws_dl_util.get_col_res_usage_req(wip_entity_id, operation_seq_num, :1, :2, null), 0) ) ';
1873: l_sql := l_sql || 'from ( ';
1874: l_sql := l_sql || 'select wo.organization_id, wo.wip_entity_id, wo.operation_seq_num, wo.department_id, ';
1875: l_sql := l_sql || ' wo.first_unit_start_date, wo.last_unit_completion_date, ';
1876: l_sql := l_sql || ' wo.quantity_in_queue, wo.quantity_running, wo.quantity_waiting_to_move, wo.cumulative_scrap_quantity, ';

Line 1983: end WIP_WS_DL_UTIL;

1979: End is_jobop_completed;
1980:
1981: begin
1982: null;
1983: end WIP_WS_DL_UTIL;
1984: