APPS.CN_USER_ACCESS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: cnwurass.pls 115.5 2002/11/25 22:32:57 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_user_access_pvt.user_access_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_user_access_pvt.user_access_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200

Line 29: , a3 out nocopy JTF_VARCHAR2_TABLE_100

25: );
26: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_VARCHAR2_TABLE_100
32: , a6 out nocopy JTF_VARCHAR2_TABLE_200
33: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 30: , a4 out nocopy JTF_VARCHAR2_TABLE_100

26: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_VARCHAR2_TABLE_100
32: , a6 out nocopy JTF_VARCHAR2_TABLE_200
33: , a7 out nocopy JTF_VARCHAR2_TABLE_200
34: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 31: , a5 out nocopy JTF_VARCHAR2_TABLE_100

27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_NUMBER_TABLE
29: , a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_VARCHAR2_TABLE_100
32: , a6 out nocopy JTF_VARCHAR2_TABLE_200
33: , a7 out nocopy JTF_VARCHAR2_TABLE_200
34: , a8 out nocopy JTF_VARCHAR2_TABLE_200
35: , a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 52: , a2 JTF_VARCHAR2_TABLE_100

48: );
49:
50: procedure rosetta_table_copy_in_p3(t out nocopy cn_user_access_pvt.user_access_sum_tbl_type, a0 JTF_NUMBER_TABLE
51: , a1 JTF_VARCHAR2_TABLE_300
52: , a2 JTF_VARCHAR2_TABLE_100
53: );
54: procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_300
56: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: , a2 out nocopy JTF_VARCHAR2_TABLE_100

52: , a2 JTF_VARCHAR2_TABLE_100
53: );
54: procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_300
56: , a2 out nocopy JTF_VARCHAR2_TABLE_100
57: );
58:
59: procedure create_user_access(p_api_version NUMBER
60: , p_init_msg_list VARCHAR2

Line 125: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

121: , p_range_high NUMBER
122: , x_total_rows out nocopy NUMBER
123: , p3_a0 out nocopy JTF_NUMBER_TABLE
124: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_300
125: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: );
127: procedure get_access_details(p_user_id NUMBER
128: , p1_a0 out nocopy JTF_NUMBER_TABLE
129: , p1_a1 out nocopy JTF_NUMBER_TABLE

Line 131: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100

127: procedure get_access_details(p_user_id NUMBER
128: , p1_a0 out nocopy JTF_NUMBER_TABLE
129: , p1_a1 out nocopy JTF_NUMBER_TABLE
130: , p1_a2 out nocopy JTF_NUMBER_TABLE
131: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
134: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_200
135: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 132: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

128: , p1_a0 out nocopy JTF_NUMBER_TABLE
129: , p1_a1 out nocopy JTF_NUMBER_TABLE
130: , p1_a2 out nocopy JTF_NUMBER_TABLE
131: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
134: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_200
135: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
136: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 133: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

129: , p1_a1 out nocopy JTF_NUMBER_TABLE
130: , p1_a2 out nocopy JTF_NUMBER_TABLE
131: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
132: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
134: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_200
135: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
136: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
137: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200