[Home] [Help]
13: PUBLIC FUNCTIONS
14: per_za_table_meaning
15: Function returns value from the specific user table for the
16: specified business group. Function uses the passed Effective date
17: else it picks up from Fnd_Sessions Table for fetching from the
18: date tracked User table rows and User table column values.
19: References:
20: PER_ZA_LEARNERSHIP_AGREEMENT_V
21:
88: AS
89: l_effective_date date;
90: l_meaning varchar2(80);
91: BEGIN
92: -- Use either the supplied date, or the date from fnd_sessions
93: --
94: if (p_effective_date is null) then
95: if (g_effective_date is null) then
96: begin
95: if (g_effective_date is null) then
96: begin
97: select effective_date
98: into g_effective_date
99: from fnd_sessions
100: where session_id = userenv('sessionid');
101: end;
102: end if;
103: l_effective_date := g_effective_date;
254:
255: begin
256: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
257: --
258: -- Use either the supplied date, or the date from fnd_sessions
259: --
260: if (p_effective_date is null) then
261: begin
262: hr_utility.set_location ('hruserdt.get_table_value', 1);
261: begin
262: hr_utility.set_location ('hruserdt.get_table_value', 1);
263: select effective_date
264: into l_effective_date
265: from fnd_sessions
266: where session_id = userenv('sessionid');
267: end;
268: else
269: l_effective_date := p_effective_date;
385:
386: begin
387: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
388: --
389: -- Use either the supplied date, or the date from fnd_sessions
390: --
391: if (p_effective_date is null) then
392: begin
393: hr_utility.set_location ('hruserdt.get_table_value', 1);
392: begin
393: hr_utility.set_location ('hruserdt.get_table_value', 1);
394: select effective_date
395: into l_effective_date
396: from fnd_sessions
397: where session_id = userenv('sessionid');
398: end;
399: else
400: l_effective_date := p_effective_date;