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.

[Home] [Help]

APPS.HZ_MERGE_DUP_CHECK dependencies on FND_API

Line 5: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

1: PACKAGE HZ_MERGE_DUP_CHECK AUTHID CURRENT_USER AS
2: /* $Header: ARHMDUPS.pls 120.5 2005/09/13 08:41:45 rbandi noship $ */
3:
4: FUNCTION check_cust_account_dup(
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: x_return_status IN OUT NOCOPY VARCHAR2)

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

3:
4: FUNCTION check_cust_account_dup(
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: x_return_status IN OUT NOCOPY VARCHAR2)
10: RETURN VARCHAR2;
11:

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

4: FUNCTION check_cust_account_dup(
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: x_return_status IN OUT NOCOPY VARCHAR2)
10: RETURN VARCHAR2;
11:
12: FUNCTION check_cust_account_role_dup(

Line 13: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

9: x_return_status IN OUT NOCOPY VARCHAR2)
10: RETURN VARCHAR2;
11:
12: FUNCTION check_cust_account_role_dup(
13: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
14: x_to_id IN OUT NOCOPY NUMBER,
15: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
16: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_return_status IN OUT NOCOPY VARCHAR2)

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

11:
12: FUNCTION check_cust_account_role_dup(
13: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
14: x_to_id IN OUT NOCOPY NUMBER,
15: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
16: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_return_status IN OUT NOCOPY VARCHAR2)
18: RETURN VARCHAR2;
19:

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

12: FUNCTION check_cust_account_role_dup(
13: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
14: x_to_id IN OUT NOCOPY NUMBER,
15: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
16: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
17: x_return_status IN OUT NOCOPY VARCHAR2)
18: RETURN VARCHAR2;
19:
20: FUNCTION check_cust_account_site_dup(

Line 21: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

17: x_return_status IN OUT NOCOPY VARCHAR2)
18: RETURN VARCHAR2;
19:
20: FUNCTION check_cust_account_site_dup(
21: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
22: x_to_id IN OUT NOCOPY NUMBER,
23: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
24: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
25: x_return_status IN OUT NOCOPY VARCHAR2)

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

19:
20: FUNCTION check_cust_account_site_dup(
21: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
22: x_to_id IN OUT NOCOPY NUMBER,
23: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
24: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
25: x_return_status IN OUT NOCOPY VARCHAR2)
26: RETURN VARCHAR2;
27:

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

20: FUNCTION check_cust_account_site_dup(
21: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
22: x_to_id IN OUT NOCOPY NUMBER,
23: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
24: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
25: x_return_status IN OUT NOCOPY VARCHAR2)
26: RETURN VARCHAR2;
27:
28: FUNCTION check_financial_profile_dup(

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

25: x_return_status IN OUT NOCOPY VARCHAR2)
26: RETURN VARCHAR2;
27:
28: FUNCTION check_financial_profile_dup(
29: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
30: x_to_id IN OUT NOCOPY NUMBER,
31: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
33: x_return_status IN OUT NOCOPY VARCHAR2)

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

27:
28: FUNCTION check_financial_profile_dup(
29: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
30: x_to_id IN OUT NOCOPY NUMBER,
31: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
33: x_return_status IN OUT NOCOPY VARCHAR2)
34: RETURN VARCHAR2;
35:

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

28: FUNCTION check_financial_profile_dup(
29: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
30: x_to_id IN OUT NOCOPY NUMBER,
31: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
33: x_return_status IN OUT NOCOPY VARCHAR2)
34: RETURN VARCHAR2;
35:
36: FUNCTION check_contact_point_dup(

Line 37: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

33: x_return_status IN OUT NOCOPY VARCHAR2)
34: RETURN VARCHAR2;
35:
36: FUNCTION check_contact_point_dup(
37: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
38: x_to_id IN OUT NOCOPY NUMBER,
39: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
40: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_owner_table_name IN VARCHAR2,

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

35:
36: FUNCTION check_contact_point_dup(
37: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
38: x_to_id IN OUT NOCOPY NUMBER,
39: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
40: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_owner_table_name IN VARCHAR2,
42: x_return_status IN OUT NOCOPY VARCHAR2)
43: RETURN VARCHAR2;

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

36: FUNCTION check_contact_point_dup(
37: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
38: x_to_id IN OUT NOCOPY NUMBER,
39: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
40: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41: p_owner_table_name IN VARCHAR2,
42: x_return_status IN OUT NOCOPY VARCHAR2)
43: RETURN VARCHAR2;
44:

Line 46: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

42: x_return_status IN OUT NOCOPY VARCHAR2)
43: RETURN VARCHAR2;
44:
45: FUNCTION check_references_dup(
46: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
47: x_to_id IN OUT NOCOPY NUMBER,
48: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
49: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_return_status IN OUT NOCOPY VARCHAR2)

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

