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_PROGRAM dependencies on FND_REQUEST_GROUPS

Line 249: group_id fnd_request_groups.request_group_id%TYPE;

245:
246: /* Get a request group ID given name and appl ID */
247: FUNCTION request_group_id_f(group_application_id number,
248: request_group varchar2) return number is
249: group_id fnd_request_groups.request_group_id%TYPE;
250: BEGIN
251: SELECT request_group_id
252: INTO group_id
253: FROM fnd_request_groups

Line 253: FROM fnd_request_groups

249: group_id fnd_request_groups.request_group_id%TYPE;
250: BEGIN
251: SELECT request_group_id
252: INTO group_id
253: FROM fnd_request_groups
254: WHERE application_id = group_application_id
255: AND request_group_name = request_group;
256:
257: RETURN group_id;

Line 1272: last_update_login fnd_request_groups.last_update_login%TYPE

1268: PROCEDURE request_group(request_group IN VARCHAR2,
1269: application IN VARCHAR2,
1270: code IN VARCHAR2 DEFAULT NULL,
1271: description IN VARCHAR2 DEFAULT NULL) is
1272: last_update_login fnd_request_groups.last_update_login%TYPE
1273: := last_update_login_f;
1274: last_update_date fnd_request_groups.last_update_date%TYPE
1275: := last_update_date_f;
1276: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 1274: last_update_date fnd_request_groups.last_update_date%TYPE

1270: code IN VARCHAR2 DEFAULT NULL,
1271: description IN VARCHAR2 DEFAULT NULL) is
1272: last_update_login fnd_request_groups.last_update_login%TYPE
1273: := last_update_login_f;
1274: last_update_date fnd_request_groups.last_update_date%TYPE
1275: := last_update_date_f;
1276: last_updated_by fnd_request_groups.last_updated_by%TYPE
1277: := last_updated_by_f;
1278: creation_date fnd_request_groups.creation_date%TYPE

Line 1276: last_updated_by fnd_request_groups.last_updated_by%TYPE

1272: last_update_login fnd_request_groups.last_update_login%TYPE
1273: := last_update_login_f;
1274: last_update_date fnd_request_groups.last_update_date%TYPE
1275: := last_update_date_f;
1276: last_updated_by fnd_request_groups.last_updated_by%TYPE
1277: := last_updated_by_f;
1278: creation_date fnd_request_groups.creation_date%TYPE
1279: := creation_date_f;
1280: created_by fnd_request_groups.created_by%TYPE

Line 1278: creation_date fnd_request_groups.creation_date%TYPE

1274: last_update_date fnd_request_groups.last_update_date%TYPE
1275: := last_update_date_f;
1276: last_updated_by fnd_request_groups.last_updated_by%TYPE
1277: := last_updated_by_f;
1278: creation_date fnd_request_groups.creation_date%TYPE
1279: := creation_date_f;
1280: created_by fnd_request_groups.created_by%TYPE
1281: := created_by_f;
1282: group_application_id fnd_application.application_id%TYPE;

Line 1280: created_by fnd_request_groups.created_by%TYPE

1276: last_updated_by fnd_request_groups.last_updated_by%TYPE
1277: := last_updated_by_f;
1278: creation_date fnd_request_groups.creation_date%TYPE
1279: := creation_date_f;
1280: created_by fnd_request_groups.created_by%TYPE
1281: := created_by_f;
1282: group_application_id fnd_application.application_id%TYPE;
1283: BEGIN
1284: message_init;

Line 1291: insert into fnd_request_groups

