APPS.OKC_UDA_TEMPLATES_UTIL dependencies on EGO_ACTIONS_B

Line 74: FROM EGO_ACTIONS_B

70:
71: BEGIN
72: SELECT ACTION_ID
73: INTO l_action_id
74: FROM EGO_ACTIONS_B
75: WHERE ACTION_NAME = p_action_name
76: AND ATTR_GROUP_ID = l_attr_grp_id
77: AND CLASSIFICATION_CODE = p_classification_code || '';
78:

Line 79: UPDATE EGO_ACTIONS_B

75: WHERE ACTION_NAME = p_action_name
76: AND ATTR_GROUP_ID = l_attr_grp_id
77: AND CLASSIFICATION_CODE = p_classification_code || '';
78:
79: UPDATE EGO_ACTIONS_B
80: SET SEQUENCE = p_sequence
81: WHERE ACTION_ID = l_action_id;
82:
83: BEGIN

Line 139: INSERT INTO EGO_ACTIONS_B

135: INTO l_action_id
136: FROM DUAL
137: WHERE ROWNUM = 1;
138:
139: INSERT INTO EGO_ACTIONS_B
140: (
141: ACTION_ID,
142: OBJECT_ID,
143: CLASSIFICATION_CODE,

Line 275: FROM EGO_ACTIONS_B

271: IF l_attr_grp_id IS NOT NULL THEN
272:
273: SELECT ACTION_ID
274: INTO l_action_id
275: FROM EGO_ACTIONS_B
276: WHERE ACTION_NAME = p_action_name
277: AND ATTR_GROUP_ID = l_attr_grp_id
278: AND CLASSIFICATION_CODE = p_classification_code || '';
279:

Line 348: FROM EGO_ACTIONS_B

344:
345: BEGIN
346: SELECT ACTION_ID
347: INTO l_action_id
348: FROM EGO_ACTIONS_B
349: WHERE ACTION_NAME = p_action_name
350: AND ATTR_GROUP_ID = l_attr_grp_id
351: AND CLASSIFICATION_CODE = p_classification_code || ''
352: AND ROWNUM = 1;

Line 467: FROM EGO_ACTIONS_B

463: BEGIN
464:
465: SELECT ACTION_ID
466: INTO l_action_id
467: FROM EGO_ACTIONS_B
468: WHERE ACTION_NAME = p_action_name
469: AND ATTR_GROUP_ID = l_attr_grp_id
470: AND CLASSIFICATION_CODE = p_classification_code || ''
471: AND ROWNUM = 1;

Line 611: FROM EGO_ACTIONS_B

607: IF l_attr_grp_id IS NOT NULL THEN
608:
609: SELECT ACTION_ID
610: INTO l_action_id
611: FROM EGO_ACTIONS_B
612: WHERE ACTION_NAME = p_action_name
613: AND ATTR_GROUP_ID = l_attr_grp_id
614: AND CLASSIFICATION_CODE = p_classification_code || ''
615: AND ROWNUM = 1;

Line 883: SELECT action_id FROM ego_actions_b

879: l_errorcode NUMBER;
880: i NUMBER := 0;
881:
882: CURSOR c_src_action_ids(p_attr_group_id NUMBER, p_src_template_code VARCHAR2, p_object_id NUMBER) IS
883: SELECT action_id FROM ego_actions_b
884: WHERE ATTR_GROUP_ID = p_attr_group_id
885: AND classification_code = p_src_template_code
886: AND OBJECT_ID = p_object_id;
887:

Line 890: FROM EGO_ACTIONS_tl tl, EGO_ACTIONS_B b

886: AND OBJECT_ID = p_object_id;
887:
888: CURSOR c_src_record(p_action_id NUMBER) IS
889: 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
890: FROM EGO_ACTIONS_tl tl, EGO_ACTIONS_B b
891: WHERE b.action_id = p_action_id AND b.action_id = tl.action_id AND tl.LANGUAGE = userenv('LANG');
892:
893: CURSOR c_src_action_display(p_action_id NUMBER) IS
894: SELECT ACTION_ID, EXECUTION_METHOD, DISPLAY_STYLE, PROMPT_APPLICATION_ID, PROMPT_MESSAGE_NAME, VISIBILITY_FLAG, PROMPT_FUNCTION_ID, VISIBILITY_FUNC_ID

Line 1543: SELECT action_id, function_id FROM EGO_ACTIONS_B

1539: where object_id = p_object_id
1540: and classification_code = p_uda_temp_id;
1541:
1542: CURSOR c_get_action_id(p_object_id NUMBER, p_uda_temp_id VARCHAR2) IS
1543: SELECT action_id, function_id FROM EGO_ACTIONS_B
1544: WHERE object_id = p_object_id
1545: AND classification_code = p_uda_temp_id;
1546:
1547: BEGIN