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_CAGR_ENT_LINES_API dependencies on PER_CAGR_ENTITLEMENT_LINES_F

Line 145: l_cagr_entitlement_line_id per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE;

141: WHERE pca.collective_agreement_id = pce.collective_agreement_id
142: AND pce.cagr_entitlement_id = p_cagr_entitlement_id
143: and cei.cagr_entitlement_item_id = pce.cagr_entitlement_item_id;
144: --
145: l_cagr_entitlement_line_id per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE;
146: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
147: l_effective_end_date per_cagr_entitlement_lines_f.effective_end_date%TYPE;
148: l_effective_date DATE;
149: l_proc VARCHAR2(72) := g_package||'create_entitlement_line';

Line 146: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;

142: AND pce.cagr_entitlement_id = p_cagr_entitlement_id
143: and cei.cagr_entitlement_item_id = pce.cagr_entitlement_item_id;
144: --
145: l_cagr_entitlement_line_id per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE;
146: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
147: l_effective_end_date per_cagr_entitlement_lines_f.effective_end_date%TYPE;
148: l_effective_date DATE;
149: l_proc VARCHAR2(72) := g_package||'create_entitlement_line';
150: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;

Line 147: l_effective_end_date per_cagr_entitlement_lines_f.effective_end_date%TYPE;

143: and cei.cagr_entitlement_item_id = pce.cagr_entitlement_item_id;
144: --
145: l_cagr_entitlement_line_id per_cagr_entitlement_lines_f.cagr_entitlement_line_id%TYPE;
146: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
147: l_effective_end_date per_cagr_entitlement_lines_f.effective_end_date%TYPE;
148: l_effective_date DATE;
149: l_proc VARCHAR2(72) := g_package||'create_entitlement_line';
150: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
151: l_business_group_id NUMBER;

Line 150: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;

146: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
147: l_effective_end_date per_cagr_entitlement_lines_f.effective_end_date%TYPE;
148: l_effective_date DATE;
149: l_proc VARCHAR2(72) := g_package||'create_entitlement_line';
150: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
151: l_business_group_id NUMBER;
152: l_opt_id ben_opt_f.opt_id%TYPE;
153: l_order_number ben_oipl_f.ordr_num%TYPE;
154: --

Line 470: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;

466: --
467: -- Declare cursors and local variables
468: --
469: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
470: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
471: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
472: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
473: l_effective_end_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
474: l_effective_date DATE;

Line 471: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;

467: -- Declare cursors and local variables
468: --
469: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
470: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
471: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
472: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
473: l_effective_end_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
474: l_effective_date DATE;
475: --

Line 472: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;

468: --
469: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
470: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
471: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
472: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
473: l_effective_end_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
474: l_effective_date DATE;
475: --
476: l_prtn_elig_prfl_id NUMBER;

Line 473: l_effective_end_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;

469: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
470: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
471: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
472: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
473: l_effective_end_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
474: l_effective_date DATE;
475: --
476: l_prtn_elig_prfl_id NUMBER;
477: l_prtn_eff_st_date DATE;

Line 706: per_cagr_entitlement_lines_f pcl

702: bep.object_version_number
703: FROM ben_prtn_elig_prfl_f bep,
704: ben_prtn_elig_f bpe,
705: ben_oipl_f bof,
706: per_cagr_entitlement_lines_f pcl
707: WHERE bep.prtn_elig_id = bpe.prtn_elig_id
708: AND bpe.oipl_id = bof.oipl_id
709: AND bof.oipl_id = pcl.oipl_id
710: AND pcl.cagr_entitlement_line_id = p_cagr_entitlement_line_id;

Line 715: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;

711: --
712:
713:
714: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
715: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
716: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
717: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
718: l_effective_END_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
719: l_end_date DATE;

Line 716: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;

712:
713:
714: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
715: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
716: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
717: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
718: l_effective_END_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
719: l_end_date DATE;
720: l_start_date DATE;

Line 717: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;

713:
714: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
715: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
716: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
717: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
718: l_effective_END_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
719: l_end_date DATE;
720: l_start_date DATE;
721: l_oipl_ovn NUMBER;

Line 718: l_effective_END_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;

714: l_proc VARCHAR2(72) := g_package||'update_entitlement_line';
715: l_object_version_number per_cagr_entitlement_lines_f.object_version_number%TYPE;
716: l_ovn per_cagr_entitlement_lines_f.object_version_number%TYPE := p_object_version_number;
717: l_effective_start_date per_cagr_entitlement_lines_f.effective_start_date%TYPE;
718: l_effective_END_date per_cagr_entitlement_lines_f.effective_END_date%TYPE;
719: l_end_date DATE;
720: l_start_date DATE;
721: l_oipl_ovn NUMBER;
722: l_oipl_id NUMBER;