1287: check_notnull(application);
1288:
1289: group_application_id := application_id_f(application);
1290:
1291: insert into fnd_request_groups
1292: (application_id,
1293: request_group_id,
1294: request_group_name,
1295: last_update_date,

Line 1304: fnd_request_groups_s.nextval,

1300: description,
1301: request_group_code)
1302: values
1303: (group_application_id,
1304: fnd_request_groups_s.nextval,
1305: request_group,
1306: last_update_date,
1307: last_updated_by,
1308: creation_date,

Line 1334: last_update_login fnd_request_groups.last_update_login%TYPE

1330: PROCEDURE add_to_group(program_short_name IN VARCHAR2,
1331: program_application IN VARCHAR2,
1332: request_group IN VARCHAR2,
1333: group_application IN VARCHAR2) is
1334: last_update_login fnd_request_groups.last_update_login%TYPE
1335: := last_update_login_f;
1336: last_update_date fnd_request_groups.last_update_date%TYPE
1337: := last_update_date_f;
1338: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 1336: last_update_date fnd_request_groups.last_update_date%TYPE

1332: request_group IN VARCHAR2,
1333: group_application IN VARCHAR2) is
1334: last_update_login fnd_request_groups.last_update_login%TYPE
1335: := last_update_login_f;
1336: last_update_date fnd_request_groups.last_update_date%TYPE
1337: := last_update_date_f;
1338: last_updated_by fnd_request_groups.last_updated_by%TYPE
1339: := last_updated_by_f;
1340: creation_date fnd_request_groups.creation_date%TYPE

Line 1338: last_updated_by fnd_request_groups.last_updated_by%TYPE

1334: last_update_login fnd_request_groups.last_update_login%TYPE
1335: := last_update_login_f;
1336: last_update_date fnd_request_groups.last_update_date%TYPE
1337: := last_update_date_f;
1338: last_updated_by fnd_request_groups.last_updated_by%TYPE
1339: := last_updated_by_f;
1340: creation_date fnd_request_groups.creation_date%TYPE
1341: := creation_date_f;
1342: created_by fnd_request_groups.created_by%TYPE

Line 1340: creation_date fnd_request_groups.creation_date%TYPE

1336: last_update_date fnd_request_groups.last_update_date%TYPE
1337: := last_update_date_f;
1338: last_updated_by fnd_request_groups.last_updated_by%TYPE
1339: := last_updated_by_f;
1340: creation_date fnd_request_groups.creation_date%TYPE
1341: := creation_date_f;
1342: created_by fnd_request_groups.created_by%TYPE
1343: := created_by_f;
1344: program_application_id

Line 1342: created_by fnd_request_groups.created_by%TYPE

1338: last_updated_by fnd_request_groups.last_updated_by%TYPE
1339: := last_updated_by_f;
1340: creation_date fnd_request_groups.creation_date%TYPE
1341: := creation_date_f;
1342: created_by fnd_request_groups.created_by%TYPE
1343: := created_by_f;
1344: program_application_id
1345: fnd_application.application_id%TYPE;
1346: group_application_id

Line 1351: fnd_request_groups.request_group_id%TYPE;

1347: fnd_application.application_id%TYPE;
1348: concurrent_program_id
1349: fnd_concurrent_programs.concurrent_program_id%TYPE;
1350: group_id
1351: fnd_request_groups.request_group_id%TYPE;
1352: BEGIN
1353: message_init;
1354:
1355: check_notnull(program_short_name);

Line 1420: fnd_request_groups.request_group_id%TYPE;

1416: fnd_application.application_id%TYPE;
1417: concurrent_program_id
1418: fnd_concurrent_programs.concurrent_program_id%TYPE;
1419: group_id
1420: fnd_request_groups.request_group_id%TYPE;
1421: BEGIN
1422: message_init;
1423:
1424: check_notnull(program_short_name);

Line 1830: from fnd_request_groups

1826:
1827: delete from fnd_request_group_units
1828: where (request_group_id, application_id) in
1829: (select request_group_id, application_id
1830: from fnd_request_groups
1831: where request_group_name = request_group
1832: and application_id = group_application_id);
1833:
1834: delete from fnd_request_groups

Line 1834: delete from fnd_request_groups

1830: from fnd_request_groups
1831: where request_group_name = request_group
1832: and application_id = group_application_id);
1833:
1834: delete from fnd_request_groups
1835: where request_group_name = request_group
1836: and application_id = group_application_id;
1837:
1838: END delete_group;

Line 2206: from fnd_request_groups

2202: group_application_id := application_id_f(application);
2203:
2204: select 'y'
2205: into dummy
2206: from fnd_request_groups
2207: where request_group_name = request_group
2208: and application_id = group_application_id;
2209:
2210: return TRUE;

