APPS.WSH_FOLDER_EXTENSIONS_PVT dependencies on WSH_FOLDER_CUSTOM_ACTIONS

Line 239: -- wsh_folder_custom_actions, so Input needs to be table of records

235: /*-------------------------------------------
236: -- Folder Custom Actions Table Handler
237: --========= INSERT/UPDATE FOLDER CUSTOM ACTIONS==
238: -- There can be multiple records for a folder_id in table
239: -- wsh_folder_custom_actions, so Input needs to be table of records
240: -------------------------------------------*/
241:
242: Procedure Insert_Update_Folder_Custom(
243: p_folder_cust_tab IN folder_cust_tab_type,

Line 249: FROM wsh_folder_custom_actions

245: IS PRAGMA AUTONOMOUS_TRANSACTION;
246:
247: CURSOR c_cust_rec_cur(v_folder_id IN NUMBER) IS
248: SELECT folder_id
249: FROM wsh_folder_custom_actions
250: WHERE folder_id = v_folder_id
251: AND rownum = 1;
252: -- FOR UPDATE NOWAIT;
253:

Line 296: -- Records May exist in wsh_folder_custom_actions for user selected

292: l_flag := 'U';
293: END IF;
294:
295:
296: -- Records May exist in wsh_folder_custom_actions for user selected
297: -- buttons,but user can chose to display a totally different set
298: -- of buttons when doing Save-As,so delete existing records and then
299: -- create new for same folder id
300: IF l_flag = 'U' THEN

Line 303: DELETE FROM wsh_folder_custom_actions

299: -- create new for same folder id
300: IF l_flag = 'U' THEN
301: -- Delete all records and then Insert New Records
302: -- No need to check for records in fnd_folders
303: DELETE FROM wsh_folder_custom_actions
304: WHERE folder_id = l_folder_id;
305: END IF;
306:
307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 310: INSERT INTO wsh_folder_custom_actions

306:
307: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
308: FOR i in 1..p_folder_cust_tab.count
309: LOOP
310: INSERT INTO wsh_folder_custom_actions
311: (ACTION_ID,
312: ACTION_NAME,
313: OBJECT,
314: USER_ENTERED_PROMPT,

Line 372: -- There can be multiple records in wsh_folder_custom_actions

368:
369: END Insert_Update_Folder_Custom;
370:
371: --========= DELETE FOLDER CUSTOM ACTIONS=================
372: -- There can be multiple records in wsh_folder_custom_actions
373: -- But they will be deleted by single delete and no need to loop
374: Procedure Delete_Folder_Custom(
375: p_folder_id IN NUMBER,
376: x_return_status OUT NOCOPY VARCHAR2)

Line 402: DELETE FROM wsh_folder_custom_actions

398: END IF;
399: --
400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
401:
402: DELETE FROM wsh_folder_custom_actions
403: WHERE folder_id = p_folder_id;
404:
405: IF sql%NOTFOUND THEN
406: IF l_debug_on THEN