eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MERGE_PKG dependencies on FND_API

Line 4: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 5: p_from_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,

Line 7: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 8: p_to_fk_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

Line 9: p_par_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
13: );

Line 10: p_batch_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: );
14: PROCEDURE party_reln_object_merge(

Line 11: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 16: p_from_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,

Line 18: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 19: p_to_fk_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

Line 20: p_par_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
24: );

Line 21: p_batch_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: );
25: PROCEDURE party_reln_subject_merge(

Line 22: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 27: p_from_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,

Line 29: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 30: p_to_fk_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

Line 31: p_par_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
35: );

Line 32: p_batch_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: );
36: PROCEDURE party_relationship_merge(

Line 33: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 38: p_from_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,

Line 40: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 41: p_to_fk_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

Line 42: p_par_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
46: );

Line 43: p_batch_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: );
47: PROCEDURE org_profile_merge(

Line 44: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 49: p_from_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,

Line 51: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 52: p_to_fk_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

Line 53: p_par_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
57: );

Line 54: p_batch_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: );
58: PROCEDURE per_profile_merge(

Line 55: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 60: p_from_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,

Line 62: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 63: p_to_fk_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

Line 64: p_par_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
68: );

Line 65: p_batch_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: );
69: PROCEDURE org_contact_merge(

Line 66: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 71: p_from_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,

Line 73: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 74: p_to_fk_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

Line 75: p_par_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
79: );

Line 76: p_batch_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: );
80: PROCEDURE cust_account_merge(

Line 77: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 82: p_from_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,

Line 84: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 85: p_to_fk_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

Line 86: p_par_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
90: );

Line 87: p_batch_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: );
91: PROCEDURE cust_account_role_merge(

Line 88: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 93: p_from_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,

Line 95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 96: p_to_fk_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

Line 97: p_par_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
101: );

Line 98: p_batch_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: );
102: PROCEDURE cust_account_site_merge(

Line 99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 104: p_from_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,

Line 106: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 107: p_to_fk_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

Line 108: p_par_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
112: );

Line 109: p_batch_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: );
113: PROCEDURE contact_point_merge(

Line 110: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 115: p_from_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,

Line 117: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 118: p_to_fk_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

Line 119: p_par_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
123: );

Line 120: p_batch_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: );
124: PROCEDURE financial_profile_merge(

Line 121: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 126: p_from_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,

Line 128: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 129: p_to_fk_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

Line 130: p_par_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
134: );

Line 131: p_batch_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: );
135: PROCEDURE references_merge(

Line 132: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 137: p_from_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,

Line 139: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 140: p_to_fk_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

Line 141: p_par_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
145: );

Line 142: p_batch_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: );
146: PROCEDURE certification_merge(

Line 143: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 148: p_from_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,

Line 150: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 151: p_to_fk_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

Line 152: p_par_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
156: );

Line 153: p_batch_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: );
157: PROCEDURE credit_ratings_merge(

Line 154: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 159: p_from_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,

Line 161: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 162: p_to_fk_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

Line 163: p_par_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
167: );

Line 164: p_batch_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: );
168: PROCEDURE party_site_merge(

Line 165: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 170: p_from_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,

Line 172: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 173: p_to_fk_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

Line 174: p_par_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
178: );

Line 175: p_batch_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: );
179: PROCEDURE org_contact_merge2(

Line 176: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 181: p_from_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,

Line 183: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 184: p_to_fk_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

Line 185: p_par_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
189: );

Line 186: p_batch_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: );
190: PROCEDURE contact_point_merge2(

Line 187: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 192: p_from_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,

Line 194: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 195: p_to_fk_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

Line 196: p_par_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
200: );

Line 197: p_batch_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: );
201: PROCEDURE party_site_use_merge(

Line 198: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 203: p_from_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,

Line 205: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 206: p_to_fk_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

Line 207: p_par_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
211: );

Line 208: p_batch_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: );
212: PROCEDURE contact_preference_merge(

Line 209: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 214: p_from_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,

Line 216: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 217: p_to_fk_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

Line 218: p_par_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
222: );

Line 219: p_batch_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: );
223: PROCEDURE contact_preference_merge2(

Line 220: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 225: p_from_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,

Line 227: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 228: p_to_fk_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

Line 229: p_par_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
233: );

