APPS.AHL_RM_ROUTE_UTIL dependencies on HZ_PARTIES

Line 209: p_operator_name IN HZ_PARTIES.party_name%TYPE,

205: PROCEDURE validate_operator
206: (
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_operator_name IN HZ_PARTIES.party_name%TYPE,
210: p_x_operator_party_id IN OUT NOCOPY NUMBER
211: )
212: IS
213:

Line 214: l_operator_party_id HZ_PARTIES.party_id%TYPE;

210: p_x_operator_party_id IN OUT NOCOPY NUMBER
211: )
212: IS
213:
214: l_operator_party_id HZ_PARTIES.party_id%TYPE;
215:
216: CURSOR get_rec_from_value ( c_operator_name HZ_PARTIES.party_name%TYPE )
217: IS
218: SELECT DISTINCT party_id

Line 216: CURSOR get_rec_from_value ( c_operator_name HZ_PARTIES.party_name%TYPE )

212: IS
213:
214: l_operator_party_id HZ_PARTIES.party_id%TYPE;
215:
216: CURSOR get_rec_from_value ( c_operator_name HZ_PARTIES.party_name%TYPE )
217: IS
218: SELECT DISTINCT party_id
219: FROM HZ_PARTIES
220: WHERE party_name = c_operator_name;

Line 219: FROM HZ_PARTIES

215:
216: CURSOR get_rec_from_value ( c_operator_name HZ_PARTIES.party_name%TYPE )
217: IS
218: SELECT DISTINCT party_id
219: FROM HZ_PARTIES
220: WHERE party_name = c_operator_name;
221:
222: CURSOR get_rec_from_id ( c_operator_party_id NUMBER )
223: IS

Line 225: FROM HZ_PARTIES

221:
222: CURSOR get_rec_from_id ( c_operator_party_id NUMBER )
223: IS
224: SELECT DISTINCT party_id
225: FROM HZ_PARTIES
226: WHERE party_id = c_operator_party_id;
227:
228: BEGIN
229: x_return_status := FND_API.G_RET_STS_SUCCESS;