APPS.HR_COLLECTIVE_AGREEMENT_API dependencies on PER_COLLECTIVE_AGREEMENTS

Line 306: l_collective_agreement_id per_collective_agreements.collective_agreement_id%TYPE;

302: ) is
303: --
304: -- Declare cursors and local variables
305: --
306: l_collective_agreement_id per_collective_agreements.collective_agreement_id%TYPE;
307: l_proc varchar2(72) := g_package||'create_collective_agreement';
308: l_object_version_number per_collective_agreements.object_version_number%TYPE;
309: --
310: l_pl_id NUMBER;

Line 308: l_object_version_number per_collective_agreements.object_version_number%TYPE;

304: -- Declare cursors and local variables
305: --
306: l_collective_agreement_id per_collective_agreements.collective_agreement_id%TYPE;
307: l_proc varchar2(72) := g_package||'create_collective_agreement';
308: l_object_version_number per_collective_agreements.object_version_number%TYPE;
309: --
310: l_pl_id NUMBER;
311: l_pl_ovn NUMBER;
312: l_effective_date DATE;

Line 747: l_object_version_number per_collective_agreements.object_version_number%TYPE;

743: --
744: -- Declare cursors and local variables
745: --
746: l_proc varchar2(72) := g_package||'update_collective_agreement';
747: l_object_version_number per_collective_agreements.object_version_number%TYPE;
748: l_temp_ovn number;
749: --
750: begin
751: --

Line 1033: l_object_version_number per_collective_agreements.object_version_number%TYPE;

1029: --
1030: -- Declare cursors and local variables
1031: --
1032: l_proc VARCHAR2(72) := g_package||'delete_collective_agreement';
1033: l_object_version_number per_collective_agreements.object_version_number%TYPE;
1034: l_pl_ovn NUMBER;
1035: l_pl_id NUMBER;
1036: l_popl_ovn NUMBER;
1037: l_dummy VARCHAR2(1);

Line 1052: per_collective_agreements cag

1048: SELECT b.pl_id,
1049: b.object_version_number,
1050: cag.start_date
1051: FROM ben_pl_f b,
1052: per_collective_agreements cag
1053: WHERE b.pl_id = cag.pl_Id
1054: AND cag.collective_agreement_id = p_collective_agreement_id;
1055: --
1056: CURSOR csr_popl_yr IS