47: , x_msg_count out nocopy NUMBER
48: , x_msg_data out nocopy VARCHAR2
49: , x_enty_attr_val_id out nocopy NUMBER
50: , p7_a0 NUMBER := 0-1962.0724
51: , p7_a1 DATE := fnd_api.g_miss_date
52: , p7_a2 NUMBER := 0-1962.0724
53: , p7_a3 DATE := fnd_api.g_miss_date
54: , p7_a4 NUMBER := 0-1962.0724
55: , p7_a5 NUMBER := 0-1962.0724
49: , x_enty_attr_val_id out nocopy NUMBER
50: , p7_a0 NUMBER := 0-1962.0724
51: , p7_a1 DATE := fnd_api.g_miss_date
52: , p7_a2 NUMBER := 0-1962.0724
53: , p7_a3 DATE := fnd_api.g_miss_date
54: , p7_a4 NUMBER := 0-1962.0724
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 NUMBER := 0-1962.0724
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a3 DATE := fnd_api.g_miss_date
54: , p7_a4 NUMBER := 0-1962.0724
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 NUMBER := 0-1962.0724
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 NUMBER := 0-1962.0724
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a6 NUMBER := 0-1962.0724
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 NUMBER := 0-1962.0724
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a13 NUMBER := 0-1962.0724
64: , p7_a14 NUMBER := 0-1962.0724
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 NUMBER := 0-1962.0724
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a13 NUMBER := 0-1962.0724
64: , p7_a14 NUMBER := 0-1962.0724
65: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 NUMBER := 0-1962.0724
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a13 NUMBER := 0-1962.0724
64: , p7_a14 NUMBER := 0-1962.0724
65: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a13 NUMBER := 0-1962.0724
64: , p7_a14 NUMBER := 0-1962.0724
65: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a17 NUMBER := 0-1962.0724
68: );
69: procedure update_attr_value(p_api_version_number NUMBER
62: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a13 NUMBER := 0-1962.0724
64: , p7_a14 NUMBER := 0-1962.0724
65: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a17 NUMBER := 0-1962.0724
68: );
69: procedure update_attr_value(p_api_version_number NUMBER
70: , p_init_msg_list VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , x_object_version_number out nocopy NUMBER
77: , p7_a0 NUMBER := 0-1962.0724
78: , p7_a1 DATE := fnd_api.g_miss_date
79: , p7_a2 NUMBER := 0-1962.0724
80: , p7_a3 DATE := fnd_api.g_miss_date
81: , p7_a4 NUMBER := 0-1962.0724
82: , p7_a5 NUMBER := 0-1962.0724
76: , x_object_version_number out nocopy NUMBER
77: , p7_a0 NUMBER := 0-1962.0724
78: , p7_a1 DATE := fnd_api.g_miss_date
79: , p7_a2 NUMBER := 0-1962.0724
80: , p7_a3 DATE := fnd_api.g_miss_date
81: , p7_a4 NUMBER := 0-1962.0724
82: , p7_a5 NUMBER := 0-1962.0724
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a3 DATE := fnd_api.g_miss_date
81: , p7_a4 NUMBER := 0-1962.0724
82: , p7_a5 NUMBER := 0-1962.0724
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 NUMBER := 0-1962.0724
86: , p7_a9 NUMBER := 0-1962.0724
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a6 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 NUMBER := 0-1962.0724
86: , p7_a9 NUMBER := 0-1962.0724
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 NUMBER := 0-1962.0724
91: , p7_a14 NUMBER := 0-1962.0724
84: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 NUMBER := 0-1962.0724
86: , p7_a9 NUMBER := 0-1962.0724
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 NUMBER := 0-1962.0724
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a8 NUMBER := 0-1962.0724
86: , p7_a9 NUMBER := 0-1962.0724
87: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 NUMBER := 0-1962.0724
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 NUMBER := 0-1962.0724
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a17 NUMBER := 0-1962.0724
95: );
96: procedure validate_attr_value(p_api_version_number NUMBER
89: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a13 NUMBER := 0-1962.0724
91: , p7_a14 NUMBER := 0-1962.0724
92: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a17 NUMBER := 0-1962.0724
95: );
96: procedure validate_attr_value(p_api_version_number NUMBER
97: , p_init_msg_list VARCHAR2
100: , x_return_status out nocopy VARCHAR2
101: , x_msg_count out nocopy NUMBER
102: , x_msg_data out nocopy VARCHAR2
103: , p4_a0 NUMBER := 0-1962.0724
104: , p4_a1 DATE := fnd_api.g_miss_date
105: , p4_a2 NUMBER := 0-1962.0724
106: , p4_a3 DATE := fnd_api.g_miss_date
107: , p4_a4 NUMBER := 0-1962.0724
108: , p4_a5 NUMBER := 0-1962.0724
102: , x_msg_data out nocopy VARCHAR2
103: , p4_a0 NUMBER := 0-1962.0724
104: , p4_a1 DATE := fnd_api.g_miss_date
105: , p4_a2 NUMBER := 0-1962.0724
106: , p4_a3 DATE := fnd_api.g_miss_date
107: , p4_a4 NUMBER := 0-1962.0724
108: , p4_a5 NUMBER := 0-1962.0724
109: , p4_a6 NUMBER := 0-1962.0724
110: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
106: , p4_a3 DATE := fnd_api.g_miss_date
107: , p4_a4 NUMBER := 0-1962.0724
108: , p4_a5 NUMBER := 0-1962.0724
109: , p4_a6 NUMBER := 0-1962.0724
110: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p4_a8 NUMBER := 0-1962.0724
112: , p4_a9 NUMBER := 0-1962.0724
113: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
109: , p4_a6 NUMBER := 0-1962.0724
110: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p4_a8 NUMBER := 0-1962.0724
112: , p4_a9 NUMBER := 0-1962.0724
113: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p4_a13 NUMBER := 0-1962.0724
117: , p4_a14 NUMBER := 0-1962.0724
110: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
111: , p4_a8 NUMBER := 0-1962.0724
112: , p4_a9 NUMBER := 0-1962.0724
113: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p4_a13 NUMBER := 0-1962.0724
117: , p4_a14 NUMBER := 0-1962.0724
118: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
111: , p4_a8 NUMBER := 0-1962.0724
112: , p4_a9 NUMBER := 0-1962.0724
113: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
114: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p4_a13 NUMBER := 0-1962.0724
117: , p4_a14 NUMBER := 0-1962.0724
118: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
119: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
114: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p4_a13 NUMBER := 0-1962.0724
117: , p4_a14 NUMBER := 0-1962.0724
118: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
119: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
120: , p4_a17 NUMBER := 0-1962.0724
121: );
122: procedure check_attr_value_items(p_validation_mode VARCHAR2
115: , p4_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p4_a13 NUMBER := 0-1962.0724
117: , p4_a14 NUMBER := 0-1962.0724
118: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
119: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
120: , p4_a17 NUMBER := 0-1962.0724
121: );
122: procedure check_attr_value_items(p_validation_mode VARCHAR2
123: , x_return_status out nocopy VARCHAR2
121: );
122: procedure check_attr_value_items(p_validation_mode VARCHAR2
123: , x_return_status out nocopy VARCHAR2
124: , p0_a0 NUMBER := 0-1962.0724
125: , p0_a1 DATE := fnd_api.g_miss_date
126: , p0_a2 NUMBER := 0-1962.0724
127: , p0_a3 DATE := fnd_api.g_miss_date
128: , p0_a4 NUMBER := 0-1962.0724
129: , p0_a5 NUMBER := 0-1962.0724
123: , x_return_status out nocopy VARCHAR2
124: , p0_a0 NUMBER := 0-1962.0724
125: , p0_a1 DATE := fnd_api.g_miss_date
126: , p0_a2 NUMBER := 0-1962.0724
127: , p0_a3 DATE := fnd_api.g_miss_date
128: , p0_a4 NUMBER := 0-1962.0724
129: , p0_a5 NUMBER := 0-1962.0724
130: , p0_a6 NUMBER := 0-1962.0724
131: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
127: , p0_a3 DATE := fnd_api.g_miss_date
128: , p0_a4 NUMBER := 0-1962.0724
129: , p0_a5 NUMBER := 0-1962.0724
130: , p0_a6 NUMBER := 0-1962.0724
131: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a8 NUMBER := 0-1962.0724
133: , p0_a9 NUMBER := 0-1962.0724
134: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
130: , p0_a6 NUMBER := 0-1962.0724
131: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a8 NUMBER := 0-1962.0724
133: , p0_a9 NUMBER := 0-1962.0724
134: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p0_a13 NUMBER := 0-1962.0724
138: , p0_a14 NUMBER := 0-1962.0724
131: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a8 NUMBER := 0-1962.0724
133: , p0_a9 NUMBER := 0-1962.0724
134: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p0_a13 NUMBER := 0-1962.0724
138: , p0_a14 NUMBER := 0-1962.0724
139: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
132: , p0_a8 NUMBER := 0-1962.0724
133: , p0_a9 NUMBER := 0-1962.0724
134: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p0_a13 NUMBER := 0-1962.0724
138: , p0_a14 NUMBER := 0-1962.0724
139: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p0_a13 NUMBER := 0-1962.0724
138: , p0_a14 NUMBER := 0-1962.0724
139: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p0_a17 NUMBER := 0-1962.0724
142: );
143: procedure validate_attr_val_rec(p_api_version_number NUMBER
136: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p0_a13 NUMBER := 0-1962.0724
138: , p0_a14 NUMBER := 0-1962.0724
139: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p0_a17 NUMBER := 0-1962.0724
142: );
143: procedure validate_attr_val_rec(p_api_version_number NUMBER
144: , p_init_msg_list VARCHAR2
146: , x_msg_count out nocopy NUMBER
147: , x_msg_data out nocopy VARCHAR2
148: , p_validation_mode VARCHAR2
149: , p5_a0 NUMBER := 0-1962.0724
150: , p5_a1 DATE := fnd_api.g_miss_date
151: , p5_a2 NUMBER := 0-1962.0724
152: , p5_a3 DATE := fnd_api.g_miss_date
153: , p5_a4 NUMBER := 0-1962.0724
154: , p5_a5 NUMBER := 0-1962.0724
148: , p_validation_mode VARCHAR2
149: , p5_a0 NUMBER := 0-1962.0724
150: , p5_a1 DATE := fnd_api.g_miss_date
151: , p5_a2 NUMBER := 0-1962.0724
152: , p5_a3 DATE := fnd_api.g_miss_date
153: , p5_a4 NUMBER := 0-1962.0724
154: , p5_a5 NUMBER := 0-1962.0724
155: , p5_a6 NUMBER := 0-1962.0724
156: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
152: , p5_a3 DATE := fnd_api.g_miss_date
153: , p5_a4 NUMBER := 0-1962.0724
154: , p5_a5 NUMBER := 0-1962.0724
155: , p5_a6 NUMBER := 0-1962.0724
156: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a8 NUMBER := 0-1962.0724
158: , p5_a9 NUMBER := 0-1962.0724
159: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a6 NUMBER := 0-1962.0724
156: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a8 NUMBER := 0-1962.0724
158: , p5_a9 NUMBER := 0-1962.0724
159: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a13 NUMBER := 0-1962.0724
163: , p5_a14 NUMBER := 0-1962.0724
156: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a8 NUMBER := 0-1962.0724
158: , p5_a9 NUMBER := 0-1962.0724
159: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a13 NUMBER := 0-1962.0724
163: , p5_a14 NUMBER := 0-1962.0724
164: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a8 NUMBER := 0-1962.0724
158: , p5_a9 NUMBER := 0-1962.0724
159: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a13 NUMBER := 0-1962.0724
163: , p5_a14 NUMBER := 0-1962.0724
164: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a13 NUMBER := 0-1962.0724
163: , p5_a14 NUMBER := 0-1962.0724
164: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a17 NUMBER := 0-1962.0724
167: );
168: end pv_enty_attr_value_pvt_w;
161: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a13 NUMBER := 0-1962.0724
163: , p5_a14 NUMBER := 0-1962.0724
164: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a17 NUMBER := 0-1962.0724
167: );
168: end pv_enty_attr_value_pvt_w;