APPS.HR_DOCUMENT_TYPES_API dependencies on HR_DOCUMENT_TYPES

Line 1: Package Body hr_document_types_api as

1: Package Body hr_document_types_api as
2: /* $Header: hrdtyapi.pkb 120.0 2005/05/30 23:53:41 appldev noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hr_document_types_api.';

2: /* $Header: hrdtyapi.pkb 120.0 2005/05/30 23:53:41 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_document_types_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_document_type >------------------------|
10: -- ----------------------------------------------------------------------------

Line 35: l_object_version_number hr_document_types.object_version_number%type;

31: ) IS
32: -- Declare cursors and local variables
33: --
34: l_proc varchar2(72) := g_package||'create_document_type';
35: l_object_version_number hr_document_types.object_version_number%type;
36: l_document_type_id hr_document_types.document_type_id%type;
37: l_language_code hr_all_organization_units_tl.language%TYPE;
38: l_document_type varchar2(40);
39: BEGIN

Line 36: l_document_type_id hr_document_types.document_type_id%type;

32: -- Declare cursors and local variables
33: --
34: l_proc varchar2(72) := g_package||'create_document_type';
35: l_object_version_number hr_document_types.object_version_number%type;
36: l_document_type_id hr_document_types.document_type_id%type;
37: l_language_code hr_all_organization_units_tl.language%TYPE;
38: l_document_type varchar2(40);
39: BEGIN
40:

Line 50: hr_document_types_bk1.create_document_type_b(

46: --
47: -- Call Before Process User Hook
48: --
49: begin
50: hr_document_types_bk1.create_document_type_b(
51: p_effective_date => p_effective_date
52: ,p_document_type => p_document_type
53: ,p_language_code => p_language_code
54: ,p_description => p_description

Line 112: -- Now insert translatable rows in HR_DOCUMENT_TYPES_TL table

108: ,p_object_version_number => l_object_version_number
109: );
110:
111: --
112: -- Now insert translatable rows in HR_DOCUMENT_TYPES_TL table
113: --
114:
115: hr_dtt_ins.ins_tl
116: ( p_language_code => l_language_code,

Line 133: hr_document_types_bk1.create_document_type_a(

129: -- Call After Process User Hook
130: --
131:
132: begin
133: hr_document_types_bk1.create_document_type_a(
134: p_document_type_id => l_document_type_id
135: ,p_effective_date => p_effective_date
136: ,p_document_type => p_document_type
137: ,p_language_code => p_language_code

Line 232: l_object_version_number hr_document_types.object_version_number%TYPE;

228: --
229: -- Declare cursors and local variables
230: --
231: l_proc varchar2(72) := g_package||'update_document_type';
232: l_object_version_number hr_document_types.object_version_number%TYPE;
233: l_ovn hr_document_types.object_version_number%TYPE := p_object_version_number;
234: --
235: begin
236: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 233: l_ovn hr_document_types.object_version_number%TYPE := p_object_version_number;

229: -- Declare cursors and local variables
230: --
231: l_proc varchar2(72) := g_package||'update_document_type';
232: l_object_version_number hr_document_types.object_version_number%TYPE;
233: l_ovn hr_document_types.object_version_number%TYPE := p_object_version_number;
234: --
235: begin
236: hr_utility.set_location('Entering:'|| l_proc, 5);
237: --

Line 245: hr_document_types_bk2.update_document_type_b(

241: --
242: -- Call Before Process User Hook
243: --
244: begin
245: hr_document_types_bk2.update_document_type_b(
246: p_effective_date => p_effective_date
247: ,p_category_code => p_category_code
248: ,p_document_type => p_document_type
249: ,p_language_code => p_language_code

Line 313: hr_document_types_bk2.update_document_type_a(

309: --
310: -- Call After Process User Hook
311: --
312: begin
313: hr_document_types_bk2.update_document_type_a(
314: p_effective_date => p_effective_date
315: ,p_category_code => p_category_code
316: ,p_document_type => p_document_type
317: ,p_language_code => p_language_code

Line 404: hr_document_types_bk3.delete_document_type_b

400: --
401: -- Call Before Process User Hook
402: --
403: begin
404: hr_document_types_bk3.delete_document_type_b
405: (p_document_type_id => p_document_type_id,
406: p_object_version_number => p_object_version_number
407: );
408: exception

Line 436: hr_document_types_bk3.delete_document_type_a

432: --
433: -- Call Before Process User Hook
434: --
435: begin
436: hr_document_types_bk3.delete_document_type_a
437: (p_document_type_id => p_document_type_id,
438: p_object_version_number => p_object_version_number
439: );
440: exception

Line 477: end hr_document_types_api;

473: raise;
474: --
475: end delete_document_type;
476: --
477: end hr_document_types_api;