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_USER_STATUSES_PVT_W

Source


1 package ams_user_statuses_pvt_w as
2   /* $Header: amswusts.pls 120.1 2005/09/30 06:55 mayjain noship $ */
3   procedure create_user_status(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_user_status_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  VARCHAR2 := fnd_api.g_miss_char
21     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
22     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a12  DATE := fnd_api.g_miss_date
24     , p7_a13  DATE := fnd_api.g_miss_date
25     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
26     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
27   );
28   procedure update_user_status(p_api_version  NUMBER
29     , p_init_msg_list  VARCHAR2
30     , p_commit  VARCHAR2
31     , p_validation_level  NUMBER
32     , x_return_status out nocopy  VARCHAR2
33     , x_msg_count out nocopy  NUMBER
34     , x_msg_data out nocopy  VARCHAR2
35     , p7_a0  NUMBER := 0-1962.0724
36     , p7_a1  DATE := fnd_api.g_miss_date
37     , p7_a2  NUMBER := 0-1962.0724
38     , p7_a3  DATE := fnd_api.g_miss_date
39     , p7_a4  NUMBER := 0-1962.0724
40     , p7_a5  NUMBER := 0-1962.0724
41     , p7_a6  NUMBER := 0-1962.0724
42     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
43     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
44     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
45     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
46     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
47     , p7_a12  DATE := fnd_api.g_miss_date
48     , p7_a13  DATE := fnd_api.g_miss_date
49     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
50     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
51   );
52   procedure validate_user_status(p_api_version  NUMBER
53     , p_init_msg_list  VARCHAR2
54     , p_commit  VARCHAR2
55     , p_validation_level  NUMBER
56     , x_return_status out nocopy  VARCHAR2
57     , x_msg_count out nocopy  NUMBER
58     , x_msg_data out nocopy  VARCHAR2
59     , p7_a0  NUMBER := 0-1962.0724
60     , p7_a1  DATE := fnd_api.g_miss_date
61     , p7_a2  NUMBER := 0-1962.0724
62     , p7_a3  DATE := fnd_api.g_miss_date
63     , p7_a4  NUMBER := 0-1962.0724
64     , p7_a5  NUMBER := 0-1962.0724
65     , p7_a6  NUMBER := 0-1962.0724
66     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
67     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
68     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
69     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
71     , p7_a12  DATE := fnd_api.g_miss_date
72     , p7_a13  DATE := fnd_api.g_miss_date
73     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
75   );
76   procedure check_user_status_items(p_validation_mode  VARCHAR2
77     , x_return_status out nocopy  VARCHAR2
78     , p0_a0  NUMBER := 0-1962.0724
79     , p0_a1  DATE := fnd_api.g_miss_date
80     , p0_a2  NUMBER := 0-1962.0724
81     , p0_a3  DATE := fnd_api.g_miss_date
82     , p0_a4  NUMBER := 0-1962.0724
83     , p0_a5  NUMBER := 0-1962.0724
84     , p0_a6  NUMBER := 0-1962.0724
85     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
86     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
87     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
88     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
89     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
90     , p0_a12  DATE := fnd_api.g_miss_date
91     , p0_a13  DATE := fnd_api.g_miss_date
92     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
93     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
94   );
95   procedure check_user_status_record(x_return_status out nocopy  VARCHAR2
96     , p0_a0  NUMBER := 0-1962.0724
97     , p0_a1  DATE := fnd_api.g_miss_date
98     , p0_a2  NUMBER := 0-1962.0724
99     , p0_a3  DATE := fnd_api.g_miss_date
100     , p0_a4  NUMBER := 0-1962.0724
101     , p0_a5  NUMBER := 0-1962.0724
102     , p0_a6  NUMBER := 0-1962.0724
103     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
104     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
105     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
106     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
107     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
108     , p0_a12  DATE := fnd_api.g_miss_date
109     , p0_a13  DATE := fnd_api.g_miss_date
110     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
111     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
112     , p1_a0  NUMBER := 0-1962.0724
113     , p1_a1  DATE := fnd_api.g_miss_date
114     , p1_a2  NUMBER := 0-1962.0724
115     , p1_a3  DATE := fnd_api.g_miss_date
116     , p1_a4  NUMBER := 0-1962.0724
117     , p1_a5  NUMBER := 0-1962.0724
118     , p1_a6  NUMBER := 0-1962.0724
119     , p1_a7  VARCHAR2 := fnd_api.g_miss_char
120     , p1_a8  VARCHAR2 := fnd_api.g_miss_char
121     , p1_a9  VARCHAR2 := fnd_api.g_miss_char
122     , p1_a10  VARCHAR2 := fnd_api.g_miss_char
123     , p1_a11  VARCHAR2 := fnd_api.g_miss_char
124     , p1_a12  DATE := fnd_api.g_miss_date
125     , p1_a13  DATE := fnd_api.g_miss_date
126     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
127     , p1_a15  VARCHAR2 := fnd_api.g_miss_char
128   );
129   procedure init_user_status_rec(p0_a0 out nocopy  NUMBER
130     , p0_a1 out nocopy  DATE
131     , p0_a2 out nocopy  NUMBER
132     , p0_a3 out nocopy  DATE
133     , p0_a4 out nocopy  NUMBER
134     , p0_a5 out nocopy  NUMBER
135     , p0_a6 out nocopy  NUMBER
136     , p0_a7 out nocopy  VARCHAR2
137     , p0_a8 out nocopy  VARCHAR2
138     , p0_a9 out nocopy  VARCHAR2
139     , p0_a10 out nocopy  VARCHAR2
140     , p0_a11 out nocopy  VARCHAR2
141     , p0_a12 out nocopy  DATE
142     , p0_a13 out nocopy  DATE
143     , p0_a14 out nocopy  VARCHAR2
144     , p0_a15 out nocopy  VARCHAR2
145   );
146   procedure complete_user_status_rec(p1_a0 out nocopy  NUMBER
147     , p1_a1 out nocopy  DATE
148     , p1_a2 out nocopy  NUMBER
149     , p1_a3 out nocopy  DATE
150     , p1_a4 out nocopy  NUMBER
151     , p1_a5 out nocopy  NUMBER
152     , p1_a6 out nocopy  NUMBER
153     , p1_a7 out nocopy  VARCHAR2
154     , p1_a8 out nocopy  VARCHAR2
155     , p1_a9 out nocopy  VARCHAR2
156     , p1_a10 out nocopy  VARCHAR2
157     , p1_a11 out nocopy  VARCHAR2
158     , p1_a12 out nocopy  DATE
159     , p1_a13 out nocopy  DATE
160     , p1_a14 out nocopy  VARCHAR2
161     , p1_a15 out nocopy  VARCHAR2
162     , p0_a0  NUMBER := 0-1962.0724
163     , p0_a1  DATE := fnd_api.g_miss_date
164     , p0_a2  NUMBER := 0-1962.0724
165     , p0_a3  DATE := fnd_api.g_miss_date
166     , p0_a4  NUMBER := 0-1962.0724
167     , p0_a5  NUMBER := 0-1962.0724
168     , p0_a6  NUMBER := 0-1962.0724
169     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
170     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
171     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
172     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
173     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
174     , p0_a12  DATE := fnd_api.g_miss_date
175     , p0_a13  DATE := fnd_api.g_miss_date
176     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
177     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
178   );
179 end ams_user_statuses_pvt_w;