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 246: group_id fnd_request_groups.request_group_id%TYPE;

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

Line 250: FROM fnd_request_groups

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

Line 1269: last_update_login fnd_request_groups.last_update_login%TYPE

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

Line 1271: last_update_date fnd_request_groups.last_update_date%TYPE

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

Line 1273: last_updated_by fnd_request_groups.last_updated_by%TYPE

1269: last_update_login fnd_request_groups.last_update_login%TYPE
1270: := last_update_login_f;
1271: last_update_date fnd_request_groups.last_update_date%TYPE
1272: := last_update_date_f;
1273: last_updated_by fnd_request_groups.last_updated_by%TYPE
1274: := last_updated_by_f;
1275: creation_date fnd_request_groups.creation_date%TYPE
1276: := creation_date_f;
1277: created_by fnd_request_groups.created_by%TYPE

Line 1275: creation_date fnd_request_groups.creation_date%TYPE

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

Line 1277: created_by fnd_request_groups.created_by%TYPE

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

Line 1288: insert into fnd_request_groups

1284: check_notnull(application);
1285:
1286: group_application_id := application_id_f(application);
1287:
1288: insert into fnd_request_groups
1289: (application_id,
1290: request_group_id,
1291: request_group_name,
1292: last_update_date,

Line 1301: fnd_request_groups_s.nextval,

1297: description,
1298: request_group_code)
1299: values
1300: (group_application_id,
1301: fnd_request_groups_s.nextval,
1302: request_group,
1303: last_update_date,
1304: last_updated_by,
1305: creation_date,

Line 1331: last_update_login fnd_request_groups.last_update_login%TYPE

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

Line 1333: last_update_date fnd_request_groups.last_update_date%TYPE

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

Line 1335: last_updated_by fnd_request_groups.last_updated_by%TYPE

1331: last_update_login fnd_request_groups.last_update_login%TYPE
1332: := last_update_login_f;
1333: last_update_date fnd_request_groups.last_update_date%TYPE
1334: := last_update_date_f;
1335: last_updated_by fnd_request_groups.last_updated_by%TYPE
1336: := last_updated_by_f;
1337: creation_date fnd_request_groups.creation_date%TYPE
1338: := creation_date_f;
1339: created_by fnd_request_groups.created_by%TYPE

Line 1337: creation_date fnd_request_groups.creation_date%TYPE

1333: last_update_date fnd_request_groups.last_update_date%TYPE
1334: := last_update_date_f;
1335: last_updated_by fnd_request_groups.last_updated_by%TYPE
1336: := last_updated_by_f;
1337: creation_date fnd_request_groups.creation_date%TYPE
1338: := creation_date_f;
1339: created_by fnd_request_groups.created_by%TYPE
1340: := created_by_f;
1341: program_application_id

Line 1339: created_by fnd_request_groups.created_by%TYPE

1335: last_updated_by fnd_request_groups.last_updated_by%TYPE
1336: := last_updated_by_f;
1337: creation_date fnd_request_groups.creation_date%TYPE
1338: := creation_date_f;
1339: created_by fnd_request_groups.created_by%TYPE
1340: := created_by_f;
1341: program_application_id
1342: fnd_application.application_id%TYPE;
1343: group_application_id

Line 1348: fnd_request_groups.request_group_id%TYPE;

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

Line 1417: fnd_request_groups.request_group_id%TYPE;

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

Line 1827: from fnd_request_groups

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

Line 1831: delete from fnd_request_groups

1827: from fnd_request_groups
1828: where request_group_name = request_group
1829: and application_id = group_application_id);
1830:
1831: delete from fnd_request_groups
1832: where request_group_name = request_group
1833: and application_id = group_application_id;
1834:
1835: END delete_group;

Line 2203: from fnd_request_groups

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

Line 2237: group_id fnd_request_groups.request_group_id%TYPE;

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

Line 2283: last_update_login fnd_request_groups.last_update_login%TYPE

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

Line 2285: last_update_date fnd_request_groups.last_update_date%TYPE

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

Line 2287: last_updated_by fnd_request_groups.last_updated_by%TYPE

2283: last_update_login fnd_request_groups.last_update_login%TYPE
2284: := last_update_login_f;
2285: last_update_date fnd_request_groups.last_update_date%TYPE
2286: := last_update_date_f;
2287: last_updated_by fnd_request_groups.last_updated_by%TYPE
2288: := last_updated_by_f;
2289: creation_date fnd_request_groups.creation_date%TYPE
2290: := creation_date_f;
2291: created_by fnd_request_groups.created_by%TYPE

Line 2289: creation_date fnd_request_groups.creation_date%TYPE

2285: last_update_date fnd_request_groups.last_update_date%TYPE
2286: := last_update_date_f;
2287: last_updated_by fnd_request_groups.last_updated_by%TYPE
2288: := last_updated_by_f;
2289: creation_date fnd_request_groups.creation_date%TYPE
2290: := creation_date_f;
2291: created_by fnd_request_groups.created_by%TYPE
2292: := created_by_f;
2293: application_id

Line 2291: created_by fnd_request_groups.created_by%TYPE

2287: last_updated_by fnd_request_groups.last_updated_by%TYPE
2288: := last_updated_by_f;
2289: creation_date fnd_request_groups.creation_date%TYPE
2290: := creation_date_f;
2291: created_by fnd_request_groups.created_by%TYPE
2292: := created_by_f;
2293: application_id
2294: fnd_application.application_id%TYPE;
2295: group_application_id

Line 2298: fnd_request_groups.request_group_id%TYPE;

2294: fnd_application.application_id%TYPE;
2295: group_application_id
2296: fnd_application.application_id%TYPE;
2297: group_id
2298: fnd_request_groups.request_group_id%TYPE;
2299: BEGIN
2300: message_init;
2301:
2302: check_notnull(application_name);

Line 2359: fnd_request_groups.request_group_id%TYPE;

2355: fnd_application.application_id%TYPE;
2356: group_application_id
2357: fnd_application.application_id%TYPE;
2358: group_id
2359: fnd_request_groups.request_group_id%TYPE;
2360: BEGIN
2361: message_init;
2362:
2363: check_notnull(application_name);

Line 2398: group_id fnd_request_groups.request_group_id%TYPE;

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