APPS.PER_PYP_SHD dependencies on PER_PAY_PROPOSALS

Line 36: If (p_constraint_name = 'PER_PAY_PROPOSALS_FK3') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_PAY_PROPOSALS_FK3') Then
37: hr_utility.set_location(l_proc,15);
38: hr_utility.set_message(801,'HR_51317_PPC_INVAL_BUS_GRP_ID');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PER_PAY_PROPOSALS_FK4') Then

Line 40: ElsIf (p_constraint_name = 'PER_PAY_PROPOSALS_FK4') Then

36: If (p_constraint_name = 'PER_PAY_PROPOSALS_FK3') Then
37: hr_utility.set_location(l_proc,15);
38: hr_utility.set_message(801,'HR_51317_PPC_INVAL_BUS_GRP_ID');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'PER_PAY_PROPOSALS_FK4') Then
41: hr_utility.set_location(l_proc,15);
42: hr_utility.set_message(800,'HR_52399_PYP_INVALID_REVIEW_ID');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_PAY_PROPOSALS_PK') Then

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

40: ElsIf (p_constraint_name = 'PER_PAY_PROPOSALS_FK4') Then
41: hr_utility.set_location(l_proc,15);
42: hr_utility.set_message(800,'HR_52399_PYP_INVALID_REVIEW_ID');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_PAY_PROPOSALS_PK') Then
45: hr_utility.set_location(l_proc,20);
46: hr_utility.set_message(801,'HR_51310_PPC_INVAL_PRO_ID');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PER_PYP_APPROVED_CHK') Then

Line 117: from per_pay_proposals

113: object_version_number,
114: multiple_components,
115: approved
116:
117: from per_pay_proposals
118: where pay_proposal_id = p_pay_proposal_id;
119: --
120: l_proc varchar2(72) := g_package||'api_updating';
121: l_fct_ret boolean;

Line 222: from per_pay_proposals

218: attribute20,
219: object_version_number,
220: multiple_components,
221: approved
222: from per_pay_proposals
223: where pay_proposal_id = p_pay_proposal_id
224: for update nowait;
225: --
226: l_proc varchar2(72) := g_package||'lck';

Line 268: hr_utility.set_message_token('TABLE_NAME', 'per_pay_proposals');

264: -- The object is locked therefore we need to supply a meaningful
265: -- error message.
266: --
267: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
268: hr_utility.set_message_token('TABLE_NAME', 'per_pay_proposals');
269: hr_utility.raise_error;
270: End lck;
271: --
272: -- ----------------------------------------------------------------------------