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_ECO_PUB dependencies on ENG_ENGINEERING_CHANGES

Line 886: FUNCTION GET_NEXT_CHANGE_NUMBER(p_type_id NUMBER) RETURN eng_engineering_changes.CHANGE_NOTICE%TYPE

882: --Added for bug 5862743
883: -- Whenever a change number is required, lock the row, get the values, update the row
884: -- and commit the transaction. A new transaction is started here as we need to keep the lock
885: -- for as short duration as possible...
886: FUNCTION GET_NEXT_CHANGE_NUMBER(p_type_id NUMBER) RETURN eng_engineering_changes.CHANGE_NOTICE%TYPE
887: IS
888: PRAGMA AUTONOMOUS_TRANSACTION;
889: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
890: BEGIN

Line 889: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;

885: -- for as short duration as possible...
886: FUNCTION GET_NEXT_CHANGE_NUMBER(p_type_id NUMBER) RETURN eng_engineering_changes.CHANGE_NOTICE%TYPE
887: IS
888: PRAGMA AUTONOMOUS_TRANSACTION;
889: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
890: BEGIN
891: select alpha_prefix||next_available_number
892: INTO l_change_number
893: from eng_auto_number_ecn

Line 922: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;

918: RETURN VARCHAR2 IS
919:
920: l_type_id NUMBER;
921: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;
922: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
923:
924: -- Added for Bug 3542172
925:
926: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;