42: , x_msg_data out nocopy VARCHAR2
43: , x_template_attribute_id out nocopy NUMBER
44: , p7_a0 NUMBER := 0-1962.0724
45: , p7_a1 NUMBER := 0-1962.0724
46: , p7_a2 DATE := fnd_api.g_miss_date
47: , p7_a3 NUMBER := 0-1962.0724
48: , p7_a4 DATE := fnd_api.g_miss_date
49: , p7_a5 NUMBER := 0-1962.0724
50: , p7_a6 NUMBER := 0-1962.0724
44: , p7_a0 NUMBER := 0-1962.0724
45: , p7_a1 NUMBER := 0-1962.0724
46: , p7_a2 DATE := fnd_api.g_miss_date
47: , p7_a3 NUMBER := 0-1962.0724
48: , p7_a4 DATE := fnd_api.g_miss_date
49: , p7_a5 NUMBER := 0-1962.0724
50: , p7_a6 NUMBER := 0-1962.0724
51: , p7_a7 NUMBER := 0-1962.0724
52: , p7_a8 NUMBER := 0-1962.0724
49: , p7_a5 NUMBER := 0-1962.0724
50: , p7_a6 NUMBER := 0-1962.0724
51: , p7_a7 NUMBER := 0-1962.0724
52: , p7_a8 NUMBER := 0-1962.0724
53: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a6 NUMBER := 0-1962.0724
51: , p7_a7 NUMBER := 0-1962.0724
52: , p7_a8 NUMBER := 0-1962.0724
53: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a7 NUMBER := 0-1962.0724
52: , p7_a8 NUMBER := 0-1962.0724
53: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
59: );
52: , p7_a8 NUMBER := 0-1962.0724
53: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
59: );
60: procedure update_template_attr(p_api_version_number NUMBER
53: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
59: );
60: procedure update_template_attr(p_api_version_number NUMBER
61: , p_init_msg_list VARCHAR2
54: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
59: );
60: procedure update_template_attr(p_api_version_number NUMBER
61: , p_init_msg_list VARCHAR2
62: , p_commit VARCHAR2
65: , x_msg_count out nocopy NUMBER
66: , x_msg_data out nocopy VARCHAR2
67: , p7_a0 NUMBER := 0-1962.0724
68: , p7_a1 NUMBER := 0-1962.0724
69: , p7_a2 DATE := fnd_api.g_miss_date
70: , p7_a3 NUMBER := 0-1962.0724
71: , p7_a4 DATE := fnd_api.g_miss_date
72: , p7_a5 NUMBER := 0-1962.0724
73: , p7_a6 NUMBER := 0-1962.0724
67: , p7_a0 NUMBER := 0-1962.0724
68: , p7_a1 NUMBER := 0-1962.0724
69: , p7_a2 DATE := fnd_api.g_miss_date
70: , p7_a3 NUMBER := 0-1962.0724
71: , p7_a4 DATE := fnd_api.g_miss_date
72: , p7_a5 NUMBER := 0-1962.0724
73: , p7_a6 NUMBER := 0-1962.0724
74: , p7_a7 NUMBER := 0-1962.0724
75: , p7_a8 NUMBER := 0-1962.0724
72: , p7_a5 NUMBER := 0-1962.0724
73: , p7_a6 NUMBER := 0-1962.0724
74: , p7_a7 NUMBER := 0-1962.0724
75: , p7_a8 NUMBER := 0-1962.0724
76: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a6 NUMBER := 0-1962.0724
74: , p7_a7 NUMBER := 0-1962.0724
75: , p7_a8 NUMBER := 0-1962.0724
76: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a7 NUMBER := 0-1962.0724
75: , p7_a8 NUMBER := 0-1962.0724
76: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
82: );
75: , p7_a8 NUMBER := 0-1962.0724
76: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
82: );
83: procedure validate_template_attr(p_api_version_number NUMBER
76: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
82: );
83: procedure validate_template_attr(p_api_version_number NUMBER
84: , p_init_msg_list VARCHAR2
77: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
82: );
83: procedure validate_template_attr(p_api_version_number NUMBER
84: , p_init_msg_list VARCHAR2
85: , p_validation_level NUMBER
88: , x_msg_count out nocopy NUMBER
89: , x_msg_data out nocopy VARCHAR2
90: , p3_a0 NUMBER := 0-1962.0724
91: , p3_a1 NUMBER := 0-1962.0724
92: , p3_a2 DATE := fnd_api.g_miss_date
93: , p3_a3 NUMBER := 0-1962.0724
94: , p3_a4 DATE := fnd_api.g_miss_date
95: , p3_a5 NUMBER := 0-1962.0724
96: , p3_a6 NUMBER := 0-1962.0724
90: , p3_a0 NUMBER := 0-1962.0724
91: , p3_a1 NUMBER := 0-1962.0724
92: , p3_a2 DATE := fnd_api.g_miss_date
93: , p3_a3 NUMBER := 0-1962.0724
94: , p3_a4 DATE := fnd_api.g_miss_date
95: , p3_a5 NUMBER := 0-1962.0724
96: , p3_a6 NUMBER := 0-1962.0724
97: , p3_a7 NUMBER := 0-1962.0724
98: , p3_a8 NUMBER := 0-1962.0724
95: , p3_a5 NUMBER := 0-1962.0724
96: , p3_a6 NUMBER := 0-1962.0724
97: , p3_a7 NUMBER := 0-1962.0724
98: , p3_a8 NUMBER := 0-1962.0724
99: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
101: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
96: , p3_a6 NUMBER := 0-1962.0724
97: , p3_a7 NUMBER := 0-1962.0724
98: , p3_a8 NUMBER := 0-1962.0724
99: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
101: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
97: , p3_a7 NUMBER := 0-1962.0724
98: , p3_a8 NUMBER := 0-1962.0724
99: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
101: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
105: );
98: , p3_a8 NUMBER := 0-1962.0724
99: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
101: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
105: );
106: procedure check_template_attr_items(p_validation_mode VARCHAR2
99: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
101: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
105: );
106: procedure check_template_attr_items(p_validation_mode VARCHAR2
107: , x_return_status out nocopy VARCHAR2
100: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
101: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
105: );
106: procedure check_template_attr_items(p_validation_mode VARCHAR2
107: , x_return_status out nocopy VARCHAR2
108: , p0_a0 NUMBER := 0-1962.0724
106: procedure check_template_attr_items(p_validation_mode VARCHAR2
107: , x_return_status out nocopy VARCHAR2
108: , p0_a0 NUMBER := 0-1962.0724
109: , p0_a1 NUMBER := 0-1962.0724
110: , p0_a2 DATE := fnd_api.g_miss_date
111: , p0_a3 NUMBER := 0-1962.0724
112: , p0_a4 DATE := fnd_api.g_miss_date
113: , p0_a5 NUMBER := 0-1962.0724
114: , p0_a6 NUMBER := 0-1962.0724
108: , p0_a0 NUMBER := 0-1962.0724
109: , p0_a1 NUMBER := 0-1962.0724
110: , p0_a2 DATE := fnd_api.g_miss_date
111: , p0_a3 NUMBER := 0-1962.0724
112: , p0_a4 DATE := fnd_api.g_miss_date
113: , p0_a5 NUMBER := 0-1962.0724
114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 NUMBER := 0-1962.0724
116: , p0_a8 NUMBER := 0-1962.0724
113: , p0_a5 NUMBER := 0-1962.0724
114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 NUMBER := 0-1962.0724
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
114: , p0_a6 NUMBER := 0-1962.0724
115: , p0_a7 NUMBER := 0-1962.0724
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
115: , p0_a7 NUMBER := 0-1962.0724
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: );
116: , p0_a8 NUMBER := 0-1962.0724
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: );
124: procedure validate_template_attr_rec(p_api_version_number NUMBER
117: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: );
124: procedure validate_template_attr_rec(p_api_version_number NUMBER
125: , p_init_msg_list VARCHAR2
118: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
119: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
120: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
123: );
124: procedure validate_template_attr_rec(p_api_version_number NUMBER
125: , p_init_msg_list VARCHAR2
126: , x_return_status out nocopy VARCHAR2
127: , x_msg_count out nocopy NUMBER
128: , x_msg_data out nocopy VARCHAR2
129: , p5_a0 NUMBER := 0-1962.0724
130: , p5_a1 NUMBER := 0-1962.0724
131: , p5_a2 DATE := fnd_api.g_miss_date
132: , p5_a3 NUMBER := 0-1962.0724
133: , p5_a4 DATE := fnd_api.g_miss_date
134: , p5_a5 NUMBER := 0-1962.0724
135: , p5_a6 NUMBER := 0-1962.0724
129: , p5_a0 NUMBER := 0-1962.0724
130: , p5_a1 NUMBER := 0-1962.0724
131: , p5_a2 DATE := fnd_api.g_miss_date
132: , p5_a3 NUMBER := 0-1962.0724
133: , p5_a4 DATE := fnd_api.g_miss_date
134: , p5_a5 NUMBER := 0-1962.0724
135: , p5_a6 NUMBER := 0-1962.0724
136: , p5_a7 NUMBER := 0-1962.0724
137: , p5_a8 NUMBER := 0-1962.0724
134: , p5_a5 NUMBER := 0-1962.0724
135: , p5_a6 NUMBER := 0-1962.0724
136: , p5_a7 NUMBER := 0-1962.0724
137: , p5_a8 NUMBER := 0-1962.0724
138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a6 NUMBER := 0-1962.0724
136: , p5_a7 NUMBER := 0-1962.0724
137: , p5_a8 NUMBER := 0-1962.0724
138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a7 NUMBER := 0-1962.0724
137: , p5_a8 NUMBER := 0-1962.0724
138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
144: );
137: , p5_a8 NUMBER := 0-1962.0724
138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
144: );
145: end ams_template_attr_pvt_w;
138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
144: );
145: end ams_template_attr_pvt_w;
139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
144: );
145: end ams_template_attr_pvt_w;