1: PACKAGE HZ_MERGE_PKG AUTHID CURRENT_USER AS
2: /*$Header: ARHMPKGS.pls 120.6 2005/07/29 16:46:28 vsegu noship $ */
3: PROCEDURE party_merge(
4: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
5: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
6: x_to_id IN OUT NOCOPY NUMBER,
7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1: PACKAGE HZ_MERGE_PKG AUTHID CURRENT_USER AS
2: /*$Header: ARHMPKGS.pls 120.6 2005/07/29 16:46:28 vsegu noship $ */
3: PROCEDURE party_merge(
4: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
5: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
6: x_to_id IN OUT NOCOPY NUMBER,
7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
3: PROCEDURE party_merge(
4: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
5: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
6: x_to_id IN OUT NOCOPY NUMBER,
7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
10: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
11: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
4: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
5: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
6: x_to_id IN OUT NOCOPY NUMBER,
7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
10: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
11: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_return_status OUT NOCOPY VARCHAR2
5: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
6: x_to_id IN OUT NOCOPY NUMBER,
7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
10: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
11: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_return_status OUT NOCOPY VARCHAR2
13: );
6: x_to_id IN OUT NOCOPY NUMBER,
7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
10: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
11: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_return_status OUT NOCOPY VARCHAR2
13: );
14: PROCEDURE party_reln_object_merge(
7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
10: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
11: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_return_status OUT NOCOPY VARCHAR2
13: );
14: PROCEDURE party_reln_object_merge(
15: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
11: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_return_status OUT NOCOPY VARCHAR2
13: );
14: PROCEDURE party_reln_object_merge(
15: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
16: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_to_id IN OUT NOCOPY NUMBER,
18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_return_status OUT NOCOPY VARCHAR2
13: );
14: PROCEDURE party_reln_object_merge(
15: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
16: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_to_id IN OUT NOCOPY NUMBER,
18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
20: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
14: PROCEDURE party_reln_object_merge(
15: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
16: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_to_id IN OUT NOCOPY NUMBER,
18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
20: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
21: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
22: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
15: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
16: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_to_id IN OUT NOCOPY NUMBER,
18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
20: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
21: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
22: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
23: x_return_status OUT NOCOPY VARCHAR2
16: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_to_id IN OUT NOCOPY NUMBER,
18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
20: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
21: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
22: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
23: x_return_status OUT NOCOPY VARCHAR2
24: );
17: x_to_id IN OUT NOCOPY NUMBER,
18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
20: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
21: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
22: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
23: x_return_status OUT NOCOPY VARCHAR2
24: );
25: PROCEDURE party_reln_subject_merge(
18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
19: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
20: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
21: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
22: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
23: x_return_status OUT NOCOPY VARCHAR2
24: );
25: PROCEDURE party_reln_subject_merge(
26: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
22: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
23: x_return_status OUT NOCOPY VARCHAR2
24: );
25: PROCEDURE party_reln_subject_merge(
26: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
27: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
28: x_to_id IN OUT NOCOPY NUMBER,
29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
23: x_return_status OUT NOCOPY VARCHAR2
24: );
25: PROCEDURE party_reln_subject_merge(
26: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
27: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
28: x_to_id IN OUT NOCOPY NUMBER,
29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
31: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
25: PROCEDURE party_reln_subject_merge(
26: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
27: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
28: x_to_id IN OUT NOCOPY NUMBER,
29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
31: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
32: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
33: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
26: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
27: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
28: x_to_id IN OUT NOCOPY NUMBER,
29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
31: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
32: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
33: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
34: x_return_status OUT NOCOPY VARCHAR2
27: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
28: x_to_id IN OUT NOCOPY NUMBER,
29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
31: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
32: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
33: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
34: x_return_status OUT NOCOPY VARCHAR2
35: );
28: x_to_id IN OUT NOCOPY NUMBER,
29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
31: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
32: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
33: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
34: x_return_status OUT NOCOPY VARCHAR2
35: );
36: PROCEDURE party_relationship_merge(
29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
31: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
32: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
33: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
34: x_return_status OUT NOCOPY VARCHAR2
35: );
36: PROCEDURE party_relationship_merge(
37: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
33: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
34: x_return_status OUT NOCOPY VARCHAR2
35: );
36: PROCEDURE party_relationship_merge(
37: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
38: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
39: x_to_id IN OUT NOCOPY NUMBER,
40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
34: x_return_status OUT NOCOPY VARCHAR2
35: );
36: PROCEDURE party_relationship_merge(
37: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
38: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
39: x_to_id IN OUT NOCOPY NUMBER,
40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
42: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
36: PROCEDURE party_relationship_merge(
37: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
38: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
39: x_to_id IN OUT NOCOPY NUMBER,
40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
42: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
43: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
44: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
37: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
38: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
39: x_to_id IN OUT NOCOPY NUMBER,
40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
42: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
43: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
44: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
45: x_return_status OUT NOCOPY VARCHAR2
38: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
39: x_to_id IN OUT NOCOPY NUMBER,
40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
42: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
43: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
44: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
45: x_return_status OUT NOCOPY VARCHAR2
46: );
39: x_to_id IN OUT NOCOPY NUMBER,
40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
42: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
43: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
44: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
45: x_return_status OUT NOCOPY VARCHAR2
46: );
47: PROCEDURE org_profile_merge(
40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
42: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
43: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
44: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
45: x_return_status OUT NOCOPY VARCHAR2
46: );
47: PROCEDURE org_profile_merge(
48: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
44: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
45: x_return_status OUT NOCOPY VARCHAR2
46: );
47: PROCEDURE org_profile_merge(
48: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
49: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_to_id IN OUT NOCOPY NUMBER,
51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
45: x_return_status OUT NOCOPY VARCHAR2
46: );
47: PROCEDURE org_profile_merge(
48: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
49: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_to_id IN OUT NOCOPY NUMBER,
51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
47: PROCEDURE org_profile_merge(
48: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
49: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_to_id IN OUT NOCOPY NUMBER,
51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
54: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
55: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
48: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
49: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_to_id IN OUT NOCOPY NUMBER,
51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
54: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
55: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
56: x_return_status OUT NOCOPY VARCHAR2
49: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_to_id IN OUT NOCOPY NUMBER,
51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
54: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
55: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
50: x_to_id IN OUT NOCOPY NUMBER,
51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
54: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
55: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
58: PROCEDURE per_profile_merge(
51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
52: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
54: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
55: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
58: PROCEDURE per_profile_merge(
59: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
55: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
58: PROCEDURE per_profile_merge(
59: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
60: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
61: x_to_id IN OUT NOCOPY NUMBER,
62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
56: x_return_status OUT NOCOPY VARCHAR2
57: );
58: PROCEDURE per_profile_merge(
59: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
60: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
61: x_to_id IN OUT NOCOPY NUMBER,
62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
64: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
58: PROCEDURE per_profile_merge(
59: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
60: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
61: x_to_id IN OUT NOCOPY NUMBER,
62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
64: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
65: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
66: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
59: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
60: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
61: x_to_id IN OUT NOCOPY NUMBER,
62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
64: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
65: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
66: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
67: x_return_status OUT NOCOPY VARCHAR2
60: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
61: x_to_id IN OUT NOCOPY NUMBER,
62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
64: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
65: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
66: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
67: x_return_status OUT NOCOPY VARCHAR2
68: );
61: x_to_id IN OUT NOCOPY NUMBER,
62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
64: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
65: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
66: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
67: x_return_status OUT NOCOPY VARCHAR2
68: );
69: PROCEDURE org_contact_merge(
62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
64: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
65: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
66: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
67: x_return_status OUT NOCOPY VARCHAR2
68: );
69: PROCEDURE org_contact_merge(
70: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
66: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
67: x_return_status OUT NOCOPY VARCHAR2
68: );
69: PROCEDURE org_contact_merge(
70: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
71: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
72: x_to_id IN OUT NOCOPY NUMBER,
73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
67: x_return_status OUT NOCOPY VARCHAR2
68: );
69: PROCEDURE org_contact_merge(
70: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
71: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
72: x_to_id IN OUT NOCOPY NUMBER,
73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
69: PROCEDURE org_contact_merge(
70: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
71: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
72: x_to_id IN OUT NOCOPY NUMBER,
73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
76: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
77: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
70: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
71: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
72: x_to_id IN OUT NOCOPY NUMBER,
73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
76: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
77: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
78: x_return_status OUT NOCOPY VARCHAR2
71: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
72: x_to_id IN OUT NOCOPY NUMBER,
73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
76: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
77: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
78: x_return_status OUT NOCOPY VARCHAR2
79: );
72: x_to_id IN OUT NOCOPY NUMBER,
73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
76: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
77: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
78: x_return_status OUT NOCOPY VARCHAR2
79: );
80: PROCEDURE cust_account_merge(
73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
76: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
77: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
78: x_return_status OUT NOCOPY VARCHAR2
79: );
80: PROCEDURE cust_account_merge(
81: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
77: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
78: x_return_status OUT NOCOPY VARCHAR2
79: );
80: PROCEDURE cust_account_merge(
81: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
82: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
83: x_to_id IN OUT NOCOPY NUMBER,
84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
78: x_return_status OUT NOCOPY VARCHAR2
79: );
80: PROCEDURE cust_account_merge(
81: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
82: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
83: x_to_id IN OUT NOCOPY NUMBER,
84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
86: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
80: PROCEDURE cust_account_merge(
81: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
82: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
83: x_to_id IN OUT NOCOPY NUMBER,
84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
86: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
87: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
88: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
81: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
82: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
83: x_to_id IN OUT NOCOPY NUMBER,
84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
86: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
87: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
88: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
89: x_return_status OUT NOCOPY VARCHAR2
82: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
83: x_to_id IN OUT NOCOPY NUMBER,
84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
86: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
87: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
88: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
89: x_return_status OUT NOCOPY VARCHAR2
90: );
83: x_to_id IN OUT NOCOPY NUMBER,
84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
86: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
87: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
88: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
89: x_return_status OUT NOCOPY VARCHAR2
90: );
91: PROCEDURE cust_account_role_merge(
84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
86: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
87: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
88: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
89: x_return_status OUT NOCOPY VARCHAR2
90: );
91: PROCEDURE cust_account_role_merge(
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
88: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
89: x_return_status OUT NOCOPY VARCHAR2
90: );
91: PROCEDURE cust_account_role_merge(
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
89: x_return_status OUT NOCOPY VARCHAR2
90: );
91: PROCEDURE cust_account_role_merge(
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
91: PROCEDURE cust_account_role_merge(
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
102: PROCEDURE cust_account_site_merge(
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
102: PROCEDURE cust_account_site_merge(
103: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
102: PROCEDURE cust_account_site_merge(
103: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
104: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
105: x_to_id IN OUT NOCOPY NUMBER,
106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
102: PROCEDURE cust_account_site_merge(
103: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
104: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
105: x_to_id IN OUT NOCOPY NUMBER,
106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
108: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
102: PROCEDURE cust_account_site_merge(
103: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
104: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
105: x_to_id IN OUT NOCOPY NUMBER,
106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
108: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
109: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
110: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
103: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
104: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
105: x_to_id IN OUT NOCOPY NUMBER,
106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
108: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
109: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
110: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_return_status OUT NOCOPY VARCHAR2
104: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
105: x_to_id IN OUT NOCOPY NUMBER,
106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
108: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
109: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
110: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_return_status OUT NOCOPY VARCHAR2
112: );
105: x_to_id IN OUT NOCOPY NUMBER,
106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
108: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
109: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
110: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_return_status OUT NOCOPY VARCHAR2
112: );
113: PROCEDURE contact_point_merge(
106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
107: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
108: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
109: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
110: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_return_status OUT NOCOPY VARCHAR2
112: );
113: PROCEDURE contact_point_merge(
114: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
110: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_return_status OUT NOCOPY VARCHAR2
112: );
113: PROCEDURE contact_point_merge(
114: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
115: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
116: x_to_id IN OUT NOCOPY NUMBER,
117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_return_status OUT NOCOPY VARCHAR2
112: );
113: PROCEDURE contact_point_merge(
114: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
115: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
116: x_to_id IN OUT NOCOPY NUMBER,
117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
119: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
113: PROCEDURE contact_point_merge(
114: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
115: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
116: x_to_id IN OUT NOCOPY NUMBER,
117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
119: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
120: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
114: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
115: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
116: x_to_id IN OUT NOCOPY NUMBER,
117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
119: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
120: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status OUT NOCOPY VARCHAR2
115: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
116: x_to_id IN OUT NOCOPY NUMBER,
117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
119: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
120: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status OUT NOCOPY VARCHAR2
123: );
116: x_to_id IN OUT NOCOPY NUMBER,
117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
119: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
120: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status OUT NOCOPY VARCHAR2
123: );
124: PROCEDURE financial_profile_merge(
117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
118: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
119: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
120: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status OUT NOCOPY VARCHAR2
123: );
124: PROCEDURE financial_profile_merge(
125: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
121: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status OUT NOCOPY VARCHAR2
123: );
124: PROCEDURE financial_profile_merge(
125: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
126: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
127: x_to_id IN OUT NOCOPY NUMBER,
128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status OUT NOCOPY VARCHAR2
123: );
124: PROCEDURE financial_profile_merge(
125: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
126: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
127: x_to_id IN OUT NOCOPY NUMBER,
128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
124: PROCEDURE financial_profile_merge(
125: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
126: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
127: x_to_id IN OUT NOCOPY NUMBER,
128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
131: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
132: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
125: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
126: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
127: x_to_id IN OUT NOCOPY NUMBER,
128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
131: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
132: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
133: x_return_status OUT NOCOPY VARCHAR2
126: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
127: x_to_id IN OUT NOCOPY NUMBER,
128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
131: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
132: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
133: x_return_status OUT NOCOPY VARCHAR2
134: );
127: x_to_id IN OUT NOCOPY NUMBER,
128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
131: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
132: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
133: x_return_status OUT NOCOPY VARCHAR2
134: );
135: PROCEDURE references_merge(
128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
131: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
132: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
133: x_return_status OUT NOCOPY VARCHAR2
134: );
135: PROCEDURE references_merge(
136: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
132: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
133: x_return_status OUT NOCOPY VARCHAR2
134: );
135: PROCEDURE references_merge(
136: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
137: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_to_id IN OUT NOCOPY NUMBER,
139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
133: x_return_status OUT NOCOPY VARCHAR2
134: );
135: PROCEDURE references_merge(
136: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
137: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_to_id IN OUT NOCOPY NUMBER,
139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
141: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
135: PROCEDURE references_merge(
136: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
137: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_to_id IN OUT NOCOPY NUMBER,
139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
141: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
142: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
143: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
136: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
137: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_to_id IN OUT NOCOPY NUMBER,
139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
141: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
142: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
143: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
144: x_return_status OUT NOCOPY VARCHAR2
137: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_to_id IN OUT NOCOPY NUMBER,
139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
141: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
142: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
143: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
138: x_to_id IN OUT NOCOPY NUMBER,
139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
141: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
142: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
143: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146: PROCEDURE certification_merge(
139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
140: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
141: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
142: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
143: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146: PROCEDURE certification_merge(
147: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
143: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146: PROCEDURE certification_merge(
147: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
148: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
149: x_to_id IN OUT NOCOPY NUMBER,
150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146: PROCEDURE certification_merge(
147: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
148: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
149: x_to_id IN OUT NOCOPY NUMBER,
150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
152: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
146: PROCEDURE certification_merge(
147: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
148: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
149: x_to_id IN OUT NOCOPY NUMBER,
150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
152: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
153: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
154: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
147: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
148: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
149: x_to_id IN OUT NOCOPY NUMBER,
150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
152: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
153: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
154: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
155: x_return_status OUT NOCOPY VARCHAR2
148: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
149: x_to_id IN OUT NOCOPY NUMBER,
150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
152: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
153: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
154: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
155: x_return_status OUT NOCOPY VARCHAR2
156: );
149: x_to_id IN OUT NOCOPY NUMBER,
150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
152: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
153: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
154: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
155: x_return_status OUT NOCOPY VARCHAR2
156: );
157: PROCEDURE credit_ratings_merge(
150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
151: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
152: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
153: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
154: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
155: x_return_status OUT NOCOPY VARCHAR2
156: );
157: PROCEDURE credit_ratings_merge(
158: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
154: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
155: x_return_status OUT NOCOPY VARCHAR2
156: );
157: PROCEDURE credit_ratings_merge(
158: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
159: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
160: x_to_id IN OUT NOCOPY NUMBER,
161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
155: x_return_status OUT NOCOPY VARCHAR2
156: );
157: PROCEDURE credit_ratings_merge(
158: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
159: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
160: x_to_id IN OUT NOCOPY NUMBER,
161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
163: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
157: PROCEDURE credit_ratings_merge(
158: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
159: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
160: x_to_id IN OUT NOCOPY NUMBER,
161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
163: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
164: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
165: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
158: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
159: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
160: x_to_id IN OUT NOCOPY NUMBER,
161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
163: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
164: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
165: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_return_status OUT NOCOPY VARCHAR2
159: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
160: x_to_id IN OUT NOCOPY NUMBER,
161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
163: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
164: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
165: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_return_status OUT NOCOPY VARCHAR2
167: );
160: x_to_id IN OUT NOCOPY NUMBER,
161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
163: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
164: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
165: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_return_status OUT NOCOPY VARCHAR2
167: );
168: PROCEDURE party_site_merge(
161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
163: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
164: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
165: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_return_status OUT NOCOPY VARCHAR2
167: );
168: PROCEDURE party_site_merge(
169: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
165: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_return_status OUT NOCOPY VARCHAR2
167: );
168: PROCEDURE party_site_merge(
169: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
170: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
171: x_to_id IN OUT NOCOPY NUMBER,
172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_return_status OUT NOCOPY VARCHAR2
167: );
168: PROCEDURE party_site_merge(
169: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
170: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
171: x_to_id IN OUT NOCOPY NUMBER,
172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
174: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
168: PROCEDURE party_site_merge(
169: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
170: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
171: x_to_id IN OUT NOCOPY NUMBER,
172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
174: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
175: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
176: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
169: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
170: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
171: x_to_id IN OUT NOCOPY NUMBER,
172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
174: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
175: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
176: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
177: x_return_status OUT NOCOPY VARCHAR2
170: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
171: x_to_id IN OUT NOCOPY NUMBER,
172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
174: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
175: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
176: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
177: x_return_status OUT NOCOPY VARCHAR2
178: );
171: x_to_id IN OUT NOCOPY NUMBER,
172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
174: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
175: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
176: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
177: x_return_status OUT NOCOPY VARCHAR2
178: );
179: PROCEDURE org_contact_merge2(
172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
173: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
174: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
175: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
176: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
177: x_return_status OUT NOCOPY VARCHAR2
178: );
179: PROCEDURE org_contact_merge2(
180: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
176: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
177: x_return_status OUT NOCOPY VARCHAR2
178: );
179: PROCEDURE org_contact_merge2(
180: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
181: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
182: x_to_id IN OUT NOCOPY NUMBER,
183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
177: x_return_status OUT NOCOPY VARCHAR2
178: );
179: PROCEDURE org_contact_merge2(
180: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
181: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
182: x_to_id IN OUT NOCOPY NUMBER,
183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
179: PROCEDURE org_contact_merge2(
180: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
181: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
182: x_to_id IN OUT NOCOPY NUMBER,
183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
186: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
187: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
180: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
181: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
182: x_to_id IN OUT NOCOPY NUMBER,
183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
186: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
187: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
188: x_return_status OUT NOCOPY VARCHAR2
181: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
182: x_to_id IN OUT NOCOPY NUMBER,
183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
186: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
187: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
188: x_return_status OUT NOCOPY VARCHAR2
189: );
182: x_to_id IN OUT NOCOPY NUMBER,
183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
186: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
187: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
188: x_return_status OUT NOCOPY VARCHAR2
189: );
190: PROCEDURE contact_point_merge2(
183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
184: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
186: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
187: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
188: x_return_status OUT NOCOPY VARCHAR2
189: );
190: PROCEDURE contact_point_merge2(
191: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
187: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
188: x_return_status OUT NOCOPY VARCHAR2
189: );
190: PROCEDURE contact_point_merge2(
191: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
192: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
193: x_to_id IN OUT NOCOPY NUMBER,
194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
188: x_return_status OUT NOCOPY VARCHAR2
189: );
190: PROCEDURE contact_point_merge2(
191: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
192: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
193: x_to_id IN OUT NOCOPY NUMBER,
194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
196: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
190: PROCEDURE contact_point_merge2(
191: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
192: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
193: x_to_id IN OUT NOCOPY NUMBER,
194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
196: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
197: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
198: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
191: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
192: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
193: x_to_id IN OUT NOCOPY NUMBER,
194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
196: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
197: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
198: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
199: x_return_status OUT NOCOPY VARCHAR2
192: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
193: x_to_id IN OUT NOCOPY NUMBER,
194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
196: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
197: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
198: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
199: x_return_status OUT NOCOPY VARCHAR2
200: );
193: x_to_id IN OUT NOCOPY NUMBER,
194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
196: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
197: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
198: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
199: x_return_status OUT NOCOPY VARCHAR2
200: );
201: PROCEDURE party_site_use_merge(
194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
196: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
197: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
198: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
199: x_return_status OUT NOCOPY VARCHAR2
200: );
201: PROCEDURE party_site_use_merge(
202: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
198: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
199: x_return_status OUT NOCOPY VARCHAR2
200: );
201: PROCEDURE party_site_use_merge(
202: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
203: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
204: x_to_id IN OUT NOCOPY NUMBER,
205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
199: x_return_status OUT NOCOPY VARCHAR2
200: );
201: PROCEDURE party_site_use_merge(
202: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
203: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
204: x_to_id IN OUT NOCOPY NUMBER,
205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
207: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
201: PROCEDURE party_site_use_merge(
202: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
203: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
204: x_to_id IN OUT NOCOPY NUMBER,
205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
207: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
208: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
209: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
202: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
203: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
204: x_to_id IN OUT NOCOPY NUMBER,
205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
207: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
208: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
209: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
210: x_return_status OUT NOCOPY VARCHAR2
203: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
204: x_to_id IN OUT NOCOPY NUMBER,
205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
207: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
208: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
209: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
210: x_return_status OUT NOCOPY VARCHAR2
211: );
204: x_to_id IN OUT NOCOPY NUMBER,
205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
207: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
208: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
209: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
210: x_return_status OUT NOCOPY VARCHAR2
211: );
212: PROCEDURE contact_preference_merge(
205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
206: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
207: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
208: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
209: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
210: x_return_status OUT NOCOPY VARCHAR2
211: );
212: PROCEDURE contact_preference_merge(
213: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
209: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
210: x_return_status OUT NOCOPY VARCHAR2
211: );
212: PROCEDURE contact_preference_merge(
213: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
214: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
215: x_to_id IN OUT NOCOPY NUMBER,
216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
210: x_return_status OUT NOCOPY VARCHAR2
211: );
212: PROCEDURE contact_preference_merge(
213: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
214: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
215: x_to_id IN OUT NOCOPY NUMBER,
216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
218: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
212: PROCEDURE contact_preference_merge(
213: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
214: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
215: x_to_id IN OUT NOCOPY NUMBER,
216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
218: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
219: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
220: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
213: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
214: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
215: x_to_id IN OUT NOCOPY NUMBER,
216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
218: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
219: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
220: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
221: x_return_status OUT NOCOPY VARCHAR2
214: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
215: x_to_id IN OUT NOCOPY NUMBER,
216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
218: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
219: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
220: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
221: x_return_status OUT NOCOPY VARCHAR2
222: );
215: x_to_id IN OUT NOCOPY NUMBER,
216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
218: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
219: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
220: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
221: x_return_status OUT NOCOPY VARCHAR2
222: );
223: PROCEDURE contact_preference_merge2(
216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
217: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
218: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
219: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
220: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
221: x_return_status OUT NOCOPY VARCHAR2
222: );
223: PROCEDURE contact_preference_merge2(
224: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
220: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
221: x_return_status OUT NOCOPY VARCHAR2
222: );
223: PROCEDURE contact_preference_merge2(
224: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
225: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
226: x_to_id IN OUT NOCOPY NUMBER,
227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
221: x_return_status OUT NOCOPY VARCHAR2
222: );
223: PROCEDURE contact_preference_merge2(
224: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
225: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
226: x_to_id IN OUT NOCOPY NUMBER,
227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
229: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
223: PROCEDURE contact_preference_merge2(
224: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
225: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
226: x_to_id IN OUT NOCOPY NUMBER,
227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
229: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
230: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
231: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
224: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
225: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
226: x_to_id IN OUT NOCOPY NUMBER,
227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
229: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
230: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
231: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
232: x_return_status OUT NOCOPY VARCHAR2
225: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
226: x_to_id IN OUT NOCOPY NUMBER,
227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
229: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
230: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
231: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
232: x_return_status OUT NOCOPY VARCHAR2
233: );
226: x_to_id IN OUT NOCOPY NUMBER,
227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
229: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
230: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
231: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
232: x_return_status OUT NOCOPY VARCHAR2
233: );
234: PROCEDURE contact_preference_merge3(
227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
228: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
229: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
230: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
231: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
232: x_return_status OUT NOCOPY VARCHAR2
233: );
234: PROCEDURE contact_preference_merge3(
235: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
231: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
232: x_return_status OUT NOCOPY VARCHAR2
233: );
234: PROCEDURE contact_preference_merge3(
235: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
236: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
237: x_to_id IN OUT NOCOPY NUMBER,
238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
232: x_return_status OUT NOCOPY VARCHAR2
233: );
234: PROCEDURE contact_preference_merge3(
235: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
236: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
237: x_to_id IN OUT NOCOPY NUMBER,
238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
240: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
234: PROCEDURE contact_preference_merge3(
235: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
236: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
237: x_to_id IN OUT NOCOPY NUMBER,
238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
240: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
241: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
242: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
235: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
236: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
237: x_to_id IN OUT NOCOPY NUMBER,
238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
240: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
241: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
242: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
243: x_return_status OUT NOCOPY VARCHAR2
236: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
237: x_to_id IN OUT NOCOPY NUMBER,
238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
240: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
241: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
242: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
243: x_return_status OUT NOCOPY VARCHAR2
244: );
237: x_to_id IN OUT NOCOPY NUMBER,
238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
240: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
241: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
242: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
243: x_return_status OUT NOCOPY VARCHAR2
244: );
245: PROCEDURE security_issued_merge(
238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
239: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
240: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
241: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
242: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
243: x_return_status OUT NOCOPY VARCHAR2
244: );
245: PROCEDURE security_issued_merge(
246: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
242: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
243: x_return_status OUT NOCOPY VARCHAR2
244: );
245: PROCEDURE security_issued_merge(
246: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
247: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
248: x_to_id IN OUT NOCOPY NUMBER,
249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
243: x_return_status OUT NOCOPY VARCHAR2
244: );
245: PROCEDURE security_issued_merge(
246: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
247: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
248: x_to_id IN OUT NOCOPY NUMBER,
249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
251: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
245: PROCEDURE security_issued_merge(
246: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
247: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
248: x_to_id IN OUT NOCOPY NUMBER,
249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
251: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
252: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
253: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
246: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
247: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
248: x_to_id IN OUT NOCOPY NUMBER,
249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
251: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
252: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
253: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
254: x_return_status OUT NOCOPY VARCHAR2
247: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
248: x_to_id IN OUT NOCOPY NUMBER,
249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
251: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
252: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
253: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
254: x_return_status OUT NOCOPY VARCHAR2
255: );
248: x_to_id IN OUT NOCOPY NUMBER,
249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
251: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
252: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
253: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
254: x_return_status OUT NOCOPY VARCHAR2
255: );
256: PROCEDURE financial_reports_merge(
249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
250: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
251: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
252: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
253: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
254: x_return_status OUT NOCOPY VARCHAR2
255: );
256: PROCEDURE financial_reports_merge(
257: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
253: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
254: x_return_status OUT NOCOPY VARCHAR2
255: );
256: PROCEDURE financial_reports_merge(
257: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
258: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
259: x_to_id IN OUT NOCOPY NUMBER,
260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
254: x_return_status OUT NOCOPY VARCHAR2
255: );
256: PROCEDURE financial_reports_merge(
257: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
258: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
259: x_to_id IN OUT NOCOPY NUMBER,
260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
262: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
256: PROCEDURE financial_reports_merge(
257: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
258: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
259: x_to_id IN OUT NOCOPY NUMBER,
260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
262: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
263: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
264: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
257: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
258: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
259: x_to_id IN OUT NOCOPY NUMBER,
260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
262: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
263: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
264: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
265: x_return_status OUT NOCOPY VARCHAR2
258: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
259: x_to_id IN OUT NOCOPY NUMBER,
260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
262: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
263: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
264: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
265: x_return_status OUT NOCOPY VARCHAR2
266: );
259: x_to_id IN OUT NOCOPY NUMBER,
260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
262: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
263: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
264: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
265: x_return_status OUT NOCOPY VARCHAR2
266: );
267: PROCEDURE org_indicators_merge(
260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
261: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
262: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
263: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
264: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
265: x_return_status OUT NOCOPY VARCHAR2
266: );
267: PROCEDURE org_indicators_merge(
268: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
264: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
265: x_return_status OUT NOCOPY VARCHAR2
266: );
267: PROCEDURE org_indicators_merge(
268: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
269: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
270: x_to_id IN OUT NOCOPY NUMBER,
271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
265: x_return_status OUT NOCOPY VARCHAR2
266: );
267: PROCEDURE org_indicators_merge(
268: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
269: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
270: x_to_id IN OUT NOCOPY NUMBER,
271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
273: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
267: PROCEDURE org_indicators_merge(
268: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
269: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
270: x_to_id IN OUT NOCOPY NUMBER,
271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
273: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
274: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
275: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
268: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
269: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
270: x_to_id IN OUT NOCOPY NUMBER,
271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
273: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
274: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
275: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
276: x_return_status OUT NOCOPY VARCHAR2
269: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
270: x_to_id IN OUT NOCOPY NUMBER,
271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
273: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
274: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
275: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
276: x_return_status OUT NOCOPY VARCHAR2
277: );
270: x_to_id IN OUT NOCOPY NUMBER,
271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
273: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
274: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
275: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
276: x_return_status OUT NOCOPY VARCHAR2
277: );
278: PROCEDURE org_ind_reference_merge(
271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
272: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
273: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
274: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
275: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
276: x_return_status OUT NOCOPY VARCHAR2
277: );
278: PROCEDURE org_ind_reference_merge(
279: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
275: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
276: x_return_status OUT NOCOPY VARCHAR2
277: );
278: PROCEDURE org_ind_reference_merge(
279: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
280: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
281: x_to_id IN OUT NOCOPY NUMBER,
282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
276: x_return_status OUT NOCOPY VARCHAR2
277: );
278: PROCEDURE org_ind_reference_merge(
279: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
280: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
281: x_to_id IN OUT NOCOPY NUMBER,
282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
284: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
278: PROCEDURE org_ind_reference_merge(
279: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
280: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
281: x_to_id IN OUT NOCOPY NUMBER,
282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
284: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
285: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
286: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
279: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
280: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
281: x_to_id IN OUT NOCOPY NUMBER,
282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
284: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
285: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
286: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
287: x_return_status OUT NOCOPY VARCHAR2
280: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
281: x_to_id IN OUT NOCOPY NUMBER,
282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
284: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
285: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
286: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
287: x_return_status OUT NOCOPY VARCHAR2
288: );
281: x_to_id IN OUT NOCOPY NUMBER,
282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
284: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
285: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
286: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
287: x_return_status OUT NOCOPY VARCHAR2
288: );
289: PROCEDURE per_interest_merge(
282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
283: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
284: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
285: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
286: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
287: x_return_status OUT NOCOPY VARCHAR2
288: );
289: PROCEDURE per_interest_merge(
290: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
286: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
287: x_return_status OUT NOCOPY VARCHAR2
288: );
289: PROCEDURE per_interest_merge(
290: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
291: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
292: x_to_id IN OUT NOCOPY NUMBER,
293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
287: x_return_status OUT NOCOPY VARCHAR2
288: );
289: PROCEDURE per_interest_merge(
290: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
291: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
292: x_to_id IN OUT NOCOPY NUMBER,
293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
295: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
289: PROCEDURE per_interest_merge(
290: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
291: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
292: x_to_id IN OUT NOCOPY NUMBER,
293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
295: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
296: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
297: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
290: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
291: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
292: x_to_id IN OUT NOCOPY NUMBER,
293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
295: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
296: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
297: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
298: x_return_status OUT NOCOPY VARCHAR2
291: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
292: x_to_id IN OUT NOCOPY NUMBER,
293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
295: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
296: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
297: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
298: x_return_status OUT NOCOPY VARCHAR2
299: );
292: x_to_id IN OUT NOCOPY NUMBER,
293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
295: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
296: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
297: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
298: x_return_status OUT NOCOPY VARCHAR2
299: );
300: PROCEDURE citizenship_merge(
293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
294: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
295: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
296: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
297: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
298: x_return_status OUT NOCOPY VARCHAR2
299: );
300: PROCEDURE citizenship_merge(
301: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
297: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
298: x_return_status OUT NOCOPY VARCHAR2
299: );
300: PROCEDURE citizenship_merge(
301: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
302: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
303: x_to_id IN OUT NOCOPY NUMBER,
304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
298: x_return_status OUT NOCOPY VARCHAR2
299: );
300: PROCEDURE citizenship_merge(
301: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
302: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
303: x_to_id IN OUT NOCOPY NUMBER,
304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
306: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
300: PROCEDURE citizenship_merge(
301: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
302: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
303: x_to_id IN OUT NOCOPY NUMBER,
304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
306: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
307: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
308: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
301: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
302: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
303: x_to_id IN OUT NOCOPY NUMBER,
304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
306: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
307: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
308: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
309: x_return_status OUT NOCOPY VARCHAR2
302: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
303: x_to_id IN OUT NOCOPY NUMBER,
304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
306: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
307: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
308: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
309: x_return_status OUT NOCOPY VARCHAR2
310: );
303: x_to_id IN OUT NOCOPY NUMBER,
304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
306: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
307: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
308: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
309: x_return_status OUT NOCOPY VARCHAR2
310: );
311: PROCEDURE education_merge(
304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
305: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
306: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
307: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
308: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
309: x_return_status OUT NOCOPY VARCHAR2
310: );
311: PROCEDURE education_merge(
312: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
308: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
309: x_return_status OUT NOCOPY VARCHAR2
310: );
311: PROCEDURE education_merge(
312: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
313: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
314: x_to_id IN OUT NOCOPY NUMBER,
315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
309: x_return_status OUT NOCOPY VARCHAR2
310: );
311: PROCEDURE education_merge(
312: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
313: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
314: x_to_id IN OUT NOCOPY NUMBER,
315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
317: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
311: PROCEDURE education_merge(
312: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
313: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
314: x_to_id IN OUT NOCOPY NUMBER,
315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
317: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
318: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
319: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
312: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
313: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
314: x_to_id IN OUT NOCOPY NUMBER,
315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
317: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
318: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
319: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
320: x_return_status OUT NOCOPY VARCHAR2
313: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
314: x_to_id IN OUT NOCOPY NUMBER,
315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
317: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
318: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
319: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
320: x_return_status OUT NOCOPY VARCHAR2
321: );
314: x_to_id IN OUT NOCOPY NUMBER,
315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
317: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
318: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
319: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
320: x_return_status OUT NOCOPY VARCHAR2
321: );
322:
315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
316: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
317: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
318: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
319: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
320: x_return_status OUT NOCOPY VARCHAR2
321: );
322:
323: PROCEDURE education_school_merge(
320: x_return_status OUT NOCOPY VARCHAR2
321: );
322:
323: PROCEDURE education_school_merge(
324: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
326: x_to_id IN OUT NOCOPY NUMBER,
327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
321: );
322:
323: PROCEDURE education_school_merge(
324: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
326: x_to_id IN OUT NOCOPY NUMBER,
327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
329: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
323: PROCEDURE education_school_merge(
324: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
326: x_to_id IN OUT NOCOPY NUMBER,
327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
329: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
330: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
331: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
324: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
326: x_to_id IN OUT NOCOPY NUMBER,
327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
329: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
330: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
331: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
332: x_return_status OUT NOCOPY VARCHAR2
325: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
326: x_to_id IN OUT NOCOPY NUMBER,
327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
329: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
330: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
331: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
332: x_return_status OUT NOCOPY VARCHAR2
333: );
326: x_to_id IN OUT NOCOPY NUMBER,
327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
329: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
330: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
331: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
332: x_return_status OUT NOCOPY VARCHAR2
333: );
334:
327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
328: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
329: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
330: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
331: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
332: x_return_status OUT NOCOPY VARCHAR2
333: );
334:
335: PROCEDURE emp_history_merge(
332: x_return_status OUT NOCOPY VARCHAR2
333: );
334:
335: PROCEDURE emp_history_merge(
336: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
337: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
338: x_to_id IN OUT NOCOPY NUMBER,
339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
333: );
334:
335: PROCEDURE emp_history_merge(
336: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
337: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
338: x_to_id IN OUT NOCOPY NUMBER,
339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
341: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
335: PROCEDURE emp_history_merge(
336: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
337: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
338: x_to_id IN OUT NOCOPY NUMBER,
339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
341: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
342: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
343: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
336: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
337: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
338: x_to_id IN OUT NOCOPY NUMBER,
339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
341: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
342: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
343: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
344: x_return_status OUT NOCOPY VARCHAR2
337: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
338: x_to_id IN OUT NOCOPY NUMBER,
339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
341: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
342: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
343: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
344: x_return_status OUT NOCOPY VARCHAR2
345: );
338: x_to_id IN OUT NOCOPY NUMBER,
339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
341: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
342: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
343: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
344: x_return_status OUT NOCOPY VARCHAR2
345: );
346:
339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
340: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
341: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
342: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
343: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
344: x_return_status OUT NOCOPY VARCHAR2
345: );
346:
347: PROCEDURE emp_history_employed_merge(
344: x_return_status OUT NOCOPY VARCHAR2
345: );
346:
347: PROCEDURE emp_history_employed_merge(
348: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
349: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
350: x_to_id IN OUT NOCOPY NUMBER,
351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
345: );
346:
347: PROCEDURE emp_history_employed_merge(
348: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
349: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
350: x_to_id IN OUT NOCOPY NUMBER,
351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
353: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
347: PROCEDURE emp_history_employed_merge(
348: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
349: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
350: x_to_id IN OUT NOCOPY NUMBER,
351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
353: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
354: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
355: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
348: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
349: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
350: x_to_id IN OUT NOCOPY NUMBER,
351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
353: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
354: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
355: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
356: x_return_status OUT NOCOPY VARCHAR2
349: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
350: x_to_id IN OUT NOCOPY NUMBER,
351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
353: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
354: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
355: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
356: x_return_status OUT NOCOPY VARCHAR2
357: );
350: x_to_id IN OUT NOCOPY NUMBER,
351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
353: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
354: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
355: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
356: x_return_status OUT NOCOPY VARCHAR2
357: );
358:
351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
352: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
353: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
354: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
355: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
356: x_return_status OUT NOCOPY VARCHAR2
357: );
358:
359: PROCEDURE per_languages_merge(
356: x_return_status OUT NOCOPY VARCHAR2
357: );
358:
359: PROCEDURE per_languages_merge(
360: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
361: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
362: x_to_id IN OUT NOCOPY NUMBER,
363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
357: );
358:
359: PROCEDURE per_languages_merge(
360: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
361: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
362: x_to_id IN OUT NOCOPY NUMBER,
363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
365: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
359: PROCEDURE per_languages_merge(
360: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
361: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
362: x_to_id IN OUT NOCOPY NUMBER,
363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
365: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
366: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
367: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
360: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
361: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
362: x_to_id IN OUT NOCOPY NUMBER,
363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
365: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
366: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
367: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
368: x_return_status OUT NOCOPY VARCHAR2
361: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
362: x_to_id IN OUT NOCOPY NUMBER,
363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
365: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
366: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
367: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
368: x_return_status OUT NOCOPY VARCHAR2
369: );
362: x_to_id IN OUT NOCOPY NUMBER,
363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
365: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
366: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
367: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
368: x_return_status OUT NOCOPY VARCHAR2
369: );
370: PROCEDURE code_assignment_merge(
363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
364: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
365: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
366: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
367: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
368: x_return_status OUT NOCOPY VARCHAR2
369: );
370: PROCEDURE code_assignment_merge(
371: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
367: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
368: x_return_status OUT NOCOPY VARCHAR2
369: );
370: PROCEDURE code_assignment_merge(
371: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
372: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
373: x_to_id IN OUT NOCOPY NUMBER,
374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
368: x_return_status OUT NOCOPY VARCHAR2
369: );
370: PROCEDURE code_assignment_merge(
371: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
372: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
373: x_to_id IN OUT NOCOPY NUMBER,
374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
376: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
370: PROCEDURE code_assignment_merge(
371: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
372: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
373: x_to_id IN OUT NOCOPY NUMBER,
374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
376: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
377: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
378: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
371: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
372: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
373: x_to_id IN OUT NOCOPY NUMBER,
374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
376: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
377: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
378: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
379: x_return_status OUT NOCOPY VARCHAR2
372: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
373: x_to_id IN OUT NOCOPY NUMBER,
374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
376: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
377: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
378: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
379: x_return_status OUT NOCOPY VARCHAR2
380: );
373: x_to_id IN OUT NOCOPY NUMBER,
374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
376: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
377: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
378: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
379: x_return_status OUT NOCOPY VARCHAR2
380: );
381: PROCEDURE code_assignment_merge2(
374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
375: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
376: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
377: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
378: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
379: x_return_status OUT NOCOPY VARCHAR2
380: );
381: PROCEDURE code_assignment_merge2(
382: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
378: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
379: x_return_status OUT NOCOPY VARCHAR2
380: );
381: PROCEDURE code_assignment_merge2(
382: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
383: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
384: x_to_id IN OUT NOCOPY NUMBER,
385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
379: x_return_status OUT NOCOPY VARCHAR2
380: );
381: PROCEDURE code_assignment_merge2(
382: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
383: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
384: x_to_id IN OUT NOCOPY NUMBER,
385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
387: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
381: PROCEDURE code_assignment_merge2(
382: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
383: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
384: x_to_id IN OUT NOCOPY NUMBER,
385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
387: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
388: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
389: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
382: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
383: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
384: x_to_id IN OUT NOCOPY NUMBER,
385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
387: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
388: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
389: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
390: x_return_status OUT NOCOPY VARCHAR2
383: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
384: x_to_id IN OUT NOCOPY NUMBER,
385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
387: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
388: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
389: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
390: x_return_status OUT NOCOPY VARCHAR2
391: );
384: x_to_id IN OUT NOCOPY NUMBER,
385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
387: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
388: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
389: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
390: x_return_status OUT NOCOPY VARCHAR2
391: );
392: PROCEDURE org_contact_role_merge(
385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
386: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
387: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
388: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
389: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
390: x_return_status OUT NOCOPY VARCHAR2
391: );
392: PROCEDURE org_contact_role_merge(
393: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
389: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
390: x_return_status OUT NOCOPY VARCHAR2
391: );
392: PROCEDURE org_contact_role_merge(
393: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
394: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
395: x_to_id IN OUT NOCOPY NUMBER,
396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
390: x_return_status OUT NOCOPY VARCHAR2
391: );
392: PROCEDURE org_contact_role_merge(
393: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
394: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
395: x_to_id IN OUT NOCOPY NUMBER,
396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
398: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
392: PROCEDURE org_contact_role_merge(
393: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
394: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
395: x_to_id IN OUT NOCOPY NUMBER,
396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
398: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
399: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
400: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
393: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
394: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
395: x_to_id IN OUT NOCOPY NUMBER,
396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
398: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
399: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
400: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
401: x_return_status OUT NOCOPY VARCHAR2
394: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
395: x_to_id IN OUT NOCOPY NUMBER,
396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
398: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
399: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
400: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
401: x_return_status OUT NOCOPY VARCHAR2
402: );
395: x_to_id IN OUT NOCOPY NUMBER,
396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
398: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
399: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
400: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
401: x_return_status OUT NOCOPY VARCHAR2
402: );
403: PROCEDURE financial_number_merge(
396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
397: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
398: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
399: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
400: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
401: x_return_status OUT NOCOPY VARCHAR2
402: );
403: PROCEDURE financial_number_merge(
404: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
400: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
401: x_return_status OUT NOCOPY VARCHAR2
402: );
403: PROCEDURE financial_number_merge(
404: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
405: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
406: x_to_id IN OUT NOCOPY NUMBER,
407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
401: x_return_status OUT NOCOPY VARCHAR2
402: );
403: PROCEDURE financial_number_merge(
404: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
405: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
406: x_to_id IN OUT NOCOPY NUMBER,
407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
409: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
403: PROCEDURE financial_number_merge(
404: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
405: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
406: x_to_id IN OUT NOCOPY NUMBER,
407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
409: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
410: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
411: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
404: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
405: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
406: x_to_id IN OUT NOCOPY NUMBER,
407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
409: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
410: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
411: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
412: x_return_status OUT NOCOPY VARCHAR2
405: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
406: x_to_id IN OUT NOCOPY NUMBER,
407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
409: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
410: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
411: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
412: x_return_status OUT NOCOPY VARCHAR2
413: );
406: x_to_id IN OUT NOCOPY NUMBER,
407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
409: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
410: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
411: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
412: x_return_status OUT NOCOPY VARCHAR2
413: );
414: PROCEDURE work_class_merge(
407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
408: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
409: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
410: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
411: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
412: x_return_status OUT NOCOPY VARCHAR2
413: );
414: PROCEDURE work_class_merge(
415: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
411: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
412: x_return_status OUT NOCOPY VARCHAR2
413: );
414: PROCEDURE work_class_merge(
415: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
416: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
417: x_to_id IN OUT NOCOPY NUMBER,
418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
412: x_return_status OUT NOCOPY VARCHAR2
413: );
414: PROCEDURE work_class_merge(
415: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
416: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
417: x_to_id IN OUT NOCOPY NUMBER,
418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
420: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
414: PROCEDURE work_class_merge(
415: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
416: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
417: x_to_id IN OUT NOCOPY NUMBER,
418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
420: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
421: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
422: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
415: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
416: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
417: x_to_id IN OUT NOCOPY NUMBER,
418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
420: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
421: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
422: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
423: x_return_status OUT NOCOPY VARCHAR2
416: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
417: x_to_id IN OUT NOCOPY NUMBER,
418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
420: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
421: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
422: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
423: x_return_status OUT NOCOPY VARCHAR2
424: );
417: x_to_id IN OUT NOCOPY NUMBER,
418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
420: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
421: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
422: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
423: x_return_status OUT NOCOPY VARCHAR2
424: );
425: PROCEDURE displayed_duns_merge(
418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
419: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
420: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
421: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
422: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
423: x_return_status OUT NOCOPY VARCHAR2
424: );
425: PROCEDURE displayed_duns_merge(
426: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
422: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
423: x_return_status OUT NOCOPY VARCHAR2
424: );
425: PROCEDURE displayed_duns_merge(
426: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
427: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
428: x_to_id IN OUT NOCOPY NUMBER,
429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
423: x_return_status OUT NOCOPY VARCHAR2
424: );
425: PROCEDURE displayed_duns_merge(
426: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
427: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
428: x_to_id IN OUT NOCOPY NUMBER,
429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
431: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
425: PROCEDURE displayed_duns_merge(
426: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
427: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
428: x_to_id IN OUT NOCOPY NUMBER,
429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
431: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
432: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
433: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
426: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
427: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
428: x_to_id IN OUT NOCOPY NUMBER,
429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
431: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
432: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
433: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
434: x_return_status OUT NOCOPY VARCHAR2
427: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
428: x_to_id IN OUT NOCOPY NUMBER,
429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
431: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
432: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
433: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
434: x_return_status OUT NOCOPY VARCHAR2
435: );
428: x_to_id IN OUT NOCOPY NUMBER,
429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
431: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
432: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
433: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
434: x_return_status OUT NOCOPY VARCHAR2
435: );
436: PROCEDURE cust_account_selling_merge(
429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
430: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
431: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
432: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
433: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
434: x_return_status OUT NOCOPY VARCHAR2
435: );
436: PROCEDURE cust_account_selling_merge(
437: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
433: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
434: x_return_status OUT NOCOPY VARCHAR2
435: );
436: PROCEDURE cust_account_selling_merge(
437: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
438: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
439: x_to_id IN OUT NOCOPY NUMBER,
440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
434: x_return_status OUT NOCOPY VARCHAR2
435: );
436: PROCEDURE cust_account_selling_merge(
437: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
438: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
439: x_to_id IN OUT NOCOPY NUMBER,
440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
442: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
436: PROCEDURE cust_account_selling_merge(
437: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
438: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
439: x_to_id IN OUT NOCOPY NUMBER,
440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
442: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
443: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
444: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
437: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
438: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
439: x_to_id IN OUT NOCOPY NUMBER,
440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
442: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
443: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
444: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
445: x_return_status OUT NOCOPY VARCHAR2
438: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
439: x_to_id IN OUT NOCOPY NUMBER,
440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
442: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
443: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
444: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
445: x_return_status OUT NOCOPY VARCHAR2
446: );
439: x_to_id IN OUT NOCOPY NUMBER,
440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
442: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
443: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
444: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
445: x_return_status OUT NOCOPY VARCHAR2
446: );
447:
440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
441: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
442: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
443: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
444: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
445: x_return_status OUT NOCOPY VARCHAR2
446: );
447:
448: PROCEDURE check_params(
445: x_return_status OUT NOCOPY VARCHAR2
446: );
447:
448: PROCEDURE check_params(
449: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
450: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
451: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
446: );
447:
448: PROCEDURE check_params(
449: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
450: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
451: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
447:
448: PROCEDURE check_params(
449: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
450: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
451: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455: p_proc_name IN VARCHAR2,
448: PROCEDURE check_params(
449: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
450: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
451: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455: p_proc_name IN VARCHAR2,
456: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
449: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
450: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
451: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455: p_proc_name IN VARCHAR2,
456: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
457: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
450: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
451: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455: p_proc_name IN VARCHAR2,
456: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
457: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
458: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455: p_proc_name IN VARCHAR2,
456: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
457: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
458: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
459: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
460: x_return_status IN OUT NOCOPY VARCHAR2
453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455: p_proc_name IN VARCHAR2,
456: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
457: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
458: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
459: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
460: x_return_status IN OUT NOCOPY VARCHAR2
461: );
454: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
455: p_proc_name IN VARCHAR2,
456: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
457: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
458: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
459: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
460: x_return_status IN OUT NOCOPY VARCHAR2
461: );
462:
455: p_proc_name IN VARCHAR2,
456: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
457: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
458: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
459: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
460: x_return_status IN OUT NOCOPY VARCHAR2
461: );
462:
463: PROCEDURE party_usage_merge(
460: x_return_status IN OUT NOCOPY VARCHAR2
461: );
462:
463: PROCEDURE party_usage_merge(
464: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
465: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
466: x_to_id IN OUT NOCOPY NUMBER,
467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
461: );
462:
463: PROCEDURE party_usage_merge(
464: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
465: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
466: x_to_id IN OUT NOCOPY NUMBER,
467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
469: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
463: PROCEDURE party_usage_merge(
464: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
465: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
466: x_to_id IN OUT NOCOPY NUMBER,
467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
469: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
470: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
471: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
464: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
465: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
466: x_to_id IN OUT NOCOPY NUMBER,
467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
469: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
470: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
471: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
472: x_return_status OUT NOCOPY VARCHAR2
465: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
466: x_to_id IN OUT NOCOPY NUMBER,
467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
469: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
470: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
471: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
472: x_return_status OUT NOCOPY VARCHAR2
473: );
466: x_to_id IN OUT NOCOPY NUMBER,
467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
469: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
470: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
471: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
472: x_return_status OUT NOCOPY VARCHAR2
473: );
474:
467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
468: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
469: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
470: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
471: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
472: x_return_status OUT NOCOPY VARCHAR2
473: );
474:
475: