1 Package pay_rtu_shd as
2 /* $Header: pyrturhi.pkh 120.0 2005/05/29 08:29:09 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Record Type Specification |
6 -- ----------------------------------------------------------------------------
7 --
8 Type g_rec_type Is Record
9 (parent_run_type_id number(9)
10 ,child_run_type_id number(9)
11 ,effective_start_date date
12 ,effective_end_date date
13 ,sequence number(9)
14 ,object_version_number number(9)
15 ,run_type_usage_id number(9)
16 ,business_group_id number(15)
17 ,legislation_code varchar2(30)
18 );
19 --
20 -- ----------------------------------------------------------------------------
21 -- | Global Definitions - Internal Development Use Only |
22 -- ----------------------------------------------------------------------------
23 --
24 g_old_rec g_rec_type; -- Global record definition
25 --
26 -- ----------------------------------------------------------------------------
27 -- |---------------------------< constraint_error >---------------------------|
28 -- ----------------------------------------------------------------------------
29 Procedure constraint_error
30 (p_constraint_name in all_constraints.constraint_name%TYPE);
31 --
32 -- ----------------------------------------------------------------------------
33 -- |-----------------------------< api_updating >-----------------------------|
34 -- ----------------------------------------------------------------------------
35 Function api_updating
36 (p_effective_date in date
37 ,p_run_type_usage_id in number
38 ,p_object_version_number in number
39 ) Return Boolean;
40 --
41 -- ----------------------------------------------------------------------------
42 -- |---------------------------< find_dt_upd_modes >--------------------------|
43 -- ----------------------------------------------------------------------------
44 Procedure find_dt_upd_modes
45 (p_effective_date in date
46 ,p_base_key_value in number
47 ,p_correction out nocopy boolean
48 ,p_update out nocopy boolean
49 ,p_update_override out nocopy boolean
50 ,p_update_change_insert out nocopy boolean
51 );
52 --
53 -- ----------------------------------------------------------------------------
54 -- |---------------------------< find_dt_del_modes >--------------------------|
55 -- ----------------------------------------------------------------------------
56 Procedure find_dt_del_modes
57 (p_effective_date in date
58 ,p_base_key_value in number
59 ,p_zap out nocopy boolean
60 ,p_delete out nocopy boolean
61 ,p_future_change out nocopy boolean
62 ,p_delete_next_change out nocopy boolean
63 );
64 --
65 -- ----------------------------------------------------------------------------
66 -- |-----------------------< upd_effective_end_date >-------------------------|
67 -- ----------------------------------------------------------------------------
68 Procedure upd_effective_end_date
69 (p_effective_date in date
70 ,p_base_key_value in number
71 ,p_new_effective_end_date in date
72 ,p_validation_start_date in date
73 ,p_validation_end_date in date
74 ,p_object_version_number out nocopy number
75 );
76 --
77 -- ----------------------------------------------------------------------------
78 -- |---------------------------------< lck >----------------------------------|
79 -- ----------------------------------------------------------------------------
80 Procedure lck
81 (p_effective_date in date
82 ,p_datetrack_mode in varchar2
83 ,p_run_type_usage_id in number
84 ,p_object_version_number in number
85 ,p_validation_start_date out nocopy date
86 ,p_validation_end_date out nocopy date
87 );
88 --
89 -- ----------------------------------------------------------------------------
90 -- |-----------------------------< convert_args >-----------------------------|
91 -- ----------------------------------------------------------------------------
92 Function convert_args
93 (p_parent_run_type_id in number
94 ,p_child_run_type_id in number
95 ,p_effective_start_date in date
96 ,p_effective_end_date in date
97 ,p_sequence in number
98 ,p_object_version_number in number
99 ,p_run_type_usage_id in number
100 ,p_business_group_id in number
101 ,p_legislation_code in varchar2
102 )
103 Return g_rec_type;
104 --
105 end pay_rtu_shd;