APPS.PER_ASP_BUS dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 112: IN per_sec_profile_assignments.user_id%TYPE

108: -- ----------------------------------------------------------------------------
109: --
110: PROCEDURE chk_assignment_dates
111: (p_user_id
112: IN per_sec_profile_assignments.user_id%TYPE
113: ,p_responsibility_id
114: IN per_sec_profile_assignments.responsibility_id%TYPE
115: ,p_application_id
116: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 114: IN per_sec_profile_assignments.responsibility_id%TYPE

110: PROCEDURE chk_assignment_dates
111: (p_user_id
112: IN per_sec_profile_assignments.user_id%TYPE
113: ,p_responsibility_id
114: IN per_sec_profile_assignments.responsibility_id%TYPE
115: ,p_application_id
116: IN per_sec_profile_assignments.responsibility_application_id%TYPE
117: ,p_security_group_id
118: IN per_sec_profile_assignments.security_group_id%TYPE

Line 116: IN per_sec_profile_assignments.responsibility_application_id%TYPE

112: IN per_sec_profile_assignments.user_id%TYPE
113: ,p_responsibility_id
114: IN per_sec_profile_assignments.responsibility_id%TYPE
115: ,p_application_id
116: IN per_sec_profile_assignments.responsibility_application_id%TYPE
117: ,p_security_group_id
118: IN per_sec_profile_assignments.security_group_id%TYPE
119: ,p_start_date
120: IN per_sec_profile_assignments.start_date%TYPE

Line 118: IN per_sec_profile_assignments.security_group_id%TYPE

114: IN per_sec_profile_assignments.responsibility_id%TYPE
115: ,p_application_id
116: IN per_sec_profile_assignments.responsibility_application_id%TYPE
117: ,p_security_group_id
118: IN per_sec_profile_assignments.security_group_id%TYPE
119: ,p_start_date
120: IN per_sec_profile_assignments.start_date%TYPE
121: ,p_end_date
122: IN per_sec_profile_assignments.end_date%TYPE

Line 120: IN per_sec_profile_assignments.start_date%TYPE

116: IN per_sec_profile_assignments.responsibility_application_id%TYPE
117: ,p_security_group_id
118: IN per_sec_profile_assignments.security_group_id%TYPE
119: ,p_start_date
120: IN per_sec_profile_assignments.start_date%TYPE
121: ,p_end_date
122: IN per_sec_profile_assignments.end_date%TYPE
123: );
124: --

Line 122: IN per_sec_profile_assignments.end_date%TYPE

118: IN per_sec_profile_assignments.security_group_id%TYPE
119: ,p_start_date
120: IN per_sec_profile_assignments.start_date%TYPE
121: ,p_end_date
122: IN per_sec_profile_assignments.end_date%TYPE
123: );
124: --
125: -- ----------------------------------------------------------------------------
126: -- |-< chk_invalid_dates >----------------------------------------------------|

Line 165: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE

