DBA Data[Home] [Help]

PACKAGE: APPS.AHL_APPR_DEPT_SHIFTS_PUB_W

Source


1 package ahl_appr_dept_shifts_pub_w as
2   /* $Header: AHLWDSHS.pls 120.1 2007/12/24 22:40:41 rbhavsar ship $ */
3   procedure create_appr_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  NUMBER
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     , p9_a34 in out nocopy  VARCHAR2
47     , p9_a35 in out nocopy  VARCHAR2
48     , p9_a36 in out nocopy  VARCHAR2
49   );
50   procedure delete_appr_dept_shifts(p_api_version  NUMBER
51     , p_init_msg_list  VARCHAR2
52     , p_commit  VARCHAR2
53     , p_validation_level  NUMBER
54     , p_default  VARCHAR2
55     , p_module_type  VARCHAR2
56     , x_return_status out nocopy  VARCHAR2
57     , x_msg_count out nocopy  NUMBER
58     , x_msg_data out nocopy  VARCHAR2
59     , p9_a0 in out nocopy  NUMBER
60     , p9_a1 in out nocopy  NUMBER
61     , p9_a2 in out nocopy  VARCHAR2
62     , p9_a3 in out nocopy  NUMBER
63     , p9_a4 in out nocopy  DATE
64     , p9_a5 in out nocopy  NUMBER
65     , p9_a6 in out nocopy  DATE
66     , p9_a7 in out nocopy  NUMBER
67     , p9_a8 in out nocopy  NUMBER
68     , p9_a9 in out nocopy  NUMBER
69     , p9_a10 in out nocopy  VARCHAR2
70     , p9_a11 in out nocopy  VARCHAR2
71     , p9_a12 in out nocopy  VARCHAR2
72     , p9_a13 in out nocopy  NUMBER
73     , p9_a14 in out nocopy  NUMBER
74     , p9_a15 in out nocopy  NUMBER
75     , p9_a16 in out nocopy  VARCHAR2
76     , p9_a17 in out nocopy  VARCHAR2
77     , p9_a18 in out nocopy  NUMBER
78     , p9_a19 in out nocopy  VARCHAR2
79     , p9_a20 in out nocopy  VARCHAR2
80     , p9_a21 in out nocopy  VARCHAR2
81     , p9_a22 in out nocopy  VARCHAR2
82     , p9_a23 in out nocopy  VARCHAR2
83     , p9_a24 in out nocopy  VARCHAR2
84     , p9_a25 in out nocopy  VARCHAR2
85     , p9_a26 in out nocopy  VARCHAR2
86     , p9_a27 in out nocopy  VARCHAR2
87     , p9_a28 in out nocopy  VARCHAR2
88     , p9_a29 in out nocopy  VARCHAR2
89     , p9_a30 in out nocopy  VARCHAR2
90     , p9_a31 in out nocopy  VARCHAR2
91     , p9_a32 in out nocopy  VARCHAR2
92     , p9_a33 in out nocopy  VARCHAR2
93     , p9_a34 in out nocopy  VARCHAR2
94     , p9_a35 in out nocopy  VARCHAR2
95     , p9_a36 in out nocopy  VARCHAR2
96   );
97 end ahl_appr_dept_shifts_pub_w;