Line 230: p_batch_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: );
234: PROCEDURE contact_preference_merge3(

Line 231: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 236: p_from_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,

Line 238: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 239: p_to_fk_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

Line 240: p_par_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
244: );

Line 241: p_batch_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: );
245: PROCEDURE security_issued_merge(

Line 242: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 247: p_from_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,

Line 249: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 250: p_to_fk_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

Line 251: p_par_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
255: );

Line 252: p_batch_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: );
256: PROCEDURE financial_reports_merge(

Line 253: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 258: p_from_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,

Line 260: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 261: p_to_fk_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

Line 262: p_par_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
266: );

Line 263: p_batch_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: );
267: PROCEDURE org_indicators_merge(

Line 264: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 269: p_from_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,

Line 271: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 272: p_to_fk_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

Line 273: p_par_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
277: );

Line 274: p_batch_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: );
278: PROCEDURE org_ind_reference_merge(

Line 275: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 280: p_from_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,

Line 282: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 283: p_to_fk_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

Line 284: p_par_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
288: );

Line 285: p_batch_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: );
289: PROCEDURE per_interest_merge(

Line 286: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 291: p_from_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,

Line 293: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 294: p_to_fk_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

Line 295: p_par_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
299: );

Line 296: p_batch_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: );
300: PROCEDURE citizenship_merge(

Line 297: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 302: p_from_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,

Line 304: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 305: p_to_fk_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

Line 306: p_par_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
310: );

Line 307: p_batch_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: );
311: PROCEDURE education_merge(

Line 308: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 313: p_from_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,

Line 315: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 316: p_to_fk_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

Line 317: p_par_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
321: );

Line 318: p_batch_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: );
322:

Line 319: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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(

Line 324: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 325: p_from_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,

Line 327: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 328: p_to_fk_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

Line 329: p_par_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
333: );

Line 330: p_batch_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: );
334:

Line 331: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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(

Line 336: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 337: p_from_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,

Line 339: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 340: p_to_fk_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

Line 341: p_par_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
345: );

Line 342: p_batch_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: );
346:

Line 343: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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(

Line 348: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 349: p_from_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,

Line 351: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 352: p_to_fk_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

Line 353: p_par_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
357: );

Line 354: p_batch_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: );
358:

Line 355: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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(

Line 360: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 361: p_from_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,

Line 363: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 364: p_to_fk_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

Line 365: p_par_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
369: );

Line 366: p_batch_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: );
370: PROCEDURE code_assignment_merge(

Line 367: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 372: p_from_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,

Line 374: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 375: p_to_fk_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

Line 376: p_par_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
380: );

Line 377: p_batch_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: );
381: PROCEDURE code_assignment_merge2(

Line 378: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 383: p_from_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,

Line 385: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 386: p_to_fk_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

Line 387: p_par_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
391: );

Line 388: p_batch_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: );
392: PROCEDURE org_contact_role_merge(

Line 389: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 394: p_from_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,

Line 396: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 397: p_to_fk_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

Line 398: p_par_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
402: );

Line 399: p_batch_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: );
403: PROCEDURE financial_number_merge(

Line 400: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 405: p_from_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,

Line 407: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 408: p_to_fk_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

Line 409: p_par_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
413: );

Line 410: p_batch_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: );
414: PROCEDURE work_class_merge(

Line 411: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 416: p_from_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,

Line 418: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 419: p_to_fk_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

Line 420: p_par_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
424: );

Line 421: p_batch_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: );
425: PROCEDURE displayed_duns_merge(

Line 422: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 427: p_from_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,

Line 429: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 430: p_to_fk_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

Line 431: p_par_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
435: );

Line 432: p_batch_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: );
436: PROCEDURE cust_account_selling_merge(

Line 433: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 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,

Line 438: p_from_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,

Line 440: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 441: p_to_fk_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

Line 442: p_par_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
446: );

Line 443: p_batch_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: );
447:

Line 444: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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(

Line 449: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 450: p_from_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,

Line 451: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 452: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 453: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 454: p_par_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,
458: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 456: p_exp_ent_name 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

Line 457: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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: );

Line 458: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,

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:

Line 459: p_par_pk_column 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:
463: PROCEDURE party_usage_merge(

Line 464: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 465: p_from_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,

Line 467: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 468: p_to_fk_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

Line 469: p_par_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
473: );

Line 470: p_batch_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: );
474:

Line 471: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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: