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 1169: l_level_id := wip_ws_util.get_preference_level_id(WP_DL_ORDERING_CRITERIA, p_resp_key, p_org_id, p_dept_id);

1165: Begin
1166: l_columns := 'expedited';
1167: l_orderby := 'expedited';
1168:
1169: l_level_id := wip_ws_util.get_preference_level_id(WP_DL_ORDERING_CRITERIA, p_resp_key, p_org_id, p_dept_id);
1170:
1171: open c_pref_order_by(WP_DL_ORDERING_CRITERIA, l_level_id);
1172:
1173: loop

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

1250: add_where(l_where, ' job_type = ' || p_job_type);
1251: end if;
1252:
1253: -- read preference, add job status type
1254: l_level_id := wip_ws_util.get_preference_level_id(WP_JOB_STATUS, p_resp_key, p_org_id, p_dept_id);
1255: open c_pref_values(WP_JOB_STATUS, l_level_id, null);
1256: loop
1257: fetch c_pref_values into l_value;
1258: exit when c_pref_values%NOTFOUND;

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

1339: add_where(l_where, l_tmp);
1340: end if;
1341:
1342: -- read preference, include complete or not
1343: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, p_org_id, p_dept_id);
1344: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1345: l_include_to_move := true;
1346: else
1347: l_include_to_move := false;

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

1340: end if;
1341:
1342: -- read preference, include complete or not
1343: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, p_org_id, p_dept_id);
1344: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1345: l_include_to_move := true;
1346: else
1347: l_include_to_move := false;
1348: end if;

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

1525: Begin
1526:
1527: l_date := sysdate;
1528:
1529: 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);
1530:
1531: l_ret := l_seq || '.' || l_num;
1532:
1533: return l_ret;

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

1698: l_cursor integer;
1699: l_dummy integer;
1700: Begin
1701:
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,

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

1844: l_sql varchar(2048);
1845: l_cursor integer;
1846: l_dummy integer;
1847: Begin
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,

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

1958: from wip_operations wo
1959: where wo.wip_entity_id = p_wip_entity_id and
1960: wo.operation_seq_num = p_op_seq;
1961:
1962: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, l_org_id, l_dept_id);
1963: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1964: l_include_to_move := true;
1965: else
1966: l_include_to_move := false;

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

1959: where wo.wip_entity_id = p_wip_entity_id and
1960: wo.operation_seq_num = p_op_seq;
1961:
1962: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, l_org_id, l_dept_id);
1963: if( wip_ws_util.get_preference_value_code(WP_INCLUDE_COMPLETE_QTY, l_level_id) = WP_VALUE_YES ) then
1964: l_include_to_move := true;
1965: else
1966: l_include_to_move := false;
1967: end if;