APPS.PER_CTC_UPD dependencies on PER_CONTRACTS_F

Line 78: (p_base_table_name => 'per_contracts_f',

74: -- version number.
75: --
76: p_rec.object_version_number :=
77: dt_api.get_object_version_number
78: (p_base_table_name => 'per_contracts_f',
79: p_base_key_column => 'contract_id',
80: p_base_key_value => p_rec.contract_id);
81: --
82: -- Update the per_contracts_f Row

Line 82: -- Update the per_contracts_f Row

78: (p_base_table_name => 'per_contracts_f',
79: p_base_key_column => 'contract_id',
80: p_base_key_value => p_rec.contract_id);
81: --
82: -- Update the per_contracts_f Row
83: --
84: update per_contracts_f
85: set
86: contract_id = p_rec.contract_id,

Line 84: update per_contracts_f

80: p_base_key_value => p_rec.contract_id);
81: --
82: -- Update the per_contracts_f Row
83: --
84: update per_contracts_f
85: set
86: contract_id = p_rec.contract_id,
87: business_group_id = p_rec.business_group_id,
88: object_version_number = p_rec.object_version_number,

Line 569: (p_module_name => 'per_contracts_f'

565: --
566: when hr_api.cannot_find_prog_unit then
567: --
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'per_contracts_f'
570: ,p_hook_type => 'AU');
571: --
572: end;
573: --

Line 1133: p_contract_id in per_contracts_f.contract_id%TYPE,

1129: -- date changes.
1130: --
1131: procedure update_effective_start_date
1132: (
1133: p_contract_id in per_contracts_f.contract_id%TYPE,
1134: p_effective_date in date,
1135: p_new_start_date in per_contracts_f.effective_start_date%TYPE,
1136: p_object_version_number in per_contracts_f.object_version_number%TYPE
1137: ) is

Line 1135: p_new_start_date in per_contracts_f.effective_start_date%TYPE,

1131: procedure update_effective_start_date
1132: (
1133: p_contract_id in per_contracts_f.contract_id%TYPE,
1134: p_effective_date in date,
1135: p_new_start_date in per_contracts_f.effective_start_date%TYPE,
1136: p_object_version_number in per_contracts_f.object_version_number%TYPE
1137: ) is
1138: --
1139: l_proc varchar2(72) := g_package||'update_effective_start_date';

Line 1136: p_object_version_number in per_contracts_f.object_version_number%TYPE

1132: (
1133: p_contract_id in per_contracts_f.contract_id%TYPE,
1134: p_effective_date in date,
1135: p_new_start_date in per_contracts_f.effective_start_date%TYPE,
1136: p_object_version_number in per_contracts_f.object_version_number%TYPE
1137: ) is
1138: --
1139: l_proc varchar2(72) := g_package||'update_effective_start_date';
1140: --

Line 1177: update per_contracts_f

1173: hr_utility.set_location('Entering:'||l_proc, 10);
1174: --
1175: -- update the row
1176: --
1177: update per_contracts_f
1178: set effective_start_date = p_new_start_date
1179: where contract_id = p_contract_id and
1180: p_effective_date between effective_start_date
1181: and effective_end_date;