APPS.PER_SIT_PKG dependencies on PER_SPECIAL_INFO_TYPE_USAGES

Line 380: -- Inserts a record into PER_SPECIAL_INFO_TYPE_USAGES for the

376: --
377: ----------------------------------------------------------------------
378: -- add_usage
379: --
380: -- Inserts a record into PER_SPECIAL_INFO_TYPE_USAGES for the
381: -- given type and category if the associated flag has been set
382: -- and the record does not already exist
383: ----------------------------------------------------------------------
384: --

Line 392: insert into per_special_info_type_usages

388: begin
389: --
390: if p_category_flag = 'Y' then
391: --
392: insert into per_special_info_type_usages
393: (special_information_type_id,
394: special_info_category)
395: select p_special_information_type_id,
396: p_special_info_category

Line 400: from per_special_info_type_usages

396: p_special_info_category
397: from dual
398: where not exists
399: (select null
400: from per_special_info_type_usages
401: where special_information_type_id = p_special_information_type_id
402: and special_info_category = p_special_info_category);
403: --
404: end if;

Line 411: -- Removes any records in PER_SPECIAL_INFO_TYPE_USAGES which have

407:
408: ----------------------------------------------------------------------
409: -- reset_usages
410: --
411: -- Removes any records in PER_SPECIAL_INFO_TYPE_USAGES which have
412: -- had their associated flag reset
413: -- Calls add_usage to insert any new usages for each category
414: --
415: ----------------------------------------------------------------------

Line 427: delete from per_special_info_type_usages

423: p_ada_category in varchar2) is
424: --
425: begin
426: --
427: delete from per_special_info_type_usages
428: where special_information_type_id = p_special_information_type_id
429: and (
430: (special_info_category = G_JOB and p_job_category = 'N') or
431: (special_info_category = G_POSITION and p_position_category = 'N') or

Line 468: -- Deletes all records from PER_SPECIAL_INFO_TYPE_USAGES for a type

464:
465: ----------------------------------------------------------------------
466: -- delete_usages
467: --
468: -- Deletes all records from PER_SPECIAL_INFO_TYPE_USAGES for a type
469: ----------------------------------------------------------------------
470: --
471: procedure delete_usages (p_special_information_type_id in number) is
472: begin

Line 474: delete from per_special_info_type_usages

470: --
471: procedure delete_usages (p_special_information_type_id in number) is
472: begin
473: --
474: delete from per_special_info_type_usages
475: where special_information_type_id = p_special_information_type_id;
476: --
477: end;
478: