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.26.12020000.3 2012/11/28 07:18:32 sjallipa ship $ */
3:
4: procedure get_first_calendar_date
5: (

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

1720: l_list_mode := wip_ws_util.get_preference_value_code(WIP_WS_DEFAULT_DL_TYPE, p_resp_key, p_org_id, p_department_id);
1721:
1722: l_bind_num := 3;
1723:
1724: wip_ws_dl_util.build_dispatch_list_sql(p_resp_key => p_resp_key,
1725: p_org_id => p_org_id,
1726: p_dept_id => p_department_id,
1727: p_resource_id => p_resource_id,
1728: p_instance_option => 1, /* all */

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

1869: l_list_mode := wip_ws_util.get_preference_value_code(WIP_WS_DEFAULT_DL_TYPE, p_resp_key, p_org_id, p_department_id);
1870:
1871: l_bind_num := 3;
1872:
1873: wip_ws_dl_util.build_dispatch_list_sql(p_resp_key => p_resp_key,
1874: p_org_id => p_org_id,
1875: p_dept_id => p_department_id,
1876: p_resource_id => p_resource_id,
1877: p_instance_option => 1, /* all */

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

1890: x_bind_var_num => x_bind_var_num,
1891: x_required =>x_required --Bug -7364131
1892: );
1893:
1894: l_sql := 'select sum( nvl(wip_ws_dl_util.get_col_res_usage_req(wip_entity_id, operation_seq_num, :1, :2, null), 0) ) ';
1895: l_sql := l_sql || 'from ( ';
1896: l_sql := l_sql || 'select wo.organization_id, wo.wip_entity_id, wo.operation_seq_num, wo.department_id, ';
1897: l_sql := l_sql || ' wo.first_unit_start_date, wo.last_unit_completion_date, ';
1898: l_sql := l_sql || ' wo.quantity_in_queue, wo.quantity_running, wo.quantity_waiting_to_move, wo.cumulative_scrap_quantity, ';

Line 2005: end WIP_WS_DL_UTIL;

2001: End is_jobop_completed;
2002:
2003: begin
2004: null;
2005: end WIP_WS_DL_UTIL;