7: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
9: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: , p7_a0 NUMBER := 0-1962.0724
11: , p7_a1 DATE := fnd_api.g_miss_date
12: , p7_a2 NUMBER := 0-1962.0724
13: , p7_a3 DATE := fnd_api.g_miss_date
14: , p7_a4 NUMBER := 0-1962.0724
15: , p7_a5 NUMBER := 0-1962.0724
9: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: , p7_a0 NUMBER := 0-1962.0724
11: , p7_a1 DATE := fnd_api.g_miss_date
12: , p7_a2 NUMBER := 0-1962.0724
13: , p7_a3 DATE := fnd_api.g_miss_date
14: , p7_a4 NUMBER := 0-1962.0724
15: , p7_a5 NUMBER := 0-1962.0724
16: , p7_a6 NUMBER := 0-1962.0724
17: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
13: , p7_a3 DATE := fnd_api.g_miss_date
14: , p7_a4 NUMBER := 0-1962.0724
15: , p7_a5 NUMBER := 0-1962.0724
16: , p7_a6 NUMBER := 0-1962.0724
17: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
18: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20: );
21: procedure check_items(p_validation_mode VARCHAR2
14: , p7_a4 NUMBER := 0-1962.0724
15: , p7_a5 NUMBER := 0-1962.0724
16: , p7_a6 NUMBER := 0-1962.0724
17: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
18: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20: );
21: procedure check_items(p_validation_mode VARCHAR2
22: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15: , p7_a5 NUMBER := 0-1962.0724
16: , p7_a6 NUMBER := 0-1962.0724
17: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
18: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20: );
21: procedure check_items(p_validation_mode VARCHAR2
22: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23: , p2_a0 NUMBER := 0-1962.0724
20: );
21: procedure check_items(p_validation_mode VARCHAR2
22: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23: , p2_a0 NUMBER := 0-1962.0724
24: , p2_a1 DATE := fnd_api.g_miss_date
25: , p2_a2 NUMBER := 0-1962.0724
26: , p2_a3 DATE := fnd_api.g_miss_date
27: , p2_a4 NUMBER := 0-1962.0724
28: , p2_a5 NUMBER := 0-1962.0724
22: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23: , p2_a0 NUMBER := 0-1962.0724
24: , p2_a1 DATE := fnd_api.g_miss_date
25: , p2_a2 NUMBER := 0-1962.0724
26: , p2_a3 DATE := fnd_api.g_miss_date
27: , p2_a4 NUMBER := 0-1962.0724
28: , p2_a5 NUMBER := 0-1962.0724
29: , p2_a6 NUMBER := 0-1962.0724
30: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
26: , p2_a3 DATE := fnd_api.g_miss_date
27: , p2_a4 NUMBER := 0-1962.0724
28: , p2_a5 NUMBER := 0-1962.0724
29: , p2_a6 NUMBER := 0-1962.0724
30: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
31: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
32: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
33: );
34: procedure check_loc_type_req_items(p_validation_mode VARCHAR2
27: , p2_a4 NUMBER := 0-1962.0724
28: , p2_a5 NUMBER := 0-1962.0724
29: , p2_a6 NUMBER := 0-1962.0724
30: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
31: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
32: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
33: );
34: procedure check_loc_type_req_items(p_validation_mode VARCHAR2
35: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , p2_a5 NUMBER := 0-1962.0724
29: , p2_a6 NUMBER := 0-1962.0724
30: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
31: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
32: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
33: );
34: procedure check_loc_type_req_items(p_validation_mode VARCHAR2
35: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , p1_a0 NUMBER := 0-1962.0724
33: );
34: procedure check_loc_type_req_items(p_validation_mode VARCHAR2
35: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , p1_a0 NUMBER := 0-1962.0724
37: , p1_a1 DATE := fnd_api.g_miss_date
38: , p1_a2 NUMBER := 0-1962.0724
39: , p1_a3 DATE := fnd_api.g_miss_date
40: , p1_a4 NUMBER := 0-1962.0724
41: , p1_a5 NUMBER := 0-1962.0724
35: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36: , p1_a0 NUMBER := 0-1962.0724
37: , p1_a1 DATE := fnd_api.g_miss_date
38: , p1_a2 NUMBER := 0-1962.0724
39: , p1_a3 DATE := fnd_api.g_miss_date
40: , p1_a4 NUMBER := 0-1962.0724
41: , p1_a5 NUMBER := 0-1962.0724
42: , p1_a6 NUMBER := 0-1962.0724
43: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
39: , p1_a3 DATE := fnd_api.g_miss_date
40: , p1_a4 NUMBER := 0-1962.0724
41: , p1_a5 NUMBER := 0-1962.0724
42: , p1_a6 NUMBER := 0-1962.0724
43: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
44: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
45: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
46: );
47: procedure check_loc_type_uk_items(p_validation_mode VARCHAR2
40: , p1_a4 NUMBER := 0-1962.0724
41: , p1_a5 NUMBER := 0-1962.0724
42: , p1_a6 NUMBER := 0-1962.0724
43: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
44: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
45: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
46: );
47: procedure check_loc_type_uk_items(p_validation_mode VARCHAR2
48: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41: , p1_a5 NUMBER := 0-1962.0724
42: , p1_a6 NUMBER := 0-1962.0724
43: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
44: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
45: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
46: );
47: procedure check_loc_type_uk_items(p_validation_mode VARCHAR2
48: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49: , p1_a0 NUMBER := 0-1962.0724
46: );
47: procedure check_loc_type_uk_items(p_validation_mode VARCHAR2
48: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49: , p1_a0 NUMBER := 0-1962.0724
50: , p1_a1 DATE := fnd_api.g_miss_date
51: , p1_a2 NUMBER := 0-1962.0724
52: , p1_a3 DATE := fnd_api.g_miss_date
53: , p1_a4 NUMBER := 0-1962.0724
54: , p1_a5 NUMBER := 0-1962.0724
48: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49: , p1_a0 NUMBER := 0-1962.0724
50: , p1_a1 DATE := fnd_api.g_miss_date
51: , p1_a2 NUMBER := 0-1962.0724
52: , p1_a3 DATE := fnd_api.g_miss_date
53: , p1_a4 NUMBER := 0-1962.0724
54: , p1_a5 NUMBER := 0-1962.0724
55: , p1_a6 NUMBER := 0-1962.0724
56: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
52: , p1_a3 DATE := fnd_api.g_miss_date
53: , p1_a4 NUMBER := 0-1962.0724
54: , p1_a5 NUMBER := 0-1962.0724
55: , p1_a6 NUMBER := 0-1962.0724
56: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
59: );
60: end jtf_loc_types_pvt_w;
53: , p1_a4 NUMBER := 0-1962.0724
54: , p1_a5 NUMBER := 0-1962.0724
55: , p1_a6 NUMBER := 0-1962.0724
56: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
59: );
60: end jtf_loc_types_pvt_w;
54: , p1_a5 NUMBER := 0-1962.0724
55: , p1_a6 NUMBER := 0-1962.0724
56: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
59: );
60: end jtf_loc_types_pvt_w;