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.PER_ASG_INS dependencies on PER_ASG_SHD

Line 79: (p_rec in out nocopy per_asg_shd.g_rec_type,

75: --
76: -- {End Of Comments}
77: -- ----------------------------------------------------------------------------
78: Procedure dt_insert_dml
79: (p_rec in out nocopy per_asg_shd.g_rec_type,
80: p_effective_date in date,
81: p_datetrack_mode in varchar2,
82: p_validation_start_date in date,
83: p_validation_end_date in date

Line 94: per_asg_shd.g_old_rec.effective_start_date

90: asg.creation_date
91: from per_all_assignments_f asg
92: where asg.assignment_id = p_rec.assignment_id
93: and asg.effective_start_date =
94: per_asg_shd.g_old_rec.effective_start_date
95: and asg.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by per_all_assignments_f.created_by%TYPE;

Line 151: per_asg_shd.g_api_dml := true; -- Set the api dml status

147: l_last_updated_by := fnd_global.user_id;
148: l_last_update_login := fnd_global.login_id;
149: End If;
150: --
151: per_asg_shd.g_api_dml := true; -- Set the api dml status
152: --
153: -- Insert the row into: per_all_assignments_f
154: --
155: insert into per_all_assignments_f

Line 392: per_asg_shd.g_api_dml := false; -- Unset the api dml status

388: p_rec.po_line_id,
389: p_rec.projected_assignment_end
390: );
391: --
392: per_asg_shd.g_api_dml := false; -- Unset the api dml status
393: hr_utility.set_location(' Leaving:'||l_proc, 15);
394: --
395: Exception
396: When hr_api.check_integrity_violated Then

Line 398: per_asg_shd.g_api_dml := false; -- Unset the api dml status

394: --
395: Exception
396: When hr_api.check_integrity_violated Then
397: -- A check constraint has been violated
398: per_asg_shd.g_api_dml := false; -- Unset the api dml status
399: per_asg_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When hr_api.unique_integrity_violated Then
402: -- Unique integrity has been violated

Line 399: per_asg_shd.constraint_error

395: Exception
396: When hr_api.check_integrity_violated Then
397: -- A check constraint has been violated
398: per_asg_shd.g_api_dml := false; -- Unset the api dml status
399: per_asg_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When hr_api.unique_integrity_violated Then
402: -- Unique integrity has been violated
403: per_asg_shd.g_api_dml := false; -- Unset the api dml status

Line 403: per_asg_shd.g_api_dml := false; -- Unset the api dml status

399: per_asg_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When hr_api.unique_integrity_violated Then
402: -- Unique integrity has been violated
403: per_asg_shd.g_api_dml := false; -- Unset the api dml status
404: per_asg_shd.constraint_error
405: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
406: When Others Then
407: per_asg_shd.g_api_dml := false; -- Unset the api dml status

Line 404: per_asg_shd.constraint_error

400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When hr_api.unique_integrity_violated Then
402: -- Unique integrity has been violated
403: per_asg_shd.g_api_dml := false; -- Unset the api dml status
404: per_asg_shd.constraint_error
405: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
406: When Others Then
407: per_asg_shd.g_api_dml := false; -- Unset the api dml status
408: Raise;

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

403: per_asg_shd.g_api_dml := false; -- Unset the api dml status
404: per_asg_shd.constraint_error
405: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
406: When Others Then
407: per_asg_shd.g_api_dml := false; -- Unset the api dml status
408: Raise;
409: End dt_insert_dml;
410: --
411: -- ----------------------------------------------------------------------------

Line 415: (p_rec in out nocopy per_asg_shd.g_rec_type,

411: -- ----------------------------------------------------------------------------
412: -- |------------------------------< insert_dml >------------------------------|
413: -- ----------------------------------------------------------------------------
414: Procedure insert_dml
415: (p_rec in out nocopy per_asg_shd.g_rec_type,
416: p_effective_date in date,
417: p_datetrack_mode in varchar2,
418: p_validation_start_date in date,
419: p_validation_end_date in date) is

Line 475: (p_rec in out nocopy per_asg_shd.g_rec_type,

471: --
472: -- {End Of Comments}
473: -- ----------------------------------------------------------------------------
474: Procedure pre_insert
475: (p_rec in out nocopy per_asg_shd.g_rec_type,
476: p_effective_date in date,
477: p_datetrack_mode in varchar2,
478: p_validation_start_date in date,
479: p_validation_end_date in date) is

Line 602: (p_rec in per_asg_shd.g_rec_type,

598: --
599: -- {End Of Comments}
600: -- ----------------------------------------------------------------------------
601: Procedure post_insert
602: (p_rec in per_asg_shd.g_rec_type,
603: p_effective_date in date,
604: p_datetrack_mode in varchar2,
605: p_validation_start_date in date,
606: p_validation_end_date in date) is

Line 991: p_rec in per_asg_shd.g_rec_type,

987: -- ----------------------------------------------------------------------------
988: Procedure ins_lck
989: (p_effective_date in date,
990: p_datetrack_mode in varchar2,
991: p_rec in per_asg_shd.g_rec_type,
992: p_validation_start_date out nocopy date,
993: p_validation_end_date out nocopy date) is
994: --
995: l_proc varchar2(72) := g_package||'ins_lck';

Line 1046: p_rec in out nocopy per_asg_shd.g_rec_type,

1042: -- |---------------------------------< ins >----------------------------------|
1043: -- ----------------------------------------------------------------------------
1044: Procedure ins
1045: (
1046: p_rec in out nocopy per_asg_shd.g_rec_type,
1047: p_effective_date in date,
1048: p_validate in boolean default false,
1049: p_validate_df_flex in boolean default true,
1050: p_other_manager_warning out nocopy boolean,

Line 1279: l_rec per_asg_shd.g_rec_type;

1275: p_projected_assignment_end in date default null
1276: )
1277: is
1278: --
1279: l_rec per_asg_shd.g_rec_type;
1280: l_proc varchar2(72) := g_package||'ins';
1281: --
1282: Begin
1283: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1289: per_asg_shd.convert_args

1285: -- Call conversion function to turn arguments into the
1286: -- p_rec structure.
1287: --
1288: l_rec :=
1289: per_asg_shd.convert_args
1290: (
1291: null,
1292: null,
1293: null,