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 11267: l_fnd_user_id NUMBER ;

11263: IS
11264:
11265: l_api_name CONSTANT VARCHAR2(30) := 'SetChangeOrderMRPFlag';
11266:
11267: l_fnd_user_id NUMBER ;
11268: l_fnd_login_id NUMBER ;
11269: l_base_cm_type_code VARCHAR2(30) ;
11270:
11271: BEGIN

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

11294: IF g_debug_flag THEN
11295: Write_Debug('Change Object is Change Order');
11296: END IF ;
11297:
11298: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
11299: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
11300:
11301: -- FND_PROFILE package is not available for workflow (WF),
11302: -- therefore manually set WHO column values

Line 11305: l_fnd_user_id := p_wf_user_id ;

11301: -- FND_PROFILE package is not available for workflow (WF),
11302: -- therefore manually set WHO column values
11303: IF p_api_caller = 'WF'
11304: THEN
11305: l_fnd_user_id := p_wf_user_id ;
11306: l_fnd_login_id := '' ;
11307: END IF;
11308:
11309: -- Put dummy fnd user id if it's still null

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

11305: l_fnd_user_id := p_wf_user_id ;
11306: l_fnd_login_id := '' ;
11307: END IF;
11308:
11309: -- Put dummy fnd user id if it's still null
11310: IF l_fnd_user_id IS NULL
11311: THEN
11312: l_fnd_user_id := -10000;
11313: END IF ;

Line 11310: IF l_fnd_user_id IS NULL

11306: l_fnd_login_id := '' ;
11307: END IF;
11308:
11309: -- Put dummy fnd user id if it's still null
11310: IF l_fnd_user_id IS NULL
11311: THEN
11312: l_fnd_user_id := -10000;
11313: END IF ;
11314:

Line 11312: l_fnd_user_id := -10000;

11308:
11309: -- Put dummy fnd user id if it's still null
11310: IF l_fnd_user_id IS NULL
11311: THEN
11312: l_fnd_user_id := -10000;
11313: END IF ;
11314:
11315: UPDATE eng_revised_items
11316: SET mrp_active = p_mrp_flag

Line 11318: , last_updated_by = l_fnd_user_id

11314:
11315: UPDATE eng_revised_items
11316: SET mrp_active = p_mrp_flag
11317: , last_update_date = SYSDATE
11318: , last_updated_by = l_fnd_user_id
11319: , last_update_login = l_fnd_login_id
11320: WHERE change_id = p_change_id
11321: AND status_type in (0, 1, 4, 7, 8) ;
11322:

Line 13192: --l_fnd_user_id NUMBER ;

13188: l_response_code VARCHAR2(30);
13189: l_comment VARCHAR2(4000);
13190:
13191: --l_party_id NUMBER;
13192: --l_fnd_user_id NUMBER ;
13193: --l_fnd_login_id NUMBER ;
13194:
13195: l_performer_user_id NUMBER;
13196: l_performer_party_id NUMBER;