eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WS_DL_UTIL dependencies on WIP_WS_UTIL

Line 243: return wip_ws_util.get_employee_name(p_employee_id, null);

239: p_employee_id number
240: ) return varchar2
241: is
242: begin
243: return wip_ws_util.get_employee_name(p_employee_id, null);
244: end get_col_job_on_name;
245:
246:
247: /* return the sum of qty in both place - direct previous op, the closest check point op

Line 964: l_level_id := wip_ws_util.get_preference_level_id(WP_READY_STATUS_CRITERIA, p_resp_key, p_org_id, p_dept_id);

960:
961: if( p_resp_key <> l_c_resp_key or nvl(p_org_id, -1) <> nvl(l_c_org_id, -1) or
962: nvl(p_dept_id, -1) <> nvl(l_c_dept_id, -1) ) then
963: /* re calculate the preference */
964: l_level_id := wip_ws_util.get_preference_level_id(WP_READY_STATUS_CRITERIA, p_resp_key, p_org_id, p_dept_id);
965: open c_pref_values(WP_READY_STATUS_CRITERIA, l_level_id);
966: loop
967: fetch c_pref_values into l_attribute_name, l_value;
968: exit when c_pref_values%NOTFOUND;

Line 1173: l_level_id := wip_ws_util.get_preference_level_id(WP_DL_ORDERING_CRITERIA, p_resp_key, p_org_id, p_dept_id);

1169: Begin
1170: l_columns := 'expedited';
1171: l_orderby := 'expedited';
1172:
1173: l_level_id := wip_ws_util.get_preference_level_id(WP_DL_ORDERING_CRITERIA, p_resp_key, p_org_id, p_dept_id);
1174:
1175: open c_pref_order_by(WP_DL_ORDERING_CRITERIA, l_level_id);
1176:
1177: loop

Line 1260: l_level_id := wip_ws_util.get_preference_level_id(WP_JOB_STATUS, p_resp_key, p_org_id, p_dept_id);

1256: add_where(l_where, ' job_type = ' || p_job_type);
1257: end if;
1258:
1259: -- read preference, add job status type
1260: l_level_id := wip_ws_util.get_preference_level_id(WP_JOB_STATUS, p_resp_key, p_org_id, p_dept_id);
1261: open c_pref_values(WP_JOB_STATUS, l_level_id, null);
1262: loop
1263: fetch c_pref_values into l_value;
1264: exit when c_pref_values%NOTFOUND;

Line 1349: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, p_org_id, p_dept_id);

1345: add_where(l_where, l_tmp);
1346: end if;
1347:
1348: -- read preference, include complete or not
1349: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, p_org_id, p_dept_id);
1350: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1351: l_include_to_move := true;
1352: else
1353: l_include_to_move := false;

Line 1350: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then

1346: end if;
1347:
1348: -- read preference, include complete or not
1349: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, p_org_id, p_dept_id);
1350: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1351: l_include_to_move := true;
1352: else
1353: l_include_to_move := false;
1354: end if;

Line 1546: wip_ws_util.retrieve_first_shift(p_org_id, p_dept_id, p_resource_id, l_date, l_seq, l_num, l_shift_start_date, l_shift_end_date, l_str);

1542: Begin
1543:
1544: l_date := sysdate;
1545:
1546: wip_ws_util.retrieve_first_shift(p_org_id, p_dept_id, p_resource_id, l_date, l_seq, l_num, l_shift_start_date, l_shift_end_date, l_str);
1547:
1548: l_ret := l_seq || '.' || l_num;
1549:
1550: return l_ret;

Line 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);

1716: l_cursor integer;
1717: l_dummy integer;
1718: Begin
1719:
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,

Line 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);

1865: l_sql varchar(2048);
1866: l_cursor integer;
1867: l_dummy integer;
1868: Begin
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,

Line 1984: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, l_org_id, l_dept_id);

1980: from wip_operations wo
1981: where wo.wip_entity_id = p_wip_entity_id and
1982: wo.operation_seq_num = p_op_seq;
1983:
1984: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, l_org_id, l_dept_id);
1985: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1986: l_include_to_move := true;
1987: else
1988: l_include_to_move := false;

Line 1985: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then

1981: where wo.wip_entity_id = p_wip_entity_id and
1982: wo.operation_seq_num = p_op_seq;
1983:
1984: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, l_org_id, l_dept_id);
1985: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1986: l_include_to_move := true;
1987: else
1988: l_include_to_move := false;
1989: end if;