DBA Data[Home] [Help]

APPS.PAY_KR_ENTRIES_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 13: g_old_rec pay_element_entries_f%ROWTYPE;

9: c_np_prem_en constant pay_element_types_f.element_name%TYPE := 'NP_PREM';
10: c_ei_prem_en constant pay_element_types_f.element_name%TYPE := 'EI_PREM'; -- Bug 10434174
11:
12: -- Global record definition
13: g_old_rec pay_element_entries_f%ROWTYPE;
14:
15: -- Global package name
16: g_package varchar2(33) := ' pay_kr_entries_pkg.';
17: g_debug boolean := hr_utility.debug_enabled;

Line 766: l_entry_type pay_element_entries_f.entry_type%TYPE;

762: )
763: is
764:
765: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
766: l_entry_type pay_element_entries_f.entry_type%TYPE;
767: l_processing_type pay_element_types_f.processing_type%TYPE;
768:
769: cursor c_sel1 is
770: select pee.entry_type,

Line 774: pay_element_entries_f pee

770: select pee.entry_type,
771: pet.processing_type
772: from pay_element_types_f pet,
773: pay_element_links_f pel,
774: pay_element_entries_f pee
775: where pee.element_entry_id = p_base_key_value
776: and p_effective_date between pee.effective_start_date
777: and pee.effective_end_date
778: and pel.element_link_id = pee.element_link_id

Line 814: p_base_table_name => 'pay_element_entries_f',

810: -- Call the corresponding datetrack api
811: --
812: dt_api.find_dt_upd_modes(
813: p_effective_date => p_effective_date,
814: p_base_table_name => 'pay_element_entries_f',
815: p_base_key_column => 'element_entry_id',
816: p_base_key_value => p_base_key_value,
817: p_correction => p_correction,
818: p_update => p_update,

Line 852: l_entry_type pay_element_entries_f.entry_type%TYPE;

848:
849: l_proc varchar2(72) := g_package || 'find_dt_del_modes';
850: l_parent_key_value1 number;
851: l_parent_key_value2 number;
852: l_entry_type pay_element_entries_f.entry_type%TYPE;
853: l_processing_type pay_element_types_f.processing_type%TYPE;
854:
855: cursor c_sel1 is
856: select pee.assignment_id,

Line 862: pay_element_entries_f pee

858: pee.entry_type,
859: pet.processing_type
860: from pay_element_types_f pet,
861: pay_element_links_f pel,
862: pay_element_entries_f pee
863: where pee.element_entry_id = p_base_key_value
864: and p_effective_date between pee.effective_start_date
865: and pee.effective_end_date
866: and pel.element_link_id = pee.element_link_id

Line 905: p_base_table_name => 'pay_element_entries_f',

901: -- Call the corresponding datetrack api
902: --
903: dt_api.find_dt_del_modes(
904: p_effective_date => p_effective_date,
905: p_base_table_name => 'pay_element_entries_f',
906: p_base_key_column => 'element_entry_id',
907: p_base_key_value => p_base_key_value,
908: p_parent_table_name1 => 'per_all_assignments_f',
909: p_parent_key_column1 => 'assignment_id',

Line 939: p_rec in pay_element_entries_f%ROWTYPE,

935: procedure ins_lck
936: (
937: p_effective_date in date,
938: p_datetrack_mode in varchar2,
939: p_rec in pay_element_entries_f%ROWTYPE,
940: p_validation_start_date out NOCOPY date,
941: p_validation_end_date out NOCOPY date
942: )
943: is

Line 960: p_base_table_name => 'pay_element_entries_f',

956: --
957: dt_api.validate_dt_mode(
958: p_effective_date => p_effective_date,
959: p_datetrack_mode => p_datetrack_mode,
960: p_base_table_name => 'pay_element_entries_f',
961: p_base_key_column => 'element_entry_id',
962: p_base_key_value => p_rec.element_entry_id,
963: p_parent_table_name1 => 'per_all_assignments_f',
964: p_parent_key_column1 => 'assignment_id',

Line 1016: from pay_element_entries_f

1012: -- ensuring that the object version numbers match.
1013: --
1014: cursor c_sel1 is
1015: select *
1016: from pay_element_entries_f
1017: where element_entry_id = p_element_entry_id
1018: and p_effective_date between effective_start_date
1019: and effective_end_date
1020: for update nowait;

Line 1080: p_base_table_name => 'pay_element_entries_f',

1076:
1077: dt_api.validate_dt_mode(
1078: p_effective_date => p_effective_date,
1079: p_datetrack_mode => p_datetrack_mode,
1080: p_base_table_name => 'pay_element_entries_f',
1081: p_base_key_column => 'element_entry_id',
1082: p_base_key_value => p_element_entry_id,
1083: p_parent_table_name1 => 'per_all_assignments_f',
1084: p_parent_key_column1 => 'assignment_id',

Line 1124: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');

1120: -- The object is locked therefore we need to supply a meaningful
1121: -- error message.
1122: --
1123: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1124: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1125: hr_utility.raise_error;
1126: when l_object_invalid then
1127: --
1128: -- The object doesn't exist or is invalid

Line 1131: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');

1127: --
1128: -- The object doesn't exist or is invalid
1129: --
1130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1131: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1132: hr_utility.raise_error;
1133:
1134: end lck;
1135: