APPS.EGO_ODI_PUB dependencies on BOM_ODI_WS_REVISIONS

Line 1404: --pointed by session_id in table BOM_ODI_WS_REVISIONS after all bom explosions have been executed

1400: */
1401:
1402: --OLD PROCEDURE ANALYZING COMPONENTS IN BATCH MODE
1403: --Checks the specified security priviledge on all components stored in table BOM_EXPLOSIONS_ALL
1404: --pointed by session_id in table BOM_ODI_WS_REVISIONS after all bom explosions have been executed
1405: --for all end-items with valid publish privilege in table BOM_ODI_WS_ENTITIES.
1406: --If an item (row) is found not to have the privilege, it is deleted from the table.
1407: /*PROCEDURE check_component_security(p_session_id IN NUMBER,
1408: p_odi_session_id IN NUMBER,

Line 1476: --BOM_EXPLOSIONS_ALL and joining with table BOM_ODI_WS_REVISIONS to update PUBLISH_FLAG

1472:
1473: BEGIN
1474:
1475: --selecting all components that do not have the publish privilege from table
1476: --BOM_EXPLOSIONS_ALL and joining with table BOM_ODI_WS_REVISIONS to update PUBLISH_FLAG
1477: l_dynamic_sql := ' select i.row_id, e.COMPONENT_ITEM_ID, e.ORGANIZATION_ID, i.sequence_number, e.group_id ' ||
1478: ' from bom_explosions_all e, bom_odi_ws_revisions i ' ||
1479: ' where i.session_id = :1 ' ||
1480: 'and e.rowid = i.row_id' ||

Line 1478: ' from bom_explosions_all e, bom_odi_ws_revisions i ' ||

1474:
1475: --selecting all components that do not have the publish privilege from table
1476: --BOM_EXPLOSIONS_ALL and joining with table BOM_ODI_WS_REVISIONS to update PUBLISH_FLAG
1477: l_dynamic_sql := ' select i.row_id, e.COMPONENT_ITEM_ID, e.ORGANIZATION_ID, i.sequence_number, e.group_id ' ||
1478: ' from bom_explosions_all e, bom_odi_ws_revisions i ' ||
1479: ' where i.session_id = :1 ' ||
1480: 'and e.rowid = i.row_id' ||
1481: ' AND NOT ' || l_sec_predicate;
1482:

Line 1530: --set the flag PUBLISH_FLAG to 'N' in table table bom_odi_ws_revisions

1526: --TODO: end
1527:
1528:
1529: --Now that the error messages have been generated,
1530: --set the flag PUBLISH_FLAG to 'N' in table table bom_odi_ws_revisions
1531: --for ecomponents with no publish privilege to prevent their publication.
1532: l_dynamic_update_sql := ' update BOM_ODI_WS_REVISIONS s ' ||
1533: ' set PUBLISH_FLAG = ''N'' ' ||
1534: ' where s.session_id = :1 ' ||

Line 1532: l_dynamic_update_sql := ' update BOM_ODI_WS_REVISIONS s ' ||

1528:
1529: --Now that the error messages have been generated,
1530: --set the flag PUBLISH_FLAG to 'N' in table table bom_odi_ws_revisions
1531: --for ecomponents with no publish privilege to prevent their publication.
1532: l_dynamic_update_sql := ' update BOM_ODI_WS_REVISIONS s ' ||
1533: ' set PUBLISH_FLAG = ''N'' ' ||
1534: ' where s.session_id = :1 ' ||
1535: ' AND nvl(s.PUBLISH_FLAG, ''Y'') = ''Y'' ' ||
1536: ' AND s.row_id =:2';

Line 1574: --pointed by session_id in table BOM_ODI_WS_REVISIONS after all bom explosions have been executed

1570: END check_component_security;*/
1571:
1572:
1573: --Checks the specified security priviledge on all components stored in table BOM_EXPLOSIONS_ALL
1574: --pointed by session_id in table BOM_ODI_WS_REVISIONS after all bom explosions have been executed
1575: --for all end-items with valid publish privilege in table BOM_ODI_WS_ENTITIES.
1576: --If an item (row) is found not to have the privilege, it is deleted from the table.
1577: PROCEDURE check_component_security(p_session_id IN NUMBER,
1578: p_odi_session_id IN NUMBER,

Line 5042: INTO bom_odi_ws_revisions(

5038: l_comp_parent_rev :=NULL;
5039: END IF;
5040:
5041: INSERT
5042: INTO bom_odi_ws_revisions(
5043: session_id,
5044: --group_id,
5045: --component_sequence_id,
5046: row_id,