DBA Data[Home] [Help]

APPS.BEN_COPY_ENTITY_RESULTS_API dependencies on BEN_COPY_ENTITY_RESULTS

Line 1: Package Body ben_copy_entity_results_api as

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: --

Line 6: g_package varchar2(33) := ' ben_copy_entity_results_api.';

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: -- ----------------------------------------------------------------------------

Line 389: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;

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

Line 391: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;

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

Line 411: l_dml_operation ben_copy_entity_results.dml_operation%type := 'REUSE';

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

Line 412: l_status ben_copy_entity_results.status%type := 'VALID';

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: --

Line 413: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type := 'INSERT';

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);

Line 1265: l_object_version_number ben_copy_entity_results.object_version_number%TYPE ;

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);

Line 1710: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;

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);

Line 1797: end ben_copy_entity_results_api;

1793: hr_utility.set_location(' Leaving:'||l_proc, 70);
1794: --
1795: end lck;
1796: --
1797: end ben_copy_entity_results_api;