52: retcode OUT NOCOPY VARCHAR2
53: );
54:
55: PROCEDURE stage_party_merge(
56: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
57: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_to_id IN OUT NOCOPY NUMBER,
59: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
53: );
54:
55: PROCEDURE stage_party_merge(
56: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
57: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_to_id IN OUT NOCOPY NUMBER,
59: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
61: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
55: PROCEDURE stage_party_merge(
56: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
57: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_to_id IN OUT NOCOPY NUMBER,
59: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
61: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
62: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
56: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
57: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_to_id IN OUT NOCOPY NUMBER,
59: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
61: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
62: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
64: x_return_status OUT NOCOPY VARCHAR2
57: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_to_id IN OUT NOCOPY NUMBER,
59: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
61: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
62: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
64: x_return_status OUT NOCOPY VARCHAR2
65: );
58: x_to_id IN OUT NOCOPY NUMBER,
59: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
61: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
62: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
64: x_return_status OUT NOCOPY VARCHAR2
65: );
66:
59: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
60: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
61: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
62: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
63: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
64: x_return_status OUT NOCOPY VARCHAR2
65: );
66:
67: PROCEDURE stage_party_site_merge(
64: x_return_status OUT NOCOPY VARCHAR2
65: );
66:
67: PROCEDURE stage_party_site_merge(
68: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
69: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
70: x_to_id IN OUT NOCOPY NUMBER,
71: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
65: );
66:
67: PROCEDURE stage_party_site_merge(
68: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
69: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
70: x_to_id IN OUT NOCOPY NUMBER,
71: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
67: PROCEDURE stage_party_site_merge(
68: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
69: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
70: x_to_id IN OUT NOCOPY NUMBER,
71: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
74: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
68: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
69: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
70: x_to_id IN OUT NOCOPY NUMBER,
71: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
74: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
76: x_return_status OUT NOCOPY VARCHAR2
69: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
70: x_to_id IN OUT NOCOPY NUMBER,
71: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
74: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
76: x_return_status OUT NOCOPY VARCHAR2
77: );
70: x_to_id IN OUT NOCOPY NUMBER,
71: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
74: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
76: x_return_status OUT NOCOPY VARCHAR2
77: );
78:
71: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
72: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
74: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
75: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
76: x_return_status OUT NOCOPY VARCHAR2
77: );
78:
79: PROCEDURE stage_contact_merge(
76: x_return_status OUT NOCOPY VARCHAR2
77: );
78:
79: PROCEDURE stage_contact_merge(
80: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
81: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_to_id IN OUT NOCOPY NUMBER,
83: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
77: );
78:
79: PROCEDURE stage_contact_merge(
80: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
81: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_to_id IN OUT NOCOPY NUMBER,
83: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
79: PROCEDURE stage_contact_merge(
80: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
81: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_to_id IN OUT NOCOPY NUMBER,
83: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
86: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
87: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
80: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
81: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_to_id IN OUT NOCOPY NUMBER,
83: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
86: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
87: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
88: x_return_status OUT NOCOPY VARCHAR2
81: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_to_id IN OUT NOCOPY NUMBER,
83: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
86: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
87: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
88: x_return_status OUT NOCOPY VARCHAR2
89: );
82: x_to_id IN OUT NOCOPY NUMBER,
83: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
86: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
87: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
88: x_return_status OUT NOCOPY VARCHAR2
89: );
90:
83: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
85: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
86: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
87: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
88: x_return_status OUT NOCOPY VARCHAR2
89: );
90:
91: PROCEDURE stage_contact_point_merge(
88: x_return_status OUT NOCOPY VARCHAR2
89: );
90:
91: PROCEDURE stage_contact_point_merge(
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
89: );
90:
91: PROCEDURE stage_contact_point_merge(
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
91: PROCEDURE stage_contact_point_merge(
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
92: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
93: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
94: x_to_id IN OUT NOCOPY NUMBER,
95: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
96: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
98: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
99: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
102:
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:
103: FUNCTION realtime_sync (p_subscription_guid IN RAW,