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_PROFILE_MERGE_PKG dependencies on FND_API

Line 11: ( p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

7: p_currency_code IN VARCHAR2)
8: RETURN NUMBER;
9:
10: PROCEDURE do_profile_merge
11: ( p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_to_id IN OUT NOCOPY NUMBER,
13: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
14: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
15: x_return_status IN OUT NOCOPY VARCHAR2);

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

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

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

10: PROCEDURE do_profile_merge
11: ( p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
12: x_to_id IN OUT NOCOPY NUMBER,
13: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
14: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
15: x_return_status IN OUT NOCOPY VARCHAR2);
16:
17: PROCEDURE do_profile_amt_transf
18: (p_from_profile_id IN NUMBER,

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

21: /**********/
22:
23:
24: PROCEDURE profile_merge(
25: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
26: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
27: x_to_id IN OUT NOCOPY NUMBER,
28: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
29: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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

22:
23:
24: PROCEDURE profile_merge(
25: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
26: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
27: x_to_id IN OUT NOCOPY NUMBER,
28: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
29: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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

24: PROCEDURE profile_merge(
25: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
26: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
27: x_to_id IN OUT NOCOPY NUMBER,
28: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
29: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
31: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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

25: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
26: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
27: x_to_id IN OUT NOCOPY NUMBER,
28: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
29: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
31: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
33: x_return_status OUT NOCOPY VARCHAR2)

Line 30: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

26: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
27: x_to_id IN OUT NOCOPY NUMBER,
28: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
29: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
31: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
33: x_return_status OUT NOCOPY VARCHAR2)
34: IS

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

27: x_to_id IN OUT NOCOPY NUMBER,
28: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
29: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
31: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
33: x_return_status OUT NOCOPY VARCHAR2)
34: IS
35: l_to_id NUMBER;

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

28: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
29: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
30: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
31: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
32: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
33: x_return_status OUT NOCOPY VARCHAR2)
34: IS
35: l_to_id NUMBER;
36: BEGIN

Line 39: l_to_id := FND_API.G_MISS_NUM;

35: l_to_id NUMBER;
36: BEGIN
37:
38: IF (x_to_id IS NULL) THEN
39: l_to_id := FND_API.G_MISS_NUM;
40: ELSE
41: l_to_id := x_to_id;
42: END IF;
43:

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: ELSE
41: l_to_id := x_to_id;
42: END IF;
43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: hz_merge_pkg.check_params(
47: p_entity_name => 'HZ_CUSTOMER_PROFILES',
48: p_from_id => p_from_id,

Line 60: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

56: p_pk_column => 'CUST_ACCOUNT_PROFILE_ID',
57: p_par_pk_column => 'PARTY_ID',
58: x_return_status => x_return_status );
59:
60: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
61:
62: do_profile_merge
63: ( p_from_id => p_from_id,
64: x_to_id => x_to_id,

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: WHEN OTHERS THEN
73: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
75: FND_MSG_PUB.ADD;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: END;
78:
79: FUNCTION has_to_prof_this_currency
80: ( p_to_profile_id IN NUMBER,

Line 91: Ret NUMBER := FND_API.G_MISS_NUM;

87: currency_code
88: FROM hz_cust_profile_amts
89: WHERE cust_account_profile_id = p_to_profile_id;
90: l_rec c1%ROWTYPE;
91: Ret NUMBER := FND_API.G_MISS_NUM;
92: BEGIN
93: OPEN c1;
94: LOOP
95: FETCH c1 INTO l_rec;

Line 133: IF l_to_prof_amt_id = FND_API.G_MISS_NUM THEN

129: l_to_prof_amt_id := has_to_prof_this_currency
130: ( p_to_profile_id => p_to_profile_id,
131: p_currency_code => l_rec.currency_code);
132:
133: IF l_to_prof_amt_id = FND_API.G_MISS_NUM THEN
134:
135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,

Line 159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

155: END IF;
156: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
157: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
158: FND_MSG_PUB.ADD;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160:
161: END;
162:
163:

Line 165: ( p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

161: END;
162:
163:
164: PROCEDURE do_profile_merge
165: ( p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_to_id IN OUT NOCOPY NUMBER,
167: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
168: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
169: x_return_status IN OUT NOCOPY VARCHAR2)

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

163:
164: PROCEDURE do_profile_merge
165: ( p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_to_id IN OUT NOCOPY NUMBER,
167: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
168: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
169: x_return_status IN OUT NOCOPY VARCHAR2)
170: IS
171:

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

164: PROCEDURE do_profile_merge
165: ( p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
166: x_to_id IN OUT NOCOPY NUMBER,
167: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
168: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
169: x_return_status IN OUT NOCOPY VARCHAR2)
170: IS
171:
172: CURSOR c_from_profile

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

284:
285: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
287: FND_MSG_PUB.ADD;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289:
290: END;
291:
292: END;