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.ENG_CHANGE_IMPORT_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 2872: l_dyn_sql := l_dyn_sql || ' FROM eng_engineering_changes eec ' ;

2868:
2869: l_dyn_sql := '' ;
2870: l_dyn_sql := ' UPDATE ' || l_intf_table(i) || ' INTF ';
2871: l_dyn_sql := l_dyn_sql || ' SET change_id = NVL(( SELECT eec.change_id ' ;
2872: l_dyn_sql := l_dyn_sql || ' FROM eng_engineering_changes eec ' ;
2873: l_dyn_sql := l_dyn_sql || ' WHERE eec.organization_id = INTF.organization_id ' ;
2874: l_dyn_sql := l_dyn_sql || ' AND eec.change_notice = INTF.' || l_intf_change_number_col(i) ;
2875: l_dyn_sql := l_dyn_sql || ' ) , -100) ' ;
2876: l_dyn_sql := l_dyn_sql || ' WHERE INTF.' || l_intf_batch_id_col(i) || ' = :BATCH_ID ' ;

Line 2889: l_dyn_sql := l_dyn_sql || ' FROM eng_engineering_changes eec ' ;

2885: Write_Debug('Populate CO Id from the batch details. . .' );
2886: l_dyn_sql := '' ;
2887: l_dyn_sql := ' UPDATE ' || l_intf_table(i) || ' INTF ';
2888: l_dyn_sql := l_dyn_sql || ' SET change_id = NVL(( SELECT eec.change_id ' ;
2889: l_dyn_sql := l_dyn_sql || ' FROM eng_engineering_changes eec ' ;
2890: l_dyn_sql := l_dyn_sql || ' WHERE eec.organization_id = INTF.organization_id ' ;
2891: l_dyn_sql := l_dyn_sql || ' AND eec.change_notice = ''' || p_change_number ||'''';
2892: l_dyn_sql := l_dyn_sql || ' ) , -100) ' ;
2893: l_dyn_sql := l_dyn_sql || ' WHERE INTF.' || l_intf_batch_id_col(i) || ' = :BATCH_ID ' ;

Line 3850: l_change_id ENG_ENGINEERING_CHANGES.CHANGE_ID%TYPE;

3846: , p_revision_import_policy IN VARCHAR2 := NULL
3847: )
3848: RETURN NUMBER
3849: IS
3850: l_change_id ENG_ENGINEERING_CHANGES.CHANGE_ID%TYPE;
3851: BEGIN
3852: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE change_notice = p_change_notice AND organization_id = p_organization_id;
3853:
3854: RETURN FIND_REV_ITEM_REC ( p_change_id => l_change_id

Line 3852: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE change_notice = p_change_notice AND organization_id = p_organization_id;

3848: RETURN NUMBER
3849: IS
3850: l_change_id ENG_ENGINEERING_CHANGES.CHANGE_ID%TYPE;
3851: BEGIN
3852: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE change_notice = p_change_notice AND organization_id = p_organization_id;
3853:
3854: RETURN FIND_REV_ITEM_REC ( p_change_id => l_change_id
3855: , p_organization_id => p_organization_id
3856: , p_revised_item_id => p_revised_item_id