DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTIONS_DL

Line 244: DELETE FROM EGO_ACTIONS_DL

240: IF FND_API.To_Boolean(p_init_msg_list) THEN
241: FND_MSG_PUB.Initialize;
242: END IF;
243:
244: DELETE FROM EGO_ACTIONS_DL
245: WHERE ACTION_ID = p_action_id;
246:
247: -- Standard check of p_commit
248: IF FND_API.To_Boolean(p_commit) THEN

Line 11027: --R12C Deleting the datalevel visibility from the EGO_ACTIONS_DL table.

11023: p_action_id, null, null, x_return_status,
11024: x_errorcode, x_msg_count, x_msg_data);
11025: END IF;
11026:
11027: --R12C Deleting the datalevel visibility from the EGO_ACTIONS_DL table.
11028: SELECT COUNT(*)
11029: INTO l_visibility_count
11030: FROM EGO_ACTIONS_DL
11031: WHERE ACTION_ID = p_action_id;

Line 11030: FROM EGO_ACTIONS_DL

11026:
11027: --R12C Deleting the datalevel visibility from the EGO_ACTIONS_DL table.
11028: SELECT COUNT(*)
11029: INTO l_visibility_count
11030: FROM EGO_ACTIONS_DL
11031: WHERE ACTION_ID = p_action_id;
11032: code_debug ('ENTERED THE FUCNTION Delete_Action l_visibility_count'||l_visibility_count);
11033:
11034: IF (l_visibility_count > 0) THEN

Line 11107: INSERT INTO EGO_ACTIONS_DL

11103: IF FND_API.To_Boolean(p_init_msg_list) THEN
11104: FND_MSG_PUB.Initialize;
11105: END IF;
11106:
11107: INSERT INTO EGO_ACTIONS_DL
11108: (
11109: ACTION_ID
11110: ,DATA_LEVEL_ID
11111: ,VISIBILITY_FLAG