44:
45: FUNCTION check_references_dup(
46: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
47: x_to_id IN OUT NOCOPY NUMBER,
48: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
49: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_return_status IN OUT NOCOPY VARCHAR2)
51: RETURN VARCHAR2;
52:

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

45: FUNCTION check_references_dup(
46: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
47: x_to_id IN OUT NOCOPY NUMBER,
48: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
49: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
50: x_return_status IN OUT NOCOPY VARCHAR2)
51: RETURN VARCHAR2;
52:
53: FUNCTION check_certification_dup(

Line 54: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

50: x_return_status IN OUT NOCOPY VARCHAR2)
51: RETURN VARCHAR2;
52:
53: FUNCTION check_certification_dup(
54: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
55: x_to_id IN OUT NOCOPY NUMBER,
56: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
57: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_return_status IN OUT NOCOPY VARCHAR2)

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

52:
53: FUNCTION check_certification_dup(
54: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
55: x_to_id IN OUT NOCOPY NUMBER,
56: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
57: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_return_status IN OUT NOCOPY VARCHAR2)
59: RETURN VARCHAR2;
60:

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

53: FUNCTION check_certification_dup(
54: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
55: x_to_id IN OUT NOCOPY NUMBER,
56: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
57: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
58: x_return_status IN OUT NOCOPY VARCHAR2)
59: RETURN VARCHAR2;
60:
61: FUNCTION check_credit_ratings_dup(

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

58: x_return_status IN OUT NOCOPY VARCHAR2)
59: RETURN VARCHAR2;
60:
61: FUNCTION check_credit_ratings_dup(
62: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
63: x_to_id IN OUT NOCOPY NUMBER,
64: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
65: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
66: x_return_status IN OUT NOCOPY VARCHAR2)

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

60:
61: FUNCTION check_credit_ratings_dup(
62: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
63: x_to_id IN OUT NOCOPY NUMBER,
64: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
65: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
66: x_return_status IN OUT NOCOPY VARCHAR2)
67: RETURN VARCHAR2;
68:

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

61: FUNCTION check_credit_ratings_dup(
62: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
63: x_to_id IN OUT NOCOPY NUMBER,
64: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
65: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
66: x_return_status IN OUT NOCOPY VARCHAR2)
67: RETURN VARCHAR2;
68:
69: FUNCTION check_security_issued_dup(

Line 70: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

66: x_return_status IN OUT NOCOPY VARCHAR2)
67: RETURN VARCHAR2;
68:
69: FUNCTION check_security_issued_dup(
70: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
71: x_to_id IN OUT NOCOPY NUMBER,
72: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: x_return_status IN OUT NOCOPY VARCHAR2)

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

68:
69: FUNCTION check_security_issued_dup(
70: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
71: x_to_id IN OUT NOCOPY NUMBER,
72: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: x_return_status IN OUT NOCOPY VARCHAR2)
75: RETURN VARCHAR2;
76:

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

69: FUNCTION check_security_issued_dup(
70: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
71: x_to_id IN OUT NOCOPY NUMBER,
72: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74: x_return_status IN OUT NOCOPY VARCHAR2)
75: RETURN VARCHAR2;
76:
77: FUNCTION check_financial_reports_dup(

Line 78: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

74: x_return_status IN OUT NOCOPY VARCHAR2)
75: RETURN VARCHAR2;
76:
77: FUNCTION check_financial_reports_dup(
78: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
79: x_to_id IN OUT NOCOPY NUMBER,
80: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
81: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_return_status IN OUT NOCOPY VARCHAR2)

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

76:
77: FUNCTION check_financial_reports_dup(
78: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
79: x_to_id IN OUT NOCOPY NUMBER,
80: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
81: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_return_status IN OUT NOCOPY VARCHAR2)
83: RETURN VARCHAR2;
84:

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

77: FUNCTION check_financial_reports_dup(
78: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
79: x_to_id IN OUT NOCOPY NUMBER,
80: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
81: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
82: x_return_status IN OUT NOCOPY VARCHAR2)
83: RETURN VARCHAR2;
84:
85: FUNCTION check_org_indicators_dup(

Line 86: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

82: x_return_status IN OUT NOCOPY VARCHAR2)
83: RETURN VARCHAR2;
84:
85: FUNCTION check_org_indicators_dup(
86: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
87: x_to_id IN OUT NOCOPY NUMBER,
88: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
89: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
90: x_return_status IN OUT NOCOPY VARCHAR2)

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

