1 PACKAGE IGS_AS_VAL_AIA AUTHID CURRENT_USER AS
2 /* $Header: IGSAS12S.pls 115.5 2002/11/28 22:42:23 nsidana ship $ */
3 --
4 -- msrinivi 24-AUG-2001 Bug No. 1956374 .The function genp_val_prsn_id removed
5 -- As part of the bug# 1956374 removed the function crsp_val_ucl_closed
6 -- As part of the bug# 1956374 removed the function crsp_val_loc_cd
7 -- As part of the bug# 1956374 removed the function crsp_val_um_closed
8 --
9 -- Validate assessment assessor type closed indicator.
10 FUNCTION assp_val_asst_closed(
11 p_ass_assessor_type IN IGS_AS_ASSESSOR_TYPE.ass_assessor_type%TYPE ,
12 p_message_name OUT NOCOPY VARCHAR2 )
13 RETURN BOOLEAN;
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;
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 ,
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 --
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 )
47 RETURN BOOLEAN;
48
49 --
50 -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
51
52 END IGS_AS_VAL_AIA;
[Home] [Help]