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_ELEMENT_TYPES_MIG dependencies on PAY_ELEMENT_TYPES_F

Line 131: l_element_type_id pay_element_types_f.element_type_id%type;

127: l_assignment_id_warning boolean;
128: l_iv_effective_start_date date;
129: l_iv_effective_end_date date;
130: l_display_sequence number(1) := 0;
131: l_element_type_id pay_element_types_f.element_type_id%type;
132: l_object_version_number pay_element_types_f.object_version_number%type;
133: l_comment_id pay_element_types_f.comment_id%type;
134: l_input_currency_code pay_element_types_f.input_currency_code%type;
135: l_output_currency_code pay_element_types_f.output_currency_code%type;

Line 132: l_object_version_number pay_element_types_f.object_version_number%type;

128: l_iv_effective_start_date date;
129: l_iv_effective_end_date date;
130: l_display_sequence number(1) := 0;
131: l_element_type_id pay_element_types_f.element_type_id%type;
132: l_object_version_number pay_element_types_f.object_version_number%type;
133: l_comment_id pay_element_types_f.comment_id%type;
134: l_input_currency_code pay_element_types_f.input_currency_code%type;
135: l_output_currency_code pay_element_types_f.output_currency_code%type;
136: l_default_priority pay_element_types_f.processing_priority%type;

Line 133: l_comment_id pay_element_types_f.comment_id%type;

129: l_iv_effective_end_date date;
130: l_display_sequence number(1) := 0;
131: l_element_type_id pay_element_types_f.element_type_id%type;
132: l_object_version_number pay_element_types_f.object_version_number%type;
133: l_comment_id pay_element_types_f.comment_id%type;
134: l_input_currency_code pay_element_types_f.input_currency_code%type;
135: l_output_currency_code pay_element_types_f.output_currency_code%type;
136: l_default_priority pay_element_types_f.processing_priority%type;
137: l_processing_priority pay_element_types_f.processing_priority%type;

Line 134: l_input_currency_code pay_element_types_f.input_currency_code%type;

130: l_display_sequence number(1) := 0;
131: l_element_type_id pay_element_types_f.element_type_id%type;
132: l_object_version_number pay_element_types_f.object_version_number%type;
133: l_comment_id pay_element_types_f.comment_id%type;
134: l_input_currency_code pay_element_types_f.input_currency_code%type;
135: l_output_currency_code pay_element_types_f.output_currency_code%type;
136: l_default_priority pay_element_types_f.processing_priority%type;
137: l_processing_priority pay_element_types_f.processing_priority%type;
138: l_input_value_id pay_input_values_f.input_value_id%type;

Line 135: l_output_currency_code pay_element_types_f.output_currency_code%type;

131: l_element_type_id pay_element_types_f.element_type_id%type;
132: l_object_version_number pay_element_types_f.object_version_number%type;
133: l_comment_id pay_element_types_f.comment_id%type;
134: l_input_currency_code pay_element_types_f.input_currency_code%type;
135: l_output_currency_code pay_element_types_f.output_currency_code%type;
136: l_default_priority pay_element_types_f.processing_priority%type;
137: l_processing_priority pay_element_types_f.processing_priority%type;
138: l_input_value_id pay_input_values_f.input_value_id%type;
139: l_iv_object_version_number pay_input_values_f.object_version_number%type;

Line 136: l_default_priority pay_element_types_f.processing_priority%type;

132: l_object_version_number pay_element_types_f.object_version_number%type;
133: l_comment_id pay_element_types_f.comment_id%type;
134: l_input_currency_code pay_element_types_f.input_currency_code%type;
135: l_output_currency_code pay_element_types_f.output_currency_code%type;
136: l_default_priority pay_element_types_f.processing_priority%type;
137: l_processing_priority pay_element_types_f.processing_priority%type;
138: l_input_value_id pay_input_values_f.input_value_id%type;
139: l_iv_object_version_number pay_input_values_f.object_version_number%type;
140: l_formula_message fnd_new_messages.message_text%type;

Line 137: l_processing_priority pay_element_types_f.processing_priority%type;

133: l_comment_id pay_element_types_f.comment_id%type;
134: l_input_currency_code pay_element_types_f.input_currency_code%type;
135: l_output_currency_code pay_element_types_f.output_currency_code%type;
136: l_default_priority pay_element_types_f.processing_priority%type;
137: l_processing_priority pay_element_types_f.processing_priority%type;
138: l_input_value_id pay_input_values_f.input_value_id%type;
139: l_iv_object_version_number pay_input_values_f.object_version_number%type;
140: l_formula_message fnd_new_messages.message_text%type;
141: l_language_code pay_element_types_f_tl.language%type;

