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.AMS_CELL_PVT_W dependencies on AMS_CELL_PVT

Line 1: package body ams_cell_pvt_w as

1: package body ams_cell_pvt_w as
2: /* $Header: amswcelb.pls 115.19 2002/11/22 08:56:52 jieli ship $ */
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:

Line 22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_cell_pvt.t_number, a0 JTF_NUMBER_TABLE) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_cell_pvt.t_number, a0 JTF_NUMBER_TABLE) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p2(t ams_cell_pvt.t_number, a0 OUT NOCOPY JTF_NUMBER_TABLE) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p2;
40: procedure rosetta_table_copy_out_p2(t ams_cell_pvt.t_number, a0 OUT NOCOPY JTF_NUMBER_TABLE) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_NUMBER_TABLE();

Line 92: ddp_cell_rec ams_cell_pvt.cell_rec_type;

88: , p7_a17 DATE := fnd_api.g_miss_date
89: , p7_a18 NUMBER := 0-1962.0724
90: )
91: as
92: ddp_cell_rec ams_cell_pvt.cell_rec_type;
93: ddindx binary_integer; indx binary_integer;
94: begin
95:
96: -- copy data to the local IN or IN-OUT args, if any

Line 126: ams_cell_pvt.create_cell(p_api_version,

122: ddp_cell_rec.user_status_id := rosetta_g_miss_num_map(p7_a18);
123:
124:
125: -- here's the delegated call to the old PL/SQL routine
126: ams_cell_pvt.create_cell(p_api_version,
127: p_init_msg_list,
128: p_commit,
129: p_validation_level,
130: x_return_status,

Line 175: ddp_cell_rec ams_cell_pvt.cell_rec_type;

171: , p7_a17 DATE := fnd_api.g_miss_date
172: , p7_a18 NUMBER := 0-1962.0724
173: )
174: as
175: ddp_cell_rec ams_cell_pvt.cell_rec_type;
176: ddindx binary_integer; indx binary_integer;
177: begin
178:
179: -- copy data to the local IN or IN-OUT args, if any

Line 208: ams_cell_pvt.update_cell(p_api_version,

204: ddp_cell_rec.status_date := rosetta_g_miss_date_in_map(p7_a17);
205: ddp_cell_rec.user_status_id := rosetta_g_miss_num_map(p7_a18);
206:
207: -- here's the delegated call to the old PL/SQL routine
208: ams_cell_pvt.update_cell(p_api_version,
209: p_init_msg_list,
210: p_commit,
211: p_validation_level,
212: x_return_status,

Line 254: ddp_cell_rec ams_cell_pvt.cell_rec_type;

250: , p6_a17 DATE := fnd_api.g_miss_date
251: , p6_a18 NUMBER := 0-1962.0724
252: )
253: as
254: ddp_cell_rec ams_cell_pvt.cell_rec_type;
255: ddindx binary_integer; indx binary_integer;
256: begin
257:
258: -- copy data to the local IN or IN-OUT args, if any

Line 286: ams_cell_pvt.validate_cell(p_api_version,

282: ddp_cell_rec.status_date := rosetta_g_miss_date_in_map(p6_a17);
283: ddp_cell_rec.user_status_id := rosetta_g_miss_num_map(p6_a18);
284:
285: -- here's the delegated call to the old PL/SQL routine
286: ams_cell_pvt.validate_cell(p_api_version,
287: p_init_msg_list,
288: p_validation_level,
289: x_return_status,
290: x_msg_count,

Line 326: ddp_cell_rec ams_cell_pvt.cell_rec_type;

322: , p0_a17 DATE := fnd_api.g_miss_date
323: , p0_a18 NUMBER := 0-1962.0724
324: )
325: as
326: ddp_cell_rec ams_cell_pvt.cell_rec_type;
327: ddindx binary_integer; indx binary_integer;
328: begin
329:
330: -- copy data to the local IN or IN-OUT args, if any

Line 354: ams_cell_pvt.check_cell_items(ddp_cell_rec,

350:
351:
352:
353: -- here's the delegated call to the old PL/SQL routine
354: ams_cell_pvt.check_cell_items(ddp_cell_rec,
355: p_validation_mode,
356: x_return_status);
357:
358: -- copy data back from the local OUT or IN-OUT args, if any

Line 384: ddx_cell_rec ams_cell_pvt.cell_rec_type;

380: , p0_a17 OUT NOCOPY DATE
381: , p0_a18 OUT NOCOPY NUMBER
382: )
383: as
384: ddx_cell_rec ams_cell_pvt.cell_rec_type;
385: ddindx binary_integer; indx binary_integer;
386: begin
387:
388: -- copy data to the local IN or IN-OUT args, if any

Line 391: ams_cell_pvt.init_cell_rec(ddx_cell_rec);

387:
388: -- copy data to the local IN or IN-OUT args, if any
389:
390: -- here's the delegated call to the old PL/SQL routine
391: ams_cell_pvt.init_cell_rec(ddx_cell_rec);
392:
393: -- copy data back from the local OUT or IN-OUT args, if any
394: p0_a0 := rosetta_g_miss_num_map(ddx_cell_rec.cell_id);
395: p0_a1 := ddx_cell_rec.sel_type;

Line 455: ddp_cell_rec ams_cell_pvt.cell_rec_type;

451: , p0_a17 DATE := fnd_api.g_miss_date
452: , p0_a18 NUMBER := 0-1962.0724
453: )
454: as
455: ddp_cell_rec ams_cell_pvt.cell_rec_type;
456: ddx_complete_rec ams_cell_pvt.cell_rec_type;
457: ddindx binary_integer; indx binary_integer;
458: begin
459:

Line 456: ddx_complete_rec ams_cell_pvt.cell_rec_type;

452: , p0_a18 NUMBER := 0-1962.0724
453: )
454: as
455: ddp_cell_rec ams_cell_pvt.cell_rec_type;
456: ddx_complete_rec ams_cell_pvt.cell_rec_type;
457: ddindx binary_integer; indx binary_integer;
458: begin
459:
460: -- copy data to the local IN or IN-OUT args, if any

Line 483: ams_cell_pvt.complete_cell_rec(ddp_cell_rec,

479: ddp_cell_rec.user_status_id := rosetta_g_miss_num_map(p0_a18);
480:
481:
482: -- here's the delegated call to the old PL/SQL routine
483: ams_cell_pvt.complete_cell_rec(ddp_cell_rec,
484: ddx_complete_rec);
485:
486: -- copy data back from the local OUT or IN-OUT args, if any
487:

Line 548: ddp_sql_cell_rec ams_cell_pvt.sqlcell_rec_type;

544: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a28 NUMBER := 0-1962.0724
546: )
547: as
548: ddp_sql_cell_rec ams_cell_pvt.sqlcell_rec_type;
549: ddindx binary_integer; indx binary_integer;
550: begin
551:
552: -- copy data to the local IN or IN-OUT args, if any

Line 592: ams_cell_pvt.create_sql_cell(p_api_version,

588: ddp_sql_cell_rec.list_query_version_number := rosetta_g_miss_num_map(p7_a28);
589:
590:
591: -- here's the delegated call to the old PL/SQL routine
592: ams_cell_pvt.create_sql_cell(p_api_version,
593: p_init_msg_list,
594: p_commit,
595: p_validation_level,
596: x_return_status,

Line 651: ddp_sql_cell_rec ams_cell_pvt.sqlcell_rec_type;

647: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a28 NUMBER := 0-1962.0724
649: )
650: as
651: ddp_sql_cell_rec ams_cell_pvt.sqlcell_rec_type;
652: ddindx binary_integer; indx binary_integer;
653: begin
654:
655: -- copy data to the local IN or IN-OUT args, if any

Line 694: ams_cell_pvt.update_sql_cell(p_api_version,

690: ddp_sql_cell_rec.source_object_name := p7_a27;
691: ddp_sql_cell_rec.list_query_version_number := rosetta_g_miss_num_map(p7_a28);
692:
693: -- here's the delegated call to the old PL/SQL routine
694: ams_cell_pvt.update_sql_cell(p_api_version,
695: p_init_msg_list,
696: p_commit,
697: p_validation_level,
698: x_return_status,

Line 713: end ams_cell_pvt_w;

709:
710:
711: end;
712:
713: end ams_cell_pvt_w;