33: , x_msg_count out nocopy NUMBER
34: , x_msg_data out nocopy VARCHAR2
35: , x_attr_code_id out nocopy NUMBER
36: , p7_a0 NUMBER := 0-1962.0724
37: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a2 DATE := fnd_api.g_miss_date
39: , p7_a3 NUMBER := 0-1962.0724
40: , p7_a4 DATE := fnd_api.g_miss_date
41: , p7_a5 NUMBER := 0-1962.0724
34: , x_msg_data out nocopy VARCHAR2
35: , x_attr_code_id out nocopy NUMBER
36: , p7_a0 NUMBER := 0-1962.0724
37: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a2 DATE := fnd_api.g_miss_date
39: , p7_a3 NUMBER := 0-1962.0724
40: , p7_a4 DATE := fnd_api.g_miss_date
41: , p7_a5 NUMBER := 0-1962.0724
42: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a0 NUMBER := 0-1962.0724
37: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a2 DATE := fnd_api.g_miss_date
39: , p7_a3 NUMBER := 0-1962.0724
40: , p7_a4 DATE := fnd_api.g_miss_date
41: , p7_a5 NUMBER := 0-1962.0724
42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724
44: , p7_a8 NUMBER := 0-1962.0724
41: , p7_a5 NUMBER := 0-1962.0724
42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724
44: , p7_a8 NUMBER := 0-1962.0724
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_attribute_code(p_api_version_number NUMBER
49: , p_init_msg_list VARCHAR2
42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724
44: , p7_a8 NUMBER := 0-1962.0724
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_attribute_code(p_api_version_number NUMBER
49: , p_init_msg_list VARCHAR2
50: , p_commit 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 VARCHAR2 := fnd_api.g_miss_char
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
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 VARCHAR2 := fnd_api.g_miss_char
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
56: , p7_a0 NUMBER := 0-1962.0724
57: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
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 NUMBER := 0-1962.0724
61: , p7_a5 NUMBER := 0-1962.0724
62: , p7_a6 NUMBER := 0-1962.0724
63: , p7_a7 NUMBER := 0-1962.0724
64: , p7_a8 NUMBER := 0-1962.0724
65: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
67: );
68: procedure validate_attribute_code(p_api_version_number NUMBER
69: , p_init_msg_list VARCHAR2
62: , p7_a6 NUMBER := 0-1962.0724
63: , p7_a7 NUMBER := 0-1962.0724
64: , p7_a8 NUMBER := 0-1962.0724
65: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
67: );
68: procedure validate_attribute_code(p_api_version_number NUMBER
69: , p_init_msg_list VARCHAR2
70: , p_validation_level NUMBER
72: , x_return_status out nocopy VARCHAR2
73: , x_msg_count out nocopy NUMBER
74: , x_msg_data out nocopy VARCHAR2
75: , p4_a0 NUMBER := 0-1962.0724
76: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a2 DATE := fnd_api.g_miss_date
78: , p4_a3 NUMBER := 0-1962.0724
79: , p4_a4 DATE := fnd_api.g_miss_date
80: , p4_a5 NUMBER := 0-1962.0724
73: , x_msg_count out nocopy NUMBER
74: , x_msg_data out nocopy VARCHAR2
75: , p4_a0 NUMBER := 0-1962.0724
76: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a2 DATE := fnd_api.g_miss_date
78: , p4_a3 NUMBER := 0-1962.0724
79: , p4_a4 DATE := fnd_api.g_miss_date
80: , p4_a5 NUMBER := 0-1962.0724
81: , p4_a6 NUMBER := 0-1962.0724
75: , p4_a0 NUMBER := 0-1962.0724
76: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a2 DATE := fnd_api.g_miss_date
78: , p4_a3 NUMBER := 0-1962.0724
79: , p4_a4 DATE := fnd_api.g_miss_date
80: , p4_a5 NUMBER := 0-1962.0724
81: , p4_a6 NUMBER := 0-1962.0724
82: , p4_a7 NUMBER := 0-1962.0724
83: , p4_a8 NUMBER := 0-1962.0724
80: , p4_a5 NUMBER := 0-1962.0724
81: , p4_a6 NUMBER := 0-1962.0724
82: , p4_a7 NUMBER := 0-1962.0724
83: , p4_a8 NUMBER := 0-1962.0724
84: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
85: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
86: );
87: procedure check_attr_code_items(p_validation_mode VARCHAR2
88: , x_return_status out nocopy VARCHAR2
81: , p4_a6 NUMBER := 0-1962.0724
82: , p4_a7 NUMBER := 0-1962.0724
83: , p4_a8 NUMBER := 0-1962.0724
84: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
85: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
86: );
87: procedure check_attr_code_items(p_validation_mode VARCHAR2
88: , x_return_status out nocopy VARCHAR2
89: , p0_a0 NUMBER := 0-1962.0724
86: );
87: procedure check_attr_code_items(p_validation_mode VARCHAR2
88: , x_return_status out nocopy VARCHAR2
89: , p0_a0 NUMBER := 0-1962.0724
90: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a2 DATE := fnd_api.g_miss_date
92: , p0_a3 NUMBER := 0-1962.0724
93: , p0_a4 DATE := fnd_api.g_miss_date
94: , p0_a5 NUMBER := 0-1962.0724
87: procedure check_attr_code_items(p_validation_mode VARCHAR2
88: , x_return_status out nocopy VARCHAR2
89: , p0_a0 NUMBER := 0-1962.0724
90: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a2 DATE := fnd_api.g_miss_date
92: , p0_a3 NUMBER := 0-1962.0724
93: , p0_a4 DATE := fnd_api.g_miss_date
94: , p0_a5 NUMBER := 0-1962.0724
95: , p0_a6 NUMBER := 0-1962.0724
89: , p0_a0 NUMBER := 0-1962.0724
90: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
91: , p0_a2 DATE := fnd_api.g_miss_date
92: , p0_a3 NUMBER := 0-1962.0724
93: , p0_a4 DATE := fnd_api.g_miss_date
94: , p0_a5 NUMBER := 0-1962.0724
95: , p0_a6 NUMBER := 0-1962.0724
96: , p0_a7 NUMBER := 0-1962.0724
97: , p0_a8 NUMBER := 0-1962.0724
94: , p0_a5 NUMBER := 0-1962.0724
95: , p0_a6 NUMBER := 0-1962.0724
96: , p0_a7 NUMBER := 0-1962.0724
97: , p0_a8 NUMBER := 0-1962.0724
98: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
100: );
101: procedure validate_attr_code_rec(p_api_version_number NUMBER
102: , p_init_msg_list VARCHAR2
95: , p0_a6 NUMBER := 0-1962.0724
96: , p0_a7 NUMBER := 0-1962.0724
97: , p0_a8 NUMBER := 0-1962.0724
98: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
100: );
101: procedure validate_attr_code_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: , p_validation_mode VARCHAR2
107: , p5_a0 NUMBER := 0-1962.0724
108: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a2 DATE := fnd_api.g_miss_date
110: , p5_a3 NUMBER := 0-1962.0724
111: , p5_a4 DATE := fnd_api.g_miss_date
112: , p5_a5 NUMBER := 0-1962.0724
105: , x_msg_data out nocopy VARCHAR2
106: , p_validation_mode VARCHAR2
107: , p5_a0 NUMBER := 0-1962.0724
108: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a2 DATE := fnd_api.g_miss_date
110: , p5_a3 NUMBER := 0-1962.0724
111: , p5_a4 DATE := fnd_api.g_miss_date
112: , p5_a5 NUMBER := 0-1962.0724
113: , p5_a6 NUMBER := 0-1962.0724
107: , p5_a0 NUMBER := 0-1962.0724
108: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a2 DATE := fnd_api.g_miss_date
110: , p5_a3 NUMBER := 0-1962.0724
111: , p5_a4 DATE := fnd_api.g_miss_date
112: , p5_a5 NUMBER := 0-1962.0724
113: , p5_a6 NUMBER := 0-1962.0724
114: , p5_a7 NUMBER := 0-1962.0724
115: , p5_a8 NUMBER := 0-1962.0724
112: , p5_a5 NUMBER := 0-1962.0724
113: , p5_a6 NUMBER := 0-1962.0724
114: , p5_a7 NUMBER := 0-1962.0724
115: , p5_a8 NUMBER := 0-1962.0724
116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
118: );
119: end pv_attribute_code_pvt_w;
113: , p5_a6 NUMBER := 0-1962.0724
114: , p5_a7 NUMBER := 0-1962.0724
115: , p5_a8 NUMBER := 0-1962.0724
116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
118: );
119: end pv_attribute_code_pvt_w;