Line 141: l_language_code pay_element_types_f_tl.language%type;

137: l_processing_priority pay_element_types_f.processing_priority%type;
138: l_input_value_id pay_input_values_f.input_value_id%type;
139: l_iv_object_version_number pay_input_values_f.object_version_number%type;
140: l_formula_message fnd_new_messages.message_text%type;
141: l_language_code pay_element_types_f_tl.language%type;
142:
143: --
144: Cursor c_non_payments
145: is

Line 393: -- Create default entries in pay_element_types_f_tl table

389: ,p_processing_priority_warning => l_processing_priority_warning
390: );
391:
392: --
393: -- Create default entries in pay_element_types_f_tl table
394: --
395: pay_ett_ins.ins_tl
396: (p_language_code => l_language_code
397: ,p_element_type_id => l_element_type_id

Line 800: l_object_version_number pay_element_types_f.object_version_number%type;

796: l_element_name_warning boolean;
797: l_element_name_change_warning boolean;
798: l_rowcount number;
799: l_datetrack_update_mode varchar2(30) := p_datetrack_update_mode;
800: l_object_version_number pay_element_types_f.object_version_number%type;
801: l_comment_id pay_element_types_f.comment_id%type;
802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;

Line 801: l_comment_id pay_element_types_f.comment_id%type;

797: l_element_name_change_warning boolean;
798: l_rowcount number;
799: l_datetrack_update_mode varchar2(30) := p_datetrack_update_mode;
800: l_object_version_number pay_element_types_f.object_version_number%type;
801: l_comment_id pay_element_types_f.comment_id%type;
802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;
805: l_recreate_db_items varchar2(1) := 'N';

Line 802: l_old_rec pay_element_types_f%rowtype;

798: l_rowcount number;
799: l_datetrack_update_mode varchar2(30) := p_datetrack_update_mode;
800: l_object_version_number pay_element_types_f.object_version_number%type;
801: l_comment_id pay_element_types_f.comment_id%type;
802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;
805: l_recreate_db_items varchar2(1) := 'N';
806: l_language_code pay_element_types_f_tl.language%type;

Line 803: l_current_rec pay_element_types_f_tl%rowtype;

799: l_datetrack_update_mode varchar2(30) := p_datetrack_update_mode;
800: l_object_version_number pay_element_types_f.object_version_number%type;
801: l_comment_id pay_element_types_f.comment_id%type;
802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;
805: l_recreate_db_items varchar2(1) := 'N';
806: l_language_code pay_element_types_f_tl.language%type;
807:

Line 804: l_base_element_name pay_element_types_f.element_name%type;

800: l_object_version_number pay_element_types_f.object_version_number%type;
801: l_comment_id pay_element_types_f.comment_id%type;
802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;
805: l_recreate_db_items varchar2(1) := 'N';
806: l_language_code pay_element_types_f_tl.language%type;
807:
808:

Line 806: l_language_code pay_element_types_f_tl.language%type;

802: l_old_rec pay_element_types_f%rowtype;
803: l_current_rec pay_element_types_f_tl%rowtype;
804: l_base_element_name pay_element_types_f.element_name%type;
805: l_recreate_db_items varchar2(1) := 'N';
806: l_language_code pay_element_types_f_tl.language%type;
807:
808:
809: Cursor c_old_rec (v_effective_date date)
810: is

Line 812: from pay_element_types_f etp

808:
809: Cursor c_old_rec (v_effective_date date)
810: is
811: select etp.*
812: from pay_element_types_f etp
813: where element_type_id = p_element_type_id
814: and nvl(v_effective_date,effective_start_date) >= effective_start_date
815: and nvl(v_effective_date,effective_end_date) <= effective_end_date;
816: --

Line 820: FROM pay_element_types_f_tl ett

816: --
817: CURSOR elem_cursor (p_language_code in varchar2)
818: IS
819: SELECT source_lang, element_name, element_type_id
820: FROM pay_element_types_f_tl ett
821: WHERE ett.element_type_id = p_element_type_id
822: AND ett.language = nvl(p_language_code,ett.language);
823:
824: begin

Line 1345: l_object_version_number pay_element_types_f.object_version_number%type;

1341: l_effective_start_date date;
1342: l_effective_end_date date;
1343: l_balance_feeds_warning boolean;
1344: l_processing_rules_warning boolean;
1345: l_object_version_number pay_element_types_f.object_version_number%type;
1346: --
1347: begin
1348: hr_utility.set_location('Entering:'|| l_proc, 10);
1349: --