[Home] [Help]
PACKAGE: APPS.OZF_VOL_OFFR_PVT_W
Source
1 package ozf_vol_offr_pvt_w as
2 /* $Header: ozfwvos.pls 120.0 2005/06/01 01:50:16 appldev noship $ */
3 procedure rosetta_table_copy_in_p2(t OUT NOCOPY ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p2(t ozf_vol_offr_pvt.vol_offr_tier_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
16 , a1 OUT NOCOPY JTF_NUMBER_TABLE
17 , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
18 , a3 OUT NOCOPY JTF_NUMBER_TABLE
19 , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
20 , a5 OUT NOCOPY JTF_NUMBER_TABLE
21 , a6 OUT NOCOPY JTF_NUMBER_TABLE
22 , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
23 , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24 , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
25 , a10 OUT NOCOPY JTF_NUMBER_TABLE
26 );
27
28 procedure create_vol_offr(p_api_version_number 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 , x_volume_offer_tiers_id OUT NOCOPY NUMBER
36 , p7_a0 NUMBER := 0-1962.0724
37 , p7_a1 NUMBER := 0-1962.0724
38 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
39 , p7_a3 NUMBER := 0-1962.0724
40 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a5 NUMBER := 0-1962.0724
42 , p7_a6 NUMBER := 0-1962.0724
43 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a10 NUMBER := 0-1962.0724
47 );
48 procedure update_vol_offr(p_api_version_number NUMBER
49 , p_init_msg_list VARCHAR2
50 , p_commit VARCHAR2
51 , p_validation_level NUMBER
52 , x_return_status OUT NOCOPY VARCHAR2
53 , x_msg_count OUT NOCOPY NUMBER
54 , x_msg_data OUT NOCOPY VARCHAR2
55 , x_object_version_number OUT NOCOPY NUMBER
56 , p7_a0 NUMBER := 0-1962.0724
57 , p7_a1 NUMBER := 0-1962.0724
58 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a3 NUMBER := 0-1962.0724
60 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a5 NUMBER := 0-1962.0724
62 , p7_a6 NUMBER := 0-1962.0724
63 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
64 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
66 , p7_a10 NUMBER := 0-1962.0724
67 );
68 procedure validate_vol_offr(p_api_version_number NUMBER
69 , p_init_msg_list VARCHAR2
70 , p_validation_level NUMBER
71 , p_validation_mode VARCHAR2
72 , x_return_status OUT NOCOPY VARCHAR2
73 , x_msg_count OUT NOCOPY NUMBER
74 , x_msg_data OUT NOCOPY VARCHAR2
75 , p3_a0 NUMBER := 0-1962.0724
76 , p3_a1 NUMBER := 0-1962.0724
77 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
78 , p3_a3 NUMBER := 0-1962.0724
79 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
80 , p3_a5 NUMBER := 0-1962.0724
81 , p3_a6 NUMBER := 0-1962.0724
82 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
83 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
84 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
85 , p3_a10 NUMBER := 0-1962.0724
86 );
87 procedure check_vol_offr_tier_items(p_validation_mode VARCHAR2
88 , x_return_status OUT NOCOPY VARCHAR2
89 , p0_a0 NUMBER := 0-1962.0724
90 , p0_a1 NUMBER := 0-1962.0724
91 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
92 , p0_a3 NUMBER := 0-1962.0724
93 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
94 , p0_a5 NUMBER := 0-1962.0724
95 , p0_a6 NUMBER := 0-1962.0724
96 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
97 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
98 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
99 , p0_a10 NUMBER := 0-1962.0724
100 );
101 procedure validate_vol_offr_tier_rec(p_api_version_number NUMBER
102 , p_init_msg_list VARCHAR2
103 , x_return_status OUT NOCOPY VARCHAR2
104 , x_msg_count OUT NOCOPY NUMBER
105 , x_msg_data OUT NOCOPY VARCHAR2
106 , p5_a0 NUMBER := 0-1962.0724
107 , p5_a1 NUMBER := 0-1962.0724
108 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a3 NUMBER := 0-1962.0724
110 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
111 , p5_a5 NUMBER := 0-1962.0724
112 , p5_a6 NUMBER := 0-1962.0724
113 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
114 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a10 NUMBER := 0-1962.0724
117 );
118 end ozf_vol_offr_pvt_w;