Line 2240: group_id fnd_request_groups.request_group_id%TYPE;

2236:
2237: program_application_id fnd_application.application_id%TYPE;
2238: group_application_id fnd_application.application_id%TYPE;
2239: concurrent_program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2240: group_id fnd_request_groups.request_group_id%TYPE;
2241: dummy varchar2(1);
2242:
2243: BEGIN
2244: message_init;

Line 2286: last_update_login fnd_request_groups.last_update_login%TYPE

2282: PROCEDURE add_application_to_group(
2283: application_name IN VARCHAR2,
2284: request_group IN VARCHAR2,
2285: group_application IN VARCHAR2) is
2286: last_update_login fnd_request_groups.last_update_login%TYPE
2287: := last_update_login_f;
2288: last_update_date fnd_request_groups.last_update_date%TYPE
2289: := last_update_date_f;
2290: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 2288: last_update_date fnd_request_groups.last_update_date%TYPE

2284: request_group IN VARCHAR2,
2285: group_application IN VARCHAR2) is
2286: last_update_login fnd_request_groups.last_update_login%TYPE
2287: := last_update_login_f;
2288: last_update_date fnd_request_groups.last_update_date%TYPE
2289: := last_update_date_f;
2290: last_updated_by fnd_request_groups.last_updated_by%TYPE
2291: := last_updated_by_f;
2292: creation_date fnd_request_groups.creation_date%TYPE

Line 2290: last_updated_by fnd_request_groups.last_updated_by%TYPE

2286: last_update_login fnd_request_groups.last_update_login%TYPE
2287: := last_update_login_f;
2288: last_update_date fnd_request_groups.last_update_date%TYPE
2289: := last_update_date_f;
2290: last_updated_by fnd_request_groups.last_updated_by%TYPE
2291: := last_updated_by_f;
2292: creation_date fnd_request_groups.creation_date%TYPE
2293: := creation_date_f;
2294: created_by fnd_request_groups.created_by%TYPE

Line 2292: creation_date fnd_request_groups.creation_date%TYPE

2288: last_update_date fnd_request_groups.last_update_date%TYPE
2289: := last_update_date_f;
2290: last_updated_by fnd_request_groups.last_updated_by%TYPE
2291: := last_updated_by_f;
2292: creation_date fnd_request_groups.creation_date%TYPE
2293: := creation_date_f;
2294: created_by fnd_request_groups.created_by%TYPE
2295: := created_by_f;
2296: application_id

Line 2294: created_by fnd_request_groups.created_by%TYPE

2290: last_updated_by fnd_request_groups.last_updated_by%TYPE
2291: := last_updated_by_f;
2292: creation_date fnd_request_groups.creation_date%TYPE
2293: := creation_date_f;
2294: created_by fnd_request_groups.created_by%TYPE
2295: := created_by_f;
2296: application_id
2297: fnd_application.application_id%TYPE;
2298: group_application_id

Line 2301: fnd_request_groups.request_group_id%TYPE;

2297: fnd_application.application_id%TYPE;
2298: group_application_id
2299: fnd_application.application_id%TYPE;
2300: group_id
2301: fnd_request_groups.request_group_id%TYPE;
2302: BEGIN
2303: message_init;
2304:
2305: check_notnull(application_name);

Line 2362: fnd_request_groups.request_group_id%TYPE;

2358: fnd_application.application_id%TYPE;
2359: group_application_id
2360: fnd_application.application_id%TYPE;
2361: group_id
2362: fnd_request_groups.request_group_id%TYPE;
2363: BEGIN
2364: message_init;
2365:
2366: check_notnull(application_name);

Line 2401: group_id fnd_request_groups.request_group_id%TYPE;

2397: group_application IN VARCHAR2) RETURN BOOLEAN is
2398:
2399: application_id fnd_application.application_id%TYPE;
2400: group_application_id fnd_application.application_id%TYPE;
2401: group_id fnd_request_groups.request_group_id%TYPE;
2402: dummy varchar2(1);
2403:
2404: BEGIN
2405: message_init;