APPS.AMV_CATEGORY_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 227: , a2 JTF_VARCHAR2_TABLE_300

223: end rosetta_table_copy_out_p7;
224:
225: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
226: , a1 JTF_NUMBER_TABLE
227: , a2 JTF_VARCHAR2_TABLE_300
228: ) as
229: ddindx binary_integer; indx binary_integer;
230: begin
231: if a0 is not null and a0.count=0 then

Line 254: , a2 out nocopy JTF_VARCHAR2_TABLE_300

250: end if;
251: end rosetta_table_copy_in_p10;
252: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
253: , a1 out nocopy JTF_NUMBER_TABLE
254: , a2 out nocopy JTF_VARCHAR2_TABLE_300
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null then

Line 265: a2 := JTF_VARCHAR2_TABLE_300();

261: a2 := null;
262: elsif t.count = 0 then
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_NUMBER_TABLE();
265: a2 := JTF_VARCHAR2_TABLE_300();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_VARCHAR2_TABLE_300();

Line 269: a2 := JTF_VARCHAR2_TABLE_300();

265: a2 := JTF_VARCHAR2_TABLE_300();
266: else
267: a0 := JTF_NUMBER_TABLE();
268: a1 := JTF_NUMBER_TABLE();
269: a2 := JTF_VARCHAR2_TABLE_300();
270: if t.count > 0 then
271: a0.extend(t.count);
272: a1.extend(t.count);
273: a2.extend(t.count);

Line 460: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

456: , p_category_id NUMBER
457: , p_include_subcats VARCHAR2
458: , p9_a0 out nocopy JTF_NUMBER_TABLE
459: , p9_a1 out nocopy JTF_NUMBER_TABLE
460: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
461: )
462:
463: as
464: ddx_content_chan_array amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 518: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

514: , p_category_id NUMBER
515: , p_include_subcats VARCHAR2
516: , p9_a0 out nocopy JTF_NUMBER_TABLE
517: , p9_a1 out nocopy JTF_NUMBER_TABLE
518: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
519: )
520:
521: as
522: ddx_items_array amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 579: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300

575: , p11_a1 out nocopy NUMBER
576: , p11_a2 out nocopy NUMBER
577: , p12_a0 out nocopy JTF_NUMBER_TABLE
578: , p12_a1 out nocopy JTF_NUMBER_TABLE
579: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
580: , p9_a0 NUMBER := 0-1962.0724
581: , p9_a1 NUMBER := 0-1962.0724
582: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
583: , p10_a0 VARCHAR2 := fnd_api.g_miss_char

Line 661: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

657: , p_check_login_user VARCHAR2
658: , p_category_id NUMBER
659: , p8_a0 out nocopy JTF_NUMBER_TABLE
660: , p8_a1 out nocopy JTF_NUMBER_TABLE
661: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
662: )
663:
664: as
665: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 715: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

711: , p_check_login_user VARCHAR2
712: , p_category_id NUMBER
713: , p8_a0 out nocopy JTF_NUMBER_TABLE
714: , p8_a1 out nocopy JTF_NUMBER_TABLE
715: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
716: )
717:
718: as
719: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 770: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

766: , p_channel_id NUMBER
767: , x_channel_name out nocopy VARCHAR2
768: , p9_a0 out nocopy JTF_NUMBER_TABLE
769: , p9_a1 out nocopy JTF_NUMBER_TABLE
770: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
771: )
772:
773: as
774: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;