DBA Data[Home] [Help]

APPS.PA_MERGE_PKG dependencies on PA_CONTROL_ITEMS

Line 46: UPDATE pa_control_items

42: BEGIN
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: IF (p_from_fk_id <> p_to_fk_id) THEN
46: UPDATE pa_control_items
47: SET owner_id = p_to_fk_id
48: WHERE owner_id = p_from_fk_id;
49:
50: x_to_id := p_from_id;

Line 70: UPDATE pa_control_items

66: BEGIN
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: IF (p_from_fk_id <> p_to_fk_id) THEN
70: UPDATE pa_control_items
71: SET last_modified_by_id = p_to_fk_id
72: WHERE last_modified_by_id = p_from_fk_id;
73:
74: x_to_id := p_from_id;

Line 94: UPDATE pa_control_items

90: BEGIN
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF (p_from_fk_id <> p_to_fk_id) THEN
94: UPDATE pa_control_items
95: SET closed_by_id = p_to_fk_id
96: WHERE closed_by_id = p_from_fk_id;
97:
98: x_to_id := p_from_id;