eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ODI_PUB dependencies on BOM_ODI_WS_ENTITIES

Line 1165: --Checks the specified security priviledge on items stored in table BOM_ODI_WS_ENTITIES.

1161:
1162: END Init_Security_Structure;
1163:
1164:
1165: --Checks the specified security priviledge on items stored in table BOM_ODI_WS_ENTITIES.
1166: --If an item (row) is found not to have the privilege, the PUBLISH_FLAG columns is set to 'N'
1167: --so the end-item data is not published by ODI interfaces.
1168: PROCEDURE check_end_item_security(p_session_id IN NUMBER,
1169: p_odi_session_id IN NUMBER,

Line 1237: --BOM_ODI_WS_ENTITIES

1233:
1234: BEGIN
1235:
1236: --selecting all end-items that do not have the publish privilege from table
1237: --BOM_ODI_WS_ENTITIES
1238: l_dynamic_sql := ' select ITEM_ID, ITEM_ORG_ID, ITEM_REV, SEQUENCE_NUMBER ' ||
1239: ' from BOM_ODI_WS_ENTITIES i ' ||
1240: ' where i.session_id = :1 ' ||
1241: ' AND NOT ' || l_sec_predicate;

Line 1239: ' from BOM_ODI_WS_ENTITIES i ' ||

1235:
1236: --selecting all end-items that do not have the publish privilege from table
1237: --BOM_ODI_WS_ENTITIES
1238: l_dynamic_sql := ' select ITEM_ID, ITEM_ORG_ID, ITEM_REV, SEQUENCE_NUMBER ' ||
1239: ' from BOM_ODI_WS_ENTITIES i ' ||
1240: ' where i.session_id = :1 ' ||
1241: ' AND NOT ' || l_sec_predicate;
1242:
1243: --remove

Line 1291: --set the flag PUBLISH_FLAG to 'N' in table table BOM_ODI_WS_ENTITIES

1287: END; -- end of BEGIN
1288:
1289:
1290: --Now that the error messages have been generated,
1291: --set the flag PUBLISH_FLAG to 'N' in table table BOM_ODI_WS_ENTITIES
1292: --for end-items with no publish privilege to prevent their publication.
1293: /*l_dynamic_update_sql := ' delete from BOM_ODI_WS_ENTITIES i ' ||
1294: ' where i.session_id = :1 ' ||
1295: ' AND NOT ' || l_sec_predicate;*/

Line 1293: /*l_dynamic_update_sql := ' delete from BOM_ODI_WS_ENTITIES i ' ||

1289:
1290: --Now that the error messages have been generated,
1291: --set the flag PUBLISH_FLAG to 'N' in table table BOM_ODI_WS_ENTITIES
1292: --for end-items with no publish privilege to prevent their publication.
1293: /*l_dynamic_update_sql := ' delete from BOM_ODI_WS_ENTITIES i ' ||
1294: ' where i.session_id = :1 ' ||
1295: ' AND NOT ' || l_sec_predicate;*/
1296:
1297: l_dynamic_update_sql := ' update BOM_ODI_WS_ENTITIES i ' ||

Line 1297: l_dynamic_update_sql := ' update BOM_ODI_WS_ENTITIES i ' ||

1293: /*l_dynamic_update_sql := ' delete from BOM_ODI_WS_ENTITIES i ' ||
1294: ' where i.session_id = :1 ' ||
1295: ' AND NOT ' || l_sec_predicate;*/
1296:
1297: l_dynamic_update_sql := ' update BOM_ODI_WS_ENTITIES i ' ||
1298: ' set PUBLISH_FLAG = ''N'' ' ||
1299: ' where i.session_id = :1 ' ||
1300: ' AND nvl(i.PUBLISH_FLAG, ''Y'') = ''Y'' ' ||
1301: ' AND NOT ' || l_sec_predicate;

Line 1326: FOR i IN (SELECT item_id, item_org_id, item_rev FROM BOM_ODI_WS_ENTITIES

1322: --selecting end-item for a given component based on group_id
1323: --
1324: -- For exploded items give error message wrt to its structure.
1325: -- So, the following query retreives the end-items for the component
1326: FOR i IN (SELECT item_id, item_org_id, item_rev FROM BOM_ODI_WS_ENTITIES
1327: where group_id = l_group_id and session_id = p_session_id)
1328:
1329: --(SELECT pk1_value, pk2_value, pk3_value FROM EGO_ODI_WS_ENTITIES ent1
1330: -- WHERE session_id = p_session_id and

Line 1405: --for all end-items with valid publish privilege in table BOM_ODI_WS_ENTITIES.

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,
1409: p_priv_check IN VARCHAR2,

Line 1575: --for all end-items with valid publish privilege in table BOM_ODI_WS_ENTITIES.

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,
1579: p_priv_check IN VARCHAR2,

Line 1677: l_dynamic_update_sql := ' update BOM_ODI_WS_ENTITIES i ' ||

1673: p_err_code => 'EGO_NO_PUBLISH_PRIV',
1674: p_err_message => 'User does not have the publilsh privilege on few components of the structure for the item');
1675:
1676: --UPDATE END-ITEM WITH PUBLISH_FLAG = 'N' TO PREVENT ITS PUBLICATION
1677: l_dynamic_update_sql := ' update BOM_ODI_WS_ENTITIES i ' ||
1678: ' set PUBLISH_FLAG = ''N'' ' ||
1679: ' where i.session_id = :1 ' ||
1680: ' and i.odi_session_id = :2 ' ||
1681: ' and i.item_id = :3 ' ||

Line 2819: --procedure that populates ODI input table BOM_ODI_WS_ENTITIES for

2815:
2816:
2817:
2818:
2819: --procedure that populates ODI input table BOM_ODI_WS_ENTITIES for
2820: --getItemStructure web service depending on the web service invocation mode
2821: --('BATCH','HMDM','LIST'). The input data is obtained from the following
2822: --sources depending on the invocation mode:
2823: --MODE='BATCH': input data obtained from Publication Framework tables

Line 3072: INTO BOM_ODI_WS_ENTITIES(

3068: --END VALIDATIONS-----------------------
3069:
3070:
3071: INSERT
3072: INTO BOM_ODI_WS_ENTITIES(
3073: session_id,
3074: odi_session_id,
3075: ITEM_ID,
3076: ITEM_ORG_ID,

Line 3230: INTO BOM_ODI_WS_ENTITIES(

3226: --if item is valid, insert to input table, otherwise generate warning
3227: IF l_is_item_id_valid = TRUE THEN
3228:
3229: INSERT
3230: INTO BOM_ODI_WS_ENTITIES(
3231: session_id,
3232: odi_session_id,
3233: ITEM_ID,
3234: ITEM_ORG_ID,

Line 3399: INTO BOM_ODI_WS_ENTITIES(

3395: raise_application_error(-20104, 'Invalid Revision Date');
3396: END IF;*/
3397:
3398: INSERT
3399: INTO BOM_ODI_WS_ENTITIES(
3400: session_id,
3401: odi_session_id,
3402: ITEM_ID,
3403: ITEM_ORG_ID,

Line 3961: INTO BOM_ODI_WS_ENTITIES(

3957: --END VALIDATIONS-----------------------
3958:
3959:
3960: INSERT
3961: INTO BOM_ODI_WS_ENTITIES(
3962: session_id,
3963: odi_session_id,
3964: ITEM_ID,
3965: ITEM_ORG_ID,

Line 4829: FROM BOM_ODI_WS_ENTITIES

4825: ITEM_REV_CODE,
4826: structure_name,
4827: explosion_date,
4828: sequence_number
4829: FROM BOM_ODI_WS_ENTITIES
4830: WHERE session_id = p_session_id
4831: and odi_session_id = p_odi_session_id
4832: and PUBLISH_FLAG = 'Y';
4833:

Line 4852: --from BOM_ODI_WS_ENTITIES table.

4848: Init_Security_Structure(p_session_id, p_odi_session_id);
4849:
4850: --Check on the publish privilege for the end-items.
4851: --If end-item has no publish privilege, then remove end-item
4852: --from BOM_ODI_WS_ENTITIES table.
4853: check_end_item_security(p_session_id => p_session_id,
4854: p_odi_session_id => p_odi_session_id,
4855: p_priv_check => 'EGO_PUBLISH_ITEM',
4856: p_for_exploded_items => 'Y',

Line 4988: UPDATE BOM_ODI_WS_ENTITIES

4984: */
4985: NULL;
4986: END IF;
4987:
4988: UPDATE BOM_ODI_WS_ENTITIES
4989: SET group_id = x_group_id,
4990: EXPLOSION_DATE = bom_exploder_pub.get_explosion_date,
4991: EXPLOSION_OPTION = bom_exploder_pub.get_explode_option,
4992: ITEM_REV_CODE = bom_exploder_pub.get_expl_end_item_rev_code,