34: --
35: -- ---------------------------------------------------------------------------
36: --
37: PROCEDURE chk_name
38: (p_name IN pay_rates.name%TYPE
39: ,p_rate_id IN pay_rates.rate_id%TYPE
40: ,p_business_group_id IN pay_rates.business_group_id%TYPE
41: ,p_object_version_number IN pay_rates.object_version_number%TYPE
42: ,p_rate_type IN pay_rates.rate_type%TYPE
35: -- ---------------------------------------------------------------------------
36: --
37: PROCEDURE chk_name
38: (p_name IN pay_rates.name%TYPE
39: ,p_rate_id IN pay_rates.rate_id%TYPE
40: ,p_business_group_id IN pay_rates.business_group_id%TYPE
41: ,p_object_version_number IN pay_rates.object_version_number%TYPE
42: ,p_rate_type IN pay_rates.rate_type%TYPE
43: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE);
36: --
37: PROCEDURE chk_name
38: (p_name IN pay_rates.name%TYPE
39: ,p_rate_id IN pay_rates.rate_id%TYPE
40: ,p_business_group_id IN pay_rates.business_group_id%TYPE
41: ,p_object_version_number IN pay_rates.object_version_number%TYPE
42: ,p_rate_type IN pay_rates.rate_type%TYPE
43: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE);
44: --
37: PROCEDURE chk_name
38: (p_name IN pay_rates.name%TYPE
39: ,p_rate_id IN pay_rates.rate_id%TYPE
40: ,p_business_group_id IN pay_rates.business_group_id%TYPE
41: ,p_object_version_number IN pay_rates.object_version_number%TYPE
42: ,p_rate_type IN pay_rates.rate_type%TYPE
43: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE);
44: --
45: -- ---------------------------------------------------------------------------
38: (p_name IN pay_rates.name%TYPE
39: ,p_rate_id IN pay_rates.rate_id%TYPE
40: ,p_business_group_id IN pay_rates.business_group_id%TYPE
41: ,p_object_version_number IN pay_rates.object_version_number%TYPE
42: ,p_rate_type IN pay_rates.rate_type%TYPE
43: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE);
44: --
45: -- ---------------------------------------------------------------------------
46: -- |----------------------------< chk_rate_basis >---------------------------|
39: ,p_rate_id IN pay_rates.rate_id%TYPE
40: ,p_business_group_id IN pay_rates.business_group_id%TYPE
41: ,p_object_version_number IN pay_rates.object_version_number%TYPE
42: ,p_rate_type IN pay_rates.rate_type%TYPE
43: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE);
44: --
45: -- ---------------------------------------------------------------------------
46: -- |----------------------------< chk_rate_basis >---------------------------|
47: -- ---------------------------------------------------------------------------
73: --
74: -- {End of Comments}
75: --
76: PROCEDURE chk_rate_basis
77: (p_rate_basis IN pay_rates.rate_basis%TYPE
78: ,p_effective_date IN DATE
79: ,p_rate_id IN pay_rates.rate_id%TYPE
80: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
81: --
75: --
76: PROCEDURE chk_rate_basis
77: (p_rate_basis IN pay_rates.rate_basis%TYPE
78: ,p_effective_date IN DATE
79: ,p_rate_id IN pay_rates.rate_id%TYPE
80: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
81: --
82: -- ---------------------------------------------------------------------------
83: -- |----------------------------< chk_rate_uom >----------------------------|
76: PROCEDURE chk_rate_basis
77: (p_rate_basis IN pay_rates.rate_basis%TYPE
78: ,p_effective_date IN DATE
79: ,p_rate_id IN pay_rates.rate_id%TYPE
80: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
81: --
82: -- ---------------------------------------------------------------------------
83: -- |----------------------------< chk_rate_uom >----------------------------|
84: -- ---------------------------------------------------------------------------
110: --
111: -- {End of Comments}
112: --
113: PROCEDURE chk_rate_uom
114: (p_rate_uom IN pay_rates.rate_uom%TYPE
115: ,p_effective_date IN DATE
116: ,p_rate_id IN pay_rates.rate_id%TYPE
117: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
118: --
112: --
113: PROCEDURE chk_rate_uom
114: (p_rate_uom IN pay_rates.rate_uom%TYPE
115: ,p_effective_date IN DATE
116: ,p_rate_id IN pay_rates.rate_id%TYPE
117: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
118: --
119: -- ---------------------------------------------------------------------------
120: -- |----------------------------< chk_rate_type >----------------------------|
113: PROCEDURE chk_rate_uom
114: (p_rate_uom IN pay_rates.rate_uom%TYPE
115: ,p_effective_date IN DATE
116: ,p_rate_id IN pay_rates.rate_id%TYPE
117: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
118: --
119: -- ---------------------------------------------------------------------------
120: -- |----------------------------< chk_rate_type >----------------------------|
121: -- ---------------------------------------------------------------------------
147: --
148: -- {End of Comments}
149: --
150: PROCEDURE chk_rate_type
151: (p_rate_type IN pay_rates.rate_type%TYPE
152: ,p_effective_date IN DATE
153: ,p_rate_id IN pay_rates.rate_id%TYPE
154: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
155: --
149: --
150: PROCEDURE chk_rate_type
151: (p_rate_type IN pay_rates.rate_type%TYPE
152: ,p_effective_date IN DATE
153: ,p_rate_id IN pay_rates.rate_id%TYPE
154: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
155: --
156: -- ---------------------------------------------------------------------------
157: -- |---------------------------< chk_parent_spine_id >------------------------|
150: PROCEDURE chk_rate_type
151: (p_rate_type IN pay_rates.rate_type%TYPE
152: ,p_effective_date IN DATE
153: ,p_rate_id IN pay_rates.rate_id%TYPE
154: ,p_object_version_number IN pay_rates.object_version_number%TYPE);
155: --
156: -- ---------------------------------------------------------------------------
157: -- |---------------------------< chk_parent_spine_id >------------------------|
158: -- ---------------------------------------------------------------------------
185: --
186: -- ---------------------------------------------------------------------------
187: --
188: PROCEDURE chk_parent_spine_id
189: (p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
190: ,p_rate_id IN pay_rates.rate_id%TYPE
191: ,p_object_version_number IN pay_rates.object_version_number%TYPE );
192: --
193: --
186: -- ---------------------------------------------------------------------------
187: --
188: PROCEDURE chk_parent_spine_id
189: (p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
190: ,p_rate_id IN pay_rates.rate_id%TYPE
191: ,p_object_version_number IN pay_rates.object_version_number%TYPE );
192: --
193: --
194: -- ---------------------------------------------------------------------------
187: --
188: PROCEDURE chk_parent_spine_id
189: (p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
190: ,p_rate_id IN pay_rates.rate_id%TYPE
191: ,p_object_version_number IN pay_rates.object_version_number%TYPE );
192: --
193: --
194: -- ---------------------------------------------------------------------------
195: -- |----------------------< set_security_group_id >--------------------------|