[Home] [Help]
1343: l_user_id number;
1344:
1345: -- determine the application from the responsibility
1346: cursor C_appl_id(p_resp_id in number) is
1347: select application_id from fnd_responsibility
1348: where responsibility_id = p_resp_id;
1349:
1350: -- determine the userid given the username
1351: cursor C_user_id(p_username in varchar2) is
1353: where user_name = p_username;
1354:
1355: -- determine whether or not the resp id corresponds to "jtf_pending_approval"
1356: cursor C_is_pending_resp(p_resp_id in number, p_appl_id in number) is
1357: select responsibility_id from fnd_responsibility
1358: where application_id = 690
1359: and responsibility_key = 'JTF_PENDING_APPROVAL';
1360:
1361: -- select default responsibility for the usertype
1359: and responsibility_key = 'JTF_PENDING_APPROVAL';
1360:
1361: -- select default responsibility for the usertype
1362: cursor c_default_resp(p_user_id in number) is
1363: select fnd.responsibility_id, fnd.application_id
1364: from jtf_um_usertype_reg reg,
1365: jtf_um_usertype_resp resp,
1366: fnd_responsibility fnd
1367: where reg.user_id = p_user_id
1362: cursor c_default_resp(p_user_id in number) is
1363: select fnd.responsibility_id, fnd.application_id
1364: from jtf_um_usertype_reg reg,
1365: jtf_um_usertype_resp resp,
1366: fnd_responsibility fnd
1367: where reg.user_id = p_user_id
1368: and reg.usertype_id = resp.usertype_id
1369: and resp.responsibility_key = fnd.responsibility_key
1370: and resp.application_id = fnd.application_id;
1365: jtf_um_usertype_resp resp,
1366: fnd_responsibility fnd
1367: where reg.user_id = p_user_id
1368: and reg.usertype_id = resp.usertype_id
1369: and resp.responsibility_key = fnd.responsibility_key
1370: and resp.application_id = fnd.application_id;
1371:
1372: -- using hardcoded value
1373: l_pending_appr_resp_id number := null;