[Home] [Help]
PACKAGE: APPS.CN_RULE_PVT_W
Source
1 package cn_rule_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwrrules.pls 120.2 2005/06/17 04:11 appldev $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy cn_rule_pvt.rule_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_2000
8 , a5 JTF_VARCHAR2_TABLE_2000
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 );
18 procedure rosetta_table_copy_out_p2(t cn_rule_pvt.rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19 , a1 out nocopy JTF_VARCHAR2_TABLE_100
20 , a2 out nocopy JTF_NUMBER_TABLE
21 , a3 out nocopy JTF_VARCHAR2_TABLE_100
22 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
23 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
24 , a6 out nocopy JTF_VARCHAR2_TABLE_100
25 , a7 out nocopy JTF_NUMBER_TABLE
26 , a8 out nocopy JTF_NUMBER_TABLE
27 , a9 out nocopy JTF_NUMBER_TABLE
28 , a10 out nocopy JTF_NUMBER_TABLE
29 , a11 out nocopy JTF_NUMBER_TABLE
30 , a12 out nocopy JTF_NUMBER_TABLE
31 , a13 out nocopy JTF_NUMBER_TABLE
32 );
33
34 procedure create_rule(p_api_version NUMBER
35 , p_init_msg_list VARCHAR2
36 , p_commit VARCHAR2
37 , p_validation_level NUMBER
38 , x_return_status out nocopy VARCHAR2
39 , x_msg_count out nocopy NUMBER
40 , x_msg_data out nocopy VARCHAR2
41 , x_loading_status out nocopy VARCHAR2
42 , p8_a0 NUMBER
43 , p8_a1 NUMBER
44 , p8_a2 VARCHAR2
45 , p8_a3 NUMBER
46 , p8_a4 NUMBER
47 , p8_a5 NUMBER
48 , p8_a6 NUMBER
49 , p8_a7 NUMBER
50 , p8_a8 NUMBER
51 , p8_a9 NUMBER
52 , x_rule_id out nocopy NUMBER
53 );
54 procedure update_rule(p_api_version NUMBER
55 , p_init_msg_list VARCHAR2
56 , p_commit VARCHAR2
57 , p_validation_level NUMBER
58 , x_return_status out nocopy VARCHAR2
59 , x_msg_count out nocopy NUMBER
60 , x_msg_data out nocopy VARCHAR2
61 , x_loading_status out nocopy VARCHAR2
62 , p8_a0 NUMBER
63 , p8_a1 NUMBER
64 , p8_a2 VARCHAR2
65 , p8_a3 NUMBER
66 , p8_a4 NUMBER
67 , p8_a5 NUMBER
68 , p8_a6 NUMBER
69 , p8_a7 NUMBER
70 , p8_a8 NUMBER
71 , p8_a9 NUMBER
72 , p9_a0 NUMBER
73 , p9_a1 NUMBER
74 , p9_a2 VARCHAR2
75 , p9_a3 NUMBER
76 , p9_a4 NUMBER
77 , p9_a5 NUMBER
78 , p9_a6 NUMBER
79 , p9_a7 NUMBER
80 , p9_a8 NUMBER
81 , p9_a9 NUMBER
82 );
83 procedure get_rules(p_api_version NUMBER
84 , p_init_msg_list VARCHAR2
85 , p_commit VARCHAR2
86 , p_validation_level NUMBER
87 , x_return_status out nocopy VARCHAR2
88 , x_msg_count out nocopy NUMBER
89 , x_msg_data out nocopy VARCHAR2
90 , p_ruleset_name VARCHAR2
91 , p_start_record NUMBER
92 , p_increment_count NUMBER
93 , p_order_by VARCHAR2
94 , p11_a0 out nocopy JTF_NUMBER_TABLE
95 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
96 , p11_a2 out nocopy JTF_NUMBER_TABLE
97 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
98 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_2000
99 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_2000
100 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
101 , p11_a7 out nocopy JTF_NUMBER_TABLE
102 , p11_a8 out nocopy JTF_NUMBER_TABLE
103 , p11_a9 out nocopy JTF_NUMBER_TABLE
104 , p11_a10 out nocopy JTF_NUMBER_TABLE
105 , p11_a11 out nocopy JTF_NUMBER_TABLE
106 , p11_a12 out nocopy JTF_NUMBER_TABLE
107 , p11_a13 out nocopy JTF_NUMBER_TABLE
108 , x_total_records out nocopy NUMBER
109 , x_status out nocopy VARCHAR2
110 , x_loading_status out nocopy VARCHAR2
111 , p_org_id NUMBER
112 );
113 end cn_rule_pvt_w;