DBA Data[Home] [Help]

APPS.AMV_CHANNEL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);

2: /* $Header: amvwchas.pls 120.2 2005/06/30 07:50 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_channel_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_channel_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE

Line 7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

3: procedure rosetta_table_copy_in_p0(t out nocopy amv_channel_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_channel_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100

Line 9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE

5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100
12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100

Line 10: , a1 JTF_NUMBER_TABLE

6: procedure rosetta_table_copy_in_p1(t out nocopy amv_channel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_channel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_channel_pvt.amv_channel_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100
12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE

Line 14: , a5 JTF_NUMBER_TABLE

10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_VARCHAR2_TABLE_100
12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_DATE_TABLE

Line 16: , a7 JTF_NUMBER_TABLE

12: , a3 JTF_VARCHAR2_TABLE_2000
13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_DATE_TABLE
19: , a10 JTF_DATE_TABLE
20: , a11 JTF_VARCHAR2_TABLE_100

Line 17: , a8 JTF_NUMBER_TABLE

13: , a4 JTF_VARCHAR2_TABLE_100
14: , a5 JTF_NUMBER_TABLE
15: , a6 JTF_VARCHAR2_TABLE_100
16: , a7 JTF_NUMBER_TABLE
17: , a8 JTF_NUMBER_TABLE
18: , a9 JTF_DATE_TABLE
19: , a10 JTF_DATE_TABLE
20: , a11 JTF_VARCHAR2_TABLE_100
21: , a12 JTF_VARCHAR2_TABLE_100

Line 30: , a21 JTF_NUMBER_TABLE

26: , a17 JTF_VARCHAR2_TABLE_100
27: , a18 JTF_VARCHAR2_TABLE_100
28: , a19 JTF_VARCHAR2_TABLE_100
29: , a20 JTF_VARCHAR2_TABLE_100
30: , a21 JTF_NUMBER_TABLE
31: , a22 JTF_VARCHAR2_TABLE_100
32: , a23 JTF_NUMBER_TABLE
33: , a24 JTF_DATE_TABLE
34: , a25 JTF_VARCHAR2_TABLE_100

Line 32: , a23 JTF_NUMBER_TABLE

28: , a19 JTF_VARCHAR2_TABLE_100
29: , a20 JTF_VARCHAR2_TABLE_100
30: , a21 JTF_NUMBER_TABLE
31: , a22 JTF_VARCHAR2_TABLE_100
32: , a23 JTF_NUMBER_TABLE
33: , a24 JTF_DATE_TABLE
34: , a25 JTF_VARCHAR2_TABLE_100
35: , a26 JTF_DATE_TABLE
36: , a27 JTF_VARCHAR2_TABLE_100

Line 53: procedure rosetta_table_copy_out_p5(t amv_channel_pvt.amv_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE

49: , a40 JTF_VARCHAR2_TABLE_200
50: , a41 JTF_VARCHAR2_TABLE_200
51: , a42 JTF_VARCHAR2_TABLE_200
52: );
53: procedure rosetta_table_copy_out_p5(t amv_channel_pvt.amv_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_100
56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 54: , a1 out nocopy JTF_NUMBER_TABLE

50: , a41 JTF_VARCHAR2_TABLE_200
51: , a42 JTF_VARCHAR2_TABLE_200
52: );
53: procedure rosetta_table_copy_out_p5(t amv_channel_pvt.amv_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_100
56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE

Line 58: , a5 out nocopy JTF_NUMBER_TABLE

54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_VARCHAR2_TABLE_100
56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: , a7 out nocopy JTF_NUMBER_TABLE
61: , a8 out nocopy JTF_NUMBER_TABLE
62: , a9 out nocopy JTF_DATE_TABLE

Line 60: , a7 out nocopy JTF_NUMBER_TABLE

56: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: , a7 out nocopy JTF_NUMBER_TABLE
61: , a8 out nocopy JTF_NUMBER_TABLE
62: , a9 out nocopy JTF_DATE_TABLE
63: , a10 out nocopy JTF_DATE_TABLE
64: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a8 out nocopy JTF_NUMBER_TABLE

57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: , a7 out nocopy JTF_NUMBER_TABLE
61: , a8 out nocopy JTF_NUMBER_TABLE
62: , a9 out nocopy JTF_DATE_TABLE
63: , a10 out nocopy JTF_DATE_TABLE
64: , a11 out nocopy JTF_VARCHAR2_TABLE_100
65: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a21 out nocopy JTF_NUMBER_TABLE

70: , a17 out nocopy JTF_VARCHAR2_TABLE_100
71: , a18 out nocopy JTF_VARCHAR2_TABLE_100
72: , a19 out nocopy JTF_VARCHAR2_TABLE_100
73: , a20 out nocopy JTF_VARCHAR2_TABLE_100
74: , a21 out nocopy JTF_NUMBER_TABLE
75: , a22 out nocopy JTF_VARCHAR2_TABLE_100
76: , a23 out nocopy JTF_NUMBER_TABLE
77: , a24 out nocopy JTF_DATE_TABLE
78: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , a23 out nocopy JTF_NUMBER_TABLE

72: , a19 out nocopy JTF_VARCHAR2_TABLE_100
73: , a20 out nocopy JTF_VARCHAR2_TABLE_100
74: , a21 out nocopy JTF_NUMBER_TABLE
75: , a22 out nocopy JTF_VARCHAR2_TABLE_100
76: , a23 out nocopy JTF_NUMBER_TABLE
77: , a24 out nocopy JTF_DATE_TABLE
78: , a25 out nocopy JTF_VARCHAR2_TABLE_100
79: , a26 out nocopy JTF_DATE_TABLE
80: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 481: , p_content_type_id_array JTF_NUMBER_TABLE

477: , p_check_login_user VARCHAR2
478: , p_channel_id NUMBER
479: , p_channel_name VARCHAR2
480: , p_category_id NUMBER
481: , p_content_type_id_array JTF_NUMBER_TABLE
482: );
483: procedure get_channelcontenttypes(p_api_version NUMBER
484: , p_init_msg_list VARCHAR2
485: , p_validation_level NUMBER

Line 493: , x_content_type_id_array out nocopy JTF_NUMBER_TABLE

489: , p_check_login_user VARCHAR2
490: , p_channel_id NUMBER
491: , p_channel_name VARCHAR2
492: , p_category_id NUMBER
493: , x_content_type_id_array out nocopy JTF_NUMBER_TABLE
494: );
495: procedure set_channelperspectives(p_api_version NUMBER
496: , p_init_msg_list VARCHAR2
497: , p_commit VARCHAR2

Line 506: , p_perspective_id_array JTF_NUMBER_TABLE

502: , p_check_login_user VARCHAR2
503: , p_channel_id NUMBER
504: , p_channel_name VARCHAR2
505: , p_category_id NUMBER
506: , p_perspective_id_array JTF_NUMBER_TABLE
507: );
508: procedure get_channelperspectives(p_api_version NUMBER
509: , p_init_msg_list VARCHAR2
510: , p_validation_level NUMBER

Line 518: , x_perspective_id_array out nocopy JTF_NUMBER_TABLE

514: , p_check_login_user VARCHAR2
515: , p_channel_id NUMBER
516: , p_channel_name VARCHAR2
517: , p_category_id NUMBER
518: , x_perspective_id_array out nocopy JTF_NUMBER_TABLE
519: );
520: procedure set_channelitemtypes(p_api_version NUMBER
521: , p_init_msg_list VARCHAR2
522: , p_commit VARCHAR2

Line 609: , x_document_id_array out nocopy JTF_NUMBER_TABLE

605: , p_item_status VARCHAR2
606: , p12_a0 out nocopy NUMBER
607: , p12_a1 out nocopy NUMBER
608: , p12_a2 out nocopy NUMBER
609: , x_document_id_array out nocopy JTF_NUMBER_TABLE
610: , p11_a0 NUMBER := 0-1962.0724
611: , p11_a1 NUMBER := 0-1962.0724
612: , p11_a2 VARCHAR2 := fnd_api.g_miss_char
613: );

Line 625: , p11_a0 out nocopy JTF_NUMBER_TABLE

621: , p_sort_by VARCHAR2
622: , p10_a0 out nocopy NUMBER
623: , p10_a1 out nocopy NUMBER
624: , p10_a2 out nocopy NUMBER
625: , p11_a0 out nocopy JTF_NUMBER_TABLE
626: , p11_a1 out nocopy JTF_NUMBER_TABLE
627: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 626: , p11_a1 out nocopy JTF_NUMBER_TABLE

622: , p10_a0 out nocopy NUMBER
623: , p10_a1 out nocopy NUMBER
624: , p10_a2 out nocopy NUMBER
625: , p11_a0 out nocopy JTF_NUMBER_TABLE
626: , p11_a1 out nocopy JTF_NUMBER_TABLE
627: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE

Line 630: , p11_a5 out nocopy JTF_NUMBER_TABLE

626: , p11_a1 out nocopy JTF_NUMBER_TABLE
627: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE
631: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a7 out nocopy JTF_NUMBER_TABLE
633: , p11_a8 out nocopy JTF_NUMBER_TABLE
634: , p11_a9 out nocopy JTF_DATE_TABLE

Line 632: , p11_a7 out nocopy JTF_NUMBER_TABLE

628: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE
631: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a7 out nocopy JTF_NUMBER_TABLE
633: , p11_a8 out nocopy JTF_NUMBER_TABLE
634: , p11_a9 out nocopy JTF_DATE_TABLE
635: , p11_a10 out nocopy JTF_DATE_TABLE
636: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 633: , p11_a8 out nocopy JTF_NUMBER_TABLE

629: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
630: , p11_a5 out nocopy JTF_NUMBER_TABLE
631: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
632: , p11_a7 out nocopy JTF_NUMBER_TABLE
633: , p11_a8 out nocopy JTF_NUMBER_TABLE
634: , p11_a9 out nocopy JTF_DATE_TABLE
635: , p11_a10 out nocopy JTF_DATE_TABLE
636: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
637: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 646: , p11_a21 out nocopy JTF_NUMBER_TABLE

642: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_100
643: , p11_a18 out nocopy JTF_VARCHAR2_TABLE_100
644: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
645: , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
646: , p11_a21 out nocopy JTF_NUMBER_TABLE
647: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
648: , p11_a23 out nocopy JTF_NUMBER_TABLE
649: , p11_a24 out nocopy JTF_DATE_TABLE
650: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 648: , p11_a23 out nocopy JTF_NUMBER_TABLE

644: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
645: , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
646: , p11_a21 out nocopy JTF_NUMBER_TABLE
647: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_100
648: , p11_a23 out nocopy JTF_NUMBER_TABLE
649: , p11_a24 out nocopy JTF_DATE_TABLE
650: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_100
651: , p11_a26 out nocopy JTF_DATE_TABLE
652: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_100