84:
85: FUNCTION check_org_indicators_dup(
86: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
87: x_to_id IN OUT NOCOPY NUMBER,
88: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
89: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
90: x_return_status IN OUT NOCOPY VARCHAR2)
91: RETURN VARCHAR2;
92:

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

85: FUNCTION check_org_indicators_dup(
86: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
87: x_to_id IN OUT NOCOPY NUMBER,
88: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
89: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
90: x_return_status IN OUT NOCOPY VARCHAR2)
91: RETURN VARCHAR2;
92:
93: FUNCTION check_ind_reference_dup(

Line 94: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

90: x_return_status IN OUT NOCOPY VARCHAR2)
91: RETURN VARCHAR2;
92:
93: FUNCTION check_ind_reference_dup(
94: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
95: x_to_id IN OUT NOCOPY NUMBER,
96: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
98: x_return_status IN OUT NOCOPY VARCHAR2)

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

92:
93: FUNCTION check_ind_reference_dup(
94: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
95: x_to_id IN OUT NOCOPY NUMBER,
96: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
98: x_return_status IN OUT NOCOPY VARCHAR2)
99: RETURN VARCHAR2;
100:

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

93: FUNCTION check_ind_reference_dup(
94: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
95: x_to_id IN OUT NOCOPY NUMBER,
96: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
98: x_return_status IN OUT NOCOPY VARCHAR2)
99: RETURN VARCHAR2;
100:
101: FUNCTION check_per_interest_dup(

Line 102: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

98: x_return_status IN OUT NOCOPY VARCHAR2)
99: RETURN VARCHAR2;
100:
101: FUNCTION check_per_interest_dup(
102: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
103: x_to_id IN OUT NOCOPY NUMBER,
104: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
105: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
106: x_return_status IN OUT NOCOPY VARCHAR2)

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

100:
101: FUNCTION check_per_interest_dup(
102: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
103: x_to_id IN OUT NOCOPY NUMBER,
104: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
105: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
106: x_return_status IN OUT NOCOPY VARCHAR2)
107: RETURN VARCHAR2;
108:

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

101: FUNCTION check_per_interest_dup(
102: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
103: x_to_id IN OUT NOCOPY NUMBER,
104: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
105: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
106: x_return_status IN OUT NOCOPY VARCHAR2)
107: RETURN VARCHAR2;
108:
109: FUNCTION check_citizenship_dup(

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

106: x_return_status IN OUT NOCOPY VARCHAR2)
107: RETURN VARCHAR2;
108:
109: FUNCTION check_citizenship_dup(
110: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_to_id IN OUT NOCOPY NUMBER,
112: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
113: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
114: x_return_status IN OUT NOCOPY VARCHAR2)

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

108:
109: FUNCTION check_citizenship_dup(
110: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_to_id IN OUT NOCOPY NUMBER,
112: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
113: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
114: x_return_status IN OUT NOCOPY VARCHAR2)
115: RETURN VARCHAR2;
116:

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

109: FUNCTION check_citizenship_dup(
110: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
111: x_to_id IN OUT NOCOPY NUMBER,
112: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
113: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
114: x_return_status IN OUT NOCOPY VARCHAR2)
115: RETURN VARCHAR2;
116:
117: FUNCTION check_education_dup(

Line 118: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

114: x_return_status IN OUT NOCOPY VARCHAR2)
115: RETURN VARCHAR2;
116:
117: FUNCTION check_education_dup(
118: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
119: x_to_id IN OUT NOCOPY NUMBER,
120: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status IN OUT NOCOPY VARCHAR2)

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

116:
117: FUNCTION check_education_dup(
118: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
119: x_to_id IN OUT NOCOPY NUMBER,
120: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status IN OUT NOCOPY VARCHAR2)
123: RETURN VARCHAR2;
124:

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

117: FUNCTION check_education_dup(
118: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
119: x_to_id IN OUT NOCOPY NUMBER,
120: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
121: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
122: x_return_status IN OUT NOCOPY VARCHAR2)
123: RETURN VARCHAR2;
124:
125: FUNCTION check_emp_history_dup(

Line 126: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

122: x_return_status IN OUT NOCOPY VARCHAR2)
123: RETURN VARCHAR2;
124:
125: FUNCTION check_emp_history_dup(
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: x_return_status IN OUT NOCOPY VARCHAR2)

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