161: -- ----------------------------------------------------------------------------
162: --
163: PROCEDURE chk_invalid_dates
164: (p_sec_profile_assignment_id
165: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
166: DEFAULT NULL
167: ,p_user_id
168: IN per_sec_profile_assignments.user_id%TYPE
169: ,p_responsibility_id

Line 168: IN per_sec_profile_assignments.user_id%TYPE

164: (p_sec_profile_assignment_id
165: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
166: DEFAULT NULL
167: ,p_user_id
168: IN per_sec_profile_assignments.user_id%TYPE
169: ,p_responsibility_id
170: IN per_sec_profile_assignments.responsibility_id%TYPE
171: ,p_application_id
172: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 170: IN per_sec_profile_assignments.responsibility_id%TYPE

166: DEFAULT NULL
167: ,p_user_id
168: IN per_sec_profile_assignments.user_id%TYPE
169: ,p_responsibility_id
170: IN per_sec_profile_assignments.responsibility_id%TYPE
171: ,p_application_id
172: IN per_sec_profile_assignments.responsibility_application_id%TYPE
173: ,p_security_group_id
174: IN per_sec_profile_assignments.security_group_id%TYPE

Line 172: IN per_sec_profile_assignments.responsibility_application_id%TYPE

168: IN per_sec_profile_assignments.user_id%TYPE
169: ,p_responsibility_id
170: IN per_sec_profile_assignments.responsibility_id%TYPE
171: ,p_application_id
172: IN per_sec_profile_assignments.responsibility_application_id%TYPE
173: ,p_security_group_id
174: IN per_sec_profile_assignments.security_group_id%TYPE
175: ,p_business_group_id
176: IN per_sec_profile_assignments.business_group_id%TYPE

Line 174: IN per_sec_profile_assignments.security_group_id%TYPE

170: IN per_sec_profile_assignments.responsibility_id%TYPE
171: ,p_application_id
172: IN per_sec_profile_assignments.responsibility_application_id%TYPE
173: ,p_security_group_id
174: IN per_sec_profile_assignments.security_group_id%TYPE
175: ,p_business_group_id
176: IN per_sec_profile_assignments.business_group_id%TYPE
177: ,p_security_profile_id
178: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 176: IN per_sec_profile_assignments.business_group_id%TYPE

172: IN per_sec_profile_assignments.responsibility_application_id%TYPE
173: ,p_security_group_id
174: IN per_sec_profile_assignments.security_group_id%TYPE
175: ,p_business_group_id
176: IN per_sec_profile_assignments.business_group_id%TYPE
177: ,p_security_profile_id
178: IN per_sec_profile_assignments.security_profile_id%TYPE
179: ,p_start_date
180: IN per_sec_profile_assignments.start_date%TYPE

Line 178: IN per_sec_profile_assignments.security_profile_id%TYPE

174: IN per_sec_profile_assignments.security_group_id%TYPE
175: ,p_business_group_id
176: IN per_sec_profile_assignments.business_group_id%TYPE
177: ,p_security_profile_id
178: IN per_sec_profile_assignments.security_profile_id%TYPE
179: ,p_start_date
180: IN per_sec_profile_assignments.start_date%TYPE
181: ,p_end_date
182: IN per_sec_profile_assignments.end_date%TYPE

Line 180: IN per_sec_profile_assignments.start_date%TYPE

176: IN per_sec_profile_assignments.business_group_id%TYPE
177: ,p_security_profile_id
178: IN per_sec_profile_assignments.security_profile_id%TYPE
179: ,p_start_date
180: IN per_sec_profile_assignments.start_date%TYPE
181: ,p_end_date
182: IN per_sec_profile_assignments.end_date%TYPE
183: );
184: --

Line 182: IN per_sec_profile_assignments.end_date%TYPE

178: IN per_sec_profile_assignments.security_profile_id%TYPE
179: ,p_start_date
180: IN per_sec_profile_assignments.start_date%TYPE
181: ,p_end_date
182: IN per_sec_profile_assignments.end_date%TYPE
183: );
184: --
185: -- ----------------------------------------------------------------------------
186: -- |-< chk_duplicate_assignments >--------------------------------------------|

Line 220: IN per_sec_profile_assignments.user_id%TYPE

