eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OID_SUBSCRIPTIONS dependencies on FND_RESPONSIBILITY

Line 1253: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type

1249: end if;
1250: end hz_create_update;
1251: --
1252: -------------------------------------------------------------------------------
1253: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type
1254: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1255: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1256:
1257: l_module_source varchar2(256);

Line 1254: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type

1250: end hz_create_update;
1251: --
1252: -------------------------------------------------------------------------------
1253: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type
1254: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1255: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1256:
1257: l_module_source varchar2(256);
1258: l_responsibility_id fnd_responsibility.responsibility_id%type;

Line 1255: , x_application_id out nocopy fnd_responsibility.application_id%type) is

1251: --
1252: -------------------------------------------------------------------------------
1253: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type
1254: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1255: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1256:
1257: l_module_source varchar2(256);
1258: l_responsibility_id fnd_responsibility.responsibility_id%type;
1259: l_application_id fnd_responsibility.application_id%type;

Line 1258: l_responsibility_id fnd_responsibility.responsibility_id%type;

1254: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1255: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1256:
1257: l_module_source varchar2(256);
1258: l_responsibility_id fnd_responsibility.responsibility_id%type;
1259: l_application_id fnd_responsibility.application_id%type;
1260: l_found boolean;
1261:
1262: cursor cur_fnd_responsibility is

Line 1259: l_application_id fnd_responsibility.application_id%type;

1255: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1256:
1257: l_module_source varchar2(256);
1258: l_responsibility_id fnd_responsibility.responsibility_id%type;
1259: l_application_id fnd_responsibility.application_id%type;
1260: l_found boolean;
1261:
1262: cursor cur_fnd_responsibility is
1263: SELECT responsibility_id, application_id

Line 1262: cursor cur_fnd_responsibility is

1258: l_responsibility_id fnd_responsibility.responsibility_id%type;
1259: l_application_id fnd_responsibility.application_id%type;
1260: l_found boolean;
1261:
1262: cursor cur_fnd_responsibility is
1263: SELECT responsibility_id, application_id
1264: from fnd_responsibility
1265: where RESPONSIBILITY_KEY = p_resp_key;
1266: begin

Line 1264: from fnd_responsibility

1260: l_found boolean;
1261:
1262: cursor cur_fnd_responsibility is
1263: SELECT responsibility_id, application_id
1264: from fnd_responsibility
1265: where RESPONSIBILITY_KEY = p_resp_key;
1266: begin
1267: l_module_source := G_MODULE_SOURCE || 'get_resp_app_id ';
1268:

Line 1274: open cur_fnd_responsibility;

1270: then
1271: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1272: end if;
1273:
1274: open cur_fnd_responsibility;
1275: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;
1276: l_found := cur_fnd_responsibility%found;
1277:
1278: if (not l_found)

Line 1275: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;

1271: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1272: end if;
1273:
1274: open cur_fnd_responsibility;
1275: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;
1276: l_found := cur_fnd_responsibility%found;
1277:
1278: if (not l_found)
1279: then

Line 1276: l_found := cur_fnd_responsibility%found;

1272: end if;
1273:
1274: open cur_fnd_responsibility;
1275: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;
1276: l_found := cur_fnd_responsibility%found;
1277:
1278: if (not l_found)
1279: then
1280: l_responsibility_id := null;

Line 1283: close cur_fnd_responsibility;

1279: then
1280: l_responsibility_id := null;
1281: l_application_id := null;
1282: end if;
1283: close cur_fnd_responsibility;
1284:
1285: x_responsibility_id := l_responsibility_id;
1286: x_application_id := l_application_id;
1287:

Line 1309: l_responsibility_id fnd_responsibility.responsibility_id%type;

1305: l_module_source varchar2(256);
1306: l_apps_user_key fnd_oid_util.apps_user_key_type;
1307: l_found boolean := false;
1308:
1309: l_responsibility_id fnd_responsibility.responsibility_id%type;
1310: l_application_id fnd_responsibility.application_id%type;
1311: l_resp_key fnd_responsibility.responsibility_key%type;
1312:
1313: begin

Line 1310: l_application_id fnd_responsibility.application_id%type;

1306: l_apps_user_key fnd_oid_util.apps_user_key_type;
1307: l_found boolean := false;
1308:
1309: l_responsibility_id fnd_responsibility.responsibility_id%type;
1310: l_application_id fnd_responsibility.application_id%type;
1311: l_resp_key fnd_responsibility.responsibility_key%type;
1312:
1313: begin
1314: l_module_source := G_MODULE_SOURCE || 'assign_default_resp: ';

Line 1311: l_resp_key fnd_responsibility.responsibility_key%type;

1307: l_found boolean := false;
1308:
1309: l_responsibility_id fnd_responsibility.responsibility_id%type;
1310: l_application_id fnd_responsibility.application_id%type;
1311: l_resp_key fnd_responsibility.responsibility_key%type;
1312:
1313: begin
1314: l_module_source := G_MODULE_SOURCE || 'assign_default_resp: ';
1315:

Line 1377: l_responsibility_id fnd_responsibility.responsibility_id%type;

1373: l_change_source varchar2(256);
1374: l_apps_user_key fnd_oid_util.apps_user_key_type;
1375: l_found boolean := false;
1376:
1377: l_responsibility_id fnd_responsibility.responsibility_id%type;
1378: l_application_id fnd_responsibility.application_id%type;
1379: l_resp_key fnd_responsibility.responsibility_key%type;
1380:
1381: begin

Line 1378: l_application_id fnd_responsibility.application_id%type;

1374: l_apps_user_key fnd_oid_util.apps_user_key_type;
1375: l_found boolean := false;
1376:
1377: l_responsibility_id fnd_responsibility.responsibility_id%type;
1378: l_application_id fnd_responsibility.application_id%type;
1379: l_resp_key fnd_responsibility.responsibility_key%type;
1380:
1381: begin
1382: l_module_source := G_MODULE_SOURCE || 'assign_def_resp: ';

Line 1379: l_resp_key fnd_responsibility.responsibility_key%type;

1375: l_found boolean := false;
1376:
1377: l_responsibility_id fnd_responsibility.responsibility_id%type;
1378: l_application_id fnd_responsibility.application_id%type;
1379: l_resp_key fnd_responsibility.responsibility_key%type;
1380:
1381: begin
1382: l_module_source := G_MODULE_SOURCE || 'assign_def_resp: ';
1383: