DBA Data[Home] [Help]

APPS.PER_PERUSADA_XMLP_PKG dependencies on FND_SESSIONS

Line 9: insert into fnd_sessions (session_id, effective_date)

5: begin
6: P_SESSION_DATE1:=TO_CHAR(P_SESSION_DATE,'DD-MON-YYYY');
7: --hr_standard.event('BEFORE REPORT');
8: p_org_structure_version_id_1:= p_org_structure_version_id;
9: insert into fnd_sessions (session_id, effective_date)
10: select userenv('sessionid'), trunc(sysdate)
11: from dual
12: where not exists
13: (select 1

Line 14: from fnd_sessions fs

10: select userenv('sessionid'), trunc(sysdate)
11: from dual
12: where not exists
13: (select 1
14: from fnd_sessions fs
15: where fs.session_id = userenv('sessionid'));
16: c_business_group_name := hr_reports.get_business_group(p_business_group_id);
17: c_organization := hr_us_reports.get_org_name(p_organization_id, p_business_group_id);
18: IF P_ORG_STRUCTURE_VERSION_ID_1 is null then