eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_VAL_AIA dependencies on IGS_AS_ITEM_ASSESSOR

Line 18: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,

14:
15: --
16: -- Validate only one primary assessor per assessment item
17: FUNCTION assp_val_aia_primary(
18: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
19: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
20: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
21: p_message_name OUT NOCOPY VARCHAR2 )
22: RETURN BOOLEAN;

Line 19: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,

15: --
16: -- Validate only one primary assessor per assessment item
17: FUNCTION assp_val_aia_primary(
18: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
19: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
20: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
21: p_message_name OUT NOCOPY VARCHAR2 )
22: RETURN BOOLEAN;
23:

Line 20: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,

16: -- Validate only one primary assessor per assessment item
17: FUNCTION assp_val_aia_primary(
18: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
19: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
20: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
21: p_message_name OUT NOCOPY VARCHAR2 )
22: RETURN BOOLEAN;
23:
24: --

Line 27: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,

23:
24: --
25: -- Validate assessor links for invalid combinations.
26: FUNCTION assp_val_aia_links(
27: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
28: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,

Line 28: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,

24: --
25: -- Validate assessor links for invalid combinations.
26: FUNCTION assp_val_aia_links(
27: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
28: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
32: p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,

Line 29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,

25: -- Validate assessor links for invalid combinations.
26: FUNCTION assp_val_aia_links(
27: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
28: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
32: p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
33: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ass_assessor_type%TYPE ,

Line 30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,

26: FUNCTION assp_val_aia_links(
27: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
28: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
32: p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
33: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ass_assessor_type%TYPE ,
34: p_message_name OUT NOCOPY VARCHAR2 )

Line 31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,

27: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
28: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
32: p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
33: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ass_assessor_type%TYPE ,
34: p_message_name OUT NOCOPY VARCHAR2 )
35: RETURN BOOLEAN;

Line 32: p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,

28: p_person_id IN IGS_AS_ITEM_ASSESSOR.person_id%TYPE ,
29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
32: p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
33: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ass_assessor_type%TYPE ,
34: p_message_name OUT NOCOPY VARCHAR2 )
35: RETURN BOOLEAN;
36:

Line 33: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ass_assessor_type%TYPE ,

29: p_sequence_number IN IGS_AS_ITEM_ASSESSOR.sequence_number%TYPE ,
30: p_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
31: p_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
32: p_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
33: p_ass_assessor_type IN IGS_AS_ITEM_ASSESSOR.ass_assessor_type%TYPE ,
34: p_message_name OUT NOCOPY VARCHAR2 )
35: RETURN BOOLEAN;
36:
37: --

Line 40: p_new_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,

36:
37: --
38: -- Generic links validation routine.
39: FUNCTION ASSP_VAL_OPTNL_LINKS(
40: p_new_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
41: p_new_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
42: p_new_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
43: p_db_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
44: p_db_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,

Line 41: p_new_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,

37: --
38: -- Generic links validation routine.
39: FUNCTION ASSP_VAL_OPTNL_LINKS(
40: p_new_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
41: p_new_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
42: p_new_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
43: p_db_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
44: p_db_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
45: p_db_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,

Line 42: p_new_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,

38: -- Generic links validation routine.
39: FUNCTION ASSP_VAL_OPTNL_LINKS(
40: p_new_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
41: p_new_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
42: p_new_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
43: p_db_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
44: p_db_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
45: p_db_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
46: p_message_name OUT NOCOPY VARCHAR2 )

Line 43: p_db_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,

39: FUNCTION ASSP_VAL_OPTNL_LINKS(
40: p_new_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
41: p_new_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
42: p_new_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
43: p_db_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
44: p_db_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
45: p_db_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
46: p_message_name OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN;

Line 44: p_db_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,

40: p_new_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
41: p_new_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
42: p_new_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
43: p_db_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
44: p_db_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
45: p_db_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
46: p_message_name OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN;
48:

Line 45: p_db_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,

41: p_new_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
42: p_new_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
43: p_db_location_cd IN IGS_AS_ITEM_ASSESSOR.location_cd%TYPE ,
44: p_db_unit_mode IN IGS_AS_ITEM_ASSESSOR.unit_mode%TYPE ,
45: p_db_unit_class IN IGS_AS_ITEM_ASSESSOR.unit_class%TYPE ,
46: p_message_name OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN;
48:
49: --