DBA Data[Home] [Help]

APPS.PA_CI_MERGE_PKG dependencies on FND_API

Line 16: x_return_status := FND_API.G_RET_STS_SUCCESS;

12: p_batch_party_id IN NUMBER,
13: x_return_status OUT NOCOPY VARCHAR2)
14: IS
15: BEGIN
16: x_return_status := FND_API.G_RET_STS_SUCCESS;
17:
18: IF (p_from_fk_id <> p_to_fk_id) THEN
19: UPDATE pa_control_items
20: SET owner_id = p_to_fk_id

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: p_batch_party_id IN NUMBER,
37: x_return_status OUT NOCOPY VARCHAR2)
38: IS
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: IF (p_from_fk_id <> p_to_fk_id) THEN
43: UPDATE pa_control_items
44: SET last_modified_by_id = p_to_fk_id

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: p_batch_party_id IN NUMBER,
61: x_return_status OUT NOCOPY VARCHAR2)
62: IS
63: BEGIN
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: IF (p_from_fk_id <> p_to_fk_id) THEN
67: UPDATE pa_control_items
68: SET closed_by_id = p_to_fk_id

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: p_batch_party_id IN NUMBER,
85: x_return_status OUT NOCOPY VARCHAR2)
86: IS
87: BEGIN
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: IF (p_from_fk_id <> p_to_fk_id) THEN
91: UPDATE pa_ci_actions
92: SET assigned_to = p_to_fk_id

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

108: p_batch_party_id IN NUMBER,
109: x_return_status OUT NOCOPY VARCHAR2)
110: IS
111: BEGIN
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113:
114: IF (p_from_fk_id <> p_to_fk_id) THEN
115: UPDATE pa_ci_impacts
116: SET implemented_by = p_to_fk_id

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148:
149: cp_party c_parties%ROWTYPE;
150:
151: BEGIN
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: IF (p_from_fk_id <> p_to_fk_id) THEN
155: BEGIN
156: --Looking for a grant from PA for the party being merged

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163: AND g.grantee_key = 'HZ_PARTY:'||p_from_fk_id
164: AND ROWNUM = 1;
165:
166: --Veto if grant is found for the same party, because grants are not yet merged
167: x_return_status := FND_API.G_RET_STS_ERROR;
168:
169: FND_MESSAGE.SET_NAME('PA', 'PA_REJECT_MERGE');
170: FND_MSG_PUB.add;
171:

Line 238: x_return_status := FND_API.G_RET_STS_SUCCESS;

234: p_to_resource_id IN NUMBER,
235: x_return_status OUT NOCOPY VARCHAR2)
236: IS
237: BEGIN
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: IF (p_from_resource_id <> p_to_resource_id) THEN
241: UPDATE pa_project_parties
242: SET resource_id = p_to_resource_id