DBA Data[Home] [Help]

APPS.MSC_WS_ATP dependencies on FND_RESPONSIBILITY

Line 532: SELECT responsibility_id, application_id INTO respId, appId FROM fnd_responsibility WHERE responsibility_key = 'SYSTEM_ADMINISTRATOR';

528:
529:
530:
531: ----------STEP 3 -- apps initialize for system_administrator , just so we can get profiles values
532: SELECT responsibility_id, application_id INTO respId, appId FROM fnd_responsibility WHERE responsibility_key = 'SYSTEM_ADMINISTRATOR';
533: error_tracking_number:= 110;
534:
535: SELECT user_id INTO userId FROM fnd_user WHERE user_name = 'SYSADMIN';
536:

Line 548: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;

544: respId := fnd_profile.value('MSC_WS_ATP_FNDRESP');
545:
546: error_tracking_number:= 150;
547: begin
548: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;
549: EXCEPTION
550: WHEN others THEN
551: RAISE atpProfilesError;
552: end;