DBA Data[Home] [Help]

APPS.AMV_CATEGORY_GRP_W dependencies on JTF_VARCHAR2_TABLE_300

Line 188: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

184: , p_category_id NUMBER
185: , p_include_subcats VARCHAR2
186: , p9_a0 out nocopy JTF_NUMBER_TABLE
187: , p9_a1 out nocopy JTF_NUMBER_TABLE
188: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
189: )
190:
191: as
192: ddx_content_chan_array amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 245: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

241: , p_check_login_user VARCHAR2
242: , p_category_id NUMBER
243: , p8_a0 out nocopy JTF_NUMBER_TABLE
244: , p8_a1 out nocopy JTF_NUMBER_TABLE
245: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
246: )
247:
248: as
249: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 299: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

295: , p_check_login_user VARCHAR2
296: , p_category_id NUMBER
297: , p8_a0 out nocopy JTF_NUMBER_TABLE
298: , p8_a1 out nocopy JTF_NUMBER_TABLE
299: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
300: )
301:
302: as
303: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 354: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

350: , p_channel_id NUMBER
351: , x_channel_name out nocopy VARCHAR2
352: , p9_a0 out nocopy JTF_NUMBER_TABLE
353: , p9_a1 out nocopy JTF_NUMBER_TABLE
354: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
355: )
356:
357: as
358: ddx_category_hierarchy amv_category_pvt.amv_cat_hierarchy_varray_type;

Line 415: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300

411: , p11_a1 out nocopy NUMBER
412: , p11_a2 out nocopy NUMBER
413: , p12_a0 out nocopy JTF_NUMBER_TABLE
414: , p12_a1 out nocopy JTF_NUMBER_TABLE
415: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
416: , p9_a0 NUMBER := 0-1962.0724
417: , p9_a1 NUMBER := 0-1962.0724
418: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
419: , p10_a0 VARCHAR2 := fnd_api.g_miss_char