eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PYR_BUS dependencies on PAY_RATES

Line 21: (p_rate_basis IN pay_rates.rate_basis%TYPE

17: -- |----------------------------< chk_rate_basis >---------------------------|
18: -- ---------------------------------------------------------------------------
19: --
20: PROCEDURE chk_rate_basis
21: (p_rate_basis IN pay_rates.rate_basis%TYPE
22: ,p_effective_date IN DATE
23: ,p_rate_id IN pay_rates.rate_id%TYPE
24: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
25: --

Line 23: ,p_rate_id IN pay_rates.rate_id%TYPE

19: --
20: PROCEDURE chk_rate_basis
21: (p_rate_basis IN pay_rates.rate_basis%TYPE
22: ,p_effective_date IN DATE
23: ,p_rate_id IN pay_rates.rate_id%TYPE
24: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
25: --
26: l_api_updating BOOLEAN;
27: l_proc VARCHAR2(72) := g_package||'chk_rate_basis';

Line 24: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS

20: PROCEDURE chk_rate_basis
21: (p_rate_basis IN pay_rates.rate_basis%TYPE
22: ,p_effective_date IN DATE
23: ,p_rate_id IN pay_rates.rate_id%TYPE
24: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
25: --
26: l_api_updating BOOLEAN;
27: l_proc VARCHAR2(72) := g_package||'chk_rate_basis';
28: --

Line 73: (p_associated_column1 => 'PAY_RATES.RATE_BASIS') THEN

69: --
70: WHEN app_exception.application_exception THEN
71: --
72: IF hr_multi_message.exception_add
73: (p_associated_column1 => 'PAY_RATES.RATE_BASIS') THEN
74: --
75: hr_utility.set_location(' Leaving : '||l_proc,998);
76: --
77: RAISE;

Line 90: (p_rate_uom IN pay_rates.rate_uom%TYPE

86: -- |-----------------------------< chk_rate_uom >----------------------------|
87: -- ---------------------------------------------------------------------------
88: --
89: PROCEDURE chk_rate_uom
90: (p_rate_uom IN pay_rates.rate_uom%TYPE
91: ,p_effective_date IN DATE
92: ,p_rate_id IN pay_rates.rate_id%TYPE
93: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
94: --

Line 92: ,p_rate_id IN pay_rates.rate_id%TYPE

88: --
89: PROCEDURE chk_rate_uom
90: (p_rate_uom IN pay_rates.rate_uom%TYPE
91: ,p_effective_date IN DATE
92: ,p_rate_id IN pay_rates.rate_id%TYPE
93: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
94: --
95: l_api_updating BOOLEAN;
96: l_proc VARCHAR2(72) := g_package||'chk_rate_uom';

Line 93: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS

89: PROCEDURE chk_rate_uom
90: (p_rate_uom IN pay_rates.rate_uom%TYPE
91: ,p_effective_date IN DATE
92: ,p_rate_id IN pay_rates.rate_id%TYPE
93: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
94: --
95: l_api_updating BOOLEAN;
96: l_proc VARCHAR2(72) := g_package||'chk_rate_uom';
97: --

Line 140: (p_associated_column1 => 'PAY_RATES.RATE_UOM') THEN

136: --
137: WHEN app_exception.application_exception THEN
138: --
139: IF hr_multi_message.exception_add
140: (p_associated_column1 => 'PAY_RATES.RATE_UOM') THEN
141: --
142: hr_utility.set_location(' Leaving : '||l_proc,998);
143: --
144: RAISE;

Line 157: (p_rate_type IN pay_rates.rate_type%TYPE

153: -- |----------------------------< chk_rate_type >----------------------------|
154: -- ---------------------------------------------------------------------------
155: --
156: PROCEDURE chk_rate_type
157: (p_rate_type IN pay_rates.rate_type%TYPE
158: ,p_effective_date IN DATE
159: ,p_rate_id IN pay_rates.rate_id%TYPE
160: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
161: --

Line 159: ,p_rate_id IN pay_rates.rate_id%TYPE

155: --
156: PROCEDURE chk_rate_type
157: (p_rate_type IN pay_rates.rate_type%TYPE
158: ,p_effective_date IN DATE
159: ,p_rate_id IN pay_rates.rate_id%TYPE
160: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
161: --
162: l_api_updating BOOLEAN;
163: l_proc VARCHAR2(72) := g_package||'chk_rate_type';

Line 160: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS

156: PROCEDURE chk_rate_type
157: (p_rate_type IN pay_rates.rate_type%TYPE
158: ,p_effective_date IN DATE
159: ,p_rate_id IN pay_rates.rate_id%TYPE
160: ,p_object_version_number IN pay_rates.object_version_number%TYPE) IS
161: --
162: l_api_updating BOOLEAN;
163: l_proc VARCHAR2(72) := g_package||'chk_rate_type';
164: --

Line 207: (p_associated_column1 => 'PAY_RATES.RATE_TYPE') THEN

203: --
204: WHEN app_exception.application_exception THEN
205: --
206: IF hr_multi_message.exception_add
207: (p_associated_column1 => 'PAY_RATES.RATE_TYPE') THEN
208: --
209: hr_utility.set_location(' Leaving : '||l_proc,998);
210: --
211: RAISE;

Line 224: (p_name IN pay_rates.name%TYPE

220: -- |--------------------------------< chk_name >-----------------------------|
221: -- ---------------------------------------------------------------------------
222: --
223: PROCEDURE chk_name
224: (p_name IN pay_rates.name%TYPE
225: ,p_rate_id IN pay_rates.rate_id%TYPE
226: ,p_business_group_id IN pay_rates.business_group_id%TYPE
227: ,p_object_version_number IN pay_rates.object_version_number%TYPE
228: ,p_rate_type IN pay_rates.rate_type%TYPE

Line 225: ,p_rate_id IN pay_rates.rate_id%TYPE

221: -- ---------------------------------------------------------------------------
222: --
223: PROCEDURE chk_name
224: (p_name IN pay_rates.name%TYPE
225: ,p_rate_id IN pay_rates.rate_id%TYPE
226: ,p_business_group_id IN pay_rates.business_group_id%TYPE
227: ,p_object_version_number IN pay_rates.object_version_number%TYPE
228: ,p_rate_type IN pay_rates.rate_type%TYPE
229: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS

Line 226: ,p_business_group_id IN pay_rates.business_group_id%TYPE

222: --
223: PROCEDURE chk_name
224: (p_name IN pay_rates.name%TYPE
225: ,p_rate_id IN pay_rates.rate_id%TYPE
226: ,p_business_group_id IN pay_rates.business_group_id%TYPE
227: ,p_object_version_number IN pay_rates.object_version_number%TYPE
228: ,p_rate_type IN pay_rates.rate_type%TYPE
229: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
230: --

Line 227: ,p_object_version_number IN pay_rates.object_version_number%TYPE

223: PROCEDURE chk_name
224: (p_name IN pay_rates.name%TYPE
225: ,p_rate_id IN pay_rates.rate_id%TYPE
226: ,p_business_group_id IN pay_rates.business_group_id%TYPE
227: ,p_object_version_number IN pay_rates.object_version_number%TYPE
228: ,p_rate_type IN pay_rates.rate_type%TYPE
229: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
230: --
231: CURSOR chk_duplicate_name IS

Line 228: ,p_rate_type IN pay_rates.rate_type%TYPE

224: (p_name IN pay_rates.name%TYPE
225: ,p_rate_id IN pay_rates.rate_id%TYPE
226: ,p_business_group_id IN pay_rates.business_group_id%TYPE
227: ,p_object_version_number IN pay_rates.object_version_number%TYPE
228: ,p_rate_type IN pay_rates.rate_type%TYPE
229: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
230: --
231: CURSOR chk_duplicate_name IS
232: SELECT pr.name

Line 229: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS

225: ,p_rate_id IN pay_rates.rate_id%TYPE
226: ,p_business_group_id IN pay_rates.business_group_id%TYPE
227: ,p_object_version_number IN pay_rates.object_version_number%TYPE
228: ,p_rate_type IN pay_rates.rate_type%TYPE
229: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
230: --
231: CURSOR chk_duplicate_name IS
232: SELECT pr.name
233: FROM pay_rates pr

Line 233: FROM pay_rates pr

229: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
230: --
231: CURSOR chk_duplicate_name IS
232: SELECT pr.name
233: FROM pay_rates pr
234: WHERE pr.name = p_name
235: AND pr.rate_type = p_rate_type
236: AND business_group_id = p_business_group_id
237: AND ((p_rate_id IS NULL) OR

Line 251: l_name pay_rates.name%TYPE;

247: AND pr.asg_rate_type is null))
248: ));
249: --
250: l_proc VARCHAR2(72):= g_package || 'chk_name';
251: l_name pay_rates.name%TYPE;
252: l_api_updating BOOLEAN;
253: --
254: BEGIN
255: --

Line 313: (p_associated_column1 => 'PAY_RATES.NAME') THEN

309: --
310: WHEN app_exception.application_exception THEN
311: --
312: IF hr_multi_message.exception_add
313: (p_associated_column1 => 'PAY_RATES.NAME') THEN
314: --
315: hr_utility.set_location(' Leaving : '||l_proc,998);
316: --
317: RAISE;

Line 330: (p_rate_id IN pay_rates.rate_id%TYPE

326: -- |-------------------------< chk_for_child_records >-----------------------|
327: -- ---------------------------------------------------------------------------
328: --
329: PROCEDURE chk_for_child_records
330: (p_rate_id IN pay_rates.rate_id%TYPE
331: ,p_rate_type IN pay_rates.rate_type%TYPE) IS
332: --
333: CURSOR chk_for_records IS
334: SELECT 'X'

Line 331: ,p_rate_type IN pay_rates.rate_type%TYPE) IS

327: -- ---------------------------------------------------------------------------
328: --
329: PROCEDURE chk_for_child_records
330: (p_rate_id IN pay_rates.rate_id%TYPE
331: ,p_rate_type IN pay_rates.rate_type%TYPE) IS
332: --
333: CURSOR chk_for_records IS
334: SELECT 'X'
335: FROM pay_grade_rules_f pgr

Line 398: (p_rate_type IN pay_rates.rate_type%TYPE

394: -- |-------------------------< chk_field_combinations >-----------------------|
395: -- ---------------------------------------------------------------------------
396: --
397: PROCEDURE chk_field_combinations
398: (p_rate_type IN pay_rates.rate_type%TYPE
399: ,p_rate_uom IN pay_rates.rate_uom%TYPE
400: ,p_rate_basis IN pay_rates.rate_basis%TYPE
401: ,p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
402: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS

Line 399: ,p_rate_uom IN pay_rates.rate_uom%TYPE

395: -- ---------------------------------------------------------------------------
396: --
397: PROCEDURE chk_field_combinations
398: (p_rate_type IN pay_rates.rate_type%TYPE
399: ,p_rate_uom IN pay_rates.rate_uom%TYPE
400: ,p_rate_basis IN pay_rates.rate_basis%TYPE
401: ,p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
402: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
403: --

Line 400: ,p_rate_basis IN pay_rates.rate_basis%TYPE

396: --
397: PROCEDURE chk_field_combinations
398: (p_rate_type IN pay_rates.rate_type%TYPE
399: ,p_rate_uom IN pay_rates.rate_uom%TYPE
400: ,p_rate_basis IN pay_rates.rate_basis%TYPE
401: ,p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
402: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
403: --
404: l_proc VARCHAR2(72):= g_package || 'chk_correct_rate';

Line 401: ,p_parent_spine_id IN pay_rates.parent_spine_id%TYPE

397: PROCEDURE chk_field_combinations
398: (p_rate_type IN pay_rates.rate_type%TYPE
399: ,p_rate_uom IN pay_rates.rate_uom%TYPE
400: ,p_rate_basis IN pay_rates.rate_basis%TYPE
401: ,p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
402: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
403: --
404: l_proc VARCHAR2(72):= g_package || 'chk_correct_rate';
405: l_name pay_rates.name%TYPE;

Line 402: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS

398: (p_rate_type IN pay_rates.rate_type%TYPE
399: ,p_rate_uom IN pay_rates.rate_uom%TYPE
400: ,p_rate_basis IN pay_rates.rate_basis%TYPE
401: ,p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
402: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
403: --
404: l_proc VARCHAR2(72):= g_package || 'chk_correct_rate';
405: l_name pay_rates.name%TYPE;
406: l_api_updating BOOLEAN;

Line 405: l_name pay_rates.name%TYPE;

401: ,p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
402: ,p_asg_rate_type IN pay_rates.asg_rate_type%TYPE) IS
403: --
404: l_proc VARCHAR2(72):= g_package || 'chk_correct_rate';
405: l_name pay_rates.name%TYPE;
406: l_api_updating BOOLEAN;
407: --
408: BEGIN
409: --

Line 502: (p_parent_spine_id IN pay_rates.parent_spine_id%TYPE

498: -- |---------------------------< chk_parent_spine_id >------------------------|
499: -- ---------------------------------------------------------------------------
500: --
501: PROCEDURE chk_parent_spine_id
502: (p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
503: ,p_rate_id IN pay_rates.rate_id%TYPE
504: ,p_object_version_number IN pay_rates.object_version_number%TYPE ) IS
505: --
506: -- Declare Cursors

Line 503: ,p_rate_id IN pay_rates.rate_id%TYPE

499: -- ---------------------------------------------------------------------------
500: --
501: PROCEDURE chk_parent_spine_id
502: (p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
503: ,p_rate_id IN pay_rates.rate_id%TYPE
504: ,p_object_version_number IN pay_rates.object_version_number%TYPE ) IS
505: --
506: -- Declare Cursors
507: --

Line 504: ,p_object_version_number IN pay_rates.object_version_number%TYPE ) IS

500: --
501: PROCEDURE chk_parent_spine_id
502: (p_parent_spine_id IN pay_rates.parent_spine_id%TYPE
503: ,p_rate_id IN pay_rates.rate_id%TYPE
504: ,p_object_version_number IN pay_rates.object_version_number%TYPE ) IS
505: --
506: -- Declare Cursors
507: --
508: CURSOR csr_chk_parent_spine_fk IS

Line 569: (p_associated_column1 => 'PAY_RATES.PARENT_SPINE_ID') THEN

565: --
566: WHEN app_exception.application_exception THEN
567: --
568: IF hr_multi_message.exception_add
569: (p_associated_column1 => 'PAY_RATES.PARENT_SPINE_ID') THEN
570: --
571: hr_utility.set_location(' Leaving: '|| l_proc,998);
572: RAISE;
573: --

Line 601: ,pay_rates pyr1

597: SELECT 'y' from dual where exists
598: (select 'y'
599: from pay_grade_rules_f pgr1
600: ,pay_grade_rules_f pgr2
601: ,pay_rates pyr1
602: ,pay_rates pyr2
603: where pgr1.rate_id=pyr1.rate_id
604: and pgr2.rate_id=pyr2.rate_id
605: and pgr1.grade_or_spinal_point_id=pgr2.grade_or_spinal_point_id

Line 602: ,pay_rates pyr2

598: (select 'y'
599: from pay_grade_rules_f pgr1
600: ,pay_grade_rules_f pgr2
601: ,pay_rates pyr1
602: ,pay_rates pyr2
603: where pgr1.rate_id=pyr1.rate_id
604: and pgr2.rate_id=pyr2.rate_id
605: and pgr1.grade_or_spinal_point_id=pgr2.grade_or_spinal_point_id
606: and pgr1.effective_start_date

Line 685: , pay_rates pyr

681: --
682: CURSOR csr_sec_grp IS
683: SELECT pbg.security_group_id
684: FROM per_business_groups pbg
685: , pay_rates pyr
686: WHERE pyr.rate_id = p_rate_id
687: AND pbg.business_group_id = pyr.business_group_id;
688: --
689: -- Declare local variables

Line 749: , pay_rates pyr

745: --
746: CURSOR csr_leg_code IS
747: SELECT pbg.legislation_code
748: FROM per_business_groups pbg
749: , pay_rates pyr
750: WHERE pyr.rate_id = p_rate_id
751: AND pbg.business_group_id = pyr.business_group_id;
752: --
753: -- Declare local variables

Line 897: ,p_descflex_name => 'PAY_RATES'

893: -- b) During insert.
894: --
895: hr_dflex_utility.ins_or_upd_descflex_attribs
896: (p_appl_short_name => 'PAY'
897: ,p_descflex_name => 'PAY_RATES'
898: ,p_attribute_category => p_rec.attribute_category
899: ,p_attribute1_name => 'ATTRIBUTE1'
900: ,p_attribute1_value => p_rec.attribute1
901: ,p_attribute2_name => 'ATTRIBUTE2'