124:
125: FUNCTION check_emp_history_dup(
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: x_return_status IN OUT NOCOPY VARCHAR2)
131: RETURN VARCHAR2;
132:

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

125: FUNCTION check_emp_history_dup(
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: x_return_status IN OUT NOCOPY VARCHAR2)
131: RETURN VARCHAR2;
132:
133: FUNCTION check_work_class_dup(

Line 134: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

130: x_return_status IN OUT NOCOPY VARCHAR2)
131: RETURN VARCHAR2;
132:
133: FUNCTION check_work_class_dup(
134: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
135: x_to_id IN OUT NOCOPY NUMBER,
136: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
137: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_return_status IN OUT NOCOPY VARCHAR2)

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

132:
133: FUNCTION check_work_class_dup(
134: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
135: x_to_id IN OUT NOCOPY NUMBER,
136: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
137: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_return_status IN OUT NOCOPY VARCHAR2)
139: RETURN VARCHAR2;
140:

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

133: FUNCTION check_work_class_dup(
134: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
135: x_to_id IN OUT NOCOPY NUMBER,
136: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
137: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
138: x_return_status IN OUT NOCOPY VARCHAR2)
139: RETURN VARCHAR2;
140:
141: FUNCTION check_languages_dup(

Line 142: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

138: x_return_status IN OUT NOCOPY VARCHAR2)
139: RETURN VARCHAR2;
140:
141: FUNCTION check_languages_dup(
142: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
143: x_to_id IN OUT NOCOPY NUMBER,
144: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
145: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
146: x_return_status IN OUT NOCOPY VARCHAR2)

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

140:
141: FUNCTION check_languages_dup(
142: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
143: x_to_id IN OUT NOCOPY NUMBER,
144: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
145: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
146: x_return_status IN OUT NOCOPY VARCHAR2)
147: RETURN VARCHAR2;
148:

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

141: FUNCTION check_languages_dup(
142: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
143: x_to_id IN OUT NOCOPY NUMBER,
144: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
145: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
146: x_return_status IN OUT NOCOPY VARCHAR2)
147: RETURN VARCHAR2;
148:
149: FUNCTION check_party_site_use_dup(

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

146: x_return_status IN OUT NOCOPY VARCHAR2)
147: RETURN VARCHAR2;
148:
149: FUNCTION check_party_site_use_dup(
150: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
151: x_to_id IN OUT NOCOPY NUMBER,
152: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
153: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
154: x_return_status IN OUT NOCOPY VARCHAR2)

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

148:
149: FUNCTION check_party_site_use_dup(
150: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
151: x_to_id IN OUT NOCOPY NUMBER,
152: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
153: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
154: x_return_status IN OUT NOCOPY VARCHAR2)
155: RETURN VARCHAR2;
156:

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

149: FUNCTION check_party_site_use_dup(
150: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
151: x_to_id IN OUT NOCOPY NUMBER,
152: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
153: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
154: x_return_status IN OUT NOCOPY VARCHAR2)
155: RETURN VARCHAR2;
156:
157: FUNCTION check_party_site_dup(

Line 158: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

154: x_return_status IN OUT NOCOPY VARCHAR2)
155: RETURN VARCHAR2;
156:
157: FUNCTION check_party_site_dup(
158: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
159: x_to_id IN OUT NOCOPY NUMBER,
160: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
161: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: x_return_status IN OUT NOCOPY VARCHAR2)

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

156:
157: FUNCTION check_party_site_dup(
158: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
159: x_to_id IN OUT NOCOPY NUMBER,
160: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
161: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: x_return_status IN OUT NOCOPY VARCHAR2)
163: RETURN VARCHAR2;
164:

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

157: FUNCTION check_party_site_dup(
158: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
159: x_to_id IN OUT NOCOPY NUMBER,
160: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
161: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162: x_return_status IN OUT NOCOPY VARCHAR2)
163: RETURN VARCHAR2;
164:
165: FUNCTION check_financial_number_dup(

Line 166: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

162: x_return_status IN OUT NOCOPY VARCHAR2)
163: RETURN VARCHAR2;
164:
165: FUNCTION check_financial_number_dup(
166: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
167: x_to_id IN OUT NOCOPY NUMBER,
168: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
169: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
170: x_return_status IN OUT NOCOPY VARCHAR2)

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

