[Home] [Help]
PACKAGE: APPS.CN_QUOTA_CATEGORIES_PUB_W
Source
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
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
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 );
25
26 procedure create_quota_category(p_api_version NUMBER
27 , p_init_msg_list VARCHAR2
28 , p_commit VARCHAR2
29 , p_validation_level NUMBER
30 , p4_a0 NUMBER
31 , p4_a1 VARCHAR2
32 , p4_a2 VARCHAR2
33 , p4_a3 VARCHAR2
34 , p4_a4 VARCHAR2
35 , p4_a5 VARCHAR2
36 , p4_a6 VARCHAR2
37 , p4_a7 NUMBER
38 , p4_a8 VARCHAR2
39 , p4_a9 NUMBER
40 , x_return_status out nocopy VARCHAR2
41 , x_msg_count out nocopy NUMBER
42 , x_msg_data out nocopy VARCHAR2
43 , x_quota_category_id out nocopy NUMBER
44 );
45 procedure update_quota_category(p_api_version NUMBER
46 , p_init_msg_list VARCHAR2
47 , p_commit VARCHAR2
48 , p_validation_level NUMBER
49 , p4_a0 NUMBER
50 , p4_a1 VARCHAR2
51 , p4_a2 VARCHAR2
52 , p4_a3 VARCHAR2
53 , p4_a4 VARCHAR2
54 , p4_a5 VARCHAR2
55 , p4_a6 VARCHAR2
56 , p4_a7 NUMBER
57 , p4_a8 VARCHAR2
58 , p4_a9 NUMBER
59 , x_return_status out nocopy VARCHAR2
60 , x_msg_count out nocopy NUMBER
61 , x_msg_data out nocopy VARCHAR2
62 );
63 procedure get_quota_category_details(p_api_version NUMBER
64 , p_init_msg_list VARCHAR2
65 , p_validation_level NUMBER
66 , x_return_status out nocopy VARCHAR2
67 , x_msg_count out nocopy NUMBER
68 , x_msg_data out nocopy VARCHAR2
69 , p_start_record NUMBER
70 , p_increment_count NUMBER
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
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;