82: , x_msg_data out nocopy VARCHAR2
83: , x_return_status out nocopy VARCHAR2
84: , x_template_id out nocopy NUMBER
85: , p3_a0 NUMBER := 0-1962.0724
86: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
87: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
88: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
83: , x_return_status out nocopy VARCHAR2
84: , x_template_id out nocopy NUMBER
85: , p3_a0 NUMBER := 0-1962.0724
86: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
87: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
88: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
84: , x_template_id out nocopy NUMBER
85: , p3_a0 NUMBER := 0-1962.0724
86: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
87: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
88: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
92: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
85: , p3_a0 NUMBER := 0-1962.0724
86: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
87: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
88: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
92: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
93: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
86: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
87: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
88: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
92: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
93: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
94: );
87: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
88: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
92: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
93: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
94: );
95: procedure update_template(p_api_version_number NUMBER
88: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
92: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
93: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
94: );
95: procedure update_template(p_api_version_number NUMBER
96: , p_init_msg_list VARCHAR2
89: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
92: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
93: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
94: );
95: procedure update_template(p_api_version_number NUMBER
96: , p_init_msg_list VARCHAR2
97: , p_commit VARCHAR
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , x_return_status out nocopy VARCHAR2
101: , p3_a0 NUMBER := 0-1962.0724
102: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
99: , x_msg_data out nocopy VARCHAR2
100: , x_return_status out nocopy VARCHAR2
101: , p3_a0 NUMBER := 0-1962.0724
102: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
100: , x_return_status out nocopy VARCHAR2
101: , p3_a0 NUMBER := 0-1962.0724
102: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
108: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
101: , p3_a0 NUMBER := 0-1962.0724
102: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
108: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
109: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
102: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
103: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
108: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
109: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
110: );
103: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
104: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
108: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
109: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
110: );
111: procedure update_template_attributes(p_api_version_number NUMBER
104: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
108: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
109: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
110: );
111: procedure update_template_attributes(p_api_version_number NUMBER
112: , p_init_msg_list VARCHAR2
105: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
108: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
109: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
110: );
111: procedure update_template_attributes(p_api_version_number NUMBER
112: , p_init_msg_list VARCHAR2
113: , p_commit VARCHAR