1 PACKAGE IGS_EN_VAL_API AS
2 /* $Header: IGSEN23S.pls 120.1 2005/08/29 08:01:02 appldev ship $ */
3
4 -------------------------------------------------------------------------------------------
5 --Change History:
6 --Who When What
7 --pkpatel 8-JUN-2002 Bug No: 2402077
8 -- Added Functions val_overlap_api, val_ssn_overlap_api, fm_equal, unformat_api
9 --jbegum 29-AUG-2001 Bug No. 1956374 . Removed function enrp_val_api_end_dt
10 --smadathi 29-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_STRT_END_DTS
11 -- removed.
12 --smadathi 24-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_SDTT_SESS
13 -- removed.
14 --msrinivi 24-AUG-2001 Bug No. 1956374 .The function declaration of genp_set_rowid
15 -- removed.
16 -------------------------------------------------------------------------------------------
17 --
18 TYPE t_api_rowids IS TABLE OF
19 ROWID
20 INDEX BY BINARY_INTEGER;
21
22 gt_rowid_table t_api_rowids;
23 gt_empty_table t_api_rowids;
24 gv_table_index BINARY_INTEGER;
25
26 -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
27 PROCEDURE genp_prc_clear_rowid;
28
29 -- Routine to process api rowids in a PL/SQL TABLE for the current commit
30 FUNCTION enrp_prc_api_rowids(
31 p_inserting IN BOOLEAN ,
32 p_updating IN BOOLEAN ,
33 p_deleting IN BOOLEAN ,
34 p_message_name OUT NOCOPY VARCHAR2)
35 RETURN BOOLEAN;
36
37
38 -- Validate the payment advice number is unique.
39 FUNCTION enrp_val_api_pan(
40 p_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE ,
41 p_pay_advice_number IGS_PE_ALT_PERS_ID.api_person_id%TYPE ,
42 p_message_name OUT NOCOPY VARCHAR2)
43 RETURN BOOLEAN;
44
45 -- Check Overlapping period for Person Id Types
46 FUNCTION val_overlap_api(
47 p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
48 RETURN BOOLEAN;
49
50 -- Check Overlapping period for Person Id Types associated with System Person ID type SSN
51 FUNCTION val_ssn_overlap_api(
52 p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
53 RETURN BOOLEAN;
54
55 -- To compare the Format mask whether it contains any character other than 9,X and special character.
56 FUNCTION fm_equal(
57 p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,
58 p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)
59 RETURN BOOLEAN;
60
61 -- To unformat the Formatted Alternate Person ID.
62 FUNCTION unformat_api(
63 p_api_pers_id IN igs_pe_alt_pers_id.api_person_id%TYPE)
64 RETURN VARCHAR2;
65
66 -- wrapper function To compare the Format mask whether it contains any character other than 9,X and special character.
67 -- This function would be called from SS
68 FUNCTION fm_equal_wrap(
69 p_format_mask IN igs_pe_person_id_typ.format_mask%TYPE,
70 p_frmt_msk_copy IN igs_pe_person_id_typ.format_mask%TYPE)
71 RETURN NUMBER;
72 END IGS_EN_VAL_API;