APPS.WIP_PREF_VALUE_PKG dependencies on WIP_PREFERENCE_VALUES

Line 59: from WIP_PREFERENCE_VALUES

55: parameters will be seeded. If there is any row existing for a preference
56: at site level (level_id =1) it wont be changed*/
57:
58: select count(*) into row_count
59: from WIP_PREFERENCE_VALUES
60: where LEVEL_ID = x_level_id
61: and PREFERENCE_ID = x_preference_id;
62:
63: if(row_count=0) then

Line 64: insert into WIP_PREFERENCE_VALUES (

60: where LEVEL_ID = x_level_id
61: and PREFERENCE_ID = x_preference_id;
62:
63: if(row_count=0) then
64: insert into WIP_PREFERENCE_VALUES (
65: PREFERENCE_VALUE_ID,
66: PREFERENCE_ID,
67: LEVEL_ID,
68: SEQUENCE_NUMBER,

Line 94: update WIP_PREFERENCE_VALUES set

90: end if;
91:
92: /*if (fnd_load_util.upload_test(user_id, f_ludate, db_luby,
93: db_ludate, x_custom_mode)) then
94: update WIP_PREFERENCE_VALUES set
95: PREFERENCE_ID = x_preference_id,
96: LEVEL_ID = x_level_id,
97: SEQUENCE_NUMBER = x_sequence_number,
98: ATTRIBUTE_NAME = x_attribute_name,

Line 109: insert into WIP_PREFERENCE_VALUES (

105:
106: exception
107: when no_data_found then
108: -- Row doesn't exist yet. Now this insert statement is placed here.
109: insert into WIP_PREFERENCE_VALUES (
110: PREFERENCE_VALUE_ID,
111: PREFERENCE_ID,
112: LEVEL_ID,
113: SEQUENCE_NUMBER,