[Home] [Help]
PACKAGE: APPS.PV_SELCRIT_PUB_W
Source
1 package pv_selcrit_pub_w AUTHID CURRENT_USER as
2 /* $Header: pvrwescs.pls 120.0 2005/05/27 15:35:19 appldev noship $ */
3 procedure create_selcrit(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_selection_criteria_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 NUMBER := 0-1962.0724
25 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
26 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
27 , p5_a15 NUMBER := 0-1962.0724
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 VARCHAR2 := fnd_api.g_miss_char
43 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
44 );
45 procedure update_selcrit(p_api_version_number NUMBER
46 , p_init_msg_list VARCHAR2
47 , p_commit VARCHAR2
48 , p_validation_level NUMBER
49 , p_identity_resource_id NUMBER
50 , x_return_status out nocopy VARCHAR2
51 , x_msg_count out nocopy NUMBER
52 , x_msg_data out nocopy VARCHAR2
53 , p5_a0 NUMBER := 0-1962.0724
54 , p5_a1 DATE := fnd_api.g_miss_date
55 , p5_a2 NUMBER := 0-1962.0724
56 , p5_a3 DATE := fnd_api.g_miss_date
57 , p5_a4 NUMBER := 0-1962.0724
58 , p5_a5 NUMBER := 0-1962.0724
59 , p5_a6 NUMBER := 0-1962.0724
60 , p5_a7 NUMBER := 0-1962.0724
61 , p5_a8 NUMBER := 0-1962.0724
62 , p5_a9 NUMBER := 0-1962.0724
63 , p5_a10 DATE := fnd_api.g_miss_date
64 , p5_a11 NUMBER := 0-1962.0724
65 , p5_a12 NUMBER := 0-1962.0724
66 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
67 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
68 , p5_a15 NUMBER := 0-1962.0724
69 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
70 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
71 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
72 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
73 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
74 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
75 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
76 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
77 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
78 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
79 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
80 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
81 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
82 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
83 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
84 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
85 );
86 procedure delete_selcrit(p_api_version_number NUMBER
87 , p_init_msg_list VARCHAR2
88 , p_commit VARCHAR2
89 , p_validation_level NUMBER
90 , p_identity_resource_id NUMBER
91 , x_return_status out nocopy VARCHAR2
92 , x_msg_count out nocopy NUMBER
93 , x_msg_data out nocopy VARCHAR2
94 , p5_a0 NUMBER := 0-1962.0724
95 , p5_a1 DATE := fnd_api.g_miss_date
96 , p5_a2 NUMBER := 0-1962.0724
97 , p5_a3 DATE := fnd_api.g_miss_date
98 , p5_a4 NUMBER := 0-1962.0724
99 , p5_a5 NUMBER := 0-1962.0724
100 , p5_a6 NUMBER := 0-1962.0724
101 , p5_a7 NUMBER := 0-1962.0724
102 , p5_a8 NUMBER := 0-1962.0724
103 , p5_a9 NUMBER := 0-1962.0724
104 , p5_a10 DATE := fnd_api.g_miss_date
105 , p5_a11 NUMBER := 0-1962.0724
106 , p5_a12 NUMBER := 0-1962.0724
107 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
108 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a15 NUMBER := 0-1962.0724
110 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
111 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
112 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
113 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
114 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
117 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
119 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
123 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
124 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
125 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
126 );
127 end pv_selcrit_pub_w;