8: , x_msg_count OUT NOCOPY NUMBER
9: , x_msg_data OUT NOCOPY VARCHAR2
10: , x_wrd_rpl_id OUT NOCOPY NUMBER
11: , p7_a0 NUMBER := 0-1962.0724
12: , p7_a1 DATE := fnd_api.g_miss_date
13: , p7_a2 NUMBER := 0-1962.0724
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
10: , x_wrd_rpl_id OUT NOCOPY NUMBER
11: , p7_a0 NUMBER := 0-1962.0724
12: , p7_a1 DATE := fnd_api.g_miss_date
13: , p7_a2 NUMBER := 0-1962.0724
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22: );
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22: );
23: procedure update_list_word_replace(p_api_version NUMBER
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22: );
23: procedure update_list_word_replace(p_api_version NUMBER
24: , p_init_msg_list VARCHAR2
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22: );
23: procedure update_list_word_replace(p_api_version NUMBER
24: , p_init_msg_list VARCHAR2
25: , p_commit VARCHAR2
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_msg_count OUT NOCOPY NUMBER
29: , x_msg_data OUT NOCOPY VARCHAR2
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
29: , x_msg_data OUT NOCOPY VARCHAR2
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: );
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: );
42: procedure validate_list_word_replace(p_api_version NUMBER
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: );
42: procedure validate_list_word_replace(p_api_version NUMBER
43: , p_init_msg_list VARCHAR2
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: );
42: procedure validate_list_word_replace(p_api_version NUMBER
43: , p_init_msg_list VARCHAR2
44: , p_validation_level NUMBER
45: , x_return_status OUT NOCOPY VARCHAR2
46: , x_msg_count OUT NOCOPY NUMBER
47: , x_msg_data OUT NOCOPY VARCHAR2
48: , p6_a0 NUMBER := 0-1962.0724
49: , p6_a1 DATE := fnd_api.g_miss_date
50: , p6_a2 NUMBER := 0-1962.0724
51: , p6_a3 DATE := fnd_api.g_miss_date
52: , p6_a4 NUMBER := 0-1962.0724
53: , p6_a5 NUMBER := 0-1962.0724
47: , x_msg_data OUT NOCOPY VARCHAR2
48: , p6_a0 NUMBER := 0-1962.0724
49: , p6_a1 DATE := fnd_api.g_miss_date
50: , p6_a2 NUMBER := 0-1962.0724
51: , p6_a3 DATE := fnd_api.g_miss_date
52: , p6_a4 NUMBER := 0-1962.0724
53: , p6_a5 NUMBER := 0-1962.0724
54: , p6_a6 NUMBER := 0-1962.0724
55: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
51: , p6_a3 DATE := fnd_api.g_miss_date
52: , p6_a4 NUMBER := 0-1962.0724
53: , p6_a5 NUMBER := 0-1962.0724
54: , p6_a6 NUMBER := 0-1962.0724
55: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
59: );
52: , p6_a4 NUMBER := 0-1962.0724
53: , p6_a5 NUMBER := 0-1962.0724
54: , p6_a6 NUMBER := 0-1962.0724
55: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
59: );
60: procedure check_items(p_validation_mode VARCHAR2
53: , p6_a5 NUMBER := 0-1962.0724
54: , p6_a6 NUMBER := 0-1962.0724
55: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
59: );
60: procedure check_items(p_validation_mode VARCHAR2
61: , x_return_status OUT NOCOPY VARCHAR2
54: , p6_a6 NUMBER := 0-1962.0724
55: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
56: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
57: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
58: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
59: );
60: procedure check_items(p_validation_mode VARCHAR2
61: , x_return_status OUT NOCOPY VARCHAR2
62: , p2_a0 NUMBER := 0-1962.0724
59: );
60: procedure check_items(p_validation_mode VARCHAR2
61: , x_return_status OUT NOCOPY VARCHAR2
62: , p2_a0 NUMBER := 0-1962.0724
63: , p2_a1 DATE := fnd_api.g_miss_date
64: , p2_a2 NUMBER := 0-1962.0724
65: , p2_a3 DATE := fnd_api.g_miss_date
66: , p2_a4 NUMBER := 0-1962.0724
67: , p2_a5 NUMBER := 0-1962.0724
61: , x_return_status OUT NOCOPY VARCHAR2
62: , p2_a0 NUMBER := 0-1962.0724
63: , p2_a1 DATE := fnd_api.g_miss_date
64: , p2_a2 NUMBER := 0-1962.0724
65: , p2_a3 DATE := fnd_api.g_miss_date
66: , p2_a4 NUMBER := 0-1962.0724
67: , p2_a5 NUMBER := 0-1962.0724
68: , p2_a6 NUMBER := 0-1962.0724
69: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
65: , p2_a3 DATE := fnd_api.g_miss_date
66: , p2_a4 NUMBER := 0-1962.0724
67: , p2_a5 NUMBER := 0-1962.0724
68: , p2_a6 NUMBER := 0-1962.0724
69: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
70: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
71: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
72: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
73: );
66: , p2_a4 NUMBER := 0-1962.0724
67: , p2_a5 NUMBER := 0-1962.0724
68: , p2_a6 NUMBER := 0-1962.0724
69: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
70: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
71: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
72: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
73: );
74: procedure check_req_items(p_validation_mode VARCHAR2
67: , p2_a5 NUMBER := 0-1962.0724
68: , p2_a6 NUMBER := 0-1962.0724
69: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
70: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
71: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
72: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
73: );
74: procedure check_req_items(p_validation_mode VARCHAR2
75: , x_return_status OUT NOCOPY VARCHAR2
68: , p2_a6 NUMBER := 0-1962.0724
69: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
70: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
71: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
72: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
73: );
74: procedure check_req_items(p_validation_mode VARCHAR2
75: , x_return_status OUT NOCOPY VARCHAR2
76: , p1_a0 NUMBER := 0-1962.0724
73: );
74: procedure check_req_items(p_validation_mode VARCHAR2
75: , x_return_status OUT NOCOPY VARCHAR2
76: , p1_a0 NUMBER := 0-1962.0724
77: , p1_a1 DATE := fnd_api.g_miss_date
78: , p1_a2 NUMBER := 0-1962.0724
79: , p1_a3 DATE := fnd_api.g_miss_date
80: , p1_a4 NUMBER := 0-1962.0724
81: , p1_a5 NUMBER := 0-1962.0724
75: , x_return_status OUT NOCOPY VARCHAR2
76: , p1_a0 NUMBER := 0-1962.0724
77: , p1_a1 DATE := fnd_api.g_miss_date
78: , p1_a2 NUMBER := 0-1962.0724
79: , p1_a3 DATE := fnd_api.g_miss_date
80: , p1_a4 NUMBER := 0-1962.0724
81: , p1_a5 NUMBER := 0-1962.0724
82: , p1_a6 NUMBER := 0-1962.0724
83: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
79: , p1_a3 DATE := fnd_api.g_miss_date
80: , p1_a4 NUMBER := 0-1962.0724
81: , p1_a5 NUMBER := 0-1962.0724
82: , p1_a6 NUMBER := 0-1962.0724
83: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
86: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
87: );
80: , p1_a4 NUMBER := 0-1962.0724
81: , p1_a5 NUMBER := 0-1962.0724
82: , p1_a6 NUMBER := 0-1962.0724
83: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
86: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
87: );
88: procedure check_uk_items(p_validation_mode VARCHAR2
81: , p1_a5 NUMBER := 0-1962.0724
82: , p1_a6 NUMBER := 0-1962.0724
83: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
86: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
87: );
88: procedure check_uk_items(p_validation_mode VARCHAR2
89: , x_return_status OUT NOCOPY VARCHAR2
82: , p1_a6 NUMBER := 0-1962.0724
83: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
85: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
86: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
87: );
88: procedure check_uk_items(p_validation_mode VARCHAR2
89: , x_return_status OUT NOCOPY VARCHAR2
90: , p1_a0 NUMBER := 0-1962.0724
87: );
88: procedure check_uk_items(p_validation_mode VARCHAR2
89: , x_return_status OUT NOCOPY VARCHAR2
90: , p1_a0 NUMBER := 0-1962.0724
91: , p1_a1 DATE := fnd_api.g_miss_date
92: , p1_a2 NUMBER := 0-1962.0724
93: , p1_a3 DATE := fnd_api.g_miss_date
94: , p1_a4 NUMBER := 0-1962.0724
95: , p1_a5 NUMBER := 0-1962.0724
89: , x_return_status OUT NOCOPY VARCHAR2
90: , p1_a0 NUMBER := 0-1962.0724
91: , p1_a1 DATE := fnd_api.g_miss_date
92: , p1_a2 NUMBER := 0-1962.0724
93: , p1_a3 DATE := fnd_api.g_miss_date
94: , p1_a4 NUMBER := 0-1962.0724
95: , p1_a5 NUMBER := 0-1962.0724
96: , p1_a6 NUMBER := 0-1962.0724
97: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
93: , p1_a3 DATE := fnd_api.g_miss_date
94: , p1_a4 NUMBER := 0-1962.0724
95: , p1_a5 NUMBER := 0-1962.0724
96: , p1_a6 NUMBER := 0-1962.0724
97: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
98: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
99: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
101: );
94: , p1_a4 NUMBER := 0-1962.0724
95: , p1_a5 NUMBER := 0-1962.0724
96: , p1_a6 NUMBER := 0-1962.0724
97: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
98: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
99: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
101: );
102: procedure complete_rec(p1_a0 OUT NOCOPY NUMBER
95: , p1_a5 NUMBER := 0-1962.0724
96: , p1_a6 NUMBER := 0-1962.0724
97: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
98: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
99: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
101: );
102: procedure complete_rec(p1_a0 OUT NOCOPY NUMBER
103: , p1_a1 OUT NOCOPY DATE
96: , p1_a6 NUMBER := 0-1962.0724
97: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
98: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
99: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
100: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
101: );
102: procedure complete_rec(p1_a0 OUT NOCOPY NUMBER
103: , p1_a1 OUT NOCOPY DATE
104: , p1_a2 OUT NOCOPY NUMBER
110: , p1_a8 OUT NOCOPY VARCHAR2
111: , p1_a9 OUT NOCOPY VARCHAR2
112: , p1_a10 OUT NOCOPY VARCHAR2
113: , p0_a0 NUMBER := 0-1962.0724
114: , p0_a1 DATE := fnd_api.g_miss_date
115: , p0_a2 NUMBER := 0-1962.0724
116: , p0_a3 DATE := fnd_api.g_miss_date
117: , p0_a4 NUMBER := 0-1962.0724
118: , p0_a5 NUMBER := 0-1962.0724
112: , p1_a10 OUT NOCOPY VARCHAR2
113: , p0_a0 NUMBER := 0-1962.0724
114: , p0_a1 DATE := fnd_api.g_miss_date
115: , p0_a2 NUMBER := 0-1962.0724
116: , p0_a3 DATE := fnd_api.g_miss_date
117: , p0_a4 NUMBER := 0-1962.0724
118: , p0_a5 NUMBER := 0-1962.0724
119: , p0_a6 NUMBER := 0-1962.0724
120: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a3 DATE := fnd_api.g_miss_date
117: , p0_a4 NUMBER := 0-1962.0724
118: , p0_a5 NUMBER := 0-1962.0724
119: , p0_a6 NUMBER := 0-1962.0724
120: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
124: );
117: , p0_a4 NUMBER := 0-1962.0724
118: , p0_a5 NUMBER := 0-1962.0724
119: , p0_a6 NUMBER := 0-1962.0724
120: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
124: );
125: procedure init_rec(p0_a0 OUT NOCOPY NUMBER
118: , p0_a5 NUMBER := 0-1962.0724
119: , p0_a6 NUMBER := 0-1962.0724
120: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
124: );
125: procedure init_rec(p0_a0 OUT NOCOPY NUMBER
126: , p0_a1 OUT NOCOPY DATE
119: , p0_a6 NUMBER := 0-1962.0724
120: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
121: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
122: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
123: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
124: );
125: procedure init_rec(p0_a0 OUT NOCOPY NUMBER
126: , p0_a1 OUT NOCOPY DATE
127: , p0_a2 OUT NOCOPY NUMBER