216: -- ----------------------------------------------------------------------------
217: --
218: PROCEDURE chk_duplicate_assignments
219: (p_user_id
220: IN per_sec_profile_assignments.user_id%TYPE
221: ,p_responsibility_id
222: IN per_sec_profile_assignments.responsibility_id%TYPE
223: ,p_application_id
224: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 222: IN per_sec_profile_assignments.responsibility_id%TYPE

218: PROCEDURE chk_duplicate_assignments
219: (p_user_id
220: IN per_sec_profile_assignments.user_id%TYPE
221: ,p_responsibility_id
222: IN per_sec_profile_assignments.responsibility_id%TYPE
223: ,p_application_id
224: IN per_sec_profile_assignments.responsibility_application_id%TYPE
225: ,p_security_group_id
226: IN per_sec_profile_assignments.security_group_id%TYPE

Line 224: IN per_sec_profile_assignments.responsibility_application_id%TYPE

220: IN per_sec_profile_assignments.user_id%TYPE
221: ,p_responsibility_id
222: IN per_sec_profile_assignments.responsibility_id%TYPE
223: ,p_application_id
224: IN per_sec_profile_assignments.responsibility_application_id%TYPE
225: ,p_security_group_id
226: IN per_sec_profile_assignments.security_group_id%TYPE
227: ,p_business_group_id
228: IN per_sec_profile_assignments.business_group_id%TYPE

Line 226: IN per_sec_profile_assignments.security_group_id%TYPE

222: IN per_sec_profile_assignments.responsibility_id%TYPE
223: ,p_application_id
224: IN per_sec_profile_assignments.responsibility_application_id%TYPE
225: ,p_security_group_id
226: IN per_sec_profile_assignments.security_group_id%TYPE
227: ,p_business_group_id
228: IN per_sec_profile_assignments.business_group_id%TYPE
229: ,p_security_profile_id
230: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 228: IN per_sec_profile_assignments.business_group_id%TYPE

224: IN per_sec_profile_assignments.responsibility_application_id%TYPE
225: ,p_security_group_id
226: IN per_sec_profile_assignments.security_group_id%TYPE
227: ,p_business_group_id
228: IN per_sec_profile_assignments.business_group_id%TYPE
229: ,p_security_profile_id
230: IN per_sec_profile_assignments.security_profile_id%TYPE
231: ,p_start_date
232: IN per_sec_profile_assignments.start_date%TYPE

Line 230: IN per_sec_profile_assignments.security_profile_id%TYPE

226: IN per_sec_profile_assignments.security_group_id%TYPE
227: ,p_business_group_id
228: IN per_sec_profile_assignments.business_group_id%TYPE
229: ,p_security_profile_id
230: IN per_sec_profile_assignments.security_profile_id%TYPE
231: ,p_start_date
232: IN per_sec_profile_assignments.start_date%TYPE
233: ,p_end_date
234: IN per_sec_profile_assignments.end_date%TYPE

Line 232: IN per_sec_profile_assignments.start_date%TYPE

228: IN per_sec_profile_assignments.business_group_id%TYPE
229: ,p_security_profile_id
230: IN per_sec_profile_assignments.security_profile_id%TYPE
231: ,p_start_date
232: IN per_sec_profile_assignments.start_date%TYPE
233: ,p_end_date
234: IN per_sec_profile_assignments.end_date%TYPE
235: );
236: --

Line 234: IN per_sec_profile_assignments.end_date%TYPE

230: IN per_sec_profile_assignments.security_profile_id%TYPE
231: ,p_start_date
232: IN per_sec_profile_assignments.start_date%TYPE
233: ,p_end_date
234: IN per_sec_profile_assignments.end_date%TYPE
235: );
236: --
237: -- ----------------------------------------------------------------------------
238: -- |-< chk_overlapping_dates >------------------------------------------------|

Line 276: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE

272: -- ----------------------------------------------------------------------------
273: --
274: PROCEDURE chk_overlapping_dates
275: (p_sec_profile_assignment_id
276: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
277: DEFAULT NULL
278: ,p_user_id
279: IN per_sec_profile_assignments.user_id%TYPE
280: ,p_responsibility_id

Line 279: IN per_sec_profile_assignments.user_id%TYPE

275: (p_sec_profile_assignment_id
276: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
277: DEFAULT NULL
278: ,p_user_id
279: IN per_sec_profile_assignments.user_id%TYPE
280: ,p_responsibility_id
281: IN per_sec_profile_assignments.responsibility_id%TYPE
282: ,p_application_id
283: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 281: IN per_sec_profile_assignments.responsibility_id%TYPE

277: DEFAULT NULL
278: ,p_user_id
279: IN per_sec_profile_assignments.user_id%TYPE
280: ,p_responsibility_id
281: IN per_sec_profile_assignments.responsibility_id%TYPE
282: ,p_application_id
283: IN per_sec_profile_assignments.responsibility_application_id%TYPE
284: ,p_security_group_id
285: IN per_sec_profile_assignments.security_group_id%TYPE

Line 283: IN per_sec_profile_assignments.responsibility_application_id%TYPE

279: IN per_sec_profile_assignments.user_id%TYPE
280: ,p_responsibility_id
281: IN per_sec_profile_assignments.responsibility_id%TYPE
282: ,p_application_id
283: IN per_sec_profile_assignments.responsibility_application_id%TYPE
284: ,p_security_group_id
285: IN per_sec_profile_assignments.security_group_id%TYPE
286: ,p_business_group_id
287: IN per_sec_profile_assignments.business_group_id%TYPE

Line 285: IN per_sec_profile_assignments.security_group_id%TYPE

281: IN per_sec_profile_assignments.responsibility_id%TYPE
282: ,p_application_id
283: IN per_sec_profile_assignments.responsibility_application_id%TYPE
284: ,p_security_group_id
285: IN per_sec_profile_assignments.security_group_id%TYPE
286: ,p_business_group_id
287: IN per_sec_profile_assignments.business_group_id%TYPE
288: ,p_security_profile_id
289: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 287: IN per_sec_profile_assignments.business_group_id%TYPE

283: IN per_sec_profile_assignments.responsibility_application_id%TYPE
284: ,p_security_group_id
285: IN per_sec_profile_assignments.security_group_id%TYPE
286: ,p_business_group_id
287: IN per_sec_profile_assignments.business_group_id%TYPE
288: ,p_security_profile_id
289: IN per_sec_profile_assignments.security_profile_id%TYPE
290: ,p_start_date
291: IN per_sec_profile_assignments.start_date%TYPE

Line 289: IN per_sec_profile_assignments.security_profile_id%TYPE

285: IN per_sec_profile_assignments.security_group_id%TYPE
286: ,p_business_group_id
287: IN per_sec_profile_assignments.business_group_id%TYPE
288: ,p_security_profile_id
289: IN per_sec_profile_assignments.security_profile_id%TYPE
290: ,p_start_date
291: IN per_sec_profile_assignments.start_date%TYPE
292: ,p_end_date
293: IN per_sec_profile_assignments.end_date%TYPE

Line 291: IN per_sec_profile_assignments.start_date%TYPE

287: IN per_sec_profile_assignments.business_group_id%TYPE
288: ,p_security_profile_id
289: IN per_sec_profile_assignments.security_profile_id%TYPE
290: ,p_start_date
291: IN per_sec_profile_assignments.start_date%TYPE
292: ,p_end_date
293: IN per_sec_profile_assignments.end_date%TYPE
294: );
295: --

Line 293: IN per_sec_profile_assignments.end_date%TYPE

289: IN per_sec_profile_assignments.security_profile_id%TYPE
290: ,p_start_date
291: IN per_sec_profile_assignments.start_date%TYPE
292: ,p_end_date
293: IN per_sec_profile_assignments.end_date%TYPE
294: );
295: --
296: -- ----------------------------------------------------------------------------
297: -- |-< chk_overlapping_dates >------------------------------------------------|

