[Home] [Help]
PACKAGE: APPS.CN_SCA_CRRULEATTR_PVT_W
Source
1 package cn_sca_crruleattr_pvt_w as
2 /* $Header: cnwscrrs.pls 120.2 2005/09/14 03:43 vensrini noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_sca_crruleattr_pvt.credit_rule_attr_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_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_300
13 , a10 JTF_VARCHAR2_TABLE_300
14 , a11 JTF_VARCHAR2_TABLE_300
15 , a12 JTF_VARCHAR2_TABLE_300
16 , a13 JTF_VARCHAR2_TABLE_300
17 , a14 JTF_VARCHAR2_TABLE_300
18 , a15 JTF_VARCHAR2_TABLE_300
19 , a16 JTF_VARCHAR2_TABLE_300
20 , a17 JTF_VARCHAR2_TABLE_300
21 , a18 JTF_VARCHAR2_TABLE_300
22 , a19 JTF_VARCHAR2_TABLE_300
23 , a20 JTF_VARCHAR2_TABLE_300
24 , a21 JTF_VARCHAR2_TABLE_300
25 , a22 JTF_VARCHAR2_TABLE_300
26 , a23 JTF_VARCHAR2_TABLE_300
27 , a24 JTF_NUMBER_TABLE
28 );
29 procedure rosetta_table_copy_out_p1(t cn_sca_crruleattr_pvt.credit_rule_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30 , a1 out nocopy JTF_VARCHAR2_TABLE_100
31 , a2 out nocopy JTF_VARCHAR2_TABLE_100
32 , a3 out nocopy JTF_VARCHAR2_TABLE_100
33 , a4 out nocopy JTF_NUMBER_TABLE
34 , a5 out nocopy JTF_VARCHAR2_TABLE_100
35 , a6 out nocopy JTF_VARCHAR2_TABLE_100
36 , a7 out nocopy JTF_VARCHAR2_TABLE_100
37 , a8 out nocopy JTF_VARCHAR2_TABLE_100
38 , a9 out nocopy JTF_VARCHAR2_TABLE_300
39 , a10 out nocopy JTF_VARCHAR2_TABLE_300
40 , a11 out nocopy JTF_VARCHAR2_TABLE_300
41 , a12 out nocopy JTF_VARCHAR2_TABLE_300
42 , a13 out nocopy JTF_VARCHAR2_TABLE_300
43 , a14 out nocopy JTF_VARCHAR2_TABLE_300
44 , a15 out nocopy JTF_VARCHAR2_TABLE_300
45 , a16 out nocopy JTF_VARCHAR2_TABLE_300
46 , a17 out nocopy JTF_VARCHAR2_TABLE_300
47 , a18 out nocopy JTF_VARCHAR2_TABLE_300
48 , a19 out nocopy JTF_VARCHAR2_TABLE_300
49 , a20 out nocopy JTF_VARCHAR2_TABLE_300
50 , a21 out nocopy JTF_VARCHAR2_TABLE_300
51 , a22 out nocopy JTF_VARCHAR2_TABLE_300
52 , a23 out nocopy JTF_VARCHAR2_TABLE_300
53 , a24 out nocopy JTF_NUMBER_TABLE
54 );
55
56 procedure create_credit_ruleattr(p_api_version NUMBER
57 , p_init_msg_list VARCHAR2
58 , p_commit VARCHAR2
59 , p_valdiation_level VARCHAR2
60 , p_org_id NUMBER
61 , p5_a0 NUMBER
62 , p5_a1 VARCHAR2
63 , p5_a2 VARCHAR2
64 , p5_a3 VARCHAR2
65 , p5_a4 NUMBER
66 , p5_a5 VARCHAR2
67 , p5_a6 VARCHAR2
68 , p5_a7 VARCHAR2
69 , p5_a8 VARCHAR2
70 , p5_a9 VARCHAR2
71 , p5_a10 VARCHAR2
72 , p5_a11 VARCHAR2
73 , p5_a12 VARCHAR2
74 , p5_a13 VARCHAR2
75 , p5_a14 VARCHAR2
76 , p5_a15 VARCHAR2
77 , p5_a16 VARCHAR2
78 , p5_a17 VARCHAR2
79 , p5_a18 VARCHAR2
80 , p5_a19 VARCHAR2
81 , p5_a20 VARCHAR2
82 , p5_a21 VARCHAR2
83 , p5_a22 VARCHAR2
84 , p5_a23 VARCHAR2
85 , p5_a24 NUMBER
86 , x_return_status out nocopy VARCHAR2
87 , x_msg_count out nocopy NUMBER
88 , x_msg_data out nocopy VARCHAR2
89 );
90 procedure update_credit_ruleattr(p_api_version NUMBER
91 , p_init_msg_list VARCHAR2
92 , p_commit VARCHAR2
93 , p_valdiation_level VARCHAR2
94 , p_org_id NUMBER
95 , p5_a0 NUMBER
96 , p5_a1 VARCHAR2
97 , p5_a2 VARCHAR2
98 , p5_a3 VARCHAR2
99 , p5_a4 NUMBER
100 , p5_a5 VARCHAR2
101 , p5_a6 VARCHAR2
102 , p5_a7 VARCHAR2
103 , p5_a8 VARCHAR2
104 , p5_a9 VARCHAR2
105 , p5_a10 VARCHAR2
106 , p5_a11 VARCHAR2
107 , p5_a12 VARCHAR2
108 , p5_a13 VARCHAR2
109 , p5_a14 VARCHAR2
110 , p5_a15 VARCHAR2
111 , p5_a16 VARCHAR2
112 , p5_a17 VARCHAR2
113 , p5_a18 VARCHAR2
114 , p5_a19 VARCHAR2
115 , p5_a20 VARCHAR2
116 , p5_a21 VARCHAR2
117 , p5_a22 VARCHAR2
118 , p5_a23 VARCHAR2
119 , p5_a24 NUMBER
120 , x_return_status out nocopy VARCHAR2
121 , x_msg_count out nocopy NUMBER
122 , x_msg_data out nocopy VARCHAR2
123 );
124 end cn_sca_crruleattr_pvt_w;