APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTION_DISPLAYS_B

Line 10409: FROM EGO_ACTION_DISPLAYS_B

10405: END IF;
10406:
10407: SELECT count(*)
10408: INTO l_function_use_count
10409: FROM EGO_ACTION_DISPLAYS_B
10410: WHERE PROMPT_FUNCTION_ID = p_function_id;
10411: IF (l_function_use_count > 0)
10412: THEN
10413: l_delete_error_flag := 'Y';

Line 10419: FROM EGO_ACTION_DISPLAYS_B

10415: END IF;
10416:
10417: SELECT count(*)
10418: INTO l_function_use_count
10419: FROM EGO_ACTION_DISPLAYS_B
10420: WHERE VISIBILITY_FUNC_ID = p_function_id;
10421: IF (l_function_use_count > 0)
10422: THEN
10423: l_delete_error_flag := 'Y';

Line 11201: INSERT INTO EGO_ACTION_DISPLAYS_B

11197: IF FND_API.To_Boolean(p_init_msg_list) THEN
11198: FND_MSG_PUB.Initialize;
11199: END IF;
11200:
11201: INSERT INTO EGO_ACTION_DISPLAYS_B
11202: (
11203: ACTION_ID
11204: ,EXECUTION_METHOD
11205: ,DISPLAY_STYLE

Line 11302: INSERT INTO EGO_ACTION_DISPLAYS_B

11298: IF FND_API.To_Boolean(p_init_msg_list) THEN
11299: FND_MSG_PUB.Initialize;
11300: END IF;
11301:
11302: INSERT INTO EGO_ACTION_DISPLAYS_B
11303: (
11304: ACTION_ID
11305: ,EXECUTION_METHOD
11306: ,EXECUTION_TRIGGER

Line 11408: FROM EGO_ACTION_DISPLAYS_B

11404: -- Just in case caller is updating an Action that doesn't yet have a Display...
11405:
11406: SELECT COUNT(*)
11407: INTO l_disp_check_count
11408: FROM EGO_ACTION_DISPLAYS_B
11409: WHERE ACTION_ID = p_action_id;
11410:
11411: IF (l_disp_check_count = 0)
11412: THEN

Line 11435: FROM EGO_ACTION_DISPLAYS_B

11431: -- If the function_id's are different, we delete Mappings.
11432:
11433: SELECT PROMPT_FUNCTION_ID
11434: INTO l_old_prompt_func_id
11435: FROM EGO_ACTION_DISPLAYS_B
11436: WHERE ACTION_ID = p_action_id;
11437:
11438: IF ((l_old_prompt_func_id IS NOT NULL)
11439: AND (l_old_prompt_func_id <> p_prompt_function_id)) THEN

Line 11458: FROM EGO_ACTION_DISPLAYS_B

11454: END IF;
11455:
11456: SELECT VISIBILITY_FUNC_ID
11457: INTO l_old_vis_func_id
11458: FROM EGO_ACTION_DISPLAYS_B
11459: WHERE ACTION_ID = p_action_id;
11460:
11461: IF l_old_vis_func_id is not null AND l_old_vis_func_id <> p_visibility_func_id
11462: THEN

Line 11479: UPDATE EGO_ACTION_DISPLAYS_B

11475: x_msg_count, x_msg_data);
11476: END IF;
11477: END IF;
11478:
11479: UPDATE EGO_ACTION_DISPLAYS_B
11480: SET
11481: EXECUTION_METHOD = 'U'
11482: ,DISPLAY_STYLE = p_display_style
11483: ,PROMPT_APPLICATION_ID = p_prompt_application_id

Line 11572: FROM EGO_ACTION_DISPLAYS_B

11568: END IF;
11569:
11570: SELECT COUNT(*)
11571: INTO l_disp_check_count
11572: FROM EGO_ACTION_DISPLAYS_B
11573: WHERE ACTION_ID = p_action_id;
11574:
11575: IF (l_disp_check_count = 0) THEN
11576: EGO_EXT_FWK_PUB.Create_Action_Display

Line 11596: FROM EGO_ACTION_DISPLAYS_B

11592: -- then we need to delete Mappings for prompt, visibility function IDs.
11593:
11594: SELECT PROMPT_FUNCTION_ID
11595: INTO l_old_prompt_func_id
11596: FROM EGO_ACTION_DISPLAYS_B
11597: WHERE ACTION_ID = p_action_id;
11598:
11599: IF l_old_prompt_func_id IS NOT NULL THEN
11600: SELECT COUNT(*)

Line 11617: FROM EGO_ACTION_DISPLAYS_B

11613: END IF;
11614:
11615: SELECT VISIBILITY_FUNC_ID
11616: INTO l_old_vis_func_id
11617: FROM EGO_ACTION_DISPLAYS_B
11618: WHERE ACTION_ID = p_action_id;
11619:
11620: IF l_old_vis_func_id IS NOT NULL THEN
11621: SELECT COUNT(*)

Line 11636: UPDATE EGO_ACTION_DISPLAYS_B

11632: x_msg_count, x_msg_data);
11633: END IF;
11634: END IF;
11635:
11636: UPDATE EGO_ACTION_DISPLAYS_B
11637: SET
11638: EXECUTION_METHOD = 'T'
11639: ,EXECUTION_TRIGGER = p_trigger_code
11640: ,DISPLAY_STYLE = NULL

Line 11731: FROM EGO_ACTION_DISPLAYS_B

11727: -- so we can also delete their function mappings, if necessary
11728:
11729: SELECT PROMPT_FUNCTION_ID
11730: INTO l_prompt_func_id
11731: FROM EGO_ACTION_DISPLAYS_B
11732: WHERE ACTION_ID = p_action_id;
11733:
11734: SELECT VISIBILITY_FUNC_ID
11735: INTO l_vis_func_id

Line 11736: FROM EGO_ACTION_DISPLAYS_B

11732: WHERE ACTION_ID = p_action_id;
11733:
11734: SELECT VISIBILITY_FUNC_ID
11735: INTO l_vis_func_id
11736: FROM EGO_ACTION_DISPLAYS_B
11737: WHERE ACTION_ID = p_action_id;
11738:
11739: -- Then we delete the row
11740:

Line 11741: DELETE FROM EGO_ACTION_DISPLAYS_B

11737: WHERE ACTION_ID = p_action_id;
11738:
11739: -- Then we delete the row
11740:
11741: DELETE FROM EGO_ACTION_DISPLAYS_B
11742: WHERE ACTION_ID = p_action_id;
11743:
11744: -- Then we delete the mappings for the prompt and visibility
11745: -- functions for this action, if there are any