Line 339: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE

335: -- ----------------------------------------------------------------------------
336: --
337: PROCEDURE chk_overlapping_dates
338: (p_sec_profile_assignment_id
339: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
340: DEFAULT NULL
341: ,p_user_id
342: IN per_sec_profile_assignments.user_id%TYPE
343: ,p_responsibility_id

Line 342: IN per_sec_profile_assignments.user_id%TYPE

338: (p_sec_profile_assignment_id
339: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
340: DEFAULT NULL
341: ,p_user_id
342: IN per_sec_profile_assignments.user_id%TYPE
343: ,p_responsibility_id
344: IN per_sec_profile_assignments.responsibility_id%TYPE
345: ,p_application_id
346: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 344: IN per_sec_profile_assignments.responsibility_id%TYPE

340: DEFAULT NULL
341: ,p_user_id
342: IN per_sec_profile_assignments.user_id%TYPE
343: ,p_responsibility_id
344: IN per_sec_profile_assignments.responsibility_id%TYPE
345: ,p_application_id
346: IN per_sec_profile_assignments.responsibility_application_id%TYPE
347: ,p_security_group_id
348: IN per_sec_profile_assignments.security_group_id%TYPE

Line 346: IN per_sec_profile_assignments.responsibility_application_id%TYPE

342: IN per_sec_profile_assignments.user_id%TYPE
343: ,p_responsibility_id
344: IN per_sec_profile_assignments.responsibility_id%TYPE
345: ,p_application_id
346: IN per_sec_profile_assignments.responsibility_application_id%TYPE
347: ,p_security_group_id
348: IN per_sec_profile_assignments.security_group_id%TYPE
349: ,p_business_group_id
350: IN per_sec_profile_assignments.business_group_id%TYPE

Line 348: IN per_sec_profile_assignments.security_group_id%TYPE

344: IN per_sec_profile_assignments.responsibility_id%TYPE
345: ,p_application_id
346: IN per_sec_profile_assignments.responsibility_application_id%TYPE
347: ,p_security_group_id
348: IN per_sec_profile_assignments.security_group_id%TYPE
349: ,p_business_group_id
350: IN per_sec_profile_assignments.business_group_id%TYPE
351: ,p_security_profile_id
352: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 350: IN per_sec_profile_assignments.business_group_id%TYPE

346: IN per_sec_profile_assignments.responsibility_application_id%TYPE
347: ,p_security_group_id
348: IN per_sec_profile_assignments.security_group_id%TYPE
349: ,p_business_group_id
350: IN per_sec_profile_assignments.business_group_id%TYPE
351: ,p_security_profile_id
352: IN per_sec_profile_assignments.security_profile_id%TYPE
353: ,p_start_date
354: IN per_sec_profile_assignments.start_date%TYPE

Line 352: IN per_sec_profile_assignments.security_profile_id%TYPE

348: IN per_sec_profile_assignments.security_group_id%TYPE
349: ,p_business_group_id
350: IN per_sec_profile_assignments.business_group_id%TYPE
351: ,p_security_profile_id
352: IN per_sec_profile_assignments.security_profile_id%TYPE
353: ,p_start_date
354: IN per_sec_profile_assignments.start_date%TYPE
355: ,p_end_date
356: IN per_sec_profile_assignments.end_date%TYPE

Line 354: IN per_sec_profile_assignments.start_date%TYPE

350: IN per_sec_profile_assignments.business_group_id%TYPE
351: ,p_security_profile_id
352: IN per_sec_profile_assignments.security_profile_id%TYPE
353: ,p_start_date
354: IN per_sec_profile_assignments.start_date%TYPE
355: ,p_end_date
356: IN per_sec_profile_assignments.end_date%TYPE
357: ,p_clashing_id
358: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE

Line 356: IN per_sec_profile_assignments.end_date%TYPE

352: IN per_sec_profile_assignments.security_profile_id%TYPE
353: ,p_start_date
354: IN per_sec_profile_assignments.start_date%TYPE
355: ,p_end_date
356: IN per_sec_profile_assignments.end_date%TYPE
357: ,p_clashing_id
358: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
359: ,p_clashing_ovn
360: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE

Line 358: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE

354: IN per_sec_profile_assignments.start_date%TYPE
355: ,p_end_date
356: IN per_sec_profile_assignments.end_date%TYPE
357: ,p_clashing_id
358: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
359: ,p_clashing_ovn
360: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
361: ,p_clashing_start_date
362: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE

Line 360: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE

356: IN per_sec_profile_assignments.end_date%TYPE
357: ,p_clashing_id
358: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
359: ,p_clashing_ovn
360: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
361: ,p_clashing_start_date
362: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE
363: ,p_clashing_end_date
364: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE

Line 362: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE

358: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
359: ,p_clashing_ovn
360: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
361: ,p_clashing_start_date
362: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE
363: ,p_clashing_end_date
364: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE
365: );
366: --

Line 364: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE

360: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
361: ,p_clashing_start_date
362: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE
363: ,p_clashing_end_date
364: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE
365: );
366: --
367: -- ----------------------------------------------------------------------------
368: -- |-< chk_assignment_exists >------------------------------------------------|

