DBA Data[Home] [Help]

APPS.CN_QUOTA_CATEGORIES_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package cn_quota_categories_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwqcats.pls 115.7 2002/11/25 22:26:26 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package cn_quota_categories_pub_w AUTHID CURRENT_USER as
2: /* $Header: cnwqcats.pls 115.7 2002/11/25 22:26:26 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: cnwqcats.pls 115.7 2002/11/25 22:26:26 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

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

Line 8: , a5 JTF_VARCHAR2_TABLE_100

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

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: );

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a1 out nocopy JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 16: , a2 out nocopy JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 17: , a3 out nocopy JTF_VARCHAR2_TABLE_100

13: );
14: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_VARCHAR2_TABLE_100
21: , a7 out nocopy JTF_NUMBER_TABLE

Line 18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

14: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_VARCHAR2_TABLE_100
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a5 out nocopy JTF_VARCHAR2_TABLE_100

15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_VARCHAR2_TABLE_100
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_NUMBER_TABLE

Line 20: , a6 out nocopy JTF_VARCHAR2_TABLE_100

16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_VARCHAR2_TABLE_100
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );

Line 22: , a8 out nocopy JTF_VARCHAR2_TABLE_100

18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_VARCHAR2_TABLE_100
20: , a6 out nocopy JTF_VARCHAR2_TABLE_100
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure create_quota_category(p_api_version NUMBER

Line 75: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

71: , p_search_name VARCHAR2
72: , p_search_type VARCHAR2
73: , p_search_unit VARCHAR2
74: , p11_a0 out nocopy JTF_NUMBER_TABLE
75: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100

72: , p_search_type VARCHAR2
73: , p_search_unit VARCHAR2
74: , p11_a0 out nocopy JTF_NUMBER_TABLE
75: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 77: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

73: , p_search_unit VARCHAR2
74: , p11_a0 out nocopy JTF_NUMBER_TABLE
75: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
81: , p11_a7 out nocopy JTF_NUMBER_TABLE

Line 78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

74: , p11_a0 out nocopy JTF_NUMBER_TABLE
75: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
81: , p11_a7 out nocopy JTF_NUMBER_TABLE
82: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

75: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
81: , p11_a7 out nocopy JTF_NUMBER_TABLE
82: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
83: , p11_a9 out nocopy JTF_NUMBER_TABLE

Line 80: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

76: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
81: , p11_a7 out nocopy JTF_NUMBER_TABLE
82: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
83: , p11_a9 out nocopy JTF_NUMBER_TABLE
84: , x_total_records out nocopy NUMBER

Line 82: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100

78: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
81: , p11_a7 out nocopy JTF_NUMBER_TABLE
82: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
83: , p11_a9 out nocopy JTF_NUMBER_TABLE
84: , x_total_records out nocopy NUMBER
85: );
86: end cn_quota_categories_pub_w;