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_PAY_INS dependencies on PAY_ALL_PAYROLLS_F

Line 129: from pay_all_payrolls_f t

125: --
126: Cursor C_Sel1 Is
127: select t.created_by,
128: t.creation_date
129: from pay_all_payrolls_f t
130: where t.payroll_id = p_rec.payroll_id
131: and t.effective_start_date =
132: pay_pay_shd.g_old_rec.effective_start_date
133: and t.effective_end_date = (p_validation_start_date - 1);

Line 136: l_created_by pay_all_payrolls_f.created_by%TYPE;

132: pay_pay_shd.g_old_rec.effective_start_date
133: and t.effective_end_date = (p_validation_start_date - 1);
134: --
135: l_proc varchar2(72) := g_package||'dt_insert_dml';
136: l_created_by pay_all_payrolls_f.created_by%TYPE;
137: l_creation_date pay_all_payrolls_f.creation_date%TYPE ;
138: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
139: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
140: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;

Line 137: l_creation_date pay_all_payrolls_f.creation_date%TYPE ;

133: and t.effective_end_date = (p_validation_start_date - 1);
134: --
135: l_proc varchar2(72) := g_package||'dt_insert_dml';
136: l_created_by pay_all_payrolls_f.created_by%TYPE;
137: l_creation_date pay_all_payrolls_f.creation_date%TYPE ;
138: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
139: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
140: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
141:

Line 138: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;

134: --
135: l_proc varchar2(72) := g_package||'dt_insert_dml';
136: l_created_by pay_all_payrolls_f.created_by%TYPE;
137: l_creation_date pay_all_payrolls_f.creation_date%TYPE ;
138: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
139: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
140: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
141:
142: l_effective_start_date date;

Line 139: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;

135: l_proc varchar2(72) := g_package||'dt_insert_dml';
136: l_created_by pay_all_payrolls_f.created_by%TYPE;
137: l_creation_date pay_all_payrolls_f.creation_date%TYPE ;
138: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
139: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
140: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
141:
142: l_effective_start_date date;
143: l_effective_end_date date;

Line 140: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;

136: l_created_by pay_all_payrolls_f.created_by%TYPE;
137: l_creation_date pay_all_payrolls_f.creation_date%TYPE ;
138: l_last_update_date pay_all_payrolls_f.last_update_date%TYPE := sysdate;
139: l_last_updated_by pay_all_payrolls_f.last_updated_by%TYPE := fnd_global.user_id;
140: l_last_update_login pay_all_payrolls_f.last_update_login%TYPE := fnd_global.login_id;
141:
142: l_effective_start_date date;
143: l_effective_end_date date;
144: c_eot constant date := to_date('4712/12/31','YYYY/MM/DD');

Line 171: (p_base_table_name => 'pay_all_payrolls_f'

167: -- Get the object version number for the insert
168: --
169: p_rec.object_version_number :=
170: dt_api.get_object_version_number
171: (p_base_table_name => 'pay_all_payrolls_f'
172: ,p_base_key_column => 'payroll_id'
173: ,p_base_key_value => p_rec.payroll_id
174: );
175: --

Line 207: -- Insert the row into: pay_all_payrolls_f

203: End If;
204: --
205: pay_pay_shd.g_api_dml := true; -- Set the api dml status
206: --
207: -- Insert the row into: pay_all_payrolls_f
208: --
209: insert into pay_all_payrolls_f
210: (payroll_id
211: ,effective_start_date

Line 209: insert into pay_all_payrolls_f

205: pay_pay_shd.g_api_dml := true; -- Set the api dml status
206: --
207: -- Insert the row into: pay_all_payrolls_f
208: --
209: insert into pay_all_payrolls_f
210: (payroll_id
211: ,effective_start_date
212: ,effective_end_date
213: ,default_payment_method_id

Line 498: from pay_all_payrolls_f

494: Cursor C_Sel1 is select pay_payrolls_s.nextval from sys.dual;
495: --
496: Cursor C_Sel2 is
497: Select null
498: from pay_all_payrolls_f
499: where payroll_id =
500: pay_pay_ins.g_payroll_id_i;
501: --
502: l_proc varchar2(72) := g_package||'pre_insert';

Line 521: fnd_message.set_token('TABLE_NAME','pay_all_payrolls_f');

517: --
518: -- The primary key values are already in use.
519: --
520: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
521: fnd_message.set_token('TABLE_NAME','pay_all_payrolls_f');
522: fnd_message.raise_error;
523: --
524: End If;
525: Close C_Sel2;

Line 551: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'

547: --
548: p_rec.comment_id :=get_comment_id();
549: hr_comm_api.ins
550: (p_comment_id => p_rec.comment_id
551: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'
552: ,p_comment_text => p_rec.comments
553: );
554: --
555: End If;

Line 797: (p_module_name => 'PAY_ALL_PAYROLLS_F'

793: --
794: when hr_api.cannot_find_prog_unit then
795: --
796: hr_api.cannot_find_prog_unit_error
797: (p_module_name => 'PAY_ALL_PAYROLLS_F'
798: ,p_hook_type => 'AI');
799: --
800: end;
801: --

Line 909: ,p_base_table_name => 'pay_all_payrolls_f'

905: --
906: dt_api.validate_dt_mode
907: (p_effective_date => p_effective_date
908: ,p_datetrack_mode => p_datetrack_mode
909: ,p_base_table_name => 'pay_all_payrolls_f'
910: ,p_base_key_column => 'payroll_id'
911: ,p_base_key_value => p_rec.payroll_id
912:
913: ,p_parent_table_name1 => 'pay_org_payment_methods_f'