1: Package Body ben_copy_entity_results_api as
2: /* $Header: becpeapi.pkb 120.0 2005/05/28 01:12:04 appldev noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: becpeapi.pkb 120.0 2005/05/28 01:12:04 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_copy_entity_results_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_copy_entity_results >----------------------|
10: -- ----------------------------------------------------------------------------
385: ) is
386: --
387: -- Declare cursors and local variables
388: --
389: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
390: l_proc varchar2(72) := g_package||'create_copy_entity_results';
391: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
392: --
393: cursor c_tbl_rt_id_with_alias is
387: -- Declare cursors and local variables
388: --
389: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
390: l_proc varchar2(72) := g_package||'create_copy_entity_results';
391: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
392: --
393: cursor c_tbl_rt_id_with_alias is
394: select table_route_id
395: from pqh_table_route
407: --
408: l_table_route_id pqh_table_route.table_route_id%type;
409: l_table_alias pqh_table_route.table_alias%type;
410: --
411: l_dml_operation ben_copy_entity_results.dml_operation%type := 'REUSE';
412: l_status ben_copy_entity_results.status%type := 'VALID';
413: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type := 'INSERT';
414:
415: begin
408: l_table_route_id pqh_table_route.table_route_id%type;
409: l_table_alias pqh_table_route.table_alias%type;
410: --
411: l_dml_operation ben_copy_entity_results.dml_operation%type := 'REUSE';
412: l_status ben_copy_entity_results.status%type := 'VALID';
413: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type := 'INSERT';
414:
415: begin
416: --
409: l_table_alias pqh_table_route.table_alias%type;
410: --
411: l_dml_operation ben_copy_entity_results.dml_operation%type := 'REUSE';
412: l_status ben_copy_entity_results.status%type := 'VALID';
413: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type := 'INSERT';
414:
415: begin
416: --
417: hr_utility.set_location('Entering:'|| l_proc, 10);
1261: --
1262: -- Declare cursors and local variables
1263: --
1264: l_proc varchar2(72) := g_package||'update_copy_entity_results';
1265: l_object_version_number ben_copy_entity_results.object_version_number%TYPE ;
1266: --
1267: begin
1268: --
1269: hr_utility.set_location('Entering:'|| l_proc, 10);
1706: --
1707: -- Declare cursors and local variables
1708: --
1709: l_proc varchar2(72) := g_package||'update_copy_entity_results';
1710: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
1711: --
1712: begin
1713: --
1714: hr_utility.set_location('Entering:'|| l_proc, 10);
1793: hr_utility.set_location(' Leaving:'||l_proc, 70);
1794: --
1795: end lck;
1796: --
1797: end ben_copy_entity_results_api;