APPS.OKC_UDA_TEMPLATES_UTIL dependencies on EGO_ACTIONS_TL

Line 87: FROM EGO_ACTIONS_TL

83: BEGIN
84:
85: SELECT ACTION_ID
86: INTO l_action_id
87: FROM EGO_ACTIONS_TL
88: WHERE ACTION_ID = l_action_id
89: AND LANGUAGE = USERENV('LANG');
90:
91: UPDATE EGO_ACTIONS_TL

Line 91: UPDATE EGO_ACTIONS_TL

87: FROM EGO_ACTIONS_TL
88: WHERE ACTION_ID = l_action_id
89: AND LANGUAGE = USERENV('LANG');
90:
91: UPDATE EGO_ACTIONS_TL
92: SET DESCRIPTION = p_description
93: WHERE ACTION_ID = l_action_id
94: AND LANGUAGE = USERENV('LANG');
95: EXCEPTION

Line 98: INSERT INTO EGO_ACTIONS_TL

94: AND LANGUAGE = USERENV('LANG');
95: EXCEPTION
96: WHEN NO_DATA_FOUND THEN
97:
98: INSERT INTO EGO_ACTIONS_TL
99: (
100: ACTION_ID,
101: DESCRIPTION,
102: LANGUAGE,

Line 124: FROM EGO_ACTIONS_TL T

120: FROM FND_LANGUAGES L
121: WHERE L.INSTALLED_FLAG in ('I', 'B')
122: AND NOT EXISTS
123: ( SELECT NULL
124: FROM EGO_ACTIONS_TL T
125: WHERE T.ACTION_ID =l_action_id
126: AND T.LANGUAGE = L.LANGUAGE_CODE
127: );
128: END;

Line 170: INSERT INTO EGO_ACTIONS_TL

166: SYSDATE,
167: 0
168: );
169:
170: INSERT INTO EGO_ACTIONS_TL
171: (
172: ACTION_ID,
173: DESCRIPTION,
174: LANGUAGE,

Line 196: FROM EGO_ACTIONS_TL T

192: FROM FND_LANGUAGES L
193: WHERE L.INSTALLED_FLAG in ('I', 'B')
194: AND NOT EXISTS
195: ( SELECT NULL
196: FROM EGO_ACTIONS_TL T
197: WHERE T.ACTION_ID =l_action_id
198: AND T.LANGUAGE = L.LANGUAGE_CODE
199: );
200:

Line 281: UPDATE EGO_ACTIONS_TL

277: AND ATTR_GROUP_ID = l_attr_grp_id
278: AND CLASSIFICATION_CODE = p_classification_code || '';
279:
280:
281: UPDATE EGO_ACTIONS_TL
282: SET DESCRIPTION = p_description,
283: SOURCE_LANG = USERENV('LANG'),
284: LAST_UPDATE_DATE = SYSDATE,
285: LAST_UPDATED_BY = DECODE(p_owner, 'SEED', 1, 0),

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