APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTIONS_B

Line 11369: FROM EGO_ACTIONS_B

11365: -- to make sure the Function we're trying to delete isn't in use.
11366:
11367: SELECT count(*)
11368: INTO l_function_use_count
11369: FROM EGO_ACTIONS_B
11370: WHERE FUNCTION_ID = p_function_id;
11371: IF (l_function_use_count > 0)
11372: THEN
11373: l_delete_error_flag := 'Y';

Line 11504: FROM EGO_ACTIONS_B

11500:
11501: -- Validate sequence
11502: SELECT COUNT(*)
11503: INTO l_validate
11504: FROM EGO_ACTIONS_B
11505: WHERE SEQUENCE = p_sequence
11506: AND OBJECT_ID = p_object_id
11507: AND CLASSIFICATION_CODE = p_classification_code
11508: AND ATTR_GROUP_ID = p_attr_group_id;

Line 11517: FROM EGO_ACTIONS_B

11513:
11514: -- Validate name
11515: SELECT COUNT(*)
11516: INTO l_validate
11517: FROM EGO_ACTIONS_B
11518: WHERE ACTION_NAME = p_action_name
11519: AND OBJECT_ID = p_object_id
11520: AND CLASSIFICATION_CODE = p_classification_code
11521: AND ATTR_GROUP_ID = p_attr_group_id;

Line 11528: INSERT INTO EGO_ACTIONS_B

11524: RAISE e_dup_action_name_error;
11525: END IF;
11526:
11527:
11528: INSERT INTO EGO_ACTIONS_B
11529: (
11530: ACTION_ID
11531: ,OBJECT_ID
11532: ,CLASSIFICATION_CODE

Line 11792: FROM EGO_ACTIONS_B

11788:
11789: -- Retrieve type/classification/attribute group info.
11790: SELECT OBJECT_ID, CLASSIFICATION_CODE, ATTR_GROUP_ID
11791: INTO l_object_id, l_classification_code, l_attr_group_id
11792: FROM EGO_ACTIONS_B
11793: WHERE ACTION_ID = p_action_id;
11794:
11795: -- Validate sequence
11796: SELECT COUNT(*)

Line 11798: FROM EGO_ACTIONS_B

11794:
11795: -- Validate sequence
11796: SELECT COUNT(*)
11797: INTO l_validate
11798: FROM EGO_ACTIONS_B
11799: WHERE SEQUENCE = p_sequence
11800: AND ACTION_ID <> p_action_id
11801: AND OBJECT_ID = l_object_id
11802: AND CLASSIFICATION_CODE = l_classification_code

Line 11812: FROM EGO_ACTIONS_B

11808:
11809: -- Validate name
11810: SELECT COUNT(*)
11811: INTO l_validate
11812: FROM EGO_ACTIONS_B
11813: WHERE ACTION_NAME = p_action_name
11814: AND ACTION_ID <> p_action_id
11815: AND OBJECT_ID = l_object_id
11816: AND CLASSIFICATION_CODE = l_classification_code

Line 11829: FROM EGO_ACTIONS_B

11825: -- Mappings for the old Function, we delete those Mappings.
11826:
11827: SELECT FUNCTION_ID
11828: INTO l_old_function_id
11829: FROM EGO_ACTIONS_B
11830: WHERE ACTION_ID = p_action_id;
11831:
11832: IF l_old_function_id <> p_function_id THEN
11833: SELECT COUNT(*)

Line 11848: UPDATE EGO_ACTIONS_B

11844: x_msg_count, x_msg_data);
11845: END IF;
11846: END IF;
11847:
11848: UPDATE EGO_ACTIONS_B
11849: SET
11850: SEQUENCE = p_sequence
11851: , ACTION_NAME = p_action_name
11852: , FUNCTION_ID = p_function_id

Line 11973: FROM EGO_ACTIONS_B

11969: -- delete Mappings for the Function if necessary.
11970:
11971: SELECT FUNCTION_ID
11972: INTO l_function_id
11973: FROM EGO_ACTIONS_B
11974: WHERE ACTION_ID = p_action_id;
11975:
11976: DELETE FROM EGO_ACTIONS_B
11977: WHERE

Line 11976: DELETE FROM EGO_ACTIONS_B

11972: INTO l_function_id
11973: FROM EGO_ACTIONS_B
11974: WHERE ACTION_ID = p_action_id;
11975:
11976: DELETE FROM EGO_ACTIONS_B
11977: WHERE
11978: ACTION_ID = p_action_id;
11979:
11980: DELETE FROM EGO_ACTIONS_TL

Line 14243: from EGO_ACTIONS_B B

14239:
14240: delete from EGO_ACTIONS_TL T
14241: where not exists
14242: (select NULL
14243: from EGO_ACTIONS_B B
14244: where B.ACTION_ID = T.ACTION_ID
14245: );
14246:
14247: update EGO_ACTIONS_TL T set (