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_XML_ELEMENT_PVT_W dependencies on AMS_XML_ELEMENT_PVT

Line 1: package body ams_xml_element_pvt_w as

1: package body ams_xml_element_pvt_w as
2: /* $Header: amswxelb.pls 115.4 2002/11/14 01:24:11 jieli 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: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 26: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_xml_element_pvt.num_data_set_type_w, a0 JTF_NUMBER_TABLE) as

22: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
23: return d;
24: end;
25:
26: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_xml_element_pvt.num_data_set_type_w, a0 JTF_NUMBER_TABLE) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count > 0 then
30: if a0.count > 0 then

Line 44: procedure rosetta_table_copy_out_p1(t ams_xml_element_pvt.num_data_set_type_w, a0 OUT NOCOPY JTF_NUMBER_TABLE) as

40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t ams_xml_element_pvt.num_data_set_type_w, a0 OUT NOCOPY JTF_NUMBER_TABLE) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();

Line 67: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_xml_element_pvt.varchar2_2000_set_type, a0 JTF_VARCHAR2_TABLE_2000) as

63: end if;
64: end if;
65: end rosetta_table_copy_out_p1;
66:
67: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_xml_element_pvt.varchar2_2000_set_type, a0 JTF_VARCHAR2_TABLE_2000) as
68: ddindx binary_integer; indx binary_integer;
69: begin
70: if a0 is not null and a0.count > 0 then
71: if a0.count > 0 then

Line 85: procedure rosetta_table_copy_out_p2(t ams_xml_element_pvt.varchar2_2000_set_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_2000) as

81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p2;
85: procedure rosetta_table_copy_out_p2(t ams_xml_element_pvt.varchar2_2000_set_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_2000) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if t is null or t.count = 0 then
89: a0 := JTF_VARCHAR2_TABLE_2000();

Line 108: procedure rosetta_table_copy_in_p5(t OUT NOCOPY ams_xml_element_pvt.xml_element_tbl_type, a0 JTF_NUMBER_TABLE

104: end if;
105: end if;
106: end rosetta_table_copy_out_p2;
107:
108: procedure rosetta_table_copy_in_p5(t OUT NOCOPY ams_xml_element_pvt.xml_element_tbl_type, a0 JTF_NUMBER_TABLE
109: , a1 JTF_NUMBER_TABLE
110: , a2 JTF_NUMBER_TABLE
111: , a3 JTF_NUMBER_TABLE
112: , a4 JTF_NUMBER_TABLE

Line 157: procedure rosetta_table_copy_out_p5(t ams_xml_element_pvt.xml_element_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p5;
157: procedure rosetta_table_copy_out_p5(t ams_xml_element_pvt.xml_element_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
158: , a1 OUT NOCOPY JTF_NUMBER_TABLE
159: , a2 OUT NOCOPY JTF_NUMBER_TABLE
160: , a3 OUT NOCOPY JTF_NUMBER_TABLE
161: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 282: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;

278: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
280: )
281: as
282: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
283: ddindx binary_integer; indx binary_integer;
284: begin
285:
286: -- copy data to the local IN or IN-OUT args, if any

Line 313: ams_xml_element_pvt.create_xml_element(p_api_version_number,

309: ddp_xml_element_rec.error_text := p7_a15;
310:
311:
312: -- here's the delegated call to the old PL/SQL routine
313: ams_xml_element_pvt.create_xml_element(p_api_version_number,
314: p_init_msg_list,
315: p_commit,
316: p_validation_level,
317: x_return_status,

Line 363: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;

359: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
361: )
362: as
363: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
364: ddp_xml_element_ids ams_xml_element_pvt.num_data_set_type_w;
365: ddp_xml_elements_data ams_xml_element_pvt.varchar2_2000_set_type;
366: ddp_xml_elements_col_name ams_xml_element_pvt.varchar2_2000_set_type;
367: ddindx binary_integer; indx binary_integer;

Line 364: ddp_xml_element_ids ams_xml_element_pvt.num_data_set_type_w;

360: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
361: )
362: as
363: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
364: ddp_xml_element_ids ams_xml_element_pvt.num_data_set_type_w;
365: ddp_xml_elements_data ams_xml_element_pvt.varchar2_2000_set_type;
366: ddp_xml_elements_col_name ams_xml_element_pvt.varchar2_2000_set_type;
367: ddindx binary_integer; indx binary_integer;
368: begin

Line 365: ddp_xml_elements_data ams_xml_element_pvt.varchar2_2000_set_type;

361: )
362: as
363: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
364: ddp_xml_element_ids ams_xml_element_pvt.num_data_set_type_w;
365: ddp_xml_elements_data ams_xml_element_pvt.varchar2_2000_set_type;
366: ddp_xml_elements_col_name ams_xml_element_pvt.varchar2_2000_set_type;
367: ddindx binary_integer; indx binary_integer;
368: begin
369:

Line 366: ddp_xml_elements_col_name ams_xml_element_pvt.varchar2_2000_set_type;

362: as
363: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
364: ddp_xml_element_ids ams_xml_element_pvt.num_data_set_type_w;
365: ddp_xml_elements_data ams_xml_element_pvt.varchar2_2000_set_type;
366: ddp_xml_elements_col_name ams_xml_element_pvt.varchar2_2000_set_type;
367: ddindx binary_integer; indx binary_integer;
368: begin
369:
370: -- copy data to the local IN or IN-OUT args, if any

Line 392: ams_xml_element_pvt_w.rosetta_table_copy_in_p1(ddp_xml_element_ids, p_xml_element_ids);

388: ddp_xml_element_rec.data_type := p4_a13;
389: ddp_xml_element_rec.load_status := p4_a14;
390: ddp_xml_element_rec.error_text := p4_a15;
391:
392: ams_xml_element_pvt_w.rosetta_table_copy_in_p1(ddp_xml_element_ids, p_xml_element_ids);
393:
394: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_data, p_xml_elements_data);
395:
396: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_col_name, p_xml_elements_col_name);

Line 394: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_data, p_xml_elements_data);

390: ddp_xml_element_rec.error_text := p4_a15;
391:
392: ams_xml_element_pvt_w.rosetta_table_copy_in_p1(ddp_xml_element_ids, p_xml_element_ids);
393:
394: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_data, p_xml_elements_data);
395:
396: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_col_name, p_xml_elements_col_name);
397:
398:

Line 396: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_col_name, p_xml_elements_col_name);

392: ams_xml_element_pvt_w.rosetta_table_copy_in_p1(ddp_xml_element_ids, p_xml_element_ids);
393:
394: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_data, p_xml_elements_data);
395:
396: ams_xml_element_pvt_w.rosetta_table_copy_in_p2(ddp_xml_elements_col_name, p_xml_elements_col_name);
397:
398:
399:
400:

Line 403: ams_xml_element_pvt.update_error_xml_element(p_api_version_number,

399:
400:
401:
402: -- here's the delegated call to the old PL/SQL routine
403: ams_xml_element_pvt.update_error_xml_element(p_api_version_number,
404: p_init_msg_list,
405: p_commit,
406: p_validation_level,
407: ddp_xml_element_rec,

Line 456: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;

452: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
454: )
455: as
456: ddp_xml_element_rec ams_xml_element_pvt.xml_element_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 487: ams_xml_element_pvt.update_xml_element(p_api_version_number,

483: ddp_xml_element_rec.error_text := p7_a15;
484:
485:
486: -- here's the delegated call to the old PL/SQL routine
487: ams_xml_element_pvt.update_xml_element(p_api_version_number,
488: p_init_msg_list,
489: p_commit,
490: p_validation_level,
491: x_return_status,

Line 533: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;

529: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
530: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
531: )
532: as
533: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
534: ddindx binary_integer; indx binary_integer;
535: begin
536:
537: -- copy data to the local IN or IN-OUT args, if any

Line 563: ams_xml_element_pvt.validate_xml_element(p_api_version_number,

559:
560:
561:
562: -- here's the delegated call to the old PL/SQL routine
563: ams_xml_element_pvt.validate_xml_element(p_api_version_number,
564: p_init_msg_list,
565: p_validation_level,
566: ddp_xml_element_rec,
567: p_validation_mode,

Line 602: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;

598: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
599: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
600: )
601: as
602: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
603: ddindx binary_integer; indx binary_integer;
604: begin
605:
606: -- copy data to the local IN or IN-OUT args, if any

Line 627: ams_xml_element_pvt.check_xml_element_items(ddp_xml_element_rec,

623:
624:
625:
626: -- here's the delegated call to the old PL/SQL routine
627: ams_xml_element_pvt.check_xml_element_items(ddp_xml_element_rec,
628: p_validation_mode,
629: x_return_status);
630:
631: -- copy data back from the local OUT or IN-OUT args, if any

Line 659: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;

655: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
657: )
658: as
659: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
660: ddindx binary_integer; indx binary_integer;
661: begin
662:
663: -- copy data to the local IN or IN-OUT args, if any

Line 687: ams_xml_element_pvt.validate_xml_element_rec(p_api_version_number,

683: ddp_xml_element_rec.load_status := p5_a14;
684: ddp_xml_element_rec.error_text := p5_a15;
685:
686: -- here's the delegated call to the old PL/SQL routine
687: ams_xml_element_pvt.validate_xml_element_rec(p_api_version_number,
688: p_init_msg_list,
689: x_return_status,
690: x_msg_count,
691: x_msg_data,

Line 702: end ams_xml_element_pvt_w;

698:
699:
700: end;
701:
702: end ams_xml_element_pvt_w;