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.PER_ASP_BUS dependencies on FND_USER_RESP_GROUPS

Line 406: FROM fnd_user_resp_groups

402: CURSOR c_get_assignment_dates
403: IS
404: SELECT start_date
405: ,end_date
406: FROM fnd_user_resp_groups
407: WHERE user_id = p_user_id
408: AND responsibility_id = p_responsibility_id
409: AND responsibility_application_id = p_application_id
410: AND security_group_id = p_security_group_id;

Line 809: RETURN fnd_user_resp_groups_api.Assignment_Exists

805: IS
806: --
807: BEGIN
808: --
809: RETURN fnd_user_resp_groups_api.Assignment_Exists
810: (user_id => p_user_id
811: ,responsibility_id => p_responsibility_id
812: ,responsibility_application_id => p_application_id
813: ,security_group_id => p_security_group_id

Line 947: fnd_user_resp_groups_api.Insert_Assignment

943: THEN
944: --
945: -- The assignment does not exist, so create it....
946: --
947: fnd_user_resp_groups_api.Insert_Assignment
948: (user_id => p_rec.user_id
949: ,responsibility_id => p_rec.responsibility_id
950: ,responsibility_application_id => p_rec.responsibility_application_id
951: ,security_group_id => p_rec.security_group_id

Line 1113: -- stored in fnd_user_resp_groups if end_date is null or the security

1109: -- kept as null rather than changed to EOT. If changed to EOT then
1110: -- the date 31-DEC-4712 shows up on FND User form IJH 8/6/00
1111: --
1112: -- This code has been uncommented due to the fact that eot must be
1113: -- stored in fnd_user_resp_groups if end_date is null or the security
1114: -- group will not be displayed in the responsibilities form.
1115: --
1116: OPEN c_chk_null_end_date;
1117: --

Line 1123: -- So set the end date in the fnd_user_resp_groups table to be the

1119: --
1120: IF c_chk_null_end_date%FOUND THEN
1121: --
1122: -- A record that has not been end-dated exists..
1123: -- So set the end date in the fnd_user_resp_groups table to be the
1124: -- end of time...
1125: l_max_date := hr_general.END_OF_TIME;
1126: END IF;
1127:

Line 1132: -- fnd_user_resp_groups table.

1128: CLOSE c_chk_null_end_date;
1129: --
1130: --
1131: -- Now we have got the start and end dates, so lets update the
1132: -- fnd_user_resp_groups table.
1133: --
1134: fnd_user_resp_groups_api.Update_Assignment
1135: (user_id => p_user_id
1136: ,responsibility_id => p_responsibility_id

Line 1134: fnd_user_resp_groups_api.Update_Assignment

1130: --
1131: -- Now we have got the start and end dates, so lets update the
1132: -- fnd_user_resp_groups table.
1133: --
1134: fnd_user_resp_groups_api.Update_Assignment
1135: (user_id => p_user_id
1136: ,responsibility_id => p_responsibility_id
1137: ,responsibility_application_id => p_application_id
1138: ,security_group_id => p_security_group_id