16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: --
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: --
48: -- pmfletch. Name is now a coded check via TL row handler
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: --
48: -- pmfletch. Name is now a coded check via TL row handler
49: --
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: --
48: -- pmfletch. Name is now a coded check via TL row handler
49: --
50: -- ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
47: --
48: -- pmfletch. Name is now a coded check via TL row handler
49: --
50: -- ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
51: -- hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
52: -- hr_utility.set_message_token('PROCEDURE', l_proc);
53: -- hr_utility.set_message_token('STEP','30');
54: -- hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
48: -- pmfletch. Name is now a coded check via TL row handler
49: --
50: -- ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
51: -- hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
52: -- hr_utility.set_message_token('PROCEDURE', l_proc);
53: -- hr_utility.set_message_token('STEP','30');
54: -- hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
56: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
49: --
50: -- ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
51: -- hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
52: -- hr_utility.set_message_token('PROCEDURE', l_proc);
53: -- hr_utility.set_message_token('STEP','30');
54: -- hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
56: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
50: -- ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
51: -- hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
52: -- hr_utility.set_message_token('PROCEDURE', l_proc);
53: -- hr_utility.set_message_token('STEP','30');
54: -- hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
56: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','35');
52: -- hr_utility.set_message_token('PROCEDURE', l_proc);
53: -- hr_utility.set_message_token('STEP','30');
54: -- hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
56: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','35');
59: hr_utility.raise_error;
60: Else
53: -- hr_utility.set_message_token('STEP','30');
54: -- hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
56: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','35');
59: hr_utility.raise_error;
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
54: -- hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
56: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','35');
59: hr_utility.raise_error;
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
55: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
56: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','35');
59: hr_utility.raise_error;
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','35');
59: hr_utility.raise_error;
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
64: hr_utility.raise_error;
65: End If;
58: hr_utility.set_message_token('STEP','35');
59: hr_utility.raise_error;
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
64: hr_utility.raise_error;
65: End If;
66: --
59: hr_utility.raise_error;
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
64: hr_utility.raise_error;
65: End If;
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
64: hr_utility.raise_error;
65: End If;
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: End constraint_error;
63: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
64: hr_utility.raise_error;
65: End If;
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: End constraint_error;
69: --
70: -- ----------------------------------------------------------------------------
71: -- |-----------------------------< api_updating >-----------------------------|
116: l_proc varchar2(72) := g_package||'api_updating';
117: l_fct_ret boolean;
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: If (
123: p_rating_level_id is null and
124: p_object_version_number is null
132: If (
133: p_rating_level_id = g_old_rec.rating_level_id and
134: p_object_version_number = g_old_rec.object_version_number
135: ) Then
136: hr_utility.set_location(l_proc, 10);
137: --
138: -- The g_old_rec is current therefore we must
139: -- set the returning function to true
140: --
149: Close C_Sel1;
150: --
151: -- The primary key is invalid therefore we must error
152: --
153: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
154: hr_utility.raise_error;
155: End If;
156: Close C_Sel1;
157: If (p_object_version_number <> g_old_rec.object_version_number) Then
150: --
151: -- The primary key is invalid therefore we must error
152: --
153: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
154: hr_utility.raise_error;
155: End If;
156: Close C_Sel1;
157: If (p_object_version_number <> g_old_rec.object_version_number) Then
158: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
154: hr_utility.raise_error;
155: End If;
156: Close C_Sel1;
157: If (p_object_version_number <> g_old_rec.object_version_number) Then
158: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
159: hr_utility.raise_error;
160: End If;
161: hr_utility.set_location(l_proc, 15);
162: l_fct_ret := true;
155: End If;
156: Close C_Sel1;
157: If (p_object_version_number <> g_old_rec.object_version_number) Then
158: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
159: hr_utility.raise_error;
160: End If;
161: hr_utility.set_location(l_proc, 15);
162: l_fct_ret := true;
163: End If;
157: If (p_object_version_number <> g_old_rec.object_version_number) Then
158: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
159: hr_utility.raise_error;
160: End If;
161: hr_utility.set_location(l_proc, 15);
162: l_fct_ret := true;
163: End If;
164: End If;
165: hr_utility.set_location(' Leaving:'||l_proc, 20);
161: hr_utility.set_location(l_proc, 15);
162: l_fct_ret := true;
163: End If;
164: End If;
165: hr_utility.set_location(' Leaving:'||l_proc, 20);
166: Return (l_fct_ret);
167: --
168: End api_updating;
169: --
214: --
215: l_proc varchar2(72) := g_package||'lck';
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- Add any mandatory argument checking here:
221: -- Example:
222: -- hr_api.mandatory_arg_error
230: Close C_Sel1;
231: --
232: -- The primary key is invalid therefore we must error
233: --
234: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
235: hr_utility.raise_error;
236: End If;
237: Close C_Sel1;
238: If (p_object_version_number <> g_old_rec.object_version_number) Then
231: --
232: -- The primary key is invalid therefore we must error
233: --
234: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
235: hr_utility.raise_error;
236: End If;
237: Close C_Sel1;
238: If (p_object_version_number <> g_old_rec.object_version_number) Then
239: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
235: hr_utility.raise_error;
236: End If;
237: Close C_Sel1;
238: If (p_object_version_number <> g_old_rec.object_version_number) Then
239: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
240: hr_utility.raise_error;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: End If;
237: Close C_Sel1;
238: If (p_object_version_number <> g_old_rec.object_version_number) Then
239: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
240: hr_utility.raise_error;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: --
239: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
240: hr_utility.raise_error;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: --
245: -- We need to trap the ORA LOCK exception
246: --
247: Exception
249: --
250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
254: hr_utility.set_message_token('TABLE_NAME', 'per_rating_levels');
255: hr_utility.raise_error;
256: End lck;
257: --
250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
254: hr_utility.set_message_token('TABLE_NAME', 'per_rating_levels');
255: hr_utility.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------
251: -- error message.
252: --
253: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
254: hr_utility.set_message_token('TABLE_NAME', 'per_rating_levels');
255: hr_utility.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |-----------------------------< convert_args >-----------------------------|
296: l_proc varchar2(72) := g_package||'convert_args';
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: -- Convert arguments into local l_rec structure.
303: --
304: l_rec.rating_level_id := p_rating_level_id;
332: l_rec.behavioural_indicator := p_behavioural_indicator;
333: --
334: -- Return the plsql record structure.
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 10);
337: Return(l_rec);
338: --
339: End convert_args;
340: --