APPS.WIP_WPS_PREFERENCES_PKG dependencies on WIP_PREFERENCES

Line 12: delete from wip_preferences

8: x_user_id NUMBER) IS
9:
10: PRAGMA AUTONOMOUS_TRANSACTION;
11: BEGIN
12: delete from wip_preferences
13: where application_id = x_application_id
14: and user_id = x_user_id
15: and organization_id = x_organization_id;
16:

Line 29: delete from wip_preferences

25:
26: PRAGMA AUTONOMOUS_TRANSACTION;
27: BEGIN
28:
29: delete from wip_preferences
30: where application_id = x_application_id
31: and user_id = x_user_id
32: and organization_id = x_organization_id
33: and module_id = x_module_id;

Line 47: delete from wip_preferences

43:
44: PRAGMA AUTONOMOUS_TRANSACTION;
45: BEGIN
46:
47: delete from wip_preferences
48: where application_id = x_application_id
49: and user_id = x_user_id
50: and organization_id = x_organization_id
51: and module_id = x_module_id

Line 70: insert into wip_preferences (preference_id,

66: x_value_index NUMBER) IS
67: PRAGMA AUTONOMOUS_TRANSACTION;
68: BEGIN
69:
70: insert into wip_preferences (preference_id,
71: application_id,
72: organization_id,
73: user_id,
74: preference_type,

Line 81: values (wip_preferences_seq.nextval,

77: last_update_date,
78: last_updated_by,
79: creation_date,
80: created_by)
81: values (wip_preferences_seq.nextval,
82: x_application_id,
83: x_organization_id,
84: x_user_id,
85: x_preference_type,

Line 109: insert into wip_preferences (preference_id,

105: x_module_id NUMBER) IS
106: PRAGMA AUTONOMOUS_TRANSACTION;
107: BEGIN
108:
109: insert into wip_preferences (preference_id,
110: application_id,
111: organization_id,
112: user_id,
113: preference_type,

Line 121: values (wip_preferences_seq.nextval,

117: last_updated_by,
118: creation_date,
119: created_by,
120: module_id)
121: values (wip_preferences_seq.nextval,
122: x_application_id,
123: x_organization_id,
124: x_user_id,
125: x_preference_type,