eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ELC_CONSTITUENCYS_API dependencies on PER_ELECTION_CONSTITUENCYS

Line 56: l_object_version_number per_election_constituencys.object_version_number%TYPE;

52: --
53: -- Declare cursors and local variables
54: --
55: l_effective_date date;
56: l_object_version_number per_election_constituencys.object_version_number%TYPE;
57: --
58: -- Declare out parameters
59: l_election_constituency_id per_election_constituencys.election_constituency_id%TYPE;
60: --

Line 59: l_election_constituency_id per_election_constituencys.election_constituency_id%TYPE;

55: l_effective_date date;
56: l_object_version_number per_election_constituencys.object_version_number%TYPE;
57: --
58: -- Declare out parameters
59: l_election_constituency_id per_election_constituencys.election_constituency_id%TYPE;
60: --
61: l_proc varchar2(72) := g_package||'create_election_constituency';
62: --
63: begin

Line 572: l_object_version_number per_election_constituencys.object_version_number%TYPE;

568: --
569: -- Declare cursors and local variables
570: --
571: l_proc varchar2(72) := (g_package||'delete_election_information');
572: l_object_version_number per_election_constituencys.object_version_number%TYPE;
573: l_election_id per_election_constituencys.election_id%TYPE;
574: --
575: cursor csr_get_elc_id is
576: select election_id

Line 573: l_election_id per_election_constituencys.election_id%TYPE;

569: -- Declare cursors and local variables
570: --
571: l_proc varchar2(72) := (g_package||'delete_election_information');
572: l_object_version_number per_election_constituencys.object_version_number%TYPE;
573: l_election_id per_election_constituencys.election_id%TYPE;
574: --
575: cursor csr_get_elc_id is
576: select election_id
577: from per_election_constituencys

Line 577: from per_election_constituencys

573: l_election_id per_election_constituencys.election_id%TYPE;
574: --
575: cursor csr_get_elc_id is
576: select election_id
577: from per_election_constituencys
578: where election_constituency_id = p_election_constituency_id;
579: --
580: begin
581: --