APPS.ARI_DB_UTILITIES dependencies on FND_RESPONSIBILITY_VL

Line 1157: appl_id fnd_responsibility_vl.application_id%type;

1153: p_customer_site_id IN VARCHAR2,
1154: p_request_id OUT NOCOPY NUMBER
1155: ) IS
1156:
1157: appl_id fnd_responsibility_vl.application_id%type;
1158: resp_id fnd_responsibility_vl.responsibility_id%type;
1159: resp_name fnd_responsibility_vl.responsibility_name%type;
1160: user_id fnd_user.user_id%type;
1161: user_name fnd_user.user_name%type;

Line 1158: resp_id fnd_responsibility_vl.responsibility_id%type;

1154: p_request_id OUT NOCOPY NUMBER
1155: ) IS
1156:
1157: appl_id fnd_responsibility_vl.application_id%type;
1158: resp_id fnd_responsibility_vl.responsibility_id%type;
1159: resp_name fnd_responsibility_vl.responsibility_name%type;
1160: user_id fnd_user.user_id%type;
1161: user_name fnd_user.user_name%type;
1162: l_request_id NUMBER(30);

Line 1159: resp_name fnd_responsibility_vl.responsibility_name%type;

1155: ) IS
1156:
1157: appl_id fnd_responsibility_vl.application_id%type;
1158: resp_id fnd_responsibility_vl.responsibility_id%type;
1159: resp_name fnd_responsibility_vl.responsibility_name%type;
1160: user_id fnd_user.user_id%type;
1161: user_name fnd_user.user_name%type;
1162: l_request_id NUMBER(30);
1163: l_message VARCHAR2(2000);

Line 1188: from fnd_responsibility_vl

1184:
1185: /* Get the environment set up and profiles set for logging */
1186: select application_id, responsibility_id, responsibility_name
1187: into appl_id, resp_id, resp_name
1188: from fnd_responsibility_vl
1189: where responsibility_name = p_resp_name;
1190:
1191: select user_id, user_name
1192: into user_id, user_name