32: begin
33:
34: SELECT APPLICATION_ID
35: INTO l_application_id
36: FROM FND_APPLICATION_VL
37: WHERE APPLICATION_SHORT_NAME = 'MSC'
38: and rownum = 1;
39:
40: -- first try to see if current destination responsibility exists in source
67: exception when no_data_found then
68:
69: SELECT APPLICATION_ID
70: INTO l_application_id
71: FROM FND_APPLICATION_VL
72: WHERE APPLICATION_SHORT_NAME = 'MRP'
73: and rownum = 1;
74:
75: SELECT responsibility_id
204: where user_name= p_user_name; -- here I can pass any userid
205:
206: SELECT APPLICATION_ID
207: INTO l_application_id
208: FROM FND_APPLICATION_VL
209: WHERE APPLICATION_SHORT_NAME ='PJM'
210: and rownum = 1;
211:
212: SELECT responsibility_id
309: where user_name= p_user_name; -- here I can pass any userid
310:
311: SELECT APPLICATION_ID
312: INTO l_application_id
313: FROM FND_APPLICATION_VL
314: WHERE APPLICATION_SHORT_NAME ='PJM'
315: and rownum = 1;
316:
317: SELECT responsibility_id
378: where user_name = p_user_name;
379:
380: select application_id
381: into l_appl_id
382: from fnd_application_vl
383: where application_short_name = p_appl_name;
384:
385: select responsibility_id
386: into l_resp_id