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_CTC_SHD dependencies on PER_CONTRACTS_F

Line 21: If (p_constraint_name = 'PER_CONTRACTS_F_PK') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_CONTRACTS_F_PK') Then
22:
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');

Line 28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then

24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27:
28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then
29:
30: hr_utility.set_message(801, 'PER_52832_CTR_INV_BG');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP','10');

Line 35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then

31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP','10');
33: hr_utility.raise_error;
34:
35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then
36:
37: hr_utility.set_message(801, 'PER_52845_CTR_INV_PID');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','15');

Line 133: from per_contracts_f

129: attribute17,
130: attribute18,
131: attribute19,
132: attribute20
133: from per_contracts_f
134: where contract_id = p_contract_id
135: and p_effective_date
136: between effective_start_date and effective_end_date;
137: --

Line 206: from per_contracts_f ctc

202: l_parent_key_value1 number;
203: --
204: Cursor C_Sel1 Is
205: select ctc.person_id
206: from per_contracts_f ctc
207: where ctc.contract_id = p_base_key_value
208: and p_effective_date between ctc.effective_start_date
209: and ctc.effective_end_date;
210: --

Line 230: p_base_table_name => 'per_contracts_f',

226: -- Call the corresponding datetrack api
227: --
228: dt_api.find_dt_del_modes
229: (p_effective_date => p_effective_date,
230: p_base_table_name => 'per_contracts_f',
231: p_base_key_column => 'contract_id',
232: p_base_key_value => p_base_key_value,
233: p_parent_table_name1 => 'per_people_f',
234: p_parent_key_column1 => 'person_id',

Line 268: p_base_table_name => 'per_contracts_f',

264: -- Call the corresponding datetrack api
265: --
266: dt_api.find_dt_upd_modes
267: (p_effective_date => p_effective_date,
268: p_base_table_name => 'per_contracts_f',
269: p_base_key_column => 'contract_id',
270: p_base_key_value => p_base_key_value,
271: p_correction => p_correction,
272: p_update => p_update,

Line 301: (p_base_table_name => 'per_contracts_f',

297: -- version number.
298: --
299: l_object_version_number :=
300: dt_api.get_object_version_number
301: (p_base_table_name => 'per_contracts_f',
302: p_base_key_column => 'contract_id',
303: p_base_key_value => p_base_key_value);
304: --
305: hr_utility.set_location(l_proc, 10);

Line 310: update per_contracts_f t

306: --
307: -- Update the specified datetrack row setting the effective
308: -- end date to the specified new effective end date.
309: --
310: update per_contracts_f t
311: set t.effective_end_date = p_new_effective_end_date,
312: t.object_version_number = l_object_version_number
313: where t.contract_id = p_base_key_value
314: and p_effective_date

Line 412: from per_contracts_f

408: attribute17,
409: attribute18,
410: attribute19,
411: attribute20
412: from per_contracts_f
413: where contract_id = p_contract_id
414: and p_effective_date
415: between effective_start_date and effective_end_date
416: for update nowait;

Line 468: p_base_table_name => 'per_contracts_f',

464: --
465: dt_api.validate_dt_mode
466: (p_effective_date => p_effective_date,
467: p_datetrack_mode => p_datetrack_mode,
468: p_base_table_name => 'per_contracts_f',
469: p_base_key_column => 'contract_id',
470: p_base_key_value => p_contract_id,
471: p_parent_table_name1 => 'per_people_f',
472: p_parent_key_column1 => 'person_id',

Line 505: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');

501: -- The object is locked therefore we need to supply a meaningful
502: -- error message.
503: --
504: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
505: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
506: hr_utility.raise_error;
507: When l_object_invalid then
508: --
509: -- The object doesn't exist or is invalid

Line 512: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');

508: --
509: -- The object doesn't exist or is invalid
510: --
511: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
512: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
513: hr_utility.raise_error;
514: End lck;
515: --
516: -- ----------------------------------------------------------------------------

Line 522: p_contract_id in per_contracts_f.contract_id%TYPE,

518: -- ----------------------------------------------------------------------------
519: --
520: Procedure lock_record
521: (
522: p_contract_id in per_contracts_f.contract_id%TYPE,
523: p_effective_date in date,
524: p_object_version_number in per_contracts_f.object_version_number%TYPE
525: ) is
526: --

Line 524: p_object_version_number in per_contracts_f.object_version_number%TYPE

520: Procedure lock_record
521: (
522: p_contract_id in per_contracts_f.contract_id%TYPE,
523: p_effective_date in date,
524: p_object_version_number in per_contracts_f.object_version_number%TYPE
525: ) is
526: --
527: -- Cursor selects the 'current' row from the HR Schema
528: --

Line 596: from per_contracts_f

592: attribute17,
593: attribute18,
594: attribute19,
595: attribute20
596: from per_contracts_f
597: where contract_id = p_contract_id
598: and p_effective_date
599: between effective_start_date and effective_end_date
600: for update nowait;

Line 651: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');

647: -- The object is locked therefore we need to supply a meaningful
648: -- error message.
649: --
650: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
651: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
652: hr_utility.raise_error;
653: End lock_record;
654: --
655: -- ----------------------------------------------------------------------------