DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTIONS_DL

Line 245: DELETE FROM EGO_ACTIONS_DL

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

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

11993: p_action_id, null, null, x_return_status,
11994: x_errorcode, x_msg_count, x_msg_data);
11995: END IF;
11996:
11997: --R12C Deleting the datalevel visibility from the EGO_ACTIONS_DL table.
11998: SELECT COUNT(*)
11999: INTO l_visibility_count
12000: FROM EGO_ACTIONS_DL
12001: WHERE ACTION_ID = p_action_id;

Line 12000: FROM EGO_ACTIONS_DL

11996:
11997: --R12C Deleting the datalevel visibility from the EGO_ACTIONS_DL table.
11998: SELECT COUNT(*)
11999: INTO l_visibility_count
12000: FROM EGO_ACTIONS_DL
12001: WHERE ACTION_ID = p_action_id;
12002: code_debug ('ENTERED THE FUCNTION Delete_Action l_visibility_count'||l_visibility_count);
12003:
12004: IF (l_visibility_count > 0) THEN

Line 12077: INSERT INTO EGO_ACTIONS_DL

12073: IF FND_API.To_Boolean(p_init_msg_list) THEN
12074: FND_MSG_PUB.Initialize;
12075: END IF;
12076:
12077: INSERT INTO EGO_ACTIONS_DL
12078: (
12079: ACTION_ID
12080: ,DATA_LEVEL_ID
12081: ,VISIBILITY_FLAG