[Home] [Help]
8: c_hi_prem_en constant pay_element_types_f.element_name%TYPE := 'HI_PREM';
9: c_np_prem_en constant pay_element_types_f.element_name%TYPE := 'NP_PREM';
10:
11: -- Global record definition
12: g_old_rec pay_element_entries_f%ROWTYPE;
13:
14: -- Global package name
15: g_package varchar2(33) := ' pay_kr_entries_pkg.';
16: g_debug boolean := hr_utility.debug_enabled;
759: )
760: is
761:
762: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
763: l_entry_type pay_element_entries_f.entry_type%TYPE;
764: l_processing_type pay_element_types_f.processing_type%TYPE;
765:
766: cursor c_sel1 is
767: select pee.entry_type,
767: select pee.entry_type,
768: pet.processing_type
769: from pay_element_types_f pet,
770: pay_element_links_f pel,
771: pay_element_entries_f pee
772: where pee.element_entry_id = p_base_key_value
773: and p_effective_date between pee.effective_start_date
774: and pee.effective_end_date
775: and pel.element_link_id = pee.element_link_id
807: -- Call the corresponding datetrack api
808: --
809: dt_api.find_dt_upd_modes(
810: p_effective_date => p_effective_date,
811: p_base_table_name => 'pay_element_entries_f',
812: p_base_key_column => 'element_entry_id',
813: p_base_key_value => p_base_key_value,
814: p_correction => p_correction,
815: p_update => p_update,
845:
846: l_proc varchar2(72) := g_package || 'find_dt_del_modes';
847: l_parent_key_value1 number;
848: l_parent_key_value2 number;
849: l_entry_type pay_element_entries_f.entry_type%TYPE;
850: l_processing_type pay_element_types_f.processing_type%TYPE;
851:
852: cursor c_sel1 is
853: select pee.assignment_id,
855: pee.entry_type,
856: pet.processing_type
857: from pay_element_types_f pet,
858: pay_element_links_f pel,
859: pay_element_entries_f pee
860: where pee.element_entry_id = p_base_key_value
861: and p_effective_date between pee.effective_start_date
862: and pee.effective_end_date
863: and pel.element_link_id = pee.element_link_id
898: -- Call the corresponding datetrack api
899: --
900: dt_api.find_dt_del_modes(
901: p_effective_date => p_effective_date,
902: p_base_table_name => 'pay_element_entries_f',
903: p_base_key_column => 'element_entry_id',
904: p_base_key_value => p_base_key_value,
905: p_parent_table_name1 => 'per_all_assignments_f',
906: p_parent_key_column1 => 'assignment_id',
932: procedure ins_lck
933: (
934: p_effective_date in date,
935: p_datetrack_mode in varchar2,
936: p_rec in pay_element_entries_f%ROWTYPE,
937: p_validation_start_date out NOCOPY date,
938: p_validation_end_date out NOCOPY date
939: )
940: is
953: --
954: dt_api.validate_dt_mode(
955: p_effective_date => p_effective_date,
956: p_datetrack_mode => p_datetrack_mode,
957: p_base_table_name => 'pay_element_entries_f',
958: p_base_key_column => 'element_entry_id',
959: p_base_key_value => p_rec.element_entry_id,
960: p_parent_table_name1 => 'per_all_assignments_f',
961: p_parent_key_column1 => 'assignment_id',
1009: -- ensuring that the object version numbers match.
1010: --
1011: cursor c_sel1 is
1012: select *
1013: from pay_element_entries_f
1014: where element_entry_id = p_element_entry_id
1015: and p_effective_date between effective_start_date
1016: and effective_end_date
1017: for update nowait;
1073:
1074: dt_api.validate_dt_mode(
1075: p_effective_date => p_effective_date,
1076: p_datetrack_mode => p_datetrack_mode,
1077: p_base_table_name => 'pay_element_entries_f',
1078: p_base_key_column => 'element_entry_id',
1079: p_base_key_value => p_element_entry_id,
1080: p_parent_table_name1 => 'per_all_assignments_f',
1081: p_parent_key_column1 => 'assignment_id',
1117: -- The object is locked therefore we need to supply a meaningful
1118: -- error message.
1119: --
1120: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1121: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1122: hr_utility.raise_error;
1123: when l_object_invalid then
1124: --
1125: -- The object doesn't exist or is invalid
1124: --
1125: -- The object doesn't exist or is invalid
1126: --
1127: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1128: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1129: hr_utility.raise_error;
1130:
1131: end lck;
1132: