APPS.AHL_FMP_COMMON_PVT dependencies on FND_LOOKUPS

Line 21: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,

17: PROCEDURE validate_lookup
18: (
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
22: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
23: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
24: )
25: IS

Line 22: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,

18: (
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
22: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
23: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
24: )
25: IS
26:

Line 23: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE

19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
22: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
23: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
24: )
25: IS
26:
27: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;

Line 27: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;

23: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
24: )
25: IS
26:
27: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
28:
29: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
30: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
31: IS

Line 29: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,

25: IS
26:
27: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
28:
29: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
30: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
31: IS
32: SELECT lookup_code
33: FROM FND_LOOKUP_VALUES_VL

Line 30: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )

26:
27: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
28:
29: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
30: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
31: IS
32: SELECT lookup_code
33: FROM FND_LOOKUP_VALUES_VL
34: WHERE lookup_type = c_lookup_type

Line 39: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,

35: AND meaning = c_lookup_meaning
36: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
37: NVL( end_date_active, SYSDATE );
38:
39: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
40: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
41: IS
42: SELECT lookup_code
43: FROM FND_LOOKUP_VALUES_VL

Line 40: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )

36: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
37: NVL( end_date_active, SYSDATE );
38:
39: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
40: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
41: IS
42: SELECT lookup_code
43: FROM FND_LOOKUP_VALUES_VL
44: WHERE lookup_type = c_lookup_type

Line 394: l_posn_meaning FND_LOOKUPS.meaning%TYPE;

390:
391: l_relationship_id NUMBER;
392:
393: l_valid_rec_found BOOLEAN := FALSE;
394: l_posn_meaning FND_LOOKUPS.meaning%TYPE;
395: l_junk VARCHAR2(1);
396: */
397: /*CURSOR get_rec_from_value ( c_position_ref_meaning VARCHAR2 )
398: IS

Line 521: l_posn_meaning FND_LOOKUPS.meaning%TYPE;

517: p_x_relationship_id IN OUT NOCOPY NUMBER
518: )
519: IS
520: l_mc_header_id NUMBER;
521: l_posn_meaning FND_LOOKUPS.meaning%TYPE;
522: l_dummy_char VARCHAR2(1);
523:
524: CURSOR get_mc_header_id ( c_relationship_id NUMBER )
525: IS