26:
27: BEGIN
28: select user_id
29: into l_user_id
30: from fnd_user
31: where user_name = p_user_name;
32: begin
33:
34: SELECT APPLICATION_ID
199: -- can not use init_source because pjm requires only Project Manufacturing
200: --specific resp and application set up.
201: select user_id
202: INTO l_user_id
203: FROM fnd_user
204: where user_name= p_user_name; -- here I can pass any userid
205:
206: SELECT APPLICATION_ID
207: INTO l_application_id
304: -- can not use init_source because pjm requires only Project Manufacturing specific resp and application set up.
305:
306: select user_id
307: INTO l_user_id
308: FROM fnd_user
309: where user_name= p_user_name; -- here I can pass any userid
310:
311: SELECT APPLICATION_ID
312: INTO l_application_id
373: begin
374:
375: select user_id
376: into l_user_id
377: from fnd_user
378: where user_name = p_user_name;
379:
380: select application_id
381: into l_appl_id