APPS.WIP_PREF_DEF_PKG dependencies on WIP_PREFERENCE_DEFINITIONS

Line 57: from WIP_PREFERENCE_DEFINITIONS

53: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
54:
55: select LAST_UPDATED_BY, LAST_UPDATE_DATE
56: into db_luby, db_ludate
57: from WIP_PREFERENCE_DEFINITIONS
58: where PREFERENCE_ID = x_preference_id;
59:
60: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
61: db_ludate, x_custom_mode)) then

Line 62: update WIP_PREFERENCE_DEFINITIONS set

58: where PREFERENCE_ID = x_preference_id;
59:
60: if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
61: db_ludate, x_custom_mode)) then
62: update WIP_PREFERENCE_DEFINITIONS set
63: PREFERENCE_CODE = x_preference_code,
64: PREFERENCE_TYPE = x_preference_type,
65: PREFERENCE_SOURCE = x_preference_source,
66: PREFERENCE_VALUE_LOOKUP_TYPE = x_preference_value_lookup_type,

Line 78: insert into WIP_PREFERENCE_DEFINITIONS (

74:
75: exception
76: when no_data_found then
77: -- Row doesn't exist yet. Now this insert statement is placed here.
78: insert into WIP_PREFERENCE_DEFINITIONS (
79: PREFERENCE_ID,
80: PREFERENCE_CODE,
81: PREFERENCE_TYPE,
82: PREFERENCE_SOURCE,