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.EAM_CONSTRUCTION_UNIT_PUB_W dependencies on EAM_CONSTRUCTION_UNIT_PUB

Line 1: package body eam_construction_unit_pub_w as

1: package body eam_construction_unit_pub_w as
2: /* $Header: EAMPCUWB.pls 120.0.12010000.2 2008/11/20 04:37:58 dsingire 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_p2(t out nocopy eam_construction_unit_pub.cu_activity_tbl, 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_p2(t out nocopy eam_construction_unit_pub.cu_activity_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE

Line 58: procedure rosetta_table_copy_out_p2(t eam_construction_unit_pub.cu_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE

54: end loop;
55: end if;
56: end if;
57: end rosetta_table_copy_in_p2;
58: procedure rosetta_table_copy_out_p2(t eam_construction_unit_pub.cu_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_100
61: , a3 out nocopy JTF_NUMBER_TABLE
62: , a4 out nocopy JTF_NUMBER_TABLE

Line 117: procedure rosetta_table_copy_in_p4(t out nocopy eam_construction_unit_pub.cu_id_tbl, a0 JTF_NUMBER_TABLE

113: end if;
114: end if;
115: end rosetta_table_copy_out_p2;
116:
117: procedure rosetta_table_copy_in_p4(t out nocopy eam_construction_unit_pub.cu_id_tbl, a0 JTF_NUMBER_TABLE
118: ) as
119: ddindx binary_integer; indx binary_integer;
120: begin
121: if a0 is not null and a0.count > 0 then

Line 136: procedure rosetta_table_copy_out_p4(t eam_construction_unit_pub.cu_id_tbl, a0 out nocopy JTF_NUMBER_TABLE

132: end loop;
133: end if;
134: end if;
135: end rosetta_table_copy_in_p4;
136: procedure rosetta_table_copy_out_p4(t eam_construction_unit_pub.cu_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
137: ) as
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then

Line 199: ddp_cu_rec eam_construction_unit_pub.cu_rec;

195: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
196: )
197:
198: as
199: ddp_cu_rec eam_construction_unit_pub.cu_rec;
200: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:

Line 200: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;

196: )
197:
198: as
199: ddp_cu_rec eam_construction_unit_pub.cu_rec;
200: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:
204: -- copy data to the local IN or IN-OUT args, if any

Line 230: eam_construction_unit_pub_w.rosetta_table_copy_in_p2(ddp_cu_activity_tbl, p3_a0

226: ddp_cu_rec.attribute13 := p2_a19;
227: ddp_cu_rec.attribute14 := p2_a20;
228: ddp_cu_rec.attribute15 := p2_a21;
229:
230: eam_construction_unit_pub_w.rosetta_table_copy_in_p2(ddp_cu_activity_tbl, p3_a0
231: , p3_a1
232: , p3_a2
233: , p3_a3
234: , p3_a4

Line 245: eam_construction_unit_pub.create_construction_unit(p_api_version,

241:
242:
243:
244: -- here's the delegated call to the old PL/SQL routine
245: eam_construction_unit_pub.create_construction_unit(p_api_version,
246: p_commit,
247: ddp_cu_rec,
248: ddp_cu_activity_tbl,
249: x_cu_id,

Line 303: ddp_cu_rec eam_construction_unit_pub.cu_rec;

299: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
300: )
301:
302: as
303: ddp_cu_rec eam_construction_unit_pub.cu_rec;
304: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;
305: ddindx binary_integer; indx binary_integer;
306: begin
307:

Line 304: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;

300: )
301:
302: as
303: ddp_cu_rec eam_construction_unit_pub.cu_rec;
304: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;
305: ddindx binary_integer; indx binary_integer;
306: begin
307:
308: -- copy data to the local IN or IN-OUT args, if any

Line 334: eam_construction_unit_pub_w.rosetta_table_copy_in_p2(ddp_cu_activity_tbl, p3_a0

330: ddp_cu_rec.attribute13 := p2_a19;
331: ddp_cu_rec.attribute14 := p2_a20;
332: ddp_cu_rec.attribute15 := p2_a21;
333:
334: eam_construction_unit_pub_w.rosetta_table_copy_in_p2(ddp_cu_activity_tbl, p3_a0
335: , p3_a1
336: , p3_a2
337: , p3_a3
338: , p3_a4

Line 349: eam_construction_unit_pub.update_construction_unit(p_api_version,

345:
346:
347:
348: -- here's the delegated call to the old PL/SQL routine
349: eam_construction_unit_pub.update_construction_unit(p_api_version,
350: p_commit,
351: ddp_cu_rec,
352: ddp_cu_activity_tbl,
353: x_cu_id,

Line 408: ddp_cu_rec eam_construction_unit_pub.cu_rec;

404: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
405: )
406:
407: as
408: ddp_cu_rec eam_construction_unit_pub.cu_rec;
409: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;
410: ddp_source_cu_id_tbl eam_construction_unit_pub.cu_id_tbl;
411: ddindx binary_integer; indx binary_integer;
412: begin

Line 409: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;

405: )
406:
407: as
408: ddp_cu_rec eam_construction_unit_pub.cu_rec;
409: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;
410: ddp_source_cu_id_tbl eam_construction_unit_pub.cu_id_tbl;
411: ddindx binary_integer; indx binary_integer;
412: begin
413:

Line 410: ddp_source_cu_id_tbl eam_construction_unit_pub.cu_id_tbl;

406:
407: as
408: ddp_cu_rec eam_construction_unit_pub.cu_rec;
409: ddp_cu_activity_tbl eam_construction_unit_pub.cu_activity_tbl;
410: ddp_source_cu_id_tbl eam_construction_unit_pub.cu_id_tbl;
411: ddindx binary_integer; indx binary_integer;
412: begin
413:
414: -- copy data to the local IN or IN-OUT args, if any

Line 440: eam_construction_unit_pub_w.rosetta_table_copy_in_p2(ddp_cu_activity_tbl, p3_a0

436: ddp_cu_rec.attribute13 := p2_a19;
437: ddp_cu_rec.attribute14 := p2_a20;
438: ddp_cu_rec.attribute15 := p2_a21;
439:
440: eam_construction_unit_pub_w.rosetta_table_copy_in_p2(ddp_cu_activity_tbl, p3_a0
441: , p3_a1
442: , p3_a2
443: , p3_a3
444: , p3_a4

Line 450: eam_construction_unit_pub_w.rosetta_table_copy_in_p4(ddp_source_cu_id_tbl, p4_a0

446: , p3_a6
447: , p3_a7
448: );
449:
450: eam_construction_unit_pub_w.rosetta_table_copy_in_p4(ddp_source_cu_id_tbl, p4_a0
451: );
452:
453:
454:

Line 458: eam_construction_unit_pub.copy_construction_unit(p_api_version,

454:
455:
456:
457: -- here's the delegated call to the old PL/SQL routine
458: eam_construction_unit_pub.copy_construction_unit(p_api_version,
459: p_commit,
460: ddp_cu_rec,
461: ddp_cu_activity_tbl,
462: ddp_source_cu_id_tbl,

Line 479: end eam_construction_unit_pub_w;

475:
476:
477: end;
478:
479: end eam_construction_unit_pub_w;