APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTIONS_B

Line 10399: FROM EGO_ACTIONS_B

10395: -- to make sure the Function we're trying to delete isn't in use.
10396:
10397: SELECT count(*)
10398: INTO l_function_use_count
10399: FROM EGO_ACTIONS_B
10400: WHERE FUNCTION_ID = p_function_id;
10401: IF (l_function_use_count > 0)
10402: THEN
10403: l_delete_error_flag := 'Y';

Line 10534: FROM EGO_ACTIONS_B

10530:
10531: -- Validate sequence
10532: SELECT COUNT(*)
10533: INTO l_validate
10534: FROM EGO_ACTIONS_B
10535: WHERE SEQUENCE = p_sequence
10536: AND OBJECT_ID = p_object_id
10537: AND CLASSIFICATION_CODE = p_classification_code
10538: AND ATTR_GROUP_ID = p_attr_group_id;

Line 10547: FROM EGO_ACTIONS_B

10543:
10544: -- Validate name
10545: SELECT COUNT(*)
10546: INTO l_validate
10547: FROM EGO_ACTIONS_B
10548: WHERE ACTION_NAME = p_action_name
10549: AND OBJECT_ID = p_object_id
10550: AND CLASSIFICATION_CODE = p_classification_code
10551: AND ATTR_GROUP_ID = p_attr_group_id;

Line 10558: INSERT INTO EGO_ACTIONS_B

10554: RAISE e_dup_action_name_error;
10555: END IF;
10556:
10557:
10558: INSERT INTO EGO_ACTIONS_B
10559: (
10560: ACTION_ID
10561: ,OBJECT_ID
10562: ,CLASSIFICATION_CODE

Line 10822: FROM EGO_ACTIONS_B

10818:
10819: -- Retrieve type/classification/attribute group info.
10820: SELECT OBJECT_ID, CLASSIFICATION_CODE, ATTR_GROUP_ID
10821: INTO l_object_id, l_classification_code, l_attr_group_id
10822: FROM EGO_ACTIONS_B
10823: WHERE ACTION_ID = p_action_id;
10824:
10825: -- Validate sequence
10826: SELECT COUNT(*)

Line 10828: FROM EGO_ACTIONS_B

10824:
10825: -- Validate sequence
10826: SELECT COUNT(*)
10827: INTO l_validate
10828: FROM EGO_ACTIONS_B
10829: WHERE SEQUENCE = p_sequence
10830: AND ACTION_ID <> p_action_id
10831: AND OBJECT_ID = l_object_id
10832: AND CLASSIFICATION_CODE = l_classification_code

Line 10842: FROM EGO_ACTIONS_B

10838:
10839: -- Validate name
10840: SELECT COUNT(*)
10841: INTO l_validate
10842: FROM EGO_ACTIONS_B
10843: WHERE ACTION_NAME = p_action_name
10844: AND ACTION_ID <> p_action_id
10845: AND OBJECT_ID = l_object_id
10846: AND CLASSIFICATION_CODE = l_classification_code

Line 10859: FROM EGO_ACTIONS_B

10855: -- Mappings for the old Function, we delete those Mappings.
10856:
10857: SELECT FUNCTION_ID
10858: INTO l_old_function_id
10859: FROM EGO_ACTIONS_B
10860: WHERE ACTION_ID = p_action_id;
10861:
10862: IF l_old_function_id <> p_function_id THEN
10863: SELECT COUNT(*)

Line 10878: UPDATE EGO_ACTIONS_B

10874: x_msg_count, x_msg_data);
10875: END IF;
10876: END IF;
10877:
10878: UPDATE EGO_ACTIONS_B
10879: SET
10880: SEQUENCE = p_sequence
10881: , ACTION_NAME = p_action_name
10882: , FUNCTION_ID = p_function_id

Line 11003: FROM EGO_ACTIONS_B

10999: -- delete Mappings for the Function if necessary.
11000:
11001: SELECT FUNCTION_ID
11002: INTO l_function_id
11003: FROM EGO_ACTIONS_B
11004: WHERE ACTION_ID = p_action_id;
11005:
11006: DELETE FROM EGO_ACTIONS_B
11007: WHERE

Line 11006: DELETE FROM EGO_ACTIONS_B

11002: INTO l_function_id
11003: FROM EGO_ACTIONS_B
11004: WHERE ACTION_ID = p_action_id;
11005:
11006: DELETE FROM EGO_ACTIONS_B
11007: WHERE
11008: ACTION_ID = p_action_id;
11009:
11010: DELETE FROM EGO_ACTIONS_TL

Line 13271: from EGO_ACTIONS_B B

13267:
13268: delete from EGO_ACTIONS_TL T
13269: where not exists
13270: (select NULL
13271: from EGO_ACTIONS_B B
13272: where B.ACTION_ID = T.ACTION_ID
13273: );
13274:
13275: update EGO_ACTIONS_TL T set (