APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTION_DISPLAYS_B

Line 11379: FROM EGO_ACTION_DISPLAYS_B

11375: END IF;
11376:
11377: SELECT count(*)
11378: INTO l_function_use_count
11379: FROM EGO_ACTION_DISPLAYS_B
11380: WHERE PROMPT_FUNCTION_ID = p_function_id;
11381: IF (l_function_use_count > 0)
11382: THEN
11383: l_delete_error_flag := 'Y';

Line 11389: FROM EGO_ACTION_DISPLAYS_B

11385: END IF;
11386:
11387: SELECT count(*)
11388: INTO l_function_use_count
11389: FROM EGO_ACTION_DISPLAYS_B
11390: WHERE VISIBILITY_FUNC_ID = p_function_id;
11391: IF (l_function_use_count > 0)
11392: THEN
11393: l_delete_error_flag := 'Y';

Line 12172: INSERT INTO EGO_ACTION_DISPLAYS_B

12168: IF FND_API.To_Boolean(p_init_msg_list) THEN
12169: FND_MSG_PUB.Initialize;
12170: END IF;
12171:
12172: INSERT INTO EGO_ACTION_DISPLAYS_B
12173: (
12174: ACTION_ID
12175: ,EXECUTION_METHOD
12176: ,DISPLAY_STYLE

Line 12273: INSERT INTO EGO_ACTION_DISPLAYS_B

12269: IF FND_API.To_Boolean(p_init_msg_list) THEN
12270: FND_MSG_PUB.Initialize;
12271: END IF;
12272:
12273: INSERT INTO EGO_ACTION_DISPLAYS_B
12274: (
12275: ACTION_ID
12276: ,EXECUTION_METHOD
12277: ,EXECUTION_TRIGGER

Line 12380: FROM EGO_ACTION_DISPLAYS_B

12376: -- Just in case caller is updating an Action that doesn't yet have a Display...
12377:
12378: SELECT COUNT(*)
12379: INTO l_disp_check_count
12380: FROM EGO_ACTION_DISPLAYS_B
12381: WHERE ACTION_ID = p_action_id;
12382:
12383: IF (l_disp_check_count = 0)
12384: THEN

Line 12407: FROM EGO_ACTION_DISPLAYS_B

12403: -- If the function_id's are different, we delete Mappings.
12404:
12405: SELECT PROMPT_FUNCTION_ID
12406: INTO l_old_prompt_func_id
12407: FROM EGO_ACTION_DISPLAYS_B
12408: WHERE ACTION_ID = p_action_id;
12409:
12410: IF ((l_old_prompt_func_id IS NOT NULL)
12411: AND (l_old_prompt_func_id <> p_prompt_function_id)) THEN

Line 12430: FROM EGO_ACTION_DISPLAYS_B

12426: END IF;
12427:
12428: SELECT VISIBILITY_FUNC_ID
12429: INTO l_old_vis_func_id
12430: FROM EGO_ACTION_DISPLAYS_B
12431: WHERE ACTION_ID = p_action_id;
12432:
12433: IF l_old_vis_func_id is not null AND l_old_vis_func_id <> p_visibility_func_id
12434: THEN

Line 12451: UPDATE EGO_ACTION_DISPLAYS_B

12447: x_msg_count, x_msg_data);
12448: END IF;
12449: END IF;
12450:
12451: UPDATE EGO_ACTION_DISPLAYS_B
12452: SET
12453: EXECUTION_METHOD = P_EXEC_CODE
12454: ,DISPLAY_STYLE = p_display_style
12455: ,PROMPT_APPLICATION_ID = p_prompt_application_id

Line 12544: FROM EGO_ACTION_DISPLAYS_B

12540: END IF;
12541:
12542: SELECT COUNT(*)
12543: INTO l_disp_check_count
12544: FROM EGO_ACTION_DISPLAYS_B
12545: WHERE ACTION_ID = p_action_id;
12546:
12547: IF (l_disp_check_count = 0) THEN
12548: EGO_EXT_FWK_PUB.Create_Action_Display

Line 12568: FROM EGO_ACTION_DISPLAYS_B

12564: -- then we need to delete Mappings for prompt, visibility function IDs.
12565:
12566: SELECT PROMPT_FUNCTION_ID
12567: INTO l_old_prompt_func_id
12568: FROM EGO_ACTION_DISPLAYS_B
12569: WHERE ACTION_ID = p_action_id;
12570:
12571: IF l_old_prompt_func_id IS NOT NULL THEN
12572: SELECT COUNT(*)

Line 12589: FROM EGO_ACTION_DISPLAYS_B

12585: END IF;
12586:
12587: SELECT VISIBILITY_FUNC_ID
12588: INTO l_old_vis_func_id
12589: FROM EGO_ACTION_DISPLAYS_B
12590: WHERE ACTION_ID = p_action_id;
12591:
12592: IF l_old_vis_func_id IS NOT NULL THEN
12593: SELECT COUNT(*)

Line 12608: UPDATE EGO_ACTION_DISPLAYS_B

12604: x_msg_count, x_msg_data);
12605: END IF;
12606: END IF;
12607:
12608: UPDATE EGO_ACTION_DISPLAYS_B
12609: SET
12610: EXECUTION_METHOD = 'T'
12611: ,EXECUTION_TRIGGER = p_trigger_code
12612: ,DISPLAY_STYLE = NULL

Line 12703: FROM EGO_ACTION_DISPLAYS_B

12699: -- so we can also delete their function mappings, if necessary
12700:
12701: SELECT PROMPT_FUNCTION_ID
12702: INTO l_prompt_func_id
12703: FROM EGO_ACTION_DISPLAYS_B
12704: WHERE ACTION_ID = p_action_id;
12705:
12706: SELECT VISIBILITY_FUNC_ID
12707: INTO l_vis_func_id

Line 12708: FROM EGO_ACTION_DISPLAYS_B

12704: WHERE ACTION_ID = p_action_id;
12705:
12706: SELECT VISIBILITY_FUNC_ID
12707: INTO l_vis_func_id
12708: FROM EGO_ACTION_DISPLAYS_B
12709: WHERE ACTION_ID = p_action_id;
12710:
12711: -- Then we delete the row
12712:

Line 12713: DELETE FROM EGO_ACTION_DISPLAYS_B

12709: WHERE ACTION_ID = p_action_id;
12710:
12711: -- Then we delete the row
12712:
12713: DELETE FROM EGO_ACTION_DISPLAYS_B
12714: WHERE ACTION_ID = p_action_id;
12715:
12716: -- Then we delete the mappings for the prompt and visibility
12717: -- functions for this action, if there are any