DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on FND_API

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

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,

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

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

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,

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

Line 61: p_par_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
65: );

Line 62: p_batch_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: );
66:

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

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(

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

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,

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

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

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,

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

Line 73: p_par_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
77: );

Line 74: p_batch_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: );
78:

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

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(

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

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,

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

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

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,

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

Line 85: p_par_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
89: );

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

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

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(

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

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,

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

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

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,

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:

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:
103: FUNCTION realtime_sync (p_subscription_guid IN RAW,