DBA Data[Home] [Help]

APPS.CN_USER_ACCESS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_user_access_pvt.user_access_tbl_type, a0 JTF_NUMBER_TABLE

1: package cn_user_access_pvt_w AUTHID CURRENT_USER as
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

Line 4: , a1 JTF_NUMBER_TABLE

1: package cn_user_access_pvt_w AUTHID CURRENT_USER as
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

Line 5: , a2 JTF_NUMBER_TABLE

1: package cn_user_access_pvt_w AUTHID CURRENT_USER as
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

Line 24: , a21 JTF_NUMBER_TABLE

20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_NUMBER_TABLE
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

Line 26: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_NUMBER_TABLE
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

Line 27: , a1 out nocopy JTF_NUMBER_TABLE

23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_NUMBER_TABLE
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

Line 28: , a2 out nocopy JTF_NUMBER_TABLE

24: , a21 JTF_NUMBER_TABLE
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

Line 47: , a21 out nocopy JTF_NUMBER_TABLE

43: , a17 out nocopy JTF_VARCHAR2_TABLE_200
44: , a18 out nocopy JTF_VARCHAR2_TABLE_200
45: , a19 out nocopy JTF_VARCHAR2_TABLE_200
46: , a20 out nocopy JTF_VARCHAR2_TABLE_200
47: , a21 out nocopy JTF_NUMBER_TABLE
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

Line 50: procedure rosetta_table_copy_in_p3(t out nocopy cn_user_access_pvt.user_access_sum_tbl_type, a0 JTF_NUMBER_TABLE

46: , a20 out nocopy JTF_VARCHAR2_TABLE_200
47: , a21 out nocopy JTF_NUMBER_TABLE
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

Line 54: procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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
57: );
58:

Line 123: , p3_a0 out nocopy JTF_NUMBER_TABLE

119: );
120: procedure get_accesses(p_range_low NUMBER
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

Line 128: , p1_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
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

Line 129: , p1_a1 out nocopy JTF_NUMBER_TABLE

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
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

Line 130: , p1_a2 out nocopy JTF_NUMBER_TABLE

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
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

Line 149: , p1_a21 out nocopy JTF_NUMBER_TABLE

145: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
146: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
147: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
148: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
149: , p1_a21 out nocopy JTF_NUMBER_TABLE
150: );
151: end cn_user_access_pvt_w;