APPS.PO_UDA_TEMPLATES_UTIL dependencies on EGO_ACTIONS_B

Line 1041: FROM EGO_ACTIONS_B

1037: BEGIN
1038:
1039: SELECT CREATED_BY, CLASSIFICATION_CODE
1040: INTO l_created_by, l_template_id
1041: FROM EGO_ACTIONS_B
1042: WHERE FUNCTION_ID = p_function_id
1043: AND ROWNUM < 2;
1044:
1045:

Line 3987: SELECT action_id FROM ego_actions_b

3983: l_src_temp_code VARCHAR2(11);
3984: i NUMBER := 0;
3985:
3986: CURSOR c_src_action_ids(p_attr_group_id NUMBER, p_src_template_code VARCHAR2, p_object_id NUMBER) IS
3987: SELECT action_id FROM ego_actions_b
3988: WHERE ATTR_GROUP_ID = p_attr_group_id
3989: AND classification_code = p_src_template_code
3990: AND OBJECT_ID = p_object_id;
3991:

Line 3994: FROM EGO_ACTIONS_tl tl, EGO_ACTIONS_B b

3990: AND OBJECT_ID = p_object_id;
3991:
3992: CURSOR c_src_record(p_action_id NUMBER) IS
3993: SELECT b.OBJECT_ID, b.CLASSIFICATION_CODE, b.SEQUENCE, b.ACTION_NAME, b.FUNCTION_ID,b.SECURITY_PRIVILEGE_ID, b.ENABLE_KEY_ATTRIBUTES, tl.DESCRIPTION
3994: FROM EGO_ACTIONS_tl tl, EGO_ACTIONS_B b
3995: WHERE b.action_id = p_action_id AND b.action_id = tl.action_id AND tl.LANGUAGE = userenv('LANG');
3996:
3997: CURSOR c_src_action_display(p_action_id NUMBER) IS
3998: SELECT ACTION_ID, EXECUTION_METHOD, DISPLAY_STYLE, PROMPT_APPLICATION_ID, PROMPT_MESSAGE_NAME, VISIBILITY_FLAG, PROMPT_FUNCTION_ID, VISIBILITY_FUNC_ID

Line 4682: SELECT action_id, function_id FROM EGO_ACTIONS_B

4678: WHERE ptu.usage_id = p_usage_id
4679: AND ptu.template_id = umv.template_id;
4680:
4681: CURSOR c_get_action_id(p_object_id NUMBER, p_template_id NUMBER, p_attribute_group_id NUMBER) IS
4682: SELECT action_id, function_id FROM EGO_ACTIONS_B
4683: WHERE object_id = p_object_id
4684: AND classification_code = p_template_id
4685: AND attr_group_id = p_attribute_group_id;
4686: