[Home] [Help]
PACKAGE: APPS.AMS_COMPETITOR_PRODUCT_PVT_W
Source
1 package ams_competitor_product_pvt_w as
2 /* $Header: amswcprs.pls 120.2 2005/08/04 08:22 appldev ship $ */
3 procedure create_comp_product(p_api_version_number 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 , x_competitor_product_id out nocopy NUMBER
11 , p7_a0 NUMBER := 0-1962.0724
12 , p7_a1 NUMBER := 0-1962.0724
13 , p7_a2 DATE := fnd_api.g_miss_date
14 , p7_a3 NUMBER := 0-1962.0724
15 , p7_a4 DATE := fnd_api.g_miss_date
16 , p7_a5 NUMBER := 0-1962.0724
17 , p7_a6 NUMBER := 0-1962.0724
18 , p7_a7 NUMBER := 0-1962.0724
19 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20 , p7_a9 NUMBER := 0-1962.0724
21 , p7_a10 NUMBER := 0-1962.0724
22 , p7_a11 NUMBER := 0-1962.0724
23 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
24 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
25 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
27 , p7_a16 DATE := fnd_api.g_miss_date
28 , p7_a17 DATE := fnd_api.g_miss_date
29 , p7_a18 NUMBER := 0-1962.0724
30 , p7_a19 NUMBER := 0-1962.0724
31 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
32 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
33 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
34 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
35 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
36 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
37 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
38 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
39 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
47 );
48 procedure update_comp_product(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 DATE := fnd_api.g_miss_date
59 , p7_a3 NUMBER := 0-1962.0724
60 , p7_a4 DATE := fnd_api.g_miss_date
61 , p7_a5 NUMBER := 0-1962.0724
62 , p7_a6 NUMBER := 0-1962.0724
63 , p7_a7 NUMBER := 0-1962.0724
64 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a9 NUMBER := 0-1962.0724
66 , p7_a10 NUMBER := 0-1962.0724
67 , p7_a11 NUMBER := 0-1962.0724
68 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
69 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
70 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
71 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
72 , p7_a16 DATE := fnd_api.g_miss_date
73 , p7_a17 DATE := fnd_api.g_miss_date
74 , p7_a18 NUMBER := 0-1962.0724
75 , p7_a19 NUMBER := 0-1962.0724
76 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
77 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
79 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
82 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
85 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
87 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
88 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
89 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
90 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
91 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
92 );
93 procedure validate_comp_prod(p_api_version_number NUMBER
94 , p_init_msg_list VARCHAR2
95 , p_validation_level NUMBER
96 , p_validation_mode VARCHAR2
97 , x_return_status out nocopy VARCHAR2
98 , x_msg_count out nocopy NUMBER
99 , x_msg_data out nocopy VARCHAR2
100 , p4_a0 NUMBER := 0-1962.0724
101 , p4_a1 NUMBER := 0-1962.0724
102 , p4_a2 DATE := fnd_api.g_miss_date
103 , p4_a3 NUMBER := 0-1962.0724
104 , p4_a4 DATE := fnd_api.g_miss_date
105 , p4_a5 NUMBER := 0-1962.0724
106 , p4_a6 NUMBER := 0-1962.0724
107 , p4_a7 NUMBER := 0-1962.0724
108 , p4_a8 VARCHAR2 := fnd_api.g_miss_char
109 , p4_a9 NUMBER := 0-1962.0724
110 , p4_a10 NUMBER := 0-1962.0724
111 , p4_a11 NUMBER := 0-1962.0724
112 , p4_a12 VARCHAR2 := fnd_api.g_miss_char
113 , p4_a13 VARCHAR2 := fnd_api.g_miss_char
114 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
115 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
116 , p4_a16 DATE := fnd_api.g_miss_date
117 , p4_a17 DATE := fnd_api.g_miss_date
118 , p4_a18 NUMBER := 0-1962.0724
119 , p4_a19 NUMBER := 0-1962.0724
120 , p4_a20 VARCHAR2 := fnd_api.g_miss_char
121 , p4_a21 VARCHAR2 := fnd_api.g_miss_char
122 , p4_a22 VARCHAR2 := fnd_api.g_miss_char
123 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
124 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
125 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
126 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
127 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
128 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
129 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
130 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
131 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
132 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
133 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
134 , p4_a34 VARCHAR2 := fnd_api.g_miss_char
135 , p4_a35 VARCHAR2 := fnd_api.g_miss_char
136 );
137 end ams_competitor_product_pvt_w;