[Home] [Help]
PACKAGE: APPS.OZF_ACT_OFFERS_PVT_W
Source
1 package ozf_act_offers_pvt_w as
2 /* $Header: ozfwoffs.pls 120.0 2005/06/01 03:04:05 appldev 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 := 0-1962.0724
11 , p7_a1 DATE := fnd_api.g_miss_date
12 , p7_a2 NUMBER := 0-1962.0724
13 , p7_a3 DATE := fnd_api.g_miss_date
14 , p7_a4 NUMBER := 0-1962.0724
15 , p7_a5 NUMBER := 0-1962.0724
16 , p7_a6 NUMBER := 0-1962.0724
17 , p7_a7 NUMBER := 0-1962.0724
18 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
21 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
22 , p7_a12 NUMBER := 0-1962.0724
23 , p7_a13 NUMBER := 0-1962.0724
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 := 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 NUMBER := 0-1962.0724
41 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a12 NUMBER := 0-1962.0724
46 , p7_a13 NUMBER := 0-1962.0724
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 := 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 NUMBER := 0-1962.0724
62 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
63 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
64 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
65 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
66 , p6_a12 NUMBER := 0-1962.0724
67 , p6_a13 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
79 , p2_a8 VARCHAR2 := fnd_api.g_miss_char
80 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
81 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
82 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
83 , p2_a12 NUMBER := 0-1962.0724
84 , p2_a13 NUMBER := 0-1962.0724
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_act_offers_pvt_w;