DBA Data[Home] [Help]

APPS.PAY_JP_ENTRIES_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 43: g_old_rec pay_element_entries_f%ROWTYPE; -- Global record definition

39: -- Current Element Entry Row Hander "pay_ele_shd" does not comply with API
40: -- strategy. "pay_ele_shd" is like API, but not API. So this package
41: -- used in PAYJPTAX form implement part of real API to use DTCSAPI library.
42: --
43: g_old_rec pay_element_entries_f%ROWTYPE; -- Global record definition
44: g_package varchar2(33) := ' pay_jp_entries_pkg.'; -- Global package name
45: --
46: -- ----------------------------------------------------------------------------
47: -- |------------------------< element_name >----------------------------------|

Line 723: l_entry_type pay_element_entries_f.entry_type%TYPE;

719: Is
720: --
721: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
722: --
723: l_entry_type pay_element_entries_f.entry_type%TYPE;
724: l_processing_type pay_element_types_f.processing_type%TYPE;
725: --
726: Cursor C_Sel1 Is
727: select pee.entry_type,

Line 731: pay_element_entries_f pee

727: select pee.entry_type,
728: pet.processing_type
729: from pay_element_types_f pet,
730: pay_element_links_f pel,
731: pay_element_entries_f pee
732: where pee.element_entry_id = p_base_key_value
733: and p_effective_date
734: between pee.effective_start_date and pee.effective_end_date
735: and pel.element_link_id = pee.element_link_id

Line 768: p_base_table_name => 'pay_element_entries_f',

764: -- Call the corresponding datetrack api
765: --
766: dt_api.find_dt_upd_modes
767: (p_effective_date => p_effective_date,
768: p_base_table_name => 'pay_element_entries_f',
769: p_base_key_column => 'element_entry_id',
770: p_base_key_value => p_base_key_value,
771: p_correction => p_correction,
772: p_update => p_update,

Line 800: l_entry_type pay_element_entries_f.entry_type%TYPE;

796: l_proc varchar2(72) := g_package||'find_dt_del_modes';
797: --
798: l_parent_key_value1 number;
799: l_parent_key_value2 number;
800: l_entry_type pay_element_entries_f.entry_type%TYPE;
801: l_processing_type pay_element_types_f.processing_type%TYPE;
802: --
803: Cursor C_Sel1 Is
804: select pee.assignment_id,

Line 810: pay_element_entries_f pee

806: pee.entry_type,
807: pet.processing_type
808: from pay_element_types_f pet,
809: pay_element_links_f pel,
810: pay_element_entries_f pee
811: where pee.element_entry_id = p_base_key_value
812: and p_effective_date
813: between pee.effective_start_date and pee.effective_end_date
814: and pel.element_link_id = pee.element_link_id

Line 849: p_base_table_name => 'pay_element_entries_f',

845: -- Call the corresponding datetrack api
846: --
847: dt_api.find_dt_del_modes
848: (p_effective_date => p_effective_date,
849: p_base_table_name => 'pay_element_entries_f',
850: p_base_key_column => 'element_entry_id',
851: p_base_key_value => p_base_key_value,
852: p_parent_table_name1 => 'per_all_assignments_f',
853: p_parent_key_column1 => 'assignment_id',

Line 877: p_rec in pay_element_entries_f%ROWTYPE,

873: --
874: Procedure ins_lck
875: (p_effective_date in date,
876: p_datetrack_mode in varchar2,
877: p_rec in pay_element_entries_f%ROWTYPE,
878: p_validation_start_date out nocopy date,
879: p_validation_end_date out nocopy date)
880: Is
881: --

Line 895: p_base_table_name => 'pay_element_entries_f',

891: --
892: dt_api.validate_dt_mode
893: (p_effective_date => p_effective_date,
894: p_datetrack_mode => p_datetrack_mode,
895: p_base_table_name => 'pay_element_entries_f',
896: p_base_key_column => 'element_entry_id',
897: p_base_key_value => p_rec.element_entry_id,
898: p_parent_table_name1 => 'per_all_assignments_f',
899: p_parent_key_column1 => 'assignment_id',

Line 946: from pay_element_entries_f

942: -- ensuring that the object version numbers match.
943: --
944: Cursor C_Sel1 is
945: select *
946: from pay_element_entries_f
947: where element_entry_id = p_element_entry_id
948: and p_effective_date between effective_start_date
949: and effective_end_date
950: for update nowait;

Line 1041: p_base_table_name => 'pay_element_entries_f',

1037: hr_utility.set_location('Entering validation_dt_mode', 15);
1038: dt_api.validate_dt_mode
1039: (p_effective_date => p_effective_date,
1040: p_datetrack_mode => p_datetrack_mode,
1041: p_base_table_name => 'pay_element_entries_f',
1042: p_base_key_column => 'element_entry_id',
1043: p_base_key_value => p_element_entry_id,
1044: p_parent_table_name1 => 'per_all_assignments_f',
1045: p_parent_key_column1 => 'assignment_id',

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

1078: -- The object is locked therefore we need to supply a meaningful
1079: -- error message.
1080: --
1081: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1082: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1083: hr_utility.raise_error;
1084: When l_object_invalid then
1085: --
1086: -- The object doesn't exist or is invalid

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

1085: --
1086: -- The object doesn't exist or is invalid
1087: --
1088: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1089: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1090: hr_utility.raise_error;
1091: End lck;
1092: --
1093: -- ----------------------------------------------------------------------------