APPS.OE_OE_FOLDER_EXT dependencies on OE_CUSTOM_ACTIONS

Line 15: FROM OE_Custom_Actions

11: /*Commented for Bug 6829128
12: CURSOR C1(l_folder_id Number) IS
13: SELECT action_id,object,action_name,user_entered_prompt,
14: folder_id,width,access_key,DISPLAY_AS_BUTTON_FLAG
15: FROM OE_Custom_Actions
16: WHERE DISPLAY_AS_BUTTON_FLAG='Y' AND
17: folder_id=l_folder_id;*/
18:
19: --Modified for Bug#6829128

Line 32: FROM oe_custom_actions

28: width,
29: access_key,
30: display_as_button_flag,
31: nvl(user_entered_prompt, default_prompt) PROMPT
32: FROM oe_custom_actions
33: WHERE display_as_button_flag = 'Y'
34: AND folder_id = l_folder_id
35: UNION
36: SELECT action_id,

Line 49: FROM oe_custom_actions oc

45: FROM oe_default_actions od
46: WHERE display_as_button_flag = 'Y'
47: AND NOT EXISTS
48: (SELECT action_id
49: FROM oe_custom_actions oc
50: WHERE oc.action_id = od.action_id
51: AND folder_id = l_folder_id)
52: )
53: ORDER BY PROMPT;

Line 63: OE_CUSTOM_ACTIONS OC

59: FROM OE_Default_Actions OD
60: WHERE DISPLAY_AS_BUTTON_FLAG='Y' AND
61: NOT EXISTS
62: (SELECT action_id FROM
63: OE_CUSTOM_ACTIONS OC
64: WHERE OC.action_id=OD.action_id
65: AND Folder_Id=l_folder_id);
66:
67: l_count Number:=1;

Line 116: FROM OE_Custom_Actions

112: IS
113: CURSOR C1(l_folder_id Number) IS
114: SELECT action_id,object,action_name,user_entered_prompt,
115: folder_id,width,access_key,display_as_button_flag,default_prompt
116: FROM OE_Custom_Actions
117: WHERE folder_id=l_folder_id;
118:
119: CURSOR C2(l_folder_id Number) IS
120: SELECT action_id,object,action_name,

Line 125: OE_CUSTOM_ACTIONS OC

121: width,display_as_button_flag
122: FROM OE_Default_Actions OD
123: WHERE NOT EXISTS
124: (SELECT action_id FROM
125: OE_CUSTOM_ACTIONS OC
126: WHERE OC.action_id=OD.action_id
127: AND Folder_Id=l_folder_id);
128:
129:

Line 147: FROM oe_custom_actions

143: x_buttons_tbl(l_count).Width:=BUTTONS.Width;
144: BEGIN
145: SELECT default_prompt into
146: x_buttons_tbl(l_count).default_prompt
147: FROM oe_custom_actions
148: WHERE action_name=BUTTONS.Action_Name
149: AND default_prompt IS NOT NULL
150: AND ROWNUM=1;
151: EXCEPTION

Line 171: FROM oe_custom_actions

167: x_buttons_tbl(l_count).display_as_button:=BUTTONS.display_as_button_flag;
168: BEGIN
169: SELECT default_prompt into
170: x_buttons_tbl(l_count).default_prompt
171: FROM oe_custom_actions
172: WHERE action_name=BUTTONS.Action_Name
173: AND default_prompt IS NOT NULL
174: AND ROWNUM=1;
175: EXCEPTION

Line 212: FROM OE_Custom_Actions

208: FOR i in p_config_buttons_tbl.first ..p_config_buttons_tbl.last LOOP
209: BEGIN
210: SELECT ACTION_ID
211: INTO l_action_id
212: FROM OE_Custom_Actions
213: WHERE action_id=p_config_buttons_tbl(i).action_id
214: AND folder_id=p_folder_id;
215:
216: UPDATE OE_Custom_Actions

Line 216: UPDATE OE_Custom_Actions

212: FROM OE_Custom_Actions
213: WHERE action_id=p_config_buttons_tbl(i).action_id
214: AND folder_id=p_folder_id;
215:
216: UPDATE OE_Custom_Actions
217: SET action_name=p_config_buttons_tbl(i).action_name,
218: width=p_config_buttons_tbl(i).width,
219: user_entered_prompt=p_config_buttons_tbl(i).user_entered_prompt,
220: access_key=p_config_buttons_tbl(i).access_key,

Line 227: INSERT INTO OE_Custom_Actions

223: AND folder_id=p_folder_id;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226:
227: INSERT INTO OE_Custom_Actions
228: (
229: action_name,
230: width,
231: folder_id,

Line 528: DELETE FROM OE_CUSTOM_ACTIONS

524: IS PRAGMA AUTONOMOUS_TRANSACTION;
525: l_folder_extension_id Number;
526: BEGIN
527:
528: DELETE FROM OE_CUSTOM_ACTIONS
529: WHERE folder_id=p_folder_id;
530:
531: DELETE FROM oe_folder_extensions
532: WHERE folder_id=p_folder_id;