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_PAY_SHD

Line 118: (p_rec in out nocopy pay_pay_shd.g_rec_type

114: --
115: -- {End Of Comments}
116: -- ----------------------------------------------------------------------------
117: Procedure dt_insert_dml
118: (p_rec in out nocopy pay_pay_shd.g_rec_type
119: ,p_effective_date in date
120: ,p_datetrack_mode in varchar2
121: ,p_validation_start_date in date
122: ,p_validation_end_date in date

Line 132: pay_pay_shd.g_old_rec.effective_start_date

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);
134: --
135: l_proc varchar2(72) := g_package||'dt_insert_dml';
136: l_created_by pay_all_payrolls_f.created_by%TYPE;

Line 205: pay_pay_shd.g_api_dml := true; -- Set the api dml status

201: p_rec.object_version_number := 1; -- Initialise the object version
202: --
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

Line 389: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

385: --
386: --Storing the result of the above DML operation.
387: l_status_of_dml:=SQL%NOTFOUND;
388:
389: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
390:
391: --Checking the status of the above dml operation.
392: if (l_status_of_dml) then
393: --

Line 407: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

403: --
404: Exception
405: When hr_api.check_integrity_violated Then
406: -- A check constraint has been violated
407: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
408: pay_pay_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When hr_api.unique_integrity_violated Then
411: -- Unique integrity has been violated

Line 408: pay_pay_shd.constraint_error

404: Exception
405: When hr_api.check_integrity_violated Then
406: -- A check constraint has been violated
407: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
408: pay_pay_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When hr_api.unique_integrity_violated Then
411: -- Unique integrity has been violated
412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

Line 412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

408: pay_pay_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When hr_api.unique_integrity_violated Then
411: -- Unique integrity has been violated
412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
413: pay_pay_shd.constraint_error
414: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
415: When Others Then
416: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

Line 413: pay_pay_shd.constraint_error

409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When hr_api.unique_integrity_violated Then
411: -- Unique integrity has been violated
412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
413: pay_pay_shd.constraint_error
414: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
415: When Others Then
416: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
417: Raise;

Line 416: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
413: pay_pay_shd.constraint_error
414: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
415: When Others Then
416: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
417: Raise;
418: End dt_insert_dml;
419: --
420: -- ----------------------------------------------------------------------------

Line 424: (p_rec in out nocopy pay_pay_shd.g_rec_type

420: -- ----------------------------------------------------------------------------
421: -- |------------------------------< insert_dml >------------------------------|
422: -- ----------------------------------------------------------------------------
423: Procedure insert_dml
424: (p_rec in out nocopy pay_pay_shd.g_rec_type
425: ,p_effective_date in date
426: ,p_datetrack_mode in varchar2
427: ,p_validation_start_date in date
428: ,p_validation_end_date in date

Line 487: (p_rec in out nocopy pay_pay_shd.g_rec_type

483: --
484: -- {End Of Comments}
485: -- ----------------------------------------------------------------------------
486: Procedure pre_insert
487: (p_rec in out nocopy pay_pay_shd.g_rec_type
488: ,p_effective_date in date
489: ,p_datetrack_mode in varchar2
490: ,p_validation_start_date in date
491: ,p_validation_end_date in date

Line 606: (p_rec in pay_pay_shd.g_rec_type

602: --
603: -- {End Of Comments}
604: -- ----------------------------------------------------------------------------
605: Procedure post_insert
606: (p_rec in pay_pay_shd.g_rec_type
607: ,p_effective_date in date
608: ,p_datetrack_mode in varchar2
609: ,p_validation_start_date in date
610: ,p_validation_end_date in date

Line 844: ,p_rec in pay_pay_shd.g_rec_type

840: -- ----------------------------------------------------------------------------
841: Procedure ins_lck
842: (p_effective_date in date
843: ,p_datetrack_mode in varchar2
844: ,p_rec in pay_pay_shd.g_rec_type
845: ,p_validation_start_date out nocopy date
846: ,p_validation_end_date out nocopy date
847: ) is
848: --

Line 915: ,p_parent_key_value1 => pay_pay_shd.g_old_rec.default_payment_method_id

911: ,p_base_key_value => p_rec.payroll_id
912:
913: ,p_parent_table_name1 => 'pay_org_payment_methods_f'
914: ,p_parent_key_column1 => 'org_payment_method_id'
915: ,p_parent_key_value1 => pay_pay_shd.g_old_rec.default_payment_method_id
916:
917: ,p_child_table_name1 => 'per_all_assignments_f'
918: ,p_child_key_column1 => 'assignment_id'
919: ,p_child_alt_base_key_column1 => 'payroll_id'

Line 948: ,p_rec in out nocopy pay_pay_shd.g_rec_type

944: -- |---------------------------------< ins >----------------------------------|
945: -- ----------------------------------------------------------------------------
946: Procedure ins
947: (p_effective_date in date
948: ,p_rec in out nocopy pay_pay_shd.g_rec_type
949: ) is
950: --
951: l_proc varchar2(72) := g_package||'ins';
952: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 1108: l_rec pay_pay_shd.g_rec_type;

1104: ,p_effective_end_date out nocopy date
1105: ,p_comment_id out nocopy number
1106: ) is
1107: --
1108: l_rec pay_pay_shd.g_rec_type;
1109: l_proc varchar2(72) := g_package||'ins';
1110: l_effective_date date;
1111: l_first_period_end_date date;
1112:

Line 1122: pay_pay_shd.convert_args

1118: -- Call conversion function to turn arguments into the
1119: -- p_rec structure.
1120: --
1121: l_rec :=
1122: pay_pay_shd.convert_args
1123: (null
1124: ,null
1125: ,null
1126: ,p_default_payment_method_id