[Home] [Help]
34: type associated with the
35: derivable factors flag from
36: 'YES_NO' to 'BEN_DTCT_TMPRL_
37: LER_TYP' in cursor c_benefit_
38: actions of the standard_header
39: procedure.
40: 15 Sep 00 C Daniels 115.9 Bug 1405067. Modified cursor
41: c_rate_prem_cvg_change in
42: both versions of overloaded
48: in procedure batch_reports
49: 11 Jan 02 Pbodla 115.11 Added Commit at the end
50: 28 Jan 02 mhoyes 115.12 - Excluded batch reporting
51: for collective agreement A mode.
52: 18 Mar 02 hnarayan 115.14 bug 1560336 - changed standard_header procedure
53: 18 Jun 02 ikasire 115.15 bug 2394141 NLS Changes
54: 18 Jun 02 ikasire 115.16 bug 2394141 Replaced nvl with decode and
55: source_lang with language
56: 17 Jul 02 mmudigon 115.17 ABSENCES : Added absences mode
83: */
84: -----------------------------------------------------------------------
85: g_package varchar2(30) := 'ben_batch_reporting.';
86: -----------------------------------------------------------------------
87: procedure standard_header
88: (p_concurrent_request_id in number,
89: p_concurrent_program_name out nocopy varchar2,
90: p_process_date out nocopy date,
91: p_mode out nocopy varchar2,
112: p_legal_entity out nocopy varchar2,
113: p_payroll out nocopy varchar2,
114: p_status out nocopy varchar2) is
115: --
116: l_proc varchar2(80) := g_package||'.standard_header';
117: l_all varchar2(80);
118: l_none varchar2(80);
119: -- bug 1560336
120: l_mode_cd_lookup_type hr_lookups.lookup_type%type := 'BEN_BENMNGLE_MD';
368: close c_benefit_actions;
369: --
370: hr_utility.set_location('Leaving :'||l_proc,10);
371: --
372: end standard_header;
373: -----------------------------------------------------------------------
374: procedure temporal_life_events
375: (p_concurrent_request_id in number,
376: p_age_changed out nocopy varchar2,