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_PRT_INS dependencies on PAY_RUN_TYPES_F

Line 89: from pay_run_types_f t

85: --
86: Cursor C_Sel1 Is
87: select t.created_by,
88: t.creation_date
89: from pay_run_types_f t
90: where t.run_type_id = p_rec.run_type_id
91: and t.effective_start_date =
92: pay_prt_shd.g_old_rec.effective_start_date
93: and t.effective_end_date = (p_validation_start_date - 1);

Line 96: l_created_by pay_run_types_f.created_by%TYPE;

92: pay_prt_shd.g_old_rec.effective_start_date
93: and t.effective_end_date = (p_validation_start_date - 1);
94: --
95: l_proc varchar2(72) := g_package||'dt_insert_dml';
96: l_created_by pay_run_types_f.created_by%TYPE;
97: l_creation_date pay_run_types_f.creation_date%TYPE;
98: l_last_update_date pay_run_types_f.last_update_date%TYPE;
99: l_last_updated_by pay_run_types_f.last_updated_by%TYPE;
100: l_last_update_login pay_run_types_f.last_update_login%TYPE;

Line 97: l_creation_date pay_run_types_f.creation_date%TYPE;

93: and t.effective_end_date = (p_validation_start_date - 1);
94: --
95: l_proc varchar2(72) := g_package||'dt_insert_dml';
96: l_created_by pay_run_types_f.created_by%TYPE;
97: l_creation_date pay_run_types_f.creation_date%TYPE;
98: l_last_update_date pay_run_types_f.last_update_date%TYPE;
99: l_last_updated_by pay_run_types_f.last_updated_by%TYPE;
100: l_last_update_login pay_run_types_f.last_update_login%TYPE;
101: --

Line 98: l_last_update_date pay_run_types_f.last_update_date%TYPE;

94: --
95: l_proc varchar2(72) := g_package||'dt_insert_dml';
96: l_created_by pay_run_types_f.created_by%TYPE;
97: l_creation_date pay_run_types_f.creation_date%TYPE;
98: l_last_update_date pay_run_types_f.last_update_date%TYPE;
99: l_last_updated_by pay_run_types_f.last_updated_by%TYPE;
100: l_last_update_login pay_run_types_f.last_update_login%TYPE;
101: --
102: Begin

Line 99: l_last_updated_by pay_run_types_f.last_updated_by%TYPE;

95: l_proc varchar2(72) := g_package||'dt_insert_dml';
96: l_created_by pay_run_types_f.created_by%TYPE;
97: l_creation_date pay_run_types_f.creation_date%TYPE;
98: l_last_update_date pay_run_types_f.last_update_date%TYPE;
99: l_last_updated_by pay_run_types_f.last_updated_by%TYPE;
100: l_last_update_login pay_run_types_f.last_update_login%TYPE;
101: --
102: Begin
103: hr_utility.set_location('Entering:'||l_proc, 5);

Line 100: l_last_update_login pay_run_types_f.last_update_login%TYPE;

96: l_created_by pay_run_types_f.created_by%TYPE;
97: l_creation_date pay_run_types_f.creation_date%TYPE;
98: l_last_update_date pay_run_types_f.last_update_date%TYPE;
99: l_last_updated_by pay_run_types_f.last_updated_by%TYPE;
100: l_last_update_login pay_run_types_f.last_update_login%TYPE;
101: --
102: Begin
103: hr_utility.set_location('Entering:'||l_proc, 5);
104: --

Line 109: (p_base_table_name => 'pay_run_types_f'

105: -- Get the object version number for the insert
106: --
107: p_rec.object_version_number :=
108: dt_api.get_object_version_number
109: (p_base_table_name => 'pay_run_types_f'
110: ,p_base_key_column => 'run_type_id'
111: ,p_base_key_value => p_rec.run_type_id
112: );
113: --

Line 150: -- Insert the row into: pay_run_types_f

146: l_last_updated_by := fnd_global.user_id;
147: l_last_update_login := fnd_global.login_id;
148: End If;
149: --
150: -- Insert the row into: pay_run_types_f
151: --
152: insert into pay_run_types_f
153: (run_type_id
154: ,run_type_name

Line 152: insert into pay_run_types_f

148: End If;
149: --
150: -- Insert the row into: pay_run_types_f
151: --
152: insert into pay_run_types_f
153: (run_type_id
154: ,run_type_name
155: ,run_method
156: ,effective_start_date

Line 398: from pay_run_types_f

394: Cursor C_Sel1 is select pay_run_types_s.nextval from sys.dual;
395: --
396: Cursor C_Sel2 is
397: Select null
398: from pay_run_types_f
399: where run_type_id =
400: pay_prt_ins.g_run_type_id_i;
401: --
402: l_proc varchar2(72) := g_package||'pre_insert';

Line 419: fnd_message.set_token('TABLE_NAME','pay_run_types_f');

415: --
416: -- The primary key values are already in use.
417: --
418: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
419: fnd_message.set_token('TABLE_NAME','pay_run_types_f');
420: fnd_message.raise_error;
421: End If;
422: Close C_Sel2;
423: --

Line 592: (p_module_name => 'PAY_RUN_TYPES_F'

588: --
589: when hr_api.cannot_find_prog_unit then
590: --
591: hr_api.cannot_find_prog_unit_error
592: (p_module_name => 'PAY_RUN_TYPES_F'
593: ,p_hook_type => 'AI');
594: --
595: end;
596: --

Line 657: ,p_base_table_name => 'pay_run_types_f'

653: --
654: dt_api.validate_dt_mode
655: (p_effective_date => p_effective_date
656: ,p_datetrack_mode => p_datetrack_mode
657: ,p_base_table_name => 'pay_run_types_f'
658: ,p_base_key_column => 'run_type_id'
659: ,p_base_key_value => p_rec.run_type_id
660: ,p_enforce_foreign_locking => true
661: ,p_validation_start_date => l_validation_start_date