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_WORKFLOW_UTIL dependencies on FND_USER

Line 410: FROM FND_USER

406: ELSE
407:
408: SELECT user_name
409: INTO l_user_name
410: FROM FND_USER
411: WHERE user_id = p_user_id ;
412:
413: END IF ;
414:

Line 2676: -- Fnd User's User Name

2672: IS
2673:
2674: BEGIN
2675:
2676: -- Fnd User's User Name
2677: SELECT owner_role
2678: INTO x_item_owner_role
2679: FROM WF_ITEMS
2680: WHERE item_type = p_item_type

Line 7570: FROM FND_USER fu

7566:
7567: CURSOR c_ntf (p_notification_id NUMBER)
7568: IS
7569: SELECT fu.user_id
7570: FROM FND_USER fu
7571: , WF_NOTIFICATIONS wn
7572: WHERE fu.user_name = wn.recipient_role
7573: AND wn.notification_id = p_notification_id ;
7574:

Line 11343: l_fnd_user_id NUMBER ;

11339: IS
11340:
11341: l_api_name CONSTANT VARCHAR2(30) := 'SetChangeOrderMRPFlag';
11342:
11343: l_fnd_user_id NUMBER ;
11344: l_fnd_login_id NUMBER ;
11345: l_base_cm_type_code VARCHAR2(30) ;
11346:
11347: BEGIN

Line 11374: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

11370: IF g_debug_flag THEN
11371: Write_Debug('Change Object is Change Order');
11372: END IF ;
11373:
11374: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
11375: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
11376:
11377: -- FND_PROFILE package is not available for workflow (WF),
11378: -- therefore manually set WHO column values

Line 11381: l_fnd_user_id := p_wf_user_id ;

11377: -- FND_PROFILE package is not available for workflow (WF),
11378: -- therefore manually set WHO column values
11379: IF p_api_caller = 'WF'
11380: THEN
11381: l_fnd_user_id := p_wf_user_id ;
11382: l_fnd_login_id := '' ;
11383: END IF;
11384:
11385: -- Put dummy fnd user id if it's still null

Line 11385: -- Put dummy fnd user id if it's still null

11381: l_fnd_user_id := p_wf_user_id ;
11382: l_fnd_login_id := '' ;
11383: END IF;
11384:
11385: -- Put dummy fnd user id if it's still null
11386: IF l_fnd_user_id IS NULL
11387: THEN
11388: l_fnd_user_id := -10000;
11389: END IF ;

Line 11386: IF l_fnd_user_id IS NULL

11382: l_fnd_login_id := '' ;
11383: END IF;
11384:
11385: -- Put dummy fnd user id if it's still null
11386: IF l_fnd_user_id IS NULL
11387: THEN
11388: l_fnd_user_id := -10000;
11389: END IF ;
11390:

Line 11388: l_fnd_user_id := -10000;

11384:
11385: -- Put dummy fnd user id if it's still null
11386: IF l_fnd_user_id IS NULL
11387: THEN
11388: l_fnd_user_id := -10000;
11389: END IF ;
11390:
11391: UPDATE eng_revised_items
11392: SET mrp_active = p_mrp_flag

Line 11394: , last_updated_by = l_fnd_user_id

11390:
11391: UPDATE eng_revised_items
11392: SET mrp_active = p_mrp_flag
11393: , last_update_date = SYSDATE
11394: , last_updated_by = l_fnd_user_id
11395: , last_update_login = l_fnd_login_id
11396: WHERE change_id = p_change_id
11397: AND status_type in (0, 1, 4, 7, 8) ;
11398:

Line 13268: --l_fnd_user_id NUMBER ;

13264: l_response_code VARCHAR2(30);
13265: l_comment VARCHAR2(4000);
13266:
13267: --l_party_id NUMBER;
13268: --l_fnd_user_id NUMBER ;
13269: --l_fnd_login_id NUMBER ;
13270:
13271: l_performer_user_id NUMBER;
13272: l_performer_party_id NUMBER;