APPS.WIP_PREF_LEVEL_PKG dependencies on WIP_PREFERENCE_LEVELS

Line 54: from WIP_PREFERENCE_LEVELS

50: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
51:
52: select LAST_UPDATED_BY, LAST_UPDATE_DATE
53: into db_luby, db_ludate
54: from WIP_PREFERENCE_LEVELS
55: where LEVEL_ID = x_level_id;
56:
57: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
58: db_ludate, x_custom_mode)) then

Line 59: update WIP_PREFERENCE_LEVELS set

55: where LEVEL_ID = x_level_id;
56:
57: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
58: db_ludate, x_custom_mode)) then
59: update WIP_PREFERENCE_LEVELS set
60: LEVEL_CODE = x_level_code,
61: RESP_KEY = x_resp_key,
62: ORGANIZATION_ID = x_organization_id,
63: DEPARTMENT_ID = x_department_id,

Line 74: insert into WIP_PREFERENCE_LEVELS (

70:
71: exception
72: when no_data_found then
73: -- Row doesn't exist yet. Now this insert statement is placed here.
74: insert into WIP_PREFERENCE_LEVELS (
75: LEVEL_ID,
76: LEVEL_CODE,
77: RESP_KEY,
78: ORGANIZATION_ID,