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.PER_BIL_SHD dependencies on HR_SUMMARY

Line 36: If (p_constraint_name = 'hr_summary_PK') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'hr_summary_PK') Then
37: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 134: from hr_summary

130: date_value1,
131: date_value2,
132: date_value3,
133: created_by
134: from hr_summary
135: where id_value = p_id_value;
136: --
137: l_proc varchar2(72) := g_package||'api_updating';
138: l_fct_ret boolean;

Line 222: from hr_summary

218: date_value1,
219: date_value2,
220: date_value3,
221: created_by
222: from hr_summary
223: where id_value = p_id_value
224: for update nowait;
225: --
226: l_proc varchar2(72) := g_package||'lck';

Line 265: hr_utility.set_message_token('TABLE_NAME', 'hr_summary');

261: -- The object is locked therefore we need to supply a meaningful
262: -- error message.
263: --
264: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
265: hr_utility.set_message_token('TABLE_NAME', 'hr_summary');
266: hr_utility.raise_error;
267: End lck;
268: --
269: -- ----------------------------------------------------------------------------

Line 341: from hr_summary

337: Function row_exist (p_rec in per_bil_shd.g_rec_type) return boolean is
338:
339: cursor csr_exists is
340: select 'x'
341: from hr_summary
342: where (type = p_rec.type
343: and p_rec.type in ('TEMPLATE','ITEM_TYPE','KEY_TYPE','RESTRICTION_TYPE')
344: and text_value1 = p_rec.text_value1
345: and business_group_id = p_rec.business_group_id

Line 440: from hr_summary_item_type_usage

436: Function sequence_exist (p_rec in per_bil_shd.g_rec_type) return boolean is
437: --
438: cursor csr_exists is
439: select 'x'
440: from hr_summary_item_type_usage
441: where sequence_number = p_rec.num_value1
442: and business_group_id = p_rec.business_group_id
443: and template_id = p_rec.fk_value1;
444: --

Line 549: from hr_summary_restriction_type rt,

545: cursor csr_lov_exists (p_ru_id number,
546: p_bus_grp_id number) is
547: select rt.restriction_sql,
548: rt.title
549: from hr_summary_restriction_type rt,
550: hr_summary_restriction_usage ru,
551: hr_summary_valid_restriction vr
552: where vr.restriction_type_id = rt.restriction_type_id
553: and ru.valid_restriction_id = vr.valid_restriction_id

Line 550: hr_summary_restriction_usage ru,

546: p_bus_grp_id number) is
547: select rt.restriction_sql,
548: rt.title
549: from hr_summary_restriction_type rt,
550: hr_summary_restriction_usage ru,
551: hr_summary_valid_restriction vr
552: where vr.restriction_type_id = rt.restriction_type_id
553: and ru.valid_restriction_id = vr.valid_restriction_id
554: and ru.restriction_usage_id = p_ru_id

Line 551: hr_summary_valid_restriction vr

547: select rt.restriction_sql,
548: rt.title
549: from hr_summary_restriction_type rt,
550: hr_summary_restriction_usage ru,
551: hr_summary_valid_restriction vr
552: where vr.restriction_type_id = rt.restriction_type_id
553: and ru.valid_restriction_id = vr.valid_restriction_id
554: and ru.restriction_usage_id = p_ru_id
555: and ru.business_group_id = p_bus_grp_id;

Line 652: from hr_summary_restriction_type rt,

648: --
649: cursor csr_get_sql is
650: select rt.restriction_sql
651: , rt.business_group_id
652: from hr_summary_restriction_type rt,
653: hr_summary_valid_restriction vr
654: where rt.restriction_type_id = vr.restriction_type_id
655: and rt.business_group_id = vr.business_group_id
656: and vr.valid_restriction_id = p_valid_restriction_id;

Line 653: hr_summary_valid_restriction vr

649: cursor csr_get_sql is
650: select rt.restriction_sql
651: , rt.business_group_id
652: from hr_summary_restriction_type rt,
653: hr_summary_valid_restriction vr
654: where rt.restriction_type_id = vr.restriction_type_id
655: and rt.business_group_id = vr.business_group_id
656: and vr.valid_restriction_id = p_valid_restriction_id;
657: --

Line 699: from hr_summary

695: Function parent_found (p_rec in per_bil_shd.g_rec_type) return boolean is
696: --
697: cursor csr_exists (p_value number) is
698: select 'x'
699: from hr_summary
700: where id_value = p_value
701: and business_group_id = p_rec.business_group_id;
702: --
703: l_dummy varchar2(1);

Line 754: from hr_summary_restriction_type rt,

750: Function chk_date_valid (p_rec in per_bil_shd.g_rec_type) return boolean is
751: --
752: cursor csr_get_datatype IS
753: select rt.data_type
754: from hr_summary_restriction_type rt,
755: hr_summary_valid_restriction vr,
756: hr_summary_restriction_usage rtu
757: where rt.restriction_type_id = vr.restriction_type_id
758: and rt.business_group_id = vr.business_group_id

Line 755: hr_summary_valid_restriction vr,

751: --
752: cursor csr_get_datatype IS
753: select rt.data_type
754: from hr_summary_restriction_type rt,
755: hr_summary_valid_restriction vr,
756: hr_summary_restriction_usage rtu
757: where rt.restriction_type_id = vr.restriction_type_id
758: and rt.business_group_id = vr.business_group_id
759: and vr.valid_restriction_id = rtu.valid_restriction_id

Line 756: hr_summary_restriction_usage rtu

752: cursor csr_get_datatype IS
753: select rt.data_type
754: from hr_summary_restriction_type rt,
755: hr_summary_valid_restriction vr,
756: hr_summary_restriction_usage rtu
757: where rt.restriction_type_id = vr.restriction_type_id
758: and rt.business_group_id = vr.business_group_id
759: and vr.valid_restriction_id = rtu.valid_restriction_id
760: and rtu.restriction_usage_id = p_rec.fk_value1;