APPS.EAM_SAFETY_REPORTS_PVT_W dependencies on EAM_SAFETY_REPORTS_PVT

Line 1: package body eam_safety_reports_pvt_w as

1: package body eam_safety_reports_pvt_w as
2: /* $Header: EAMWSRPB.pls 120.2 2011/06/01 10:15:58 vboddapa noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p1(t out nocopy eam_safety_reports_pvt.eam_permit_tab_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy eam_safety_reports_pvt.eam_permit_tab_type, a0 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count=0 then

Line 30: t := eam_safety_reports_pvt.eam_permit_tab_type();

26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count=0 then
30: t := eam_safety_reports_pvt.eam_permit_tab_type();
31: elsif a0 is not null and a0.count > 0 then
32: if a0.count > 0 then
33: t := eam_safety_reports_pvt.eam_permit_tab_type();
34: t.extend(a0.count);

Line 33: t := eam_safety_reports_pvt.eam_permit_tab_type();

29: if a0 is not null and a0.count=0 then
30: t := eam_safety_reports_pvt.eam_permit_tab_type();
31: elsif a0 is not null and a0.count > 0 then
32: if a0.count > 0 then
33: t := eam_safety_reports_pvt.eam_permit_tab_type();
34: t.extend(a0.count);
35: indx := a0.first;
36: ddindx := 1;
37: while true loop

Line 48: procedure rosetta_table_copy_out_p1(t eam_safety_reports_pvt.eam_permit_tab_type, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t eam_safety_reports_pvt.eam_permit_tab_type, a0 out nocopy JTF_NUMBER_TABLE
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if t is null then

Line 83: ddp_permit_ids eam_safety_reports_pvt.eam_permit_tab_type;

79: , p_file_attachment_flag NUMBER
80: ) return clob
81:
82: as
83: ddp_permit_ids eam_safety_reports_pvt.eam_permit_tab_type;
84: ddindx binary_integer; indx binary_integer;
85: ddrosetta_retval clob;
86: begin
87:

Line 89: eam_safety_reports_pvt_w.rosetta_table_copy_in_p1(ddp_permit_ids, p0_a0

85: ddrosetta_retval clob;
86: begin
87:
88: -- copy data to the local IN or IN-OUT args, if any
89: eam_safety_reports_pvt_w.rosetta_table_copy_in_p1(ddp_permit_ids, p0_a0
90: );
91:
92:
93:

Line 98: ddrosetta_retval := eam_safety_reports_pvt.getworkpermitreportxml(ddp_permit_ids,

94:
95:
96:
97: -- here's the delegated call to the old PL/SQL routine
98: ddrosetta_retval := eam_safety_reports_pvt.getworkpermitreportxml(ddp_permit_ids,
99: p_work_clearance_flag,
100: p_work_order_flag,
101: p_text_attachment_flag,
102: p_url_attachment_flag,

Line 128: ddrosetta_retval := eam_safety_reports_pvt.convert_to_client_time(ddp_server_time);

124: -- copy data to the local IN or IN-OUT args, if any
125: ddp_server_time := rosetta_g_miss_date_in_map(p_server_time);
126:
127: -- here's the delegated call to the old PL/SQL routine
128: ddrosetta_retval := eam_safety_reports_pvt.convert_to_client_time(ddp_server_time);
129:
130: -- copy data back from the local variables to OUT or IN-OUT args, if any
131:
132: return ddrosetta_retval;

Line 135: end eam_safety_reports_pvt_w;

131:
132: return ddrosetta_retval;
133: end;
134:
135: end eam_safety_reports_pvt_w;