[Home] [Help]
PACKAGE: APPS.PV_SELATTVAL_PUB_W
Source
1 package pv_selattval_pub_w AUTHID CURRENT_USER as
2 /* $Header: pvrwsavs.pls 115.4 2003/09/24 22:10:21 pklin ship $ */
3 procedure create_selattval(p_api_version_number NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p_identity_resource_id NUMBER
8 , x_attr_value_id out nocopy NUMBER
9 , x_return_status out nocopy VARCHAR2
10 , x_msg_count out nocopy NUMBER
11 , x_msg_data out nocopy VARCHAR2
12 , p5_a0 NUMBER := 0-1962.0724
13 , p5_a1 DATE := fnd_api.g_miss_date
14 , p5_a2 NUMBER := 0-1962.0724
15 , p5_a3 DATE := fnd_api.g_miss_date
16 , p5_a4 NUMBER := 0-1962.0724
17 , p5_a5 NUMBER := 0-1962.0724
18 , p5_a6 NUMBER := 0-1962.0724
19 , p5_a7 NUMBER := 0-1962.0724
20 , p5_a8 NUMBER := 0-1962.0724
21 , p5_a9 NUMBER := 0-1962.0724
22 , p5_a10 DATE := fnd_api.g_miss_date
23 , p5_a11 NUMBER := 0-1962.0724
24 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
25 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
26 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
27 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
28 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
29 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
30 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
31 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
32 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
33 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
34 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
35 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
36 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
37 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
38 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
39 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
40 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
41 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
42 , p5_a30 NUMBER := 0-1962.0724
43 );
44 procedure update_selattval(p_api_version_number NUMBER
45 , p_init_msg_list VARCHAR2
46 , p_commit VARCHAR2
47 , p_validation_level NUMBER
48 , p_identity_resource_id NUMBER
49 , x_return_status out nocopy VARCHAR2
50 , x_msg_count out nocopy NUMBER
51 , x_msg_data out nocopy VARCHAR2
52 , p5_a0 NUMBER := 0-1962.0724
53 , p5_a1 DATE := fnd_api.g_miss_date
54 , p5_a2 NUMBER := 0-1962.0724
55 , p5_a3 DATE := fnd_api.g_miss_date
56 , p5_a4 NUMBER := 0-1962.0724
57 , p5_a5 NUMBER := 0-1962.0724
58 , p5_a6 NUMBER := 0-1962.0724
59 , p5_a7 NUMBER := 0-1962.0724
60 , p5_a8 NUMBER := 0-1962.0724
61 , p5_a9 NUMBER := 0-1962.0724
62 , p5_a10 DATE := fnd_api.g_miss_date
63 , p5_a11 NUMBER := 0-1962.0724
64 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
65 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
66 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
67 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
68 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
69 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
70 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
71 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
72 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
73 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
74 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
75 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
76 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
77 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
78 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
79 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
80 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
81 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
82 , p5_a30 NUMBER := 0-1962.0724
83 );
84 procedure delete_selattval(p_api_version_number NUMBER
85 , p_init_msg_list VARCHAR2
86 , p_commit VARCHAR2
87 , p_validation_level NUMBER
88 , p_identity_resource_id NUMBER
89 , x_return_status out nocopy VARCHAR2
90 , x_msg_count out nocopy NUMBER
91 , x_msg_data out nocopy VARCHAR2
92 , p5_a0 NUMBER := 0-1962.0724
93 , p5_a1 DATE := fnd_api.g_miss_date
94 , p5_a2 NUMBER := 0-1962.0724
95 , p5_a3 DATE := fnd_api.g_miss_date
96 , p5_a4 NUMBER := 0-1962.0724
97 , p5_a5 NUMBER := 0-1962.0724
98 , p5_a6 NUMBER := 0-1962.0724
99 , p5_a7 NUMBER := 0-1962.0724
100 , p5_a8 NUMBER := 0-1962.0724
101 , p5_a9 NUMBER := 0-1962.0724
102 , p5_a10 DATE := fnd_api.g_miss_date
103 , p5_a11 NUMBER := 0-1962.0724
104 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
105 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
106 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
107 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
108 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
110 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
111 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
112 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
113 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
114 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
117 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
119 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a30 NUMBER := 0-1962.0724
123 );
124 end pv_selattval_pub_w;