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_PTU_INS dependencies on PER_PERSON_TYPE_USAGES_F

Line 63: from per_person_type_usages_f t

59: --
60: Cursor C_Sel1 Is
61: select t.created_by,
62: t.creation_date
63: from per_person_type_usages_f t
64: where t.person_type_usage_id = p_rec.person_type_usage_id
65: and t.effective_start_date =
66: per_ptu_shd.g_old_rec.effective_start_date
67: and t.effective_end_date = (p_validation_start_date - 1);

Line 70: l_created_by per_person_type_usages_f.created_by%TYPE;

66: per_ptu_shd.g_old_rec.effective_start_date
67: and t.effective_end_date = (p_validation_start_date - 1);
68: --
69: l_proc varchar2(72) := g_package||'dt_insert_dml';
70: l_created_by per_person_type_usages_f.created_by%TYPE;
71: l_creation_date per_person_type_usages_f.creation_date%TYPE;
72: l_last_update_date per_person_type_usages_f.last_update_date%TYPE;
73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;
74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;

Line 71: l_creation_date per_person_type_usages_f.creation_date%TYPE;

67: and t.effective_end_date = (p_validation_start_date - 1);
68: --
69: l_proc varchar2(72) := g_package||'dt_insert_dml';
70: l_created_by per_person_type_usages_f.created_by%TYPE;
71: l_creation_date per_person_type_usages_f.creation_date%TYPE;
72: l_last_update_date per_person_type_usages_f.last_update_date%TYPE;
73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;
74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;
75: --

Line 72: l_last_update_date per_person_type_usages_f.last_update_date%TYPE;

68: --
69: l_proc varchar2(72) := g_package||'dt_insert_dml';
70: l_created_by per_person_type_usages_f.created_by%TYPE;
71: l_creation_date per_person_type_usages_f.creation_date%TYPE;
72: l_last_update_date per_person_type_usages_f.last_update_date%TYPE;
73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;
74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;
75: --
76: Begin

Line 73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;

69: l_proc varchar2(72) := g_package||'dt_insert_dml';
70: l_created_by per_person_type_usages_f.created_by%TYPE;
71: l_creation_date per_person_type_usages_f.creation_date%TYPE;
72: l_last_update_date per_person_type_usages_f.last_update_date%TYPE;
73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;
74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;
75: --
76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);

Line 74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;

70: l_created_by per_person_type_usages_f.created_by%TYPE;
71: l_creation_date per_person_type_usages_f.creation_date%TYPE;
72: l_last_update_date per_person_type_usages_f.last_update_date%TYPE;
73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;
74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;
75: --
76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);
78: --

Line 83: (p_base_table_name => 'per_person_type_usages_f',

79: -- Get the object version number for the insert
80: --
81: p_rec.object_version_number :=
82: dt_api.get_object_version_number
83: (p_base_table_name => 'per_person_type_usages_f',
84: p_base_key_column => 'person_type_usage_id',
85: p_base_key_value => p_rec.person_type_usage_id);
86: --
87: -- Set the effective start and end dates to the corresponding

Line 124: -- Insert the row into: per_person_type_usages_f

120: l_last_update_login := fnd_global.login_id;
121: End If;
122: --
123: --
124: -- Insert the row into: per_person_type_usages_f
125: --
126: insert into per_person_type_usages_f
127: ( person_type_usage_id,
128: person_id,

Line 126: insert into per_person_type_usages_f

122: --
123: --
124: -- Insert the row into: per_person_type_usages_f
125: --
126: insert into per_person_type_usages_f
127: ( person_type_usage_id,
128: person_id,
129: person_type_id,
130: effective_start_date,

Line 430: (p_module_name => 'PER_PERSON_TYPE_USAGES_F'

426: ,p_validation_end_date => p_validation_end_date );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'PER_PERSON_TYPE_USAGES_F'
431: ,p_hook_type => 'AI'
432: );
433: end;
434: --

Line 517: p_base_table_name => 'per_person_type_usages_f',

513: --
514: dt_api.validate_dt_mode
515: (p_effective_date => p_effective_date,
516: p_datetrack_mode => p_datetrack_mode,
517: p_base_table_name => 'per_person_type_usages_f',
518: p_base_key_column => 'person_type_usage_id',
519: p_base_key_value => p_rec.person_type_usage_id,
520: p_parent_table_name1 => 'per_all_people_f',
521: p_parent_key_column1 => 'person_id',