33: , x_msg_count OUT NOCOPY NUMBER
34: , x_msg_data OUT NOCOPY VARCHAR2
35: , x_template_id OUT NOCOPY NUMBER
36: , p7_a0 NUMBER := 0-1962.0724
37: , p7_a1 DATE := fnd_api.g_miss_date
38: , p7_a2 NUMBER := 0-1962.0724
39: , p7_a3 DATE := fnd_api.g_miss_date
40: , p7_a4 NUMBER := 0-1962.0724
41: , p7_a5 NUMBER := 0-1962.0724
35: , x_template_id OUT NOCOPY NUMBER
36: , p7_a0 NUMBER := 0-1962.0724
37: , p7_a1 DATE := fnd_api.g_miss_date
38: , p7_a2 NUMBER := 0-1962.0724
39: , p7_a3 DATE := fnd_api.g_miss_date
40: , p7_a4 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
40: , p7_a4 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 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_prod_template(p_api_version_number NUMBER
41: , p7_a5 NUMBER := 0-1962.0724
42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724
44: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_prod_template(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 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_prod_template(p_api_version_number NUMBER
49: , p_init_msg_list VARCHAR2
50: , p_commit VARCHAR2
52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_msg_count OUT NOCOPY NUMBER
54: , x_msg_data OUT NOCOPY VARCHAR2
55: , p7_a0 NUMBER := 0-1962.0724
56: , p7_a1 DATE := fnd_api.g_miss_date
57: , p7_a2 NUMBER := 0-1962.0724
58: , p7_a3 DATE := fnd_api.g_miss_date
59: , p7_a4 NUMBER := 0-1962.0724
60: , p7_a5 NUMBER := 0-1962.0724
54: , x_msg_data OUT NOCOPY VARCHAR2
55: , p7_a0 NUMBER := 0-1962.0724
56: , p7_a1 DATE := fnd_api.g_miss_date
57: , p7_a2 NUMBER := 0-1962.0724
58: , p7_a3 DATE := fnd_api.g_miss_date
59: , p7_a4 NUMBER := 0-1962.0724
60: , p7_a5 NUMBER := 0-1962.0724
61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724
59: , p7_a4 NUMBER := 0-1962.0724
60: , p7_a5 NUMBER := 0-1962.0724
61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724
63: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure validate_prod_template(p_api_version_number NUMBER
60: , p7_a5 NUMBER := 0-1962.0724
61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724
63: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure validate_prod_template(p_api_version_number NUMBER
68: , p_init_msg_list VARCHAR2
61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724
63: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure validate_prod_template(p_api_version_number NUMBER
68: , p_init_msg_list VARCHAR2
69: , p_validation_level NUMBER
71: , x_return_status OUT NOCOPY VARCHAR2
72: , x_msg_count OUT NOCOPY NUMBER
73: , x_msg_data OUT NOCOPY VARCHAR2
74: , p3_a0 NUMBER := 0-1962.0724
75: , p3_a1 DATE := fnd_api.g_miss_date
76: , p3_a2 NUMBER := 0-1962.0724
77: , p3_a3 DATE := fnd_api.g_miss_date
78: , p3_a4 NUMBER := 0-1962.0724
79: , p3_a5 NUMBER := 0-1962.0724
73: , x_msg_data OUT NOCOPY VARCHAR2
74: , p3_a0 NUMBER := 0-1962.0724
75: , p3_a1 DATE := fnd_api.g_miss_date
76: , p3_a2 NUMBER := 0-1962.0724
77: , p3_a3 DATE := fnd_api.g_miss_date
78: , p3_a4 NUMBER := 0-1962.0724
79: , p3_a5 NUMBER := 0-1962.0724
80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724
78: , p3_a4 NUMBER := 0-1962.0724
79: , p3_a5 NUMBER := 0-1962.0724
80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724
82: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
84: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2
79: , p3_a5 NUMBER := 0-1962.0724
80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724
82: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
84: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2
87: , x_return_status OUT NOCOPY VARCHAR2
80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724
82: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
84: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2
87: , x_return_status OUT NOCOPY VARCHAR2
88: , p0_a0 NUMBER := 0-1962.0724
85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2
87: , x_return_status OUT NOCOPY VARCHAR2
88: , p0_a0 NUMBER := 0-1962.0724
89: , p0_a1 DATE := fnd_api.g_miss_date
90: , p0_a2 NUMBER := 0-1962.0724
91: , p0_a3 DATE := fnd_api.g_miss_date
92: , p0_a4 NUMBER := 0-1962.0724
93: , p0_a5 NUMBER := 0-1962.0724
87: , x_return_status OUT NOCOPY VARCHAR2
88: , p0_a0 NUMBER := 0-1962.0724
89: , p0_a1 DATE := fnd_api.g_miss_date
90: , p0_a2 NUMBER := 0-1962.0724
91: , p0_a3 DATE := fnd_api.g_miss_date
92: , p0_a4 NUMBER := 0-1962.0724
93: , p0_a5 NUMBER := 0-1962.0724
94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724
92: , p0_a4 NUMBER := 0-1962.0724
93: , p0_a5 NUMBER := 0-1962.0724
94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724
96: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
99: );
100: procedure validate_prod_template_rec(p_api_version_number NUMBER
93: , p0_a5 NUMBER := 0-1962.0724
94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724
96: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
99: );
100: procedure validate_prod_template_rec(p_api_version_number NUMBER
101: , p_init_msg_list VARCHAR2
94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724
96: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
99: );
100: procedure validate_prod_template_rec(p_api_version_number NUMBER
101: , p_init_msg_list VARCHAR2
102: , x_return_status OUT NOCOPY VARCHAR2
102: , x_return_status OUT NOCOPY VARCHAR2
103: , x_msg_count OUT NOCOPY NUMBER
104: , x_msg_data OUT NOCOPY VARCHAR2
105: , p5_a0 NUMBER := 0-1962.0724
106: , p5_a1 DATE := fnd_api.g_miss_date
107: , p5_a2 NUMBER := 0-1962.0724
108: , p5_a3 DATE := fnd_api.g_miss_date
109: , p5_a4 NUMBER := 0-1962.0724
110: , p5_a5 NUMBER := 0-1962.0724
104: , x_msg_data OUT NOCOPY VARCHAR2
105: , p5_a0 NUMBER := 0-1962.0724
106: , p5_a1 DATE := fnd_api.g_miss_date
107: , p5_a2 NUMBER := 0-1962.0724
108: , p5_a3 DATE := fnd_api.g_miss_date
109: , p5_a4 NUMBER := 0-1962.0724
110: , p5_a5 NUMBER := 0-1962.0724
111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724
109: , p5_a4 NUMBER := 0-1962.0724
110: , p5_a5 NUMBER := 0-1962.0724
111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724
113: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
116: );
117: end ams_prod_template_pvt_w;
110: , p5_a5 NUMBER := 0-1962.0724
111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724
113: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
116: );
117: end ams_prod_template_pvt_w;
111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724
113: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
116: );
117: end ams_prod_template_pvt_w;