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 = 'AVCON_21709591_TRANS_000') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'AVCON_21709591_TRANS_000') Then
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');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK1') Then
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'AVCON_21709591_TRANS_000') Then
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');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK1') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'AVCON_21709591_TRANS_000') Then
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');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK1') 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 = 'AVCON_21709591_TRANS_000') Then
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');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK1') 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 = 'PQH_BUDGETS_FK1') 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 = 'PQH_BUDGETS_FK2') Then
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK1') 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 = 'PQH_BUDGETS_FK2') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK1') 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 = 'PQH_BUDGETS_FK2') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
27: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK1') 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 = 'PQH_BUDGETS_FK2') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PQH_BUDGETS_FK2') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PQH_BUDGETS_FK3') Then
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK2') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PQH_BUDGETS_FK3') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK2') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PQH_BUDGETS_FK3') 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 = 'PQH_BUDGETS_FK2') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PQH_BUDGETS_FK3') 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 = 'PQH_BUDGETS_FK3') 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 = 'PQH_BUDGETS_FK4') Then
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK3') 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 = 'PQH_BUDGETS_FK4') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK3') 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 = 'PQH_BUDGETS_FK4') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
37: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK3') 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 = 'PQH_BUDGETS_FK4') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PQH_BUDGETS_FK4') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK4') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK4') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
42: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK4') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
47: ElsIf (p_constraint_name = 'PQH_BUDGETS_FK5') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
52: ElsIf (p_constraint_name = 'PQH_BUDGETS_PK') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --
64: hr_utility.set_location(' Leaving:'||l_proc, 10);
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --
64: hr_utility.set_location(' Leaving:'||l_proc, 10);
65: End constraint_error;
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --
64: hr_utility.set_location(' Leaving:'||l_proc, 10);
65: End constraint_error;
66: --
67: -- ----------------------------------------------------------------------------+
68: -- |-----------------------------< api_updating >-----------------------------|
111: l_proc varchar2(72) := g_package||'api_updating';
112: l_fct_ret boolean;
113: --
114: Begin
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: If (
118: p_budget_id is null and
119: p_object_version_number is null
127: If (
128: p_budget_id = g_old_rec.budget_id and
129: p_object_version_number = g_old_rec.object_version_number
130: ) Then
131: hr_utility.set_location(l_proc, 10);
132: --
133: -- The g_old_rec is current therefore we must
134: -- set the returning function to true
135: --
144: Close C_Sel1;
145: --
146: -- The primary key is invalid therefore we must error
147: --
148: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
149: hr_utility.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
145: --
146: -- The primary key is invalid therefore we must error
147: --
148: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
149: hr_utility.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
149: hr_utility.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
154: hr_utility.raise_error;
155: End If;
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
154: hr_utility.raise_error;
155: End If;
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;
158: End If;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
154: hr_utility.raise_error;
155: End If;
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;
158: End If;
159: End If;
160: hr_utility.set_location(' Leaving:'||l_proc, 20);
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;
158: End If;
159: End If;
160: hr_utility.set_location(' Leaving:'||l_proc, 20);
161: Return (l_fct_ret);
162: --
163: End api_updating;
164: --
207: --
208: l_proc varchar2(72) := g_package||'lck';
209: --
210: Begin
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: --
213: -- Add any mandatory argument checking here:
214: -- Example:
215: -- hr_api.mandatory_arg_error
223: Close C_Sel1;
224: --
225: -- The primary key is invalid therefore we must error
226: --
227: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
228: hr_utility.raise_error;
229: End If;
230: Close C_Sel1;
231: If (p_object_version_number <> g_old_rec.object_version_number) Then
224: --
225: -- The primary key is invalid therefore we must error
226: --
227: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
228: hr_utility.raise_error;
229: End If;
230: Close C_Sel1;
231: If (p_object_version_number <> g_old_rec.object_version_number) Then
232: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
228: hr_utility.raise_error;
229: End If;
230: Close C_Sel1;
231: If (p_object_version_number <> g_old_rec.object_version_number) Then
232: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
233: hr_utility.raise_error;
234: End If;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End If;
230: Close C_Sel1;
231: If (p_object_version_number <> g_old_rec.object_version_number) Then
232: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
233: hr_utility.raise_error;
234: End If;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: --
232: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
233: hr_utility.raise_error;
234: End If;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: --
238: -- We need to trap the ORA LOCK exception
239: --
240: Exception
242: --
243: -- The object is locked therefore we need to supply a meaningful
244: -- error message.
245: --
246: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
247: hr_utility.set_message_token('TABLE_NAME', 'pqh_budgets');
248: hr_utility.raise_error;
249: End lck;
250: --
243: -- The object is locked therefore we need to supply a meaningful
244: -- error message.
245: --
246: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
247: hr_utility.set_message_token('TABLE_NAME', 'pqh_budgets');
248: hr_utility.raise_error;
249: End lck;
250: --
251: -- ----------------------------------------------------------------------------+
244: -- error message.
245: --
246: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
247: hr_utility.set_message_token('TABLE_NAME', 'pqh_budgets');
248: hr_utility.raise_error;
249: End lck;
250: --
251: -- ----------------------------------------------------------------------------+
252: -- |-----------------------------< convert_args >-----------------------------|
287: l_proc varchar2(72) := g_package||'convert_args';
288: --
289: Begin
290: --
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- Convert arguments into local l_rec structure.
294: --
295: l_rec.budget_id := p_budget_id;
321: l_rec.dflt_budget_set_id := p_dflt_budget_set_id;
322: --
323: -- Return the plsql record structure.
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 10);
326: Return(l_rec);
327: --
328: End convert_args;
329: --