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_POS_SHD dependencies on PER_POSITIONS

Line 38: If (p_constraint_name = 'PER_POSITIONS_FK1') Then

34: --
35: Begin
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: --
38: If (p_constraint_name = 'PER_POSITIONS_FK1') Then
39: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');

Line 41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then

37: --
38: If (p_constraint_name = 'PER_POSITIONS_FK1') Then
39: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then
45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');

Line 44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then

40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then
45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_POSITIONS_FK4') Then
48: fnd_message.set_name('PER','PER_52979_POS_SUCC_NOT_EXIST');

Line 47: ElsIf (p_constraint_name = 'PER_POSITIONS_FK4') Then

43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then
45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_POSITIONS_FK4') Then
48: fnd_message.set_name('PER','PER_52979_POS_SUCC_NOT_EXIST');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'PER_POSITIONS_FK5') Then
51: fnd_message.set_name('PER','PER_52980_POS_RELF_NOT_EXIST');

Line 50: ElsIf (p_constraint_name = 'PER_POSITIONS_FK5') Then

46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_POSITIONS_FK4') Then
48: fnd_message.set_name('PER','PER_52979_POS_SUCC_NOT_EXIST');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'PER_POSITIONS_FK5') Then
51: fnd_message.set_name('PER','PER_52980_POS_RELF_NOT_EXIST');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PER_POSITIONS_FK6') Then
54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');

Line 53: ElsIf (p_constraint_name = 'PER_POSITIONS_FK6') Then

49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'PER_POSITIONS_FK5') Then
51: fnd_message.set_name('PER','PER_52980_POS_RELF_NOT_EXIST');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PER_POSITIONS_FK6') Then
54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');

Line 56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then

52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PER_POSITIONS_FK6') Then
54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

Line 59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then

55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then
63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');

Line 62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then

58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then
63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_POST_REPLACEMENT_REQUI_CHK') Then
66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');

Line 138: from per_positions

134: attribute18,
135: attribute19,
136: attribute20,
137: object_version_number
138: from per_positions
139: where position_id = p_position_id;
140: --
141: l_proc varchar2(72) := g_package||'api_updating';
142: l_fct_ret boolean;