35: , x_msg_count OUT NOCOPY NUMBER
36: , x_msg_data OUT NOCOPY VARCHAR2
37: )
38: as
39: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
40: ddindx binary_integer; indx binary_integer;
41: begin
42:
43: -- copy data to the local IN or IN-OUT args, if any
48:
49:
50:
51:
52: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
53:
54:
55:
56:
108: , x_msg_count OUT NOCOPY NUMBER
109: , x_msg_data OUT NOCOPY VARCHAR2
110: )
111: as
112: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
113: ddp_query_param ams_list_query_pvt.sql_string_tbl;
114: ddindx binary_integer; indx binary_integer;
115: begin
116:
109: , x_msg_data OUT NOCOPY VARCHAR2
110: )
111: as
112: ddp_sql_string_tbl ams_list_query_pvt.sql_string_tbl;
113: ddp_query_param ams_list_query_pvt.sql_string_tbl;
114: ddindx binary_integer; indx binary_integer;
115: begin
116:
117: -- copy data to the local IN or IN-OUT args, if any
122:
123:
124:
125:
126: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_sql_string_tbl, p_sql_string_tbl);
127:
128:
129:
130:
127:
128:
129:
130:
131: ams_list_query_pvt_w.rosetta_table_copy_in_p2(ddp_query_param, p_query_param);
132:
133:
134:
135: