DBA Data[Home] [Help]

APPS.PQH_BGT_UPD dependencies on HR_UTILITY

Line 53: hr_utility.set_location('Entering:'||l_proc, 5);

49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;

Line 94: hr_utility.set_location(' Leaving:'||l_proc, 10);

90: dflt_budget_set_id = p_rec.dflt_budget_set_id
91: where budget_id = p_rec.budget_id;
92: --
93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated

Line 157: hr_utility.set_location('Entering:'||l_proc, 5);

153: from pqh_budgets
154: where budget_id = p_budget_id;
155:
156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: /*
160: --
161: OPEN csr_budget(p_budget_id => p_rec.budget_id);

Line 166: hr_utility.set_location('Transfer to GL :'||l_budgets_rec.transfer_to_gl_flag, 6);

162: FETCH csr_budget INTO l_budgets_rec;
163: CLOSE csr_budget;
164:
165:
166: hr_utility.set_location('Transfer to GL :'||l_budgets_rec.transfer_to_gl_flag, 6);
167:
168: IF NVL(l_budgets_rec.transfer_to_gl_flag,'N') = 'N' THEN
169: -- delete from pqh_budget_gl_flex_maps
170: delete from pqh_budget_gl_flex_maps

Line 177: hr_utility.set_location(' Leaving:'||l_proc, 10);

173: END IF;
174:
175: */
176:
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: End pre_update;
179: --
180: -- ----------------------------------------------------------------------------
181: -- |-----------------------------< post_update >------------------------------|

Line 218: hr_utility.set_location('Entering:'||l_proc, 5);

214: --
215: l_proc varchar2(72) := g_package||'post_update';
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: --
221: -- Start of API User Hook for post_update.
222: --

Line 296: hr_utility.set_location(' Leaving:'||l_proc, 10);

292: --
293: -- End of API User Hook for post_update.
294: --
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: End post_update;
298: --
299: -- ----------------------------------------------------------------------------
300: -- |-----------------------------< convert_defs >-----------------------------|

Line 348: hr_utility.set_location('Entering:'||l_proc, 5);

344: l_proc varchar2(72) := g_package||'convert_defs';
345: --
346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: -- We must now examine each argument value in the
351: -- p_rec plsql record structure
352: -- to see if a system default is being used. If a system default

Line 457: hr_utility.set_location(' Leaving:'||l_proc, 10);

453: pqh_bgt_shd.g_old_rec.dflt_budget_set_id;
454: End If;
455:
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: --
459: End convert_defs;
460: --
461: -- ----------------------------------------------------------------------------

Line 473: hr_utility.set_location('Entering:'||l_proc, 5);

469: --
470: l_proc varchar2(72) := g_package||'upd';
471: --
472: Begin
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- We must lock the row which we need to update.
476: --
477: pqh_bgt_shd.lck

Line 546: hr_utility.set_location('Entering:'||l_proc, 5);

542: l_rec pqh_bgt_shd.g_rec_type;
543: l_proc varchar2(72) := g_package||'upd';
544: --
545: Begin
546: hr_utility.set_location('Entering:'||l_proc, 5);
547: --
548: -- Call conversion function to turn arguments into the
549: -- l_rec structure.
550: --

Line 591: hr_utility.set_location(' Leaving:'||l_proc, 10);

587: upd(
588: p_effective_date,l_rec);
589: p_object_version_number := l_rec.object_version_number;
590: --
591: hr_utility.set_location(' Leaving:'||l_proc, 10);
592: End upd;
593: --
594: end pqh_bgt_upd;