164:
165: FUNCTION check_financial_number_dup(
166: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
167: x_to_id IN OUT NOCOPY NUMBER,
168: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
169: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
170: x_return_status IN OUT NOCOPY VARCHAR2)
171: RETURN VARCHAR2;
172:

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

165: FUNCTION check_financial_number_dup(
166: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
167: x_to_id IN OUT NOCOPY NUMBER,
168: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
169: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
170: x_return_status IN OUT NOCOPY VARCHAR2)
171: RETURN VARCHAR2;
172:
173: FUNCTION check_org_contact_role_dup(

Line 174: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

170: x_return_status IN OUT NOCOPY VARCHAR2)
171: RETURN VARCHAR2;
172:
173: FUNCTION check_org_contact_role_dup(
174: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
175: x_to_id IN OUT NOCOPY NUMBER,
176: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
177: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
178: x_return_status IN OUT NOCOPY VARCHAR2)

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

172:
173: FUNCTION check_org_contact_role_dup(
174: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
175: x_to_id IN OUT NOCOPY NUMBER,
176: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
177: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
178: x_return_status IN OUT NOCOPY VARCHAR2)
179: RETURN VARCHAR2;
180:

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

173: FUNCTION check_org_contact_role_dup(
174: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
175: x_to_id IN OUT NOCOPY NUMBER,
176: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
177: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
178: x_return_status IN OUT NOCOPY VARCHAR2)
179: RETURN VARCHAR2;
180:
181: FUNCTION check_code_assignment_dup(

Line 182: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

178: x_return_status IN OUT NOCOPY VARCHAR2)
179: RETURN VARCHAR2;
180:
181: FUNCTION check_code_assignment_dup(
182: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
183: x_to_id IN OUT NOCOPY NUMBER,
184: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
186: p_owner_table_name IN VARCHAR2,

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

180:
181: FUNCTION check_code_assignment_dup(
182: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
183: x_to_id IN OUT NOCOPY NUMBER,
184: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
186: p_owner_table_name IN VARCHAR2,
187: x_return_status IN OUT NOCOPY VARCHAR2)
188: RETURN VARCHAR2;

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

181: FUNCTION check_code_assignment_dup(
182: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
183: x_to_id IN OUT NOCOPY NUMBER,
184: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
186: p_owner_table_name IN VARCHAR2,
187: x_return_status IN OUT NOCOPY VARCHAR2)
188: RETURN VARCHAR2;
189:

Line 191: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

187: x_return_status IN OUT NOCOPY VARCHAR2)
188: RETURN VARCHAR2;
189:
190: FUNCTION check_contact_preference_dup(
191: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
192: x_to_id IN OUT NOCOPY NUMBER,
193: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
194: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_owner_table_name IN VARCHAR2,

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

189:
190: FUNCTION check_contact_preference_dup(
191: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
192: x_to_id IN OUT NOCOPY NUMBER,
193: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
194: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_owner_table_name IN VARCHAR2,
196: x_return_status IN OUT NOCOPY VARCHAR2)
197: RETURN VARCHAR2;

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

190: FUNCTION check_contact_preference_dup(
191: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
192: x_to_id IN OUT NOCOPY NUMBER,
193: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
194: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195: p_owner_table_name IN VARCHAR2,
196: x_return_status IN OUT NOCOPY VARCHAR2)
197: RETURN VARCHAR2;
198:

Line 201: p_from_location_id IN NUMBER:=FND_API.G_MISS_NUM,

197: RETURN VARCHAR2;
198:
199: --Bug Fix 4577535
200: FUNCTION check_address_dup(
201: p_from_location_id IN NUMBER:=FND_API.G_MISS_NUM,
202: x_to_id IN OUT NOCOPY NUMBER,
203: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
204: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
205: x_return_status IN OUT NOCOPY VARCHAR2)

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

199: --Bug Fix 4577535
200: FUNCTION check_address_dup(
201: p_from_location_id IN NUMBER:=FND_API.G_MISS_NUM,
202: x_to_id IN OUT NOCOPY NUMBER,
203: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
204: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
205: x_return_status IN OUT NOCOPY VARCHAR2)
206: RETURN VARCHAR2;
207:

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

200: FUNCTION check_address_dup(
201: p_from_location_id IN NUMBER:=FND_API.G_MISS_NUM,
202: x_to_id IN OUT NOCOPY NUMBER,
203: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
204: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
205: x_return_status IN OUT NOCOPY VARCHAR2)
206: RETURN VARCHAR2;
207:
208: