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 1241: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type

1237: end if;
1238: end hz_create_update;
1239: --
1240: -------------------------------------------------------------------------------
1241: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type
1242: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1243: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1244:
1245: l_module_source varchar2(256);

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

1238: end hz_create_update;
1239: --
1240: -------------------------------------------------------------------------------
1241: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type
1242: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1243: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1244:
1245: l_module_source varchar2(256);
1246: l_responsibility_id fnd_responsibility.responsibility_id%type;

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

1239: --
1240: -------------------------------------------------------------------------------
1241: procedure get_resp_app_id(p_resp_key in fnd_responsibility.responsibility_key%type
1242: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1243: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1244:
1245: l_module_source varchar2(256);
1246: l_responsibility_id fnd_responsibility.responsibility_id%type;
1247: l_application_id fnd_responsibility.application_id%type;

Line 1246: l_responsibility_id fnd_responsibility.responsibility_id%type;

1242: , x_responsibility_id out nocopy fnd_responsibility.responsibility_id%type
1243: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1244:
1245: l_module_source varchar2(256);
1246: l_responsibility_id fnd_responsibility.responsibility_id%type;
1247: l_application_id fnd_responsibility.application_id%type;
1248: l_found boolean;
1249:
1250: cursor cur_fnd_responsibility is

Line 1247: l_application_id fnd_responsibility.application_id%type;

1243: , x_application_id out nocopy fnd_responsibility.application_id%type) is
1244:
1245: l_module_source varchar2(256);
1246: l_responsibility_id fnd_responsibility.responsibility_id%type;
1247: l_application_id fnd_responsibility.application_id%type;
1248: l_found boolean;
1249:
1250: cursor cur_fnd_responsibility is
1251: SELECT responsibility_id, application_id

Line 1250: cursor cur_fnd_responsibility is

1246: l_responsibility_id fnd_responsibility.responsibility_id%type;
1247: l_application_id fnd_responsibility.application_id%type;
1248: l_found boolean;
1249:
1250: cursor cur_fnd_responsibility is
1251: SELECT responsibility_id, application_id
1252: from fnd_responsibility
1253: where RESPONSIBILITY_KEY = p_resp_key;
1254: begin

Line 1252: from fnd_responsibility

1248: l_found boolean;
1249:
1250: cursor cur_fnd_responsibility is
1251: SELECT responsibility_id, application_id
1252: from fnd_responsibility
1253: where RESPONSIBILITY_KEY = p_resp_key;
1254: begin
1255: l_module_source := G_MODULE_SOURCE || 'get_resp_app_id ';
1256:

Line 1262: open cur_fnd_responsibility;

1258: then
1259: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1260: end if;
1261:
1262: open cur_fnd_responsibility;
1263: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;
1264: l_found := cur_fnd_responsibility%found;
1265:
1266: if (not l_found)

Line 1263: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;

1259: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1260: end if;
1261:
1262: open cur_fnd_responsibility;
1263: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;
1264: l_found := cur_fnd_responsibility%found;
1265:
1266: if (not l_found)
1267: then

Line 1264: l_found := cur_fnd_responsibility%found;

1260: end if;
1261:
1262: open cur_fnd_responsibility;
1263: fetch cur_fnd_responsibility into l_responsibility_id, l_application_id;
1264: l_found := cur_fnd_responsibility%found;
1265:
1266: if (not l_found)
1267: then
1268: l_responsibility_id := null;

Line 1271: close cur_fnd_responsibility;

1267: then
1268: l_responsibility_id := null;
1269: l_application_id := null;
1270: end if;
1271: close cur_fnd_responsibility;
1272:
1273: x_responsibility_id := l_responsibility_id;
1274: x_application_id := l_application_id;
1275:

Line 1297: l_responsibility_id fnd_responsibility.responsibility_id%type;

1293: l_module_source varchar2(256);
1294: l_apps_user_key fnd_oid_util.apps_user_key_type;
1295: l_found boolean := false;
1296:
1297: l_responsibility_id fnd_responsibility.responsibility_id%type;
1298: l_application_id fnd_responsibility.application_id%type;
1299: l_resp_key fnd_responsibility.responsibility_key%type;
1300:
1301: begin

Line 1298: l_application_id fnd_responsibility.application_id%type;

1294: l_apps_user_key fnd_oid_util.apps_user_key_type;
1295: l_found boolean := false;
1296:
1297: l_responsibility_id fnd_responsibility.responsibility_id%type;
1298: l_application_id fnd_responsibility.application_id%type;
1299: l_resp_key fnd_responsibility.responsibility_key%type;
1300:
1301: begin
1302: l_module_source := G_MODULE_SOURCE || 'assign_default_resp: ';

Line 1299: l_resp_key fnd_responsibility.responsibility_key%type;

1295: l_found boolean := false;
1296:
1297: l_responsibility_id fnd_responsibility.responsibility_id%type;
1298: l_application_id fnd_responsibility.application_id%type;
1299: l_resp_key fnd_responsibility.responsibility_key%type;
1300:
1301: begin
1302: l_module_source := G_MODULE_SOURCE || 'assign_default_resp: ';
1303:

Line 1365: l_responsibility_id fnd_responsibility.responsibility_id%type;

1361: l_change_source varchar2(256);
1362: l_apps_user_key fnd_oid_util.apps_user_key_type;
1363: l_found boolean := false;
1364:
1365: l_responsibility_id fnd_responsibility.responsibility_id%type;
1366: l_application_id fnd_responsibility.application_id%type;
1367: l_resp_key fnd_responsibility.responsibility_key%type;
1368:
1369: begin

Line 1366: l_application_id fnd_responsibility.application_id%type;

1362: l_apps_user_key fnd_oid_util.apps_user_key_type;
1363: l_found boolean := false;
1364:
1365: l_responsibility_id fnd_responsibility.responsibility_id%type;
1366: l_application_id fnd_responsibility.application_id%type;
1367: l_resp_key fnd_responsibility.responsibility_key%type;
1368:
1369: begin
1370: l_module_source := G_MODULE_SOURCE || 'assign_def_resp: ';

Line 1367: l_resp_key fnd_responsibility.responsibility_key%type;

1363: l_found boolean := false;
1364:
1365: l_responsibility_id fnd_responsibility.responsibility_id%type;
1366: l_application_id fnd_responsibility.application_id%type;
1367: l_resp_key fnd_responsibility.responsibility_key%type;
1368:
1369: begin
1370: l_module_source := G_MODULE_SOURCE || 'assign_def_resp: ';
1371: