APPS.AHL_FMP_COMMON_PVT dependencies on FND_LOOKUPS

Line 12: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,

8: PROCEDURE validate_lookup
9: (
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
13: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
14: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
15: )
16: IS

Line 13: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,

9: (
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
13: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
14: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
15: )
16: IS
17:

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

10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
13: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
14: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
15: )
16: IS
17:
18: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;

Line 18: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;

14: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
15: )
16: IS
17:
18: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
19:
20: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
21: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
22: IS

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

16: IS
17:
18: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
19:
20: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
21: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
22: IS
23: SELECT lookup_code
24: FROM FND_LOOKUP_VALUES_VL

Line 21: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )

17:
18: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
19:
20: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
21: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
22: IS
23: SELECT lookup_code
24: FROM FND_LOOKUP_VALUES_VL
25: WHERE lookup_type = c_lookup_type

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

26: AND meaning = c_lookup_meaning
27: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
28: NVL( end_date_active, SYSDATE );
29:
30: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
31: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
32: IS
33: SELECT lookup_code
34: FROM FND_LOOKUP_VALUES_VL

Line 31: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )

27: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
28: NVL( end_date_active, SYSDATE );
29:
30: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
31: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
32: IS
33: SELECT lookup_code
34: FROM FND_LOOKUP_VALUES_VL
35: WHERE lookup_type = c_lookup_type

Line 385: l_posn_meaning FND_LOOKUPS.meaning%TYPE;

381:
382: l_relationship_id NUMBER;
383:
384: l_valid_rec_found BOOLEAN := FALSE;
385: l_posn_meaning FND_LOOKUPS.meaning%TYPE;
386: l_junk VARCHAR2(1);
387: */
388: /*CURSOR get_rec_from_value ( c_position_ref_meaning VARCHAR2 )
389: IS

Line 512: l_posn_meaning FND_LOOKUPS.meaning%TYPE;

508: p_x_relationship_id IN OUT NOCOPY NUMBER
509: )
510: IS
511: l_mc_header_id NUMBER;
512: l_posn_meaning FND_LOOKUPS.meaning%TYPE;
513: l_dummy_char VARCHAR2(1);
514:
515: CURSOR get_mc_header_id ( c_relationship_id NUMBER )
516: IS