APPS.HR_DTY_BUS dependencies on HR_DOCUMENT_TYPES

Line 120: p_category_code in hr_document_types.category_code%TYPE

116: -- {End Of Comments}
117: -- ----------------------------------------------------------------------------
118: procedure chk_category_code
119: (
120: p_category_code in hr_document_types.category_code%TYPE
121: ,p_legislation_code in hr_document_types.legislation_code%TYPE
122: )
123: is
124: --

Line 121: ,p_legislation_code in hr_document_types.legislation_code%TYPE

117: -- ----------------------------------------------------------------------------
118: procedure chk_category_code
119: (
120: p_category_code in hr_document_types.category_code%TYPE
121: ,p_legislation_code in hr_document_types.legislation_code%TYPE
122: )
123: is
124: --
125:

Line 183: (p_associated_column1 => 'hr_document_types.category_code'

179:
180: exception
181: when app_exception.application_exception then
182: if hr_multi_message.exception_add
183: (p_associated_column1 => 'hr_document_types.category_code'
184: ) then
185: hr_utility.set_location('Leaving:'||l_proc, 50);
186: raise;
187: end if;

Line 221: p_category_code in hr_document_types.category_code%TYPE

217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: procedure chk_sub_category_code
220: (
221: p_category_code in hr_document_types.category_code%TYPE
222: ,p_sub_category_code in hr_document_types.sub_category_code%TYPE
223: )
224: is
225: --

Line 222: ,p_sub_category_code in hr_document_types.sub_category_code%TYPE

218: -- ----------------------------------------------------------------------------
219: procedure chk_sub_category_code
220: (
221: p_category_code in hr_document_types.category_code%TYPE
222: ,p_sub_category_code in hr_document_types.sub_category_code%TYPE
223: )
224: is
225: --
226:

Line 276: (p_associated_column1 => 'hr_document_types.sub_category_code'

272:
273: exception
274: when app_exception.application_exception then
275: if hr_multi_message.exception_add
276: (p_associated_column1 => 'hr_document_types.sub_category_code'
277: ) then
278: hr_utility.set_location('Leaving:'||l_proc, 50);
279: raise;
280: end if;

Line 313: p_active_flag in hr_document_types.active_inactive_flag%TYPE

309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: procedure chk_active_flag
312: (
313: p_active_flag in hr_document_types.active_inactive_flag%TYPE
314: )
315: is
316: --
317:

Line 400: p_multiple_occurence_flag in hr_document_types.multiple_occurences_flag%TYPE

396: -- {End Of Comments}
397: -- ----------------------------------------------------------------------------
398: procedure chk_multiple_occurence_flag
399: (
400: p_multiple_occurence_flag in hr_document_types.multiple_occurences_flag%TYPE
401: )
402: is
403: --
404:

Line 491: p_legislation_code in hr_document_types.legislation_code%TYPE

487: -- {End Of Comments}
488: -- ----------------------------------------------------------------------------
489: procedure chk_legislation_code
490: (
491: p_legislation_code in hr_document_types.legislation_code%TYPE
492: )
493: is
494: --
495:

Line 572: p_authorization_required in hr_document_types.authorization_required%TYPE

568: -- {End Of Comments}
569: -- ----------------------------------------------------------------------------
570: procedure chk_authorization_required
571: (
572: p_authorization_required in hr_document_types.authorization_required%TYPE
573: )
574: is
575: --
576:

Line 662: p_document_type in hr_document_types.document_type_id%TYPE

658: -- {End Of Comments}
659: -- ----------------------------------------------------------------------------
660: procedure chk_document_type_delete
661: (
662: p_document_type in hr_document_types.document_type_id%TYPE
663: )
664: is
665: --
666:

Line 677: from hr_document_types_v

673: -- Cursor for Validating Deletion of Document Type Id
674: cursor get_document_type(p_document_type_id number)
675: is
676: select document_type
677: from hr_document_types_v
678: where document_type_id=p_document_type_id;
679:
680:
681: cursor csr_doc_type_delete