7: , x_return_status out NOCOPY VARCHAR2
8: , x_msg_count out NOCOPY NUMBER
9: , x_msg_data out NOCOPY 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 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 NUMBER := 0-1962.0724
14: , p7_a4 NUMBER := 0-1962.0724
15: , p7_a5 NUMBER := 0-1962.0724
16: , p7_a6 NUMBER := 0-1962.0724
17: , p7_a7 NUMBER := 0-1962.0724
18: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
22: , p7_a12 NUMBER := 0-1962.0724
15: , p7_a5 NUMBER := 0-1962.0724
16: , p7_a6 NUMBER := 0-1962.0724
17: , p7_a7 NUMBER := 0-1962.0724
18: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
22: , p7_a12 NUMBER := 0-1962.0724
23: , p7_a13 NUMBER := 0-1962.0724
16: , p7_a6 NUMBER := 0-1962.0724
17: , p7_a7 NUMBER := 0-1962.0724
18: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
22: , p7_a12 NUMBER := 0-1962.0724
23: , p7_a13 NUMBER := 0-1962.0724
24: , x_act_offer_id out NOCOPY NUMBER
17: , p7_a7 NUMBER := 0-1962.0724
18: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
22: , p7_a12 NUMBER := 0-1962.0724
23: , p7_a13 NUMBER := 0-1962.0724
24: , x_act_offer_id out NOCOPY NUMBER
25: );
30: , x_return_status out NOCOPY VARCHAR2
31: , x_msg_count out NOCOPY NUMBER
32: , x_msg_data out NOCOPY VARCHAR2
33: , p7_a0 NUMBER := 0-1962.0724
34: , p7_a1 DATE := fnd_api.g_miss_date
35: , p7_a2 NUMBER := 0-1962.0724
36: , p7_a3 DATE := fnd_api.g_miss_date
37: , p7_a4 NUMBER := 0-1962.0724
38: , p7_a5 NUMBER := 0-1962.0724
32: , x_msg_data out NOCOPY VARCHAR2
33: , p7_a0 NUMBER := 0-1962.0724
34: , p7_a1 DATE := fnd_api.g_miss_date
35: , p7_a2 NUMBER := 0-1962.0724
36: , p7_a3 DATE := fnd_api.g_miss_date
37: , p7_a4 NUMBER := 0-1962.0724
38: , p7_a5 NUMBER := 0-1962.0724
39: , p7_a6 NUMBER := 0-1962.0724
40: , p7_a7 NUMBER := 0-1962.0724
37: , p7_a4 NUMBER := 0-1962.0724
38: , p7_a5 NUMBER := 0-1962.0724
39: , p7_a6 NUMBER := 0-1962.0724
40: , p7_a7 NUMBER := 0-1962.0724
41: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a12 NUMBER := 0-1962.0724
38: , p7_a5 NUMBER := 0-1962.0724
39: , p7_a6 NUMBER := 0-1962.0724
40: , p7_a7 NUMBER := 0-1962.0724
41: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a12 NUMBER := 0-1962.0724
46: , p7_a13 NUMBER := 0-1962.0724
39: , p7_a6 NUMBER := 0-1962.0724
40: , p7_a7 NUMBER := 0-1962.0724
41: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a12 NUMBER := 0-1962.0724
46: , p7_a13 NUMBER := 0-1962.0724
47: );
40: , p7_a7 NUMBER := 0-1962.0724
41: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a12 NUMBER := 0-1962.0724
46: , p7_a13 NUMBER := 0-1962.0724
47: );
48: procedure validate_act_offer(p_api_version NUMBER
51: , x_return_status out NOCOPY VARCHAR2
52: , x_msg_count out NOCOPY NUMBER
53: , x_msg_data out NOCOPY VARCHAR2
54: , p6_a0 NUMBER := 0-1962.0724
55: , p6_a1 DATE := fnd_api.g_miss_date
56: , p6_a2 NUMBER := 0-1962.0724
57: , p6_a3 DATE := fnd_api.g_miss_date
58: , p6_a4 NUMBER := 0-1962.0724
59: , p6_a5 NUMBER := 0-1962.0724
53: , x_msg_data out NOCOPY VARCHAR2
54: , p6_a0 NUMBER := 0-1962.0724
55: , p6_a1 DATE := fnd_api.g_miss_date
56: , p6_a2 NUMBER := 0-1962.0724
57: , p6_a3 DATE := fnd_api.g_miss_date
58: , p6_a4 NUMBER := 0-1962.0724
59: , p6_a5 NUMBER := 0-1962.0724
60: , p6_a6 NUMBER := 0-1962.0724
61: , p6_a7 NUMBER := 0-1962.0724
58: , p6_a4 NUMBER := 0-1962.0724
59: , p6_a5 NUMBER := 0-1962.0724
60: , p6_a6 NUMBER := 0-1962.0724
61: , p6_a7 NUMBER := 0-1962.0724
62: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
65: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
66: , p6_a12 NUMBER := 0-1962.0724
59: , p6_a5 NUMBER := 0-1962.0724
60: , p6_a6 NUMBER := 0-1962.0724
61: , p6_a7 NUMBER := 0-1962.0724
62: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
65: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
66: , p6_a12 NUMBER := 0-1962.0724
67: , p6_a13 NUMBER := 0-1962.0724
60: , p6_a6 NUMBER := 0-1962.0724
61: , p6_a7 NUMBER := 0-1962.0724
62: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
65: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
66: , p6_a12 NUMBER := 0-1962.0724
67: , p6_a13 NUMBER := 0-1962.0724
68: );
61: , p6_a7 NUMBER := 0-1962.0724
62: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
65: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
66: , p6_a12 NUMBER := 0-1962.0724
67: , p6_a13 NUMBER := 0-1962.0724
68: );
69: procedure check_items(p_validation_mode VARCHAR2
68: );
69: procedure check_items(p_validation_mode VARCHAR2
70: , x_return_status out NOCOPY VARCHAR2
71: , p2_a0 NUMBER := 0-1962.0724
72: , p2_a1 DATE := fnd_api.g_miss_date
73: , p2_a2 NUMBER := 0-1962.0724
74: , p2_a3 DATE := fnd_api.g_miss_date
75: , p2_a4 NUMBER := 0-1962.0724
76: , p2_a5 NUMBER := 0-1962.0724
70: , x_return_status out NOCOPY VARCHAR2
71: , p2_a0 NUMBER := 0-1962.0724
72: , p2_a1 DATE := fnd_api.g_miss_date
73: , p2_a2 NUMBER := 0-1962.0724
74: , p2_a3 DATE := fnd_api.g_miss_date
75: , p2_a4 NUMBER := 0-1962.0724
76: , p2_a5 NUMBER := 0-1962.0724
77: , p2_a6 NUMBER := 0-1962.0724
78: , p2_a7 NUMBER := 0-1962.0724
75: , p2_a4 NUMBER := 0-1962.0724
76: , p2_a5 NUMBER := 0-1962.0724
77: , p2_a6 NUMBER := 0-1962.0724
78: , p2_a7 NUMBER := 0-1962.0724
79: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
81: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
82: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
83: , p2_a12 NUMBER := 0-1962.0724
76: , p2_a5 NUMBER := 0-1962.0724
77: , p2_a6 NUMBER := 0-1962.0724
78: , p2_a7 NUMBER := 0-1962.0724
79: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
81: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
82: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
83: , p2_a12 NUMBER := 0-1962.0724
84: , p2_a13 NUMBER := 0-1962.0724
77: , p2_a6 NUMBER := 0-1962.0724
78: , p2_a7 NUMBER := 0-1962.0724
79: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
81: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
82: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
83: , p2_a12 NUMBER := 0-1962.0724
84: , p2_a13 NUMBER := 0-1962.0724
85: );
78: , p2_a7 NUMBER := 0-1962.0724
79: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
81: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
82: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
83: , p2_a12 NUMBER := 0-1962.0724
84: , p2_a13 NUMBER := 0-1962.0724
85: );
86: procedure check_record(p0_a0 NUMBER