APPS.FND_PROGRAM dependencies on FND_REQUEST_GROUP_UNITS

Line 1365: insert into Fnd_Request_Group_Units(APPLICATION_ID,

1361: concurrent_program_id_f(program_application_id, program_short_name);
1362:
1363: group_id := request_group_id_f(group_application_id, request_group);
1364:
1365: insert into Fnd_Request_Group_Units(APPLICATION_ID,
1366: REQUEST_GROUP_ID,
1367: REQUEST_UNIT_TYPE,
1368: UNIT_APPLICATION_ID,
1369: REQUEST_UNIT_ID,

Line 1435: delete from fnd_request_group_units u

1431: concurrent_program_id_f(program_application_id, program_short_name);
1432:
1433: group_id := request_group_id_f(group_application_id, request_group);
1434:
1435: delete from fnd_request_group_units u
1436: where application_id = group_application_id
1437: and request_group_id = group_id
1438: and request_unit_type = 'P'
1439: and unit_application_id = program_application_id

Line 1509: DELETE FROM fnd_request_group_units

1505: AND concurrent_program_id = program_id;
1506:
1507: -- Remove set from request groups
1508:
1509: DELETE FROM fnd_request_group_units
1510: WHERE request_unit_type = 'S'
1511: AND request_unit_id = set_id
1512: AND unit_application_id = program_application_id;
1513:

Line 1564: DELETE fnd_request_group_units

1560: AND concurrent_program_id = program_id;
1561:
1562: -- Remove the program from request groups
1563:
1564: DELETE fnd_request_group_units
1565: WHERE request_unit_type = 'P'
1566: AND request_unit_id = program_id
1567: AND unit_application_id = program_application_id;
1568:

Line 1824: delete from fnd_request_group_units

1820: check_notnull(application);
1821:
1822: group_application_id := application_id_f(application);
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

Line 2253: from fnd_request_group_units u

2249: group_id := request_group_id_f(group_application_id, request_group);
2250:
2251: select 'y'
2252: into dummy
2253: from fnd_request_group_units u
2254: where application_id = group_application_id
2255: and request_group_id = group_id
2256: and request_unit_type = 'P'
2257: and unit_application_id = program_application_id

Line 2312: insert into Fnd_Request_Group_Units(APPLICATION_ID,

2308:
2309:
2310: group_id := request_group_id_f(group_application_id, request_group);
2311:
2312: insert into Fnd_Request_Group_Units(APPLICATION_ID,
2313: REQUEST_GROUP_ID,
2314: REQUEST_UNIT_TYPE,
2315: UNIT_APPLICATION_ID,
2316: REQUEST_UNIT_ID,

Line 2373: delete from fnd_request_group_units u

2369:
2370:
2371: group_id := request_group_id_f(group_application_id, request_group);
2372:
2373: delete from fnd_request_group_units u
2374: where application_id = group_application_id
2375: and request_group_id = group_id
2376: and request_unit_type = 'A'
2377: and request_unit_id = application_id;

Line 2411: from fnd_request_group_units u

2407: group_id := request_group_id_f(group_application_id, request_group);
2408:
2409: select 'y'
2410: into dummy
2411: from fnd_request_group_units u
2412: where application_id = group_application_id
2413: and request_group_id = group_id
2414: and request_unit_type = 'A'
2415: and request_unit_id = application_id;