DBA Data[Home] [Help]

PACKAGE: APPS.AMS_ACT_LIST_PVT_W

Source


1 package ams_act_list_pvt_w as
2   /* $Header: amswalss.pls 120.1 2005/06/27 05:42:37 appldev ship $ */
3   procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_act_list_pvt.child_type, a0 JTF_VARCHAR2_TABLE_100);
4   procedure rosetta_table_copy_out_p1(t ams_act_list_pvt.child_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100);
5 
6   procedure rosetta_table_copy_in_p4(t OUT NOCOPY ams_act_list_pvt.act_list_tbl_type, a0 JTF_NUMBER_TABLE
7     , a1 JTF_DATE_TABLE
8     , a2 JTF_NUMBER_TABLE
9     , a3 JTF_DATE_TABLE
10     , a4 JTF_NUMBER_TABLE
11     , a5 JTF_NUMBER_TABLE
12     , a6 JTF_NUMBER_TABLE
13     , a7 JTF_NUMBER_TABLE
14     , a8 JTF_VARCHAR2_TABLE_100
15     , a9 JTF_NUMBER_TABLE
16     , a10 JTF_VARCHAR2_TABLE_100
17     , a11 JTF_VARCHAR2_TABLE_100
18     , a12 JTF_VARCHAR2_TABLE_100
19     , a13 JTF_NUMBER_TABLE
20     );
21   procedure rosetta_table_copy_out_p4(t ams_act_list_pvt.act_list_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
22     , a1 OUT NOCOPY JTF_DATE_TABLE
23     , a2 OUT NOCOPY JTF_NUMBER_TABLE
24     , a3 OUT NOCOPY JTF_DATE_TABLE
25     , a4 OUT NOCOPY JTF_NUMBER_TABLE
26     , a5 OUT NOCOPY JTF_NUMBER_TABLE
27     , a6 OUT NOCOPY JTF_NUMBER_TABLE
28     , a7 OUT NOCOPY JTF_NUMBER_TABLE
29     , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
30     , a9 OUT NOCOPY JTF_NUMBER_TABLE
31     , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
32     , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
33     , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
34     , a13 OUT NOCOPY JTF_NUMBER_TABLE
35     );
36 
37   procedure create_act_list(p_api_version_number  NUMBER
38     , p_init_msg_list  VARCHAR2
39     , p_commit  VARCHAR2
40     , p_validation_level  NUMBER
41     , x_return_status OUT NOCOPY  VARCHAR2
42     , x_msg_count OUT NOCOPY  NUMBER
43     , x_msg_data OUT NOCOPY  VARCHAR2
44     , x_act_list_header_id OUT NOCOPY  NUMBER
45     , p7_a0  NUMBER := 0-1962.0724
46     , p7_a1  DATE := fnd_api.g_miss_date
47     , p7_a2  NUMBER := 0-1962.0724
48     , p7_a3  DATE := fnd_api.g_miss_date
49     , p7_a4  NUMBER := 0-1962.0724
50     , p7_a5  NUMBER := 0-1962.0724
51     , p7_a6  NUMBER := 0-1962.0724
52     , p7_a7  NUMBER := 0-1962.0724
53     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
54     , p7_a9  NUMBER := 0-1962.0724
55     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
56     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
57     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
58     , p7_a13  NUMBER := 0-1962.0724
59   );
60   procedure update_act_list(p_api_version_number  NUMBER
61     , p_init_msg_list  VARCHAR2
62     , p_commit  VARCHAR2
63     , p_validation_level  NUMBER
64     , x_return_status OUT NOCOPY  VARCHAR2
65     , x_msg_count OUT NOCOPY  NUMBER
66     , x_msg_data OUT NOCOPY  VARCHAR2
67     , x_object_version_number OUT NOCOPY  NUMBER
68     , p7_a0  NUMBER := 0-1962.0724
69     , p7_a1  DATE := fnd_api.g_miss_date
70     , p7_a2  NUMBER := 0-1962.0724
71     , p7_a3  DATE := fnd_api.g_miss_date
72     , p7_a4  NUMBER := 0-1962.0724
73     , p7_a5  NUMBER := 0-1962.0724
74     , p7_a6  NUMBER := 0-1962.0724
75     , p7_a7  NUMBER := 0-1962.0724
76     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a9  NUMBER := 0-1962.0724
78     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
79     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a13  NUMBER := 0-1962.0724
82   );
83   procedure validate_act_list(p_api_version_number  NUMBER
84     , p_init_msg_list  VARCHAR2
85     , p_validation_level  NUMBER
86     , x_return_status OUT NOCOPY  VARCHAR2
87     , x_msg_count OUT NOCOPY  NUMBER
88     , x_msg_data OUT NOCOPY  VARCHAR2
89     , p3_a0  NUMBER := 0-1962.0724
90     , p3_a1  DATE := fnd_api.g_miss_date
91     , p3_a2  NUMBER := 0-1962.0724
92     , p3_a3  DATE := fnd_api.g_miss_date
93     , p3_a4  NUMBER := 0-1962.0724
94     , p3_a5  NUMBER := 0-1962.0724
95     , p3_a6  NUMBER := 0-1962.0724
96     , p3_a7  NUMBER := 0-1962.0724
97     , p3_a8  VARCHAR2 := fnd_api.g_miss_char
98     , p3_a9  NUMBER := 0-1962.0724
99     , p3_a10  VARCHAR2 := fnd_api.g_miss_char
100     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
101     , p3_a12  VARCHAR2 := fnd_api.g_miss_char
102     , p3_a13  NUMBER := 0-1962.0724
103   );
104   procedure check_act_list_items(p_validation_mode  VARCHAR2
105     , x_return_status OUT NOCOPY  VARCHAR2
106     , p0_a0  NUMBER := 0-1962.0724
107     , p0_a1  DATE := fnd_api.g_miss_date
108     , p0_a2  NUMBER := 0-1962.0724
109     , p0_a3  DATE := fnd_api.g_miss_date
110     , p0_a4  NUMBER := 0-1962.0724
111     , p0_a5  NUMBER := 0-1962.0724
112     , p0_a6  NUMBER := 0-1962.0724
113     , p0_a7  NUMBER := 0-1962.0724
114     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
115     , p0_a9  NUMBER := 0-1962.0724
116     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
117     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
118     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
119     , p0_a13  NUMBER := 0-1962.0724
120   );
121   procedure validate_act_list_rec(p_api_version_number  NUMBER
122     , p_init_msg_list  VARCHAR2
123     , x_return_status OUT NOCOPY  VARCHAR2
124     , x_msg_count OUT NOCOPY  NUMBER
125     , x_msg_data OUT NOCOPY  VARCHAR2
126     , p5_a0  NUMBER := 0-1962.0724
127     , p5_a1  DATE := fnd_api.g_miss_date
128     , p5_a2  NUMBER := 0-1962.0724
129     , p5_a3  DATE := fnd_api.g_miss_date
130     , p5_a4  NUMBER := 0-1962.0724
131     , p5_a5  NUMBER := 0-1962.0724
132     , p5_a6  NUMBER := 0-1962.0724
133     , p5_a7  NUMBER := 0-1962.0724
134     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
135     , p5_a9  NUMBER := 0-1962.0724
136     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
137     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
138     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
139     , p5_a13  NUMBER := 0-1962.0724
140   );
141   procedure init_act_list_rec(p0_a0 OUT NOCOPY  NUMBER
142     , p0_a1 OUT NOCOPY  DATE
143     , p0_a2 OUT NOCOPY  NUMBER
144     , p0_a3 OUT NOCOPY  DATE
145     , p0_a4 OUT NOCOPY  NUMBER
146     , p0_a5 OUT NOCOPY  NUMBER
147     , p0_a6 OUT NOCOPY  NUMBER
148     , p0_a7 OUT NOCOPY  NUMBER
149     , p0_a8 OUT NOCOPY  VARCHAR2
150     , p0_a9 OUT NOCOPY  NUMBER
151     , p0_a10 OUT NOCOPY  VARCHAR2
152     , p0_a11 OUT NOCOPY  VARCHAR2
153     , p0_a12 OUT NOCOPY  VARCHAR2
154     , p0_a13 OUT NOCOPY  NUMBER
155   );
156   procedure complete_act_list_rec(p1_a0 OUT NOCOPY  NUMBER
157     , p1_a1 OUT NOCOPY  DATE
158     , p1_a2 OUT NOCOPY  NUMBER
159     , p1_a3 OUT NOCOPY  DATE
160     , p1_a4 OUT NOCOPY  NUMBER
161     , p1_a5 OUT NOCOPY  NUMBER
162     , p1_a6 OUT NOCOPY  NUMBER
163     , p1_a7 OUT NOCOPY  NUMBER
164     , p1_a8 OUT NOCOPY  VARCHAR2
165     , p1_a9 OUT NOCOPY  NUMBER
166     , p1_a10 OUT NOCOPY  VARCHAR2
167     , p1_a11 OUT NOCOPY  VARCHAR2
168     , p1_a12 OUT NOCOPY  VARCHAR2
169     , p1_a13 OUT NOCOPY  NUMBER
170     , p0_a0  NUMBER := 0-1962.0724
171     , p0_a1  DATE := fnd_api.g_miss_date
172     , p0_a2  NUMBER := 0-1962.0724
173     , p0_a3  DATE := fnd_api.g_miss_date
174     , p0_a4  NUMBER := 0-1962.0724
175     , p0_a5  NUMBER := 0-1962.0724
176     , p0_a6  NUMBER := 0-1962.0724
177     , p0_a7  NUMBER := 0-1962.0724
178     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
179     , p0_a9  NUMBER := 0-1962.0724
180     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
181     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
182     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
183     , p0_a13  NUMBER := 0-1962.0724
184   );
185 end ams_act_list_pvt_w;