APPS.EGO_ODI_PUB dependencies on BOM_EXPLOSIONS_ALL

Line 1403: --Checks the specified security priviledge on all components stored in table BOM_EXPLOSIONS_ALL

1399: END generate_component_error;
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,

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 1573: --Checks the specified security priviledge on all components stored in table BOM_EXPLOSIONS_ALL

1569:
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,

Line 1644: --BOM_EXPLOSIONS_ALL

1640:
1641: BEGIN
1642:
1643: --selecting all components that do not have the publish privilege from table
1644: --BOM_EXPLOSIONS_ALL
1645: /*l_dynamic_sql := ' select e.COMPONENT_ITEM_ID, e.ORGANIZATION_ID, e.group_id ' ||
1646: ' from bom_explosions_all e ' ||
1647: ' where e.group_id = :1 ' ||
1648: ' AND NOT ' || l_sec_predicate;*/

Line 1646: ' from bom_explosions_all e ' ||

1642:
1643: --selecting all components that do not have the publish privilege from table
1644: --BOM_EXPLOSIONS_ALL
1645: /*l_dynamic_sql := ' select e.COMPONENT_ITEM_ID, e.ORGANIZATION_ID, e.group_id ' ||
1646: ' from bom_explosions_all e ' ||
1647: ' where e.group_id = :1 ' ||
1648: ' AND NOT ' || l_sec_predicate;*/
1649:
1650: l_dynamic_sql := ' select count(*) ' ||

Line 1651: ' from bom_explosions_all e ' ||

1647: ' where e.group_id = :1 ' ||
1648: ' AND NOT ' || l_sec_predicate;*/
1649:
1650: l_dynamic_sql := ' select count(*) ' ||
1651: ' from bom_explosions_all e ' ||
1652: ' where e.group_id = :1 ' ||
1653: ' AND NOT ' || l_sec_predicate;
1654:
1655:

Line 4841: from bom_explosions_all be

4837: select rowid row_id,
4838: component_sequence_id,
4839: comp_fixed_revision_id,
4840: parent_comp_seq_id
4841: from bom_explosions_all be
4842: where group_id = p_group_id;
4843:
4844:
4845: BEGIN