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 2881: l_dyn_sql := l_dyn_sql || ' FROM eng_engineering_changes eec ' ;

2877:
2878: l_dyn_sql := '' ;
2879: l_dyn_sql := ' UPDATE ' || l_intf_table(i) || ' INTF ';
2880: l_dyn_sql := l_dyn_sql || ' SET change_id = NVL(( SELECT eec.change_id ' ;
2881: l_dyn_sql := l_dyn_sql || ' FROM eng_engineering_changes eec ' ;
2882: l_dyn_sql := l_dyn_sql || ' WHERE eec.organization_id = INTF.organization_id ' ;
2883: l_dyn_sql := l_dyn_sql || ' AND eec.change_notice = INTF.' || l_intf_change_number_col(i) ;
2884: l_dyn_sql := l_dyn_sql || ' ) , -100) ' ;
2885: l_dyn_sql := l_dyn_sql || ' WHERE INTF.' || l_intf_batch_id_col(i) || ' = :BATCH_ID ' ;

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

2894: Write_Debug('Populate CO Id from the batch details. . .' );
2895: l_dyn_sql := '' ;
2896: l_dyn_sql := ' UPDATE ' || l_intf_table(i) || ' INTF ';
2897: l_dyn_sql := l_dyn_sql || ' SET change_id = NVL(( SELECT eec.change_id ' ;
2898: l_dyn_sql := l_dyn_sql || ' FROM eng_engineering_changes eec ' ;
2899: l_dyn_sql := l_dyn_sql || ' WHERE eec.organization_id = INTF.organization_id ' ;
2900: l_dyn_sql := l_dyn_sql || ' AND eec.change_notice = ''' || p_change_number ||'''';
2901: l_dyn_sql := l_dyn_sql || ' ) , -100) ' ;
2902: l_dyn_sql := l_dyn_sql || ' WHERE INTF.' || l_intf_batch_id_col(i) || ' = :BATCH_ID ' ;

Line 3956: l_change_id ENG_ENGINEERING_CHANGES.CHANGE_ID%TYPE;

3952: , p_revision_import_policy IN VARCHAR2 := NULL
3953: )
3954: RETURN NUMBER
3955: IS
3956: l_change_id ENG_ENGINEERING_CHANGES.CHANGE_ID%TYPE;
3957: BEGIN
3958: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE change_notice = p_change_notice AND organization_id = p_organization_id;
3959:
3960: RETURN FIND_REV_ITEM_REC ( p_change_id => l_change_id

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

3954: RETURN NUMBER
3955: IS
3956: l_change_id ENG_ENGINEERING_CHANGES.CHANGE_ID%TYPE;
3957: BEGIN
3958: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE change_notice = p_change_notice AND organization_id = p_organization_id;
3959:
3960: RETURN FIND_REV_ITEM_REC ( p_change_id => l_change_id
3961: , p_organization_id => p_organization_id
3962: , p_revised_item_id => p_revised_item_id

Line 5340: l_change_number ENG_ENGINEERING_CHANGES.CHANGE_NOTICE%TYPE;

5336: and CHANGE_ID = c_change_id
5337: ;
5338:
5339: --Begin code change for bug 9398720
5340: l_change_number ENG_ENGINEERING_CHANGES.CHANGE_NOTICE%TYPE;
5341:
5342: CURSOR get_change_number(c_change_id NUMBER)
5343: IS
5344: SELECT CHANGE_NOTICE

Line 5345: FROM ENG_ENGINEERING_CHANGES

5341:
5342: CURSOR get_change_number(c_change_id NUMBER)
5343: IS
5344: SELECT CHANGE_NOTICE
5345: FROM ENG_ENGINEERING_CHANGES
5346: WHERE CHANGE_ID = c_change_id;
5347: --End code change for bug 9398720
5348:
5349: BEGIN