Line 406: IN per_sec_profile_assignments.user_id%TYPE

402: -- ----------------------------------------------------------------------------
403: --
404: PROCEDURE chk_assignment_exists
405: (p_user_id
406: IN per_sec_profile_assignments.user_id%TYPE
407: ,p_responsibility_id
408: IN per_sec_profile_assignments.responsibility_id%TYPE
409: ,p_application_id
410: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 408: IN per_sec_profile_assignments.responsibility_id%TYPE

404: PROCEDURE chk_assignment_exists
405: (p_user_id
406: IN per_sec_profile_assignments.user_id%TYPE
407: ,p_responsibility_id
408: IN per_sec_profile_assignments.responsibility_id%TYPE
409: ,p_application_id
410: IN per_sec_profile_assignments.responsibility_application_id%TYPE
411: ,p_security_group_id
412: IN per_sec_profile_assignments.security_group_id%TYPE

Line 410: IN per_sec_profile_assignments.responsibility_application_id%TYPE

406: IN per_sec_profile_assignments.user_id%TYPE
407: ,p_responsibility_id
408: IN per_sec_profile_assignments.responsibility_id%TYPE
409: ,p_application_id
410: IN per_sec_profile_assignments.responsibility_application_id%TYPE
411: ,p_security_group_id
412: IN per_sec_profile_assignments.security_group_id%TYPE
413: );
414: --

Line 412: IN per_sec_profile_assignments.security_group_id%TYPE

408: IN per_sec_profile_assignments.responsibility_id%TYPE
409: ,p_application_id
410: IN per_sec_profile_assignments.responsibility_application_id%TYPE
411: ,p_security_group_id
412: IN per_sec_profile_assignments.security_group_id%TYPE
413: );
414: --
415: -- ----------------------------------------------------------------------------
416: -- |-< chk_assignment_exists >-------------------------------------------------|

Line 450: IN per_sec_profile_assignments.user_id%TYPE

