DBA Data[Home] [Help]

APPS.AMV_SEARCH_GRP_W dependencies on AMV_SEARCH_PVT

Line 42: ddx_searchrep_array amv_search_pvt.amv_searchrep_varray_type;

38: , p12_a4 out nocopy JTF_NUMBER_TABLE
39: )
40:
41: as
42: ddx_searchrep_array amv_search_pvt.amv_searchrep_varray_type;
43: ddindx binary_integer; indx binary_integer;
44: begin
45:
46: -- copy data to the local IN or IN-OUT args, if any

Line 88: amv_search_pvt_w.rosetta_table_copy_out_p7(ddx_searchrep_array, p12_a0

84:
85:
86:
87:
88: amv_search_pvt_w.rosetta_table_copy_out_p7(ddx_searchrep_array, p12_a0
89: , p12_a1
90: , p12_a2
91: , p12_a3
92: , p12_a4

Line 122: ddp_searcharea_obj amv_search_pvt.amv_searchara_obj_type;

118: , p7_a7 NUMBER := 0-1962.0724
119: )
120:
121: as
122: ddp_searcharea_obj amv_search_pvt.amv_searchara_obj_type;
123: ddx_searcharea_array amv_search_pvt.amv_searchara_varray_type;
124: ddindx binary_integer; indx binary_integer;
125: begin
126:

Line 123: ddx_searcharea_array amv_search_pvt.amv_searchara_varray_type;

119: )
120:
121: as
122: ddp_searcharea_obj amv_search_pvt.amv_searchara_obj_type;
123: ddx_searcharea_array amv_search_pvt.amv_searchara_varray_type;
124: ddindx binary_integer; indx binary_integer;
125: begin
126:
127: -- copy data to the local IN or IN-OUT args, if any

Line 165: amv_search_pvt_w.rosetta_table_copy_out_p9(ddx_searcharea_array, p8_a0

161:
162:
163:
164:
165: amv_search_pvt_w.rosetta_table_copy_out_p9(ddx_searcharea_array, p8_a0
166: , p8_a1
167: , p8_a2
168: , p8_a3
169: , p8_a4

Line 212: ddp_area_array amv_search_pvt.amv_char_varray_type;

208: , p17_a2 VARCHAR2 := fnd_api.g_miss_char
209: )
210:
211: as
212: ddp_area_array amv_search_pvt.amv_char_varray_type;
213: ddp_content_array amv_search_pvt.amv_char_varray_type;
214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
215: ddp_category_id amv_search_pvt.amv_number_varray_type;
216: ddp_request_obj amv_search_pvt.amv_request_obj_type;

Line 213: ddp_content_array amv_search_pvt.amv_char_varray_type;

209: )
210:
211: as
212: ddp_area_array amv_search_pvt.amv_char_varray_type;
213: ddp_content_array amv_search_pvt.amv_char_varray_type;
214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
215: ddp_category_id amv_search_pvt.amv_number_varray_type;
216: ddp_request_obj amv_search_pvt.amv_request_obj_type;
217: ddx_return_obj amv_search_pvt.amv_return_obj_type;

Line 214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;

210:
211: as
212: ddp_area_array amv_search_pvt.amv_char_varray_type;
213: ddp_content_array amv_search_pvt.amv_char_varray_type;
214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
215: ddp_category_id amv_search_pvt.amv_number_varray_type;
216: ddp_request_obj amv_search_pvt.amv_request_obj_type;
217: ddx_return_obj amv_search_pvt.amv_return_obj_type;
218: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;

Line 215: ddp_category_id amv_search_pvt.amv_number_varray_type;

211: as
212: ddp_area_array amv_search_pvt.amv_char_varray_type;
213: ddp_content_array amv_search_pvt.amv_char_varray_type;
214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
215: ddp_category_id amv_search_pvt.amv_number_varray_type;
216: ddp_request_obj amv_search_pvt.amv_request_obj_type;
217: ddx_return_obj amv_search_pvt.amv_return_obj_type;
218: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
219: ddindx binary_integer; indx binary_integer;

Line 216: ddp_request_obj amv_search_pvt.amv_request_obj_type;

212: ddp_area_array amv_search_pvt.amv_char_varray_type;
213: ddp_content_array amv_search_pvt.amv_char_varray_type;
214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
215: ddp_category_id amv_search_pvt.amv_number_varray_type;
216: ddp_request_obj amv_search_pvt.amv_request_obj_type;
217: ddx_return_obj amv_search_pvt.amv_return_obj_type;
218: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
219: ddindx binary_integer; indx binary_integer;
220: begin

Line 217: ddx_return_obj amv_search_pvt.amv_return_obj_type;

213: ddp_content_array amv_search_pvt.amv_char_varray_type;
214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
215: ddp_category_id amv_search_pvt.amv_number_varray_type;
216: ddp_request_obj amv_search_pvt.amv_request_obj_type;
217: ddx_return_obj amv_search_pvt.amv_return_obj_type;
218: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
219: ddindx binary_integer; indx binary_integer;
220: begin
221:

Line 218: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;

214: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
215: ddp_category_id amv_search_pvt.amv_number_varray_type;
216: ddp_request_obj amv_search_pvt.amv_request_obj_type;
217: ddx_return_obj amv_search_pvt.amv_return_obj_type;
218: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
219: ddindx binary_integer; indx binary_integer;
220: begin
221:
222: -- copy data to the local IN or IN-OUT args, if any

Line 231: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);

227:
228:
229:
230:
231: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);
232:
233: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);
234:
235: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0

Line 233: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);

229:
230:
231: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);
232:
233: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);
234:
235: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0
236: , p10_a1
237: );

Line 235: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0

231: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);
232:
233: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);
234:
235: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0
236: , p10_a1
237: );
238:
239:

Line 242: amv_search_pvt_w.rosetta_table_copy_in_p1(ddp_category_id, p_category_id);

238:
239:
240:
241:
242: amv_search_pvt_w.rosetta_table_copy_in_p1(ddp_category_id, p_category_id);
243:
244:
245:
246: ddp_request_obj.records_requested := rosetta_g_miss_num_map(p17_a0);

Line 297: amv_search_pvt_w.rosetta_table_copy_out_p13(ddx_searchres_array, p19_a0

293: p18_a0 := rosetta_g_miss_num_map(ddx_return_obj.returned_record_count);
294: p18_a1 := rosetta_g_miss_num_map(ddx_return_obj.next_record_position);
295: p18_a2 := rosetta_g_miss_num_map(ddx_return_obj.total_record_count);
296:
297: amv_search_pvt_w.rosetta_table_copy_out_p13(ddx_searchres_array, p19_a0
298: , p19_a1
299: , p19_a2
300: , p19_a3
301: , p19_a4