eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AMS_CT_RULE_PVT_W

Source


1 package ams_ct_rule_pvt_w as
2   /* $Header: amswctrs.pls 120.2 2006/05/30 11:11:33 prageorg noship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ams_ct_rule_pvt.ct_rule_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_DATE_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_DATE_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_2000
13     , a10 JTF_VARCHAR2_TABLE_2000
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_VARCHAR2_TABLE_2000
19     , a16 JTF_VARCHAR2_TABLE_2000
20     , a17 JTF_VARCHAR2_TABLE_100
21     );
22   procedure rosetta_table_copy_out_p3(t ams_ct_rule_pvt.ct_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23     , a1 out nocopy JTF_NUMBER_TABLE
24     , a2 out nocopy JTF_DATE_TABLE
25     , a3 out nocopy JTF_NUMBER_TABLE
26     , a4 out nocopy JTF_DATE_TABLE
27     , a5 out nocopy JTF_NUMBER_TABLE
28     , a6 out nocopy JTF_NUMBER_TABLE
29     , a7 out nocopy JTF_VARCHAR2_TABLE_100
30     , a8 out nocopy JTF_NUMBER_TABLE
31     , a9 out nocopy JTF_VARCHAR2_TABLE_2000
32     , a10 out nocopy JTF_VARCHAR2_TABLE_2000
33     , a11 out nocopy JTF_NUMBER_TABLE
34     , a12 out nocopy JTF_VARCHAR2_TABLE_100
35     , a13 out nocopy JTF_VARCHAR2_TABLE_100
36     , a14 out nocopy JTF_VARCHAR2_TABLE_100
37     , a15 out nocopy JTF_VARCHAR2_TABLE_2000
38     , a16 out nocopy JTF_VARCHAR2_TABLE_2000
39     , a17 out nocopy JTF_VARCHAR2_TABLE_100
40     );
41 
42   procedure create_ct_rule(p_api_version_number  NUMBER
43     , p_init_msg_list  VARCHAR2
44     , p_commit  VARCHAR2
45     , p_validation_level  NUMBER
46     , x_return_status out nocopy  VARCHAR2
47     , x_msg_count out nocopy  NUMBER
48     , x_msg_data out nocopy  VARCHAR2
49     , x_content_rule_id out nocopy  NUMBER
50     , p7_a0  NUMBER := 0-1962.0724
51     , p7_a1  NUMBER := 0-1962.0724
52     , p7_a2  DATE := fnd_api.g_miss_date
53     , p7_a3  NUMBER := 0-1962.0724
54     , p7_a4  DATE := fnd_api.g_miss_date
55     , p7_a5  NUMBER := 0-1962.0724
56     , p7_a6  NUMBER := 0-1962.0724
57     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
58     , p7_a8  NUMBER := 0-1962.0724
59     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
60     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
61     , p7_a11  NUMBER := 0-1962.0724
62     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
63     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
64     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
65     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
66     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
67     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
68   );
69   procedure update_ct_rule(p_api_version_number  NUMBER
70     , p_init_msg_list  VARCHAR2
71     , p_commit  VARCHAR2
72     , p_validation_level  NUMBER
73     , x_return_status out nocopy  VARCHAR2
74     , x_msg_count out nocopy  NUMBER
75     , x_msg_data out nocopy  VARCHAR2
76     , x_object_version_number out nocopy  NUMBER
77     , p7_a0  NUMBER := 0-1962.0724
78     , p7_a1  NUMBER := 0-1962.0724
79     , p7_a2  DATE := fnd_api.g_miss_date
80     , p7_a3  NUMBER := 0-1962.0724
81     , p7_a4  DATE := fnd_api.g_miss_date
82     , p7_a5  NUMBER := 0-1962.0724
83     , p7_a6  NUMBER := 0-1962.0724
84     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a8  NUMBER := 0-1962.0724
86     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
87     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
88     , p7_a11  NUMBER := 0-1962.0724
89     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
90     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
91     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
92     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
95   );
96   procedure validate_ct_rule(p_api_version_number  NUMBER
97     , p_init_msg_list  VARCHAR2
98     , p_validation_level  NUMBER
99     , p_validation_mode  VARCHAR2
100     , x_return_status out nocopy  VARCHAR2
101     , x_msg_count out nocopy  NUMBER
102     , x_msg_data out nocopy  VARCHAR2
103     , p3_a0  NUMBER := 0-1962.0724
104     , p3_a1  NUMBER := 0-1962.0724
105     , p3_a2  DATE := fnd_api.g_miss_date
106     , p3_a3  NUMBER := 0-1962.0724
107     , p3_a4  DATE := fnd_api.g_miss_date
108     , p3_a5  NUMBER := 0-1962.0724
109     , p3_a6  NUMBER := 0-1962.0724
110     , p3_a7  VARCHAR2 := fnd_api.g_miss_char
111     , p3_a8  NUMBER := 0-1962.0724
112     , p3_a9  VARCHAR2 := fnd_api.g_miss_char
113     , p3_a10  VARCHAR2 := fnd_api.g_miss_char
114     , p3_a11  NUMBER := 0-1962.0724
115     , p3_a12  VARCHAR2 := fnd_api.g_miss_char
116     , p3_a13  VARCHAR2 := fnd_api.g_miss_char
117     , p3_a14  VARCHAR2 := fnd_api.g_miss_char
118     , p3_a15  VARCHAR2 := fnd_api.g_miss_char
119     , p3_a16  VARCHAR2 := fnd_api.g_miss_char
120     , p3_a17  VARCHAR2 := fnd_api.g_miss_char
121   );
122   procedure check_ct_rule_items(p_validation_mode  VARCHAR2
123     , x_return_status out nocopy  VARCHAR2
124     , p0_a0  NUMBER := 0-1962.0724
125     , p0_a1  NUMBER := 0-1962.0724
126     , p0_a2  DATE := fnd_api.g_miss_date
127     , p0_a3  NUMBER := 0-1962.0724
128     , p0_a4  DATE := fnd_api.g_miss_date
129     , p0_a5  NUMBER := 0-1962.0724
130     , p0_a6  NUMBER := 0-1962.0724
131     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
132     , p0_a8  NUMBER := 0-1962.0724
133     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
134     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
135     , p0_a11  NUMBER := 0-1962.0724
136     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
137     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
138     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
139     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
140     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
141     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
142   );
143   procedure validate_ct_rule_rec(p_api_version_number  NUMBER
144     , p_init_msg_list  VARCHAR2
145     , x_return_status out nocopy  VARCHAR2
146     , x_msg_count out nocopy  NUMBER
147     , x_msg_data out nocopy  VARCHAR2
148     , p5_a0  NUMBER := 0-1962.0724
149     , p5_a1  NUMBER := 0-1962.0724
150     , p5_a2  DATE := fnd_api.g_miss_date
151     , p5_a3  NUMBER := 0-1962.0724
152     , p5_a4  DATE := fnd_api.g_miss_date
153     , p5_a5  NUMBER := 0-1962.0724
154     , p5_a6  NUMBER := 0-1962.0724
155     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
156     , p5_a8  NUMBER := 0-1962.0724
157     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
158     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
159     , p5_a11  NUMBER := 0-1962.0724
160     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
161     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
163     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
164     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
165     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
166   );
167 end ams_ct_rule_pvt_w;