446: -- ----------------------------------------------------------------------------
447: --
448: FUNCTION chk_assignment_exists
449: (p_user_id
450: IN per_sec_profile_assignments.user_id%TYPE
451: ,p_responsibility_id
452: IN per_sec_profile_assignments.responsibility_id%TYPE
453: ,p_application_id
454: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 452: IN per_sec_profile_assignments.responsibility_id%TYPE

448: FUNCTION chk_assignment_exists
449: (p_user_id
450: IN per_sec_profile_assignments.user_id%TYPE
451: ,p_responsibility_id
452: IN per_sec_profile_assignments.responsibility_id%TYPE
453: ,p_application_id
454: IN per_sec_profile_assignments.responsibility_application_id%TYPE
455: ,p_security_group_id
456: IN per_sec_profile_assignments.security_group_id%TYPE

Line 454: IN per_sec_profile_assignments.responsibility_application_id%TYPE

450: IN per_sec_profile_assignments.user_id%TYPE
451: ,p_responsibility_id
452: IN per_sec_profile_assignments.responsibility_id%TYPE
453: ,p_application_id
454: IN per_sec_profile_assignments.responsibility_application_id%TYPE
455: ,p_security_group_id
456: IN per_sec_profile_assignments.security_group_id%TYPE
457: ) RETURN BOOLEAN;
458: --

Line 456: IN per_sec_profile_assignments.security_group_id%TYPE

452: IN per_sec_profile_assignments.responsibility_id%TYPE
453: ,p_application_id
454: IN per_sec_profile_assignments.responsibility_application_id%TYPE
455: ,p_security_group_id
456: IN per_sec_profile_assignments.security_group_id%TYPE
457: ) RETURN BOOLEAN;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |-< get_security_group_id >------------------------------------------------|

Line 500: -- table are synchronized with the dates in the PER_SEC_PROFILE_ASSIGNMENTS

496: -- {Start Of Comments}
497: --
498: -- Description:
499: -- This procedure is used to ensure that the dates in FND_USER_RESP_GROUPS
500: -- table are synchronized with the dates in the PER_SEC_PROFILE_ASSIGNMENTS
501: -- table. The basic rule is that the start date in F_U_R_G is set to the
502: -- minimum start date in P_S_P_A, and the end date in F_U_R_G is set to the
503: -- maximum end date in P_S_P_A (or the end of time if a null entry for the
504: -- end date exists).

Line 533: IN per_sec_profile_assignments.user_id%TYPE

529: -- ----------------------------------------------------------------------------
530: --
531: PROCEDURE Synchronize_Assignment_Dates
532: (p_user_id
533: IN per_sec_profile_assignments.user_id%TYPE
534: ,p_responsibility_id
535: IN per_sec_profile_assignments.responsibility_id%TYPE
536: ,p_application_id
537: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 535: IN per_sec_profile_assignments.responsibility_id%TYPE

531: PROCEDURE Synchronize_Assignment_Dates
532: (p_user_id
533: IN per_sec_profile_assignments.user_id%TYPE
534: ,p_responsibility_id
535: IN per_sec_profile_assignments.responsibility_id%TYPE
536: ,p_application_id
537: IN per_sec_profile_assignments.responsibility_application_id%TYPE
538: ,p_security_group_id
539: IN per_sec_profile_assignments.security_group_id%TYPE

Line 537: IN per_sec_profile_assignments.responsibility_application_id%TYPE

533: IN per_sec_profile_assignments.user_id%TYPE
534: ,p_responsibility_id
535: IN per_sec_profile_assignments.responsibility_id%TYPE
536: ,p_application_id
537: IN per_sec_profile_assignments.responsibility_application_id%TYPE
538: ,p_security_group_id
539: IN per_sec_profile_assignments.security_group_id%TYPE
540: ,p_business_group_id
541: IN per_sec_profile_assignments.business_group_id%TYPE

Line 539: IN per_sec_profile_assignments.security_group_id%TYPE

535: IN per_sec_profile_assignments.responsibility_id%TYPE
536: ,p_application_id
537: IN per_sec_profile_assignments.responsibility_application_id%TYPE
538: ,p_security_group_id
539: IN per_sec_profile_assignments.security_group_id%TYPE
540: ,p_business_group_id
541: IN per_sec_profile_assignments.business_group_id%TYPE
542: );
543: --

Line 541: IN per_sec_profile_assignments.business_group_id%TYPE

537: IN per_sec_profile_assignments.responsibility_application_id%TYPE
538: ,p_security_group_id
539: IN per_sec_profile_assignments.security_group_id%TYPE
540: ,p_business_group_id
541: IN per_sec_profile_assignments.business_group_id%TYPE
542: );
543: --
544: end per_asp_bus;