DBA Data[Home] [Help]

PACKAGE: APPS.AMS_LIST_WORD_FIELDS_PVT_W

Source


1 package ams_list_word_fields_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswwdfs.pls 115.5 2002/11/22 08:58:00 jieli ship $ */
3   procedure create_list_word_field(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , x_return_status OUT NOCOPY  VARCHAR2
8     , x_msg_count OUT NOCOPY  NUMBER
9     , x_msg_data OUT NOCOPY  VARCHAR2
10     , x_wrd_fld_id OUT NOCOPY  NUMBER
11     , p7_a0  NUMBER := 0-1962.0724
12     , p7_a1  DATE := fnd_api.g_miss_date
13     , p7_a2  NUMBER := 0-1962.0724
14     , p7_a3  DATE := fnd_api.g_miss_date
15     , p7_a4  NUMBER := 0-1962.0724
16     , p7_a5  NUMBER := 0-1962.0724
17     , p7_a6  NUMBER := 0-1962.0724
18     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
19     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
20     , p7_a9  NUMBER := 0-1962.0724
21     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
22     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
24     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
25   );
26   procedure update_list_word_field(p_api_version  NUMBER
27     , p_init_msg_list  VARCHAR2
28     , p_commit  VARCHAR2
29     , p_validation_level  NUMBER
30     , x_return_status OUT NOCOPY  VARCHAR2
31     , x_msg_count OUT NOCOPY  NUMBER
32     , x_msg_data OUT NOCOPY  VARCHAR2
33     , p7_a0  NUMBER := 0-1962.0724
34     , p7_a1  DATE := fnd_api.g_miss_date
35     , p7_a2  NUMBER := 0-1962.0724
36     , p7_a3  DATE := fnd_api.g_miss_date
37     , p7_a4  NUMBER := 0-1962.0724
38     , p7_a5  NUMBER := 0-1962.0724
39     , p7_a6  NUMBER := 0-1962.0724
40     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
41     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
42     , p7_a9  NUMBER := 0-1962.0724
43     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
44     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
45     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
46     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
47   );
48   procedure validate_list_word_field(p_api_version  NUMBER
49     , p_init_msg_list  VARCHAR2
50     , p_validation_level  NUMBER
51     , x_return_status OUT NOCOPY  VARCHAR2
52     , x_msg_count OUT NOCOPY  NUMBER
53     , x_msg_data OUT NOCOPY  VARCHAR2
54     , p6_a0  NUMBER := 0-1962.0724
55     , p6_a1  DATE := fnd_api.g_miss_date
56     , p6_a2  NUMBER := 0-1962.0724
57     , p6_a3  DATE := fnd_api.g_miss_date
58     , p6_a4  NUMBER := 0-1962.0724
59     , p6_a5  NUMBER := 0-1962.0724
60     , p6_a6  NUMBER := 0-1962.0724
61     , p6_a7  VARCHAR2 := fnd_api.g_miss_char
62     , p6_a8  VARCHAR2 := fnd_api.g_miss_char
63     , p6_a9  NUMBER := 0-1962.0724
64     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
65     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
66     , p6_a12  VARCHAR2 := fnd_api.g_miss_char
67     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
68   );
69   procedure check_items(p_validation_mode  VARCHAR2
70     , x_return_status OUT NOCOPY  VARCHAR2
71     , p2_a0  NUMBER := 0-1962.0724
72     , p2_a1  DATE := fnd_api.g_miss_date
73     , p2_a2  NUMBER := 0-1962.0724
74     , p2_a3  DATE := fnd_api.g_miss_date
75     , p2_a4  NUMBER := 0-1962.0724
76     , p2_a5  NUMBER := 0-1962.0724
77     , p2_a6  NUMBER := 0-1962.0724
78     , p2_a7  VARCHAR2 := fnd_api.g_miss_char
79     , p2_a8  VARCHAR2 := fnd_api.g_miss_char
80     , p2_a9  NUMBER := 0-1962.0724
81     , p2_a10  VARCHAR2 := fnd_api.g_miss_char
82     , p2_a11  VARCHAR2 := fnd_api.g_miss_char
83     , p2_a12  VARCHAR2 := fnd_api.g_miss_char
84     , p2_a13  VARCHAR2 := fnd_api.g_miss_char
85   );
86   procedure check_req_items(p_validation_mode  VARCHAR2
87     , x_return_status OUT NOCOPY  VARCHAR2
88     , p1_a0  NUMBER := 0-1962.0724
89     , p1_a1  DATE := fnd_api.g_miss_date
90     , p1_a2  NUMBER := 0-1962.0724
91     , p1_a3  DATE := fnd_api.g_miss_date
92     , p1_a4  NUMBER := 0-1962.0724
93     , p1_a5  NUMBER := 0-1962.0724
94     , p1_a6  NUMBER := 0-1962.0724
95     , p1_a7  VARCHAR2 := fnd_api.g_miss_char
96     , p1_a8  VARCHAR2 := fnd_api.g_miss_char
97     , p1_a9  NUMBER := 0-1962.0724
98     , p1_a10  VARCHAR2 := fnd_api.g_miss_char
99     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
100     , p1_a12  VARCHAR2 := fnd_api.g_miss_char
101     , p1_a13  VARCHAR2 := fnd_api.g_miss_char
102   );
103   procedure check_fk_items(x_return_status OUT NOCOPY  VARCHAR2
104     , p0_a0  NUMBER := 0-1962.0724
105     , p0_a1  DATE := fnd_api.g_miss_date
106     , p0_a2  NUMBER := 0-1962.0724
107     , p0_a3  DATE := fnd_api.g_miss_date
108     , p0_a4  NUMBER := 0-1962.0724
109     , p0_a5  NUMBER := 0-1962.0724
110     , p0_a6  NUMBER := 0-1962.0724
111     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
112     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
113     , p0_a9  NUMBER := 0-1962.0724
114     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
115     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
116     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
117     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
118   );
119   procedure check_uk_items(p_validation_mode  VARCHAR2
120     , x_return_status OUT NOCOPY  VARCHAR2
121     , p1_a0  NUMBER := 0-1962.0724
122     , p1_a1  DATE := fnd_api.g_miss_date
123     , p1_a2  NUMBER := 0-1962.0724
124     , p1_a3  DATE := fnd_api.g_miss_date
125     , p1_a4  NUMBER := 0-1962.0724
126     , p1_a5  NUMBER := 0-1962.0724
127     , p1_a6  NUMBER := 0-1962.0724
128     , p1_a7  VARCHAR2 := fnd_api.g_miss_char
129     , p1_a8  VARCHAR2 := fnd_api.g_miss_char
130     , p1_a9  NUMBER := 0-1962.0724
131     , p1_a10  VARCHAR2 := fnd_api.g_miss_char
132     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
133     , p1_a12  VARCHAR2 := fnd_api.g_miss_char
134     , p1_a13  VARCHAR2 := fnd_api.g_miss_char
135   );
136   procedure complete_rec(p1_a0 OUT NOCOPY  NUMBER
137     , p1_a1 OUT NOCOPY  DATE
138     , p1_a2 OUT NOCOPY  NUMBER
139     , p1_a3 OUT NOCOPY  DATE
140     , p1_a4 OUT NOCOPY  NUMBER
141     , p1_a5 OUT NOCOPY  NUMBER
142     , p1_a6 OUT NOCOPY  NUMBER
143     , p1_a7 OUT NOCOPY  VARCHAR2
144     , p1_a8 OUT NOCOPY  VARCHAR2
145     , p1_a9 OUT NOCOPY  NUMBER
146     , p1_a10 OUT NOCOPY  VARCHAR2
147     , p1_a11 OUT NOCOPY  VARCHAR2
148     , p1_a12 OUT NOCOPY  VARCHAR2
149     , p1_a13 OUT NOCOPY  VARCHAR2
150     , p0_a0  NUMBER := 0-1962.0724
151     , p0_a1  DATE := fnd_api.g_miss_date
152     , p0_a2  NUMBER := 0-1962.0724
153     , p0_a3  DATE := fnd_api.g_miss_date
154     , p0_a4  NUMBER := 0-1962.0724
155     , p0_a5  NUMBER := 0-1962.0724
156     , p0_a6  NUMBER := 0-1962.0724
157     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
158     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
159     , p0_a9  NUMBER := 0-1962.0724
160     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
161     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
162     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
163     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
164   );
165   procedure init_rec(p0_a0 OUT NOCOPY  NUMBER
166     , p0_a1 OUT NOCOPY  DATE
167     , p0_a2 OUT NOCOPY  NUMBER
168     , p0_a3 OUT NOCOPY  DATE
169     , p0_a4 OUT NOCOPY  NUMBER
170     , p0_a5 OUT NOCOPY  NUMBER
171     , p0_a6 OUT NOCOPY  NUMBER
172     , p0_a7 OUT NOCOPY  VARCHAR2
173     , p0_a8 OUT NOCOPY  VARCHAR2
174     , p0_a9 OUT NOCOPY  NUMBER
175     , p0_a10 OUT NOCOPY  VARCHAR2
176     , p0_a11 OUT NOCOPY  VARCHAR2
177     , p0_a12 OUT NOCOPY  VARCHAR2
178     , p0_a13 OUT NOCOPY  VARCHAR2
179   );
180 end ams_list_word_fields_pvt_w;