DBA Data[Home] [Help]

APPS.FND_SET dependencies on FND_REQUEST_GROUP_UNITS

Line 1585: insert into Fnd_Request_Group_Units( APPLICATION_ID,

1581: set_id := request_set_id_f(set_application_id, request_set);
1582: group_id :=
1583: request_group_id_f(group_application_id, request_group);
1584:
1585: insert into Fnd_Request_Group_Units( APPLICATION_ID,
1586: REQUEST_GROUP_ID,
1587: REQUEST_UNIT_TYPE,
1588: UNIT_APPLICATION_ID,
1589: REQUEST_UNIT_ID,

Line 1654: delete from fnd_request_group_units u

1650: set_id := request_set_id_f(set_application_id, request_set);
1651: group_id :=
1652: request_group_id_f(group_application_id, request_group);
1653:
1654: delete from fnd_request_group_units u
1655: where application_id = group_application_id
1656: and request_group_id = group_id
1657: and request_unit_type = 'S'
1658: and unit_application_id = set_application_id

Line 1820: DELETE FROM fnd_request_group_units

1816: -- It doesn't matter anyway. This will be rare.
1817:
1818: -- Remove set from request groups
1819:
1820: DELETE FROM fnd_request_group_units
1821: WHERE request_unit_type = 'S'
1822: AND request_unit_id = set_id
1823: AND unit_application_id = set_appl_id;
1824:

Line 2339: from fnd_request_group_units u

2335: group_id := request_group_id_f(group_application_id, request_group);
2336:
2337: select 'y'
2338: into dummy
2339: from fnd_request_group_units u
2340: where application_id = group_application_id
2341: and request_group_id = group_id
2342: and request_unit_type = 'S'
2343: and unit_application_id = set_application_id

Line 2538: delete from fnd_request_group_units

2534: delete from fnd_executables
2535: where executable_id = exec_id
2536: and application_id = exec_application_id;
2537:
2538: delete from fnd_request_group_units
2539: where request_unit_id = exec_id
2540: and unit_application_id = exec_application_id
2541: and request_unit_type = 'F';
2542:

Line 2580: from fnd_request_group_units u

2576: group_id := request_group_id_f(group_application_id, request_group);
2577:
2578: select 'y'
2579: into dummy
2580: from fnd_request_group_units u
2581: where application_id = group_application_id
2582: and request_group_id = group_id
2583: and request_unit_type = 'F'
2584: and unit_application_id = fn_application_id

Line 2643: insert into Fnd_Request_Group_Units( APPLICATION_ID,

2639: fn_id := function_id_f(fn_application_id, function_short_name);
2640: group_id :=
2641: request_group_id_f(group_application_id, request_group);
2642:
2643: insert into Fnd_Request_Group_Units( APPLICATION_ID,
2644: REQUEST_GROUP_ID,
2645: REQUEST_UNIT_TYPE,
2646: UNIT_APPLICATION_ID,
2647: REQUEST_UNIT_ID,

Line 2707: delete from fnd_request_group_units u

2703: fn_id := function_id_f(fn_application_id, function_short_name);
2704: group_id :=
2705: request_group_id_f(group_application_id, request_group);
2706:
2707: delete from fnd_request_group_units u
2708: where application_id = group_application_id
2709: and request_group_id = group_id
2710: and request_unit_type = 'F'
2711: and unit_application_id = fn_application_id