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_LIST_QUERY_PVT_W dependencies on AMS_LIST_QUERY_PVT

Line 1: package body ams_list_query_pvt_w as

1: package body ams_list_query_pvt_w as
2: /* $Header: amswliqb.pls 115.9 2002/11/22 08:57:20 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_list_query_pvt.sql_string_tbl, a0 JTF_VARCHAR2_TABLE_4000) 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_list_query_pvt.sql_string_tbl, a0 JTF_VARCHAR2_TABLE_4000) 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_list_query_pvt.sql_string_tbl, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) 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_list_query_pvt.sql_string_tbl, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_4000();

Line 63: procedure rosetta_table_copy_in_p6(t OUT NOCOPY ams_list_query_pvt.list_query_id_tbl_type, a0 JTF_NUMBER_TABLE) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p2;
62:
63: procedure rosetta_table_copy_in_p6(t OUT NOCOPY ams_list_query_pvt.list_query_id_tbl_type, a0 JTF_NUMBER_TABLE) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then
67: if a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p6(t ams_list_query_pvt.list_query_id_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p6;
81: procedure rosetta_table_copy_out_p6(t ams_list_query_pvt.list_query_id_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();

Line 135: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

131: , p7_a19 NUMBER := 0-1962.0724
132: , p7_a20 NUMBER := 0-1962.0724
133: )
134: as
135: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;
136: ddindx binary_integer; indx binary_integer;
137: begin
138:
139: -- copy data to the local IN or IN-OUT args, if any

Line 171: ams_list_query_pvt.create_list_query(p_api_version_number,

167: ddp_list_query_rec.sequence_order := rosetta_g_miss_num_map(p7_a20);
168:
169:
170: -- here's the delegated call to the old PL/SQL routine
171: ams_list_query_pvt.create_list_query(p_api_version_number,
172: p_init_msg_list,
173: p_commit,
174: p_validation_level,
175: x_return_status,

Line 223: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;

219: , p7_a18 NUMBER := 0-1962.0724
220: , p7_a19 NUMBER := 0-1962.0724
221: )
222: as
223: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;
224: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
225: ddindx binary_integer; indx binary_integer;
226: begin
227:

Line 224: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;

220: , p7_a19 NUMBER := 0-1962.0724
221: )
222: as
223: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;
224: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
225: ddindx binary_integer; indx binary_integer;
226: begin
227:
228: -- copy data to the local IN or IN-OUT args, if any

Line 257: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);

253: ddp_list_query_rec_tbl.arc_act_list_query_used_by := p7_a17;
254: ddp_list_query_rec_tbl.parent_list_query_id := rosetta_g_miss_num_map(p7_a18);
255: ddp_list_query_rec_tbl.sequence_order := rosetta_g_miss_num_map(p7_a19);
256:
257: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
258:
259:
260: -- here's the delegated call to the old PL/SQL routine
261: ams_list_query_pvt.create_list_query(p_api_version_number,

Line 261: ams_list_query_pvt.create_list_query(p_api_version_number,

257: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
258:
259:
260: -- here's the delegated call to the old PL/SQL routine
261: ams_list_query_pvt.create_list_query(p_api_version_number,
262: p_init_msg_list,
263: p_commit,
264: p_validation_level,
265: x_return_status,

Line 315: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

311: , p7_a19 NUMBER := 0-1962.0724
312: , p7_a20 NUMBER := 0-1962.0724
313: )
314: as
315: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;
316: ddindx binary_integer; indx binary_integer;
317: begin
318:
319: -- copy data to the local IN or IN-OUT args, if any

Line 351: ams_list_query_pvt.update_list_query(p_api_version_number,

347: ddp_list_query_rec.sequence_order := rosetta_g_miss_num_map(p7_a20);
348:
349:
350: -- here's the delegated call to the old PL/SQL routine
351: ams_list_query_pvt.update_list_query(p_api_version_number,
352: p_init_msg_list,
353: p_commit,
354: p_validation_level,
355: x_return_status,

Line 403: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;

399: , p7_a18 NUMBER := 0-1962.0724
400: , p7_a19 NUMBER := 0-1962.0724
401: )
402: as
403: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;
404: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
405: ddindx binary_integer; indx binary_integer;
406: begin
407:

Line 404: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;

400: , p7_a19 NUMBER := 0-1962.0724
401: )
402: as
403: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;
404: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
405: ddindx binary_integer; indx binary_integer;
406: begin
407:
408: -- copy data to the local IN or IN-OUT args, if any

Line 437: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);

433: ddp_list_query_rec_tbl.arc_act_list_query_used_by := p7_a17;
434: ddp_list_query_rec_tbl.parent_list_query_id := rosetta_g_miss_num_map(p7_a18);
435: ddp_list_query_rec_tbl.sequence_order := rosetta_g_miss_num_map(p7_a19);
436:
437: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
438:
439:
440: -- here's the delegated call to the old PL/SQL routine
441: ams_list_query_pvt.update_list_query(p_api_version_number,

Line 441: ams_list_query_pvt.update_list_query(p_api_version_number,

437: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
438:
439:
440: -- here's the delegated call to the old PL/SQL routine
441: ams_list_query_pvt.update_list_query(p_api_version_number,
442: p_init_msg_list,
443: p_commit,
444: p_validation_level,
445: x_return_status,

Line 493: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

489: , p3_a19 NUMBER := 0-1962.0724
490: , p3_a20 NUMBER := 0-1962.0724
491: )
492: as
493: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;
494: ddindx binary_integer; indx binary_integer;
495: begin
496:
497: -- copy data to the local IN or IN-OUT args, if any

Line 527: ams_list_query_pvt.validate_list_query(p_api_version_number,

523:
524:
525:
526: -- here's the delegated call to the old PL/SQL routine
527: ams_list_query_pvt.validate_list_query(p_api_version_number,
528: p_init_msg_list,
529: p_validation_level,
530: ddp_list_query_rec,
531: x_return_status,

Line 569: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

565: , p0_a19 NUMBER := 0-1962.0724
566: , p0_a20 NUMBER := 0-1962.0724
567: )
568: as
569: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;
570: ddindx binary_integer; indx binary_integer;
571: begin
572:
573: -- copy data to the local IN or IN-OUT args, if any

Line 599: ams_list_query_pvt.check_list_query_items(ddp_list_query_rec,

595:
596:
597:
598: -- here's the delegated call to the old PL/SQL routine
599: ams_list_query_pvt.check_list_query_items(ddp_list_query_rec,
600: p_validation_mode,
601: x_return_status);
602:
603: -- copy data back from the local OUT or IN-OUT args, if any

Line 636: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

632: , p5_a19 NUMBER := 0-1962.0724
633: , p5_a20 NUMBER := 0-1962.0724
634: )
635: as
636: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;
637: ddindx binary_integer; indx binary_integer;
638: begin
639:
640: -- copy data to the local IN or IN-OUT args, if any

Line 669: ams_list_query_pvt.validate_list_query_rec(p_api_version_number,

665: ddp_list_query_rec.parent_list_query_id := rosetta_g_miss_num_map(p5_a19);
666: ddp_list_query_rec.sequence_order := rosetta_g_miss_num_map(p5_a20);
667:
668: -- here's the delegated call to the old PL/SQL routine
669: ams_list_query_pvt.validate_list_query_rec(p_api_version_number,
670: p_init_msg_list,
671: x_return_status,
672: x_msg_count,
673: x_msg_data,

Line 684: end ams_list_query_pvt_w;

680:
681:
682: end;
683:
684: end ams_list_query_pvt_w;