DBA Data[Home] [Help]

APPS.WIP_PREF_VALUE_PKG dependencies on WIP_PREFERENCE_VALUES

Line 54: from WIP_PREFERENCE_VALUES

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_VALUES
55: where PREFERENCE_VALUE_ID = x_preference_value_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_VALUES set

55: where PREFERENCE_VALUE_ID = x_preference_value_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_VALUES set
60: PREFERENCE_ID = x_preference_id,
61: LEVEL_ID = x_level_id,
62: SEQUENCE_NUMBER = x_sequence_number,
63: ATTRIBUTE_NAME = x_attribute_name,

Line 74: insert into WIP_PREFERENCE_VALUES (

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_VALUES (
75: PREFERENCE_VALUE_ID,
76: PREFERENCE_ID,
77: LEVEL_ID,
78: SEQUENCE_NUMBER,