APPS.AHL_RM_ROUTE_UTIL dependencies on HZ_PARTIES

Line 211: p_operator_name IN HZ_PARTIES.party_name%TYPE,

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

Line 216: l_operator_party_id HZ_PARTIES.party_id%TYPE;

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

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

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

Line 221: FROM HZ_PARTIES

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

Line 227: FROM HZ_PARTIES

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