DBA Data[Home] [Help]

PACKAGE: APPS.AHL_VWP_DEPT_SHIFTS_PUB_W

Source


1 package ahl_vwp_dept_shifts_pub_w AUTHID CURRENT_USER as
2   /* $Header: AHLWDSHS.pls 115.2 2002/11/22 23:16:21 ssurapan noship $ */
3   procedure create_vwp_dept_shifts(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , p_default  VARCHAR2
8     , p_module_type  VARCHAR2
9     , x_return_status out nocopy  VARCHAR2
10     , x_msg_count out nocopy  NUMBER
11     , x_msg_data out nocopy  VARCHAR2
12     , p9_a0 in out nocopy  NUMBER
13     , p9_a1 in out nocopy  NUMBER
14     , p9_a2 in out nocopy  VARCHAR2
15     , p9_a3 in out nocopy  NUMBER
16     , p9_a4 in out nocopy  DATE
17     , p9_a5 in out nocopy  NUMBER
18     , p9_a6 in out nocopy  DATE
19     , p9_a7 in out nocopy  NUMBER
20     , p9_a8 in out nocopy  NUMBER
21     , p9_a9 in out nocopy  NUMBER
22     , p9_a10 in out nocopy  VARCHAR2
23     , p9_a11 in out nocopy  VARCHAR2
24     , p9_a12 in out nocopy  VARCHAR2
25     , p9_a13 in out nocopy  NUMBER
26     , p9_a14 in out nocopy  NUMBER
27     , p9_a15 in out nocopy  NUMBER
28     , p9_a16 in out nocopy  VARCHAR2
29     , p9_a17 in out nocopy  VARCHAR2
30     , p9_a18 in out nocopy  VARCHAR2
31     , p9_a19 in out nocopy  VARCHAR2
32     , p9_a20 in out nocopy  VARCHAR2
33     , p9_a21 in out nocopy  VARCHAR2
34     , p9_a22 in out nocopy  VARCHAR2
35     , p9_a23 in out nocopy  VARCHAR2
36     , p9_a24 in out nocopy  VARCHAR2
37     , p9_a25 in out nocopy  VARCHAR2
38     , p9_a26 in out nocopy  VARCHAR2
39     , p9_a27 in out nocopy  VARCHAR2
40     , p9_a28 in out nocopy  VARCHAR2
41     , p9_a29 in out nocopy  VARCHAR2
42     , p9_a30 in out nocopy  VARCHAR2
43     , p9_a31 in out nocopy  VARCHAR2
44     , p9_a32 in out nocopy  VARCHAR2
45     , p9_a33 in out nocopy  VARCHAR2
46   );
47   procedure delete_vwp_dept_shifts(p_api_version  NUMBER
48     , p_init_msg_list  VARCHAR2
49     , p_commit  VARCHAR2
50     , p_validation_level  NUMBER
51     , p_default  VARCHAR2
52     , p_module_type  VARCHAR2
53     , x_return_status out nocopy  VARCHAR2
54     , x_msg_count out nocopy  NUMBER
55     , x_msg_data out nocopy  VARCHAR2
56     , p9_a0 in out nocopy  NUMBER
57     , p9_a1 in out nocopy  NUMBER
58     , p9_a2 in out nocopy  VARCHAR2
59     , p9_a3 in out nocopy  NUMBER
60     , p9_a4 in out nocopy  DATE
61     , p9_a5 in out nocopy  NUMBER
62     , p9_a6 in out nocopy  DATE
63     , p9_a7 in out nocopy  NUMBER
64     , p9_a8 in out nocopy  NUMBER
65     , p9_a9 in out nocopy  NUMBER
66     , p9_a10 in out nocopy  VARCHAR2
67     , p9_a11 in out nocopy  VARCHAR2
68     , p9_a12 in out nocopy  VARCHAR2
69     , p9_a13 in out nocopy  NUMBER
70     , p9_a14 in out nocopy  NUMBER
71     , p9_a15 in out nocopy  NUMBER
72     , p9_a16 in out nocopy  VARCHAR2
73     , p9_a17 in out nocopy  VARCHAR2
74     , p9_a18 in out nocopy  VARCHAR2
75     , p9_a19 in out nocopy  VARCHAR2
76     , p9_a20 in out nocopy  VARCHAR2
77     , p9_a21 in out nocopy  VARCHAR2
78     , p9_a22 in out nocopy  VARCHAR2
79     , p9_a23 in out nocopy  VARCHAR2
80     , p9_a24 in out nocopy  VARCHAR2
81     , p9_a25 in out nocopy  VARCHAR2
82     , p9_a26 in out nocopy  VARCHAR2
83     , p9_a27 in out nocopy  VARCHAR2
84     , p9_a28 in out nocopy  VARCHAR2
85     , p9_a29 in out nocopy  VARCHAR2
86     , p9_a30 in out nocopy  VARCHAR2
87     , p9_a31 in out nocopy  VARCHAR2
88     , p9_a32 in out nocopy  VARCHAR2
89     , p9_a33 in out nocopy  VARCHAR2
90   );
91 end ahl_vwp_dept_shifts_pub_w;