DBA Data[Home] [Help]

APPS.FND_PROGRAM dependencies on FND_REQUEST_GROUP_UNITS

Line 1368: insert into Fnd_Request_Group_Units(APPLICATION_ID,

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

Line 1438: delete from fnd_request_group_units u

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

Line 1512: DELETE FROM fnd_request_group_units

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

Line 1567: DELETE fnd_request_group_units

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

Line 1827: delete from fnd_request_group_units

1823: check_notnull(application);
1824:
1825: group_application_id := application_id_f(application);
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

Line 2256: from fnd_request_group_units u

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

Line 2315: insert into Fnd_Request_Group_Units(APPLICATION_ID,

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

Line 2376: delete from fnd_request_group_units u

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

Line 2414: from fnd_request_group_units u

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