47: , x_msg_count out nocopy NUMBER
48: , x_msg_data out nocopy VARCHAR2
49: , x_lead_owner_id out nocopy NUMBER
50: , p7_a0 NUMBER := 0-1962.0724
51: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a5 NUMBER := 0-1962.0724
48: , x_msg_data out nocopy VARCHAR2
49: , x_lead_owner_id out nocopy NUMBER
50: , p7_a0 NUMBER := 0-1962.0724
51: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
49: , x_lead_owner_id out nocopy NUMBER
50: , p7_a0 NUMBER := 0-1962.0724
51: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a0 NUMBER := 0-1962.0724
51: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 DATE := fnd_api.g_miss_date
52: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 DATE := fnd_api.g_miss_date
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 DATE := fnd_api.g_miss_date
53: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 DATE := fnd_api.g_miss_date
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 DATE := fnd_api.g_miss_date
61: , p7_a11 NUMBER := 0-1962.0724
54: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a5 NUMBER := 0-1962.0724
56: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 DATE := fnd_api.g_miss_date
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 DATE := fnd_api.g_miss_date
61: , p7_a11 NUMBER := 0-1962.0724
62: , p7_a12 NUMBER := 0-1962.0724
56: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a8 DATE := fnd_api.g_miss_date
59: , p7_a9 NUMBER := 0-1962.0724
60: , p7_a10 DATE := fnd_api.g_miss_date
61: , p7_a11 NUMBER := 0-1962.0724
62: , p7_a12 NUMBER := 0-1962.0724
63: , p7_a13 NUMBER := 0-1962.0724
64: , p7_a14 NUMBER := 0-1962.0724
63: , p7_a13 NUMBER := 0-1962.0724
64: , p7_a14 NUMBER := 0-1962.0724
65: , p7_a15 NUMBER := 0-1962.0724
66: , p7_a16 NUMBER := 0-1962.0724
67: , p7_a17 DATE := fnd_api.g_miss_date
68: );
69: procedure update_lead_owner(p_api_version NUMBER
70: , p_init_msg_list VARCHAR2
71: , p_commit VARCHAR2
73: , x_return_status out nocopy VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p7_a0 NUMBER := 0-1962.0724
77: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a5 NUMBER := 0-1962.0724
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p7_a0 NUMBER := 0-1962.0724
77: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a5 NUMBER := 0-1962.0724
82: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
75: , x_msg_data out nocopy VARCHAR2
76: , p7_a0 NUMBER := 0-1962.0724
77: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a5 NUMBER := 0-1962.0724
82: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
76: , p7_a0 NUMBER := 0-1962.0724
77: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a5 NUMBER := 0-1962.0724
82: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p7_a8 DATE := fnd_api.g_miss_date
78: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
79: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a5 NUMBER := 0-1962.0724
82: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p7_a8 DATE := fnd_api.g_miss_date
85: , p7_a9 NUMBER := 0-1962.0724
86: , p7_a10 DATE := fnd_api.g_miss_date
79: , p7_a3 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a5 NUMBER := 0-1962.0724
82: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p7_a8 DATE := fnd_api.g_miss_date
85: , p7_a9 NUMBER := 0-1962.0724
86: , p7_a10 DATE := fnd_api.g_miss_date
87: , p7_a11 NUMBER := 0-1962.0724
80: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a5 NUMBER := 0-1962.0724
82: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p7_a8 DATE := fnd_api.g_miss_date
85: , p7_a9 NUMBER := 0-1962.0724
86: , p7_a10 DATE := fnd_api.g_miss_date
87: , p7_a11 NUMBER := 0-1962.0724
88: , p7_a12 NUMBER := 0-1962.0724
82: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
84: , p7_a8 DATE := fnd_api.g_miss_date
85: , p7_a9 NUMBER := 0-1962.0724
86: , p7_a10 DATE := fnd_api.g_miss_date
87: , p7_a11 NUMBER := 0-1962.0724
88: , p7_a12 NUMBER := 0-1962.0724
89: , p7_a13 NUMBER := 0-1962.0724
90: , p7_a14 NUMBER := 0-1962.0724
89: , p7_a13 NUMBER := 0-1962.0724
90: , p7_a14 NUMBER := 0-1962.0724
91: , p7_a15 NUMBER := 0-1962.0724
92: , p7_a16 NUMBER := 0-1962.0724
93: , p7_a17 DATE := fnd_api.g_miss_date
94: );
95: procedure get_salesreps(p_api_version NUMBER
96: , p_init_msg_list VARCHAR2
97: , p_commit VARCHAR2