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_LIFECYCLE_UTIL dependencies on ENG_STATUS_PROPERTIES

Line 3190: FROM eng_status_properties

3186: l_new_route_id NUMBER;
3187:
3188: CURSOR c_statusProp IS
3189: SELECT *
3190: FROM eng_status_properties
3191: WHERE change_lifecycle_status_id = l_old_row_id
3192: FOR UPDATE;
3193: l_status_prop_row eng_status_properties%ROWTYPE;
3194:

Line 3193: l_status_prop_row eng_status_properties%ROWTYPE;

3189: SELECT *
3190: FROM eng_status_properties
3191: WHERE change_lifecycle_status_id = l_old_row_id
3192: FOR UPDATE;
3193: l_status_prop_row eng_status_properties%ROWTYPE;
3194:
3195: CURSOR c_revItems IS
3196: SELECT status_code
3197: FROM eng_revised_items

Line 3459: -- Before insertion, update all the corresponding rows in eng_status_properties table

3455: -- populate completion_date to null for all new phase rows
3456: l_lcStatuses_row.completion_date := null;
3457:
3458:
3459: -- Before insertion, update all the corresponding rows in eng_status_properties table
3460: OPEN c_statusProp;
3461: LOOP
3462: FETCH c_statusProp INTO l_status_prop_row;
3463: EXIT WHEN c_statusProp%NOTFOUND;

Line 3464: UPDATE eng_status_properties

3460: OPEN c_statusProp;
3461: LOOP
3462: FETCH c_statusProp INTO l_status_prop_row;
3463: EXIT WHEN c_statusProp%NOTFOUND;
3464: UPDATE eng_status_properties
3465: SET change_lifecycle_status_id = l_new_row_id,
3466: last_update_date = sysdate,
3467: last_updated_by = l_fnd_user_id,
3468: last_update_login = l_fnd_login_id

Line 3473: Write_Debug('After updating eng_status_properties row''s change_lifecycle_status_id');

3469: WHERE current of c_statusProp;
3470: END LOOP;
3471: CLOSE c_statusProp;
3472: IF g_debug_flag THEN
3473: Write_Debug('After updating eng_status_properties row''s change_lifecycle_status_id');
3474: END IF;
3475:
3476: -- Insert the new phase row
3477: /* Only Oracle 9.2+ supports this directly row insertion feature

Line 8244: INSERT INTO ENG_STATUS_PROPERTIES

8240: END IF ;
8241:
8242: -- Add LC Phase Properties for reocrds for active_flag S
8243: -- Inserting the status properties
8244: INSERT INTO ENG_STATUS_PROPERTIES
8245: (
8246: CHANGE_LIFECYCLE_STATUS_ID
8247: , STATUS_CODE
8248: , PROMOTION_STATUS_FLAG

Line 8264: FROM ENG_STATUS_PROPERTIES phase_prop_setup

8260: , l_fnd_user_id
8261: , SYSDATE
8262: , l_fnd_user_id
8263: , l_fnd_login_id
8264: FROM ENG_STATUS_PROPERTIES phase_prop_setup
8265: , ENG_LIFECYCLE_STATUSES lc_phase_setup
8266: , ENG_LIFECYCLE_STATUSES lc_phase
8267: , ENG_ENGINEERING_CHANGES ch
8268: WHERE lc_phase_setup.entity_id1 = p_change_type_id