[Home] [Help]
PACKAGE: APPS.OZF_OA_ACT_OFFERS_PVT_W
Source
1 package ozf_oa_act_offers_pvt_w AUTHID CURRENT_USER as
2 /* $Header: ozfaoffs.pls 115.0 2003/10/23 04:22:45 musman noship $ */
3 procedure create_act_offer(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 , p7_a0 NUMBER
11 , p7_a1 DATE
12 , p7_a2 NUMBER
13 , p7_a3 DATE
14 , p7_a4 NUMBER
15 , p7_a5 NUMBER
16 , p7_a6 NUMBER
17 , p7_a7 NUMBER
18 , p7_a8 VARCHAR2
19 , p7_a9 VARCHAR2
20 , p7_a10 VARCHAR2
21 , p7_a11 VARCHAR2
22 , p7_a12 NUMBER
23 , p7_a13 NUMBER
24 , x_act_offer_id out nocopy NUMBER
25 );
26 procedure update_act_offer(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
34 , p7_a1 DATE
35 , p7_a2 NUMBER
36 , p7_a3 DATE
37 , p7_a4 NUMBER
38 , p7_a5 NUMBER
39 , p7_a6 NUMBER
40 , p7_a7 NUMBER
41 , p7_a8 VARCHAR2
42 , p7_a9 VARCHAR2
43 , p7_a10 VARCHAR2
44 , p7_a11 VARCHAR2
45 , p7_a12 NUMBER
46 , p7_a13 NUMBER
47 );
48 procedure validate_act_offer(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
55 , p6_a1 DATE
56 , p6_a2 NUMBER
57 , p6_a3 DATE
58 , p6_a4 NUMBER
59 , p6_a5 NUMBER
60 , p6_a6 NUMBER
61 , p6_a7 NUMBER
62 , p6_a8 VARCHAR2
63 , p6_a9 VARCHAR2
64 , p6_a10 VARCHAR2
65 , p6_a11 VARCHAR2
66 , p6_a12 NUMBER
67 , p6_a13 NUMBER
68 );
69 procedure check_items(p_validation_mode VARCHAR2
70 , x_return_status out nocopy VARCHAR2
71 , p2_a0 NUMBER
72 , p2_a1 DATE
73 , p2_a2 NUMBER
74 , p2_a3 DATE
75 , p2_a4 NUMBER
76 , p2_a5 NUMBER
77 , p2_a6 NUMBER
78 , p2_a7 NUMBER
79 , p2_a8 VARCHAR2
80 , p2_a9 VARCHAR2
81 , p2_a10 VARCHAR2
82 , p2_a11 VARCHAR2
83 , p2_a12 NUMBER
84 , p2_a13 NUMBER
85 );
86 procedure check_record(p0_a0 NUMBER
87 , p0_a1 DATE
88 , p0_a2 NUMBER
89 , p0_a3 DATE
90 , p0_a4 NUMBER
91 , p0_a5 NUMBER
92 , p0_a6 NUMBER
93 , p0_a7 NUMBER
94 , p0_a8 VARCHAR2
95 , p0_a9 VARCHAR2
96 , p0_a10 VARCHAR2
97 , p0_a11 VARCHAR2
98 , p0_a12 NUMBER
99 , p0_a13 NUMBER
100 , p1_a0 NUMBER
101 , p1_a1 DATE
102 , p1_a2 NUMBER
103 , p1_a3 DATE
104 , p1_a4 NUMBER
105 , p1_a5 NUMBER
106 , p1_a6 NUMBER
107 , p1_a7 NUMBER
108 , p1_a8 VARCHAR2
109 , p1_a9 VARCHAR2
110 , p1_a10 VARCHAR2
111 , p1_a11 VARCHAR2
112 , p1_a12 NUMBER
113 , p1_a13 NUMBER
114 , x_return_status out nocopy VARCHAR2
115 );
116 procedure complete_rec(p0_a0 NUMBER
117 , p0_a1 DATE
118 , p0_a2 NUMBER
119 , p0_a3 DATE
120 , p0_a4 NUMBER
121 , p0_a5 NUMBER
122 , p0_a6 NUMBER
123 , p0_a7 NUMBER
124 , p0_a8 VARCHAR2
125 , p0_a9 VARCHAR2
126 , p0_a10 VARCHAR2
127 , p0_a11 VARCHAR2
128 , p0_a12 NUMBER
129 , p0_a13 NUMBER
130 , p1_a0 out nocopy NUMBER
131 , p1_a1 out nocopy DATE
132 , p1_a2 out nocopy NUMBER
133 , p1_a3 out nocopy DATE
134 , p1_a4 out nocopy NUMBER
135 , p1_a5 out nocopy NUMBER
136 , p1_a6 out nocopy NUMBER
137 , p1_a7 out nocopy NUMBER
138 , p1_a8 out nocopy VARCHAR2
139 , p1_a9 out nocopy VARCHAR2
140 , p1_a10 out nocopy VARCHAR2
141 , p1_a11 out nocopy VARCHAR2
142 , p1_a12 out nocopy NUMBER
143 , p1_a13 out nocopy NUMBER
144 );
145 procedure init_rec(p0_a0 out nocopy NUMBER
146 , p0_a1 out nocopy DATE
147 , p0_a2 out nocopy NUMBER
148 , p0_a3 out nocopy DATE
149 , p0_a4 out nocopy NUMBER
150 , p0_a5 out nocopy NUMBER
151 , p0_a6 out nocopy NUMBER
152 , p0_a7 out nocopy NUMBER
153 , p0_a8 out nocopy VARCHAR2
154 , p0_a9 out nocopy VARCHAR2
155 , p0_a10 out nocopy VARCHAR2
156 , p0_a11 out nocopy VARCHAR2
157 , p0_a12 out nocopy NUMBER
158 , p0_a13 out nocopy NUMBER
159 );
160 end ozf_oa_act_offers_pvt_w;