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

Line 52: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

48: , p6_a19 NUMBER := 0-1962.0724
49: , p6_a20 NUMBER := 0-1962.0724
50: )
51: as
52: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;
53: ddindx binary_integer; indx binary_integer;
54: begin
55:
56: -- copy data to the local IN or IN-OUT args, if any

Line 137: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;

133: , p7_a18 NUMBER := 0-1962.0724
134: , p7_a19 NUMBER := 0-1962.0724
135: )
136: as
137: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;
138: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
139: ddindx binary_integer; indx binary_integer;
140: begin
141:

Line 138: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;

134: , p7_a19 NUMBER := 0-1962.0724
135: )
136: as
137: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;
138: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
139: ddindx binary_integer; indx binary_integer;
140: begin
141:
142: -- copy data to the local IN or IN-OUT args, if any

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

167: ddp_list_query_rec_tbl.arc_act_list_query_used_by := p7_a17;
168: ddp_list_query_rec_tbl.parent_list_query_id := rosetta_g_miss_num_map(p7_a18);
169: ddp_list_query_rec_tbl.sequence_order := rosetta_g_miss_num_map(p7_a19);
170:
171: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
172:
173:
174: -- here's the delegated call to the old PL/SQL routine
175: ams_list_query_pub.create_list_query(p_api_version_number,

Line 228: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;

224: , p6_a19 NUMBER := 0-1962.0724
225: , p6_a20 NUMBER := 0-1962.0724
226: )
227: as
228: ddp_list_query_rec ams_list_query_pvt.list_query_rec_type;
229: ddindx binary_integer; indx binary_integer;
230: begin
231:
232: -- copy data to the local IN or IN-OUT args, if any

Line 313: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;

309: , p7_a18 NUMBER := 0-1962.0724
310: , p7_a19 NUMBER := 0-1962.0724
311: )
312: as
313: ddp_list_query_rec_tbl ams_list_query_pvt.list_query_rec_type_tbl;
314: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
315: ddindx binary_integer; indx binary_integer;
316: begin
317:

Line 314: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;

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

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

343: ddp_list_query_rec_tbl.arc_act_list_query_used_by := p7_a17;
344: ddp_list_query_rec_tbl.parent_list_query_id := rosetta_g_miss_num_map(p7_a18);
345: ddp_list_query_rec_tbl.sequence_order := rosetta_g_miss_num_map(p7_a19);
346:
347: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
348:
349:
350: -- here's the delegated call to the old PL/SQL routine
351: ams_list_query_pub.update_list_query(p_api_version_number,