1 PACKAGE PER_BG_NUMBERING_METHOD_PKG AUTHID CURRENT_USER AS
2 /* $Header: pebgnuma.pkh 115.3 2004/01/30 09:11:39 irgonzal noship $ */
3
4 --
5 PROCEDURE convert_to_auto_gen_method
6 (errbuf OUT nocopy varchar2
7 ,retcode OUT nocopy number
8 ,p_business_group_id IN number
9 ,p_person_type IN varchar2
10 );
11 --
12 -- Enables the global sequence to generate automatic person numbers.
13 --
14 PROCEDURE convert_to_global_sequence
15 (errbuf OUT nocopy varchar2
16 ,retcode OUT nocopy number
17 ,p_person_type IN varchar2
18 );
19
20 --
21 -- Returns true if Cross-BG person numbering is set to 'Y'
22 --
23 FUNCTION Global_person_numbering(p_person_type IN varchar2)
24 RETURN BOOLEAN;
25 --
26 -- Returns Next person number from global sequence
27 --
28 FUNCTION GetGlobalPersonNum(p_person_type IN varchar2)
29 RETURN NUMBER;
30 --
31 -- Alters global sequence based on last number
32 --
33 PROCEDURE SET_GLOBAL_SEQUENCE(p_person_type IN varchar2
34 ,p_last_number IN NUMBER);
35 --
36 -- --------------------------------------------------------------------- +
37 -- Name: Get_PersonNumber_Formula
38 -- Purpose: Retrieves the fast formula id defined for person number
39 -- generation.
40 -- Returns: formula id is successful, null otherwise.
41 -- --------------------------------------------------------------------- +
42 FUNCTION Get_PersonNumber_Formula(p_person_type varchar2
43 ,p_effective_date date)
44 RETURN number;
45 --
46 -- --------------------------------------------------------------------- +
47 -- Name: Execute_Get_Person_Number_FF
48 -- Purpose: Execute fast formula in order to generate next person number.
49 -- Returns: Next person number
50 -- --------------------------------------------------------------------- +
51 FUNCTION EXECUTE_GET_PERSON_NUMBER_FF(
52 p_formula_id number
53 ,p_effective_date date
54 ,p_business_group_id number
55 ,p_person_type varchar2
56 ,p_legislation_code varchar2
57 ,p_person_id number
58 ,p_person_number varchar2
59 ,p_party_id number
60 ,p_date_of_birth date
61 ,p_start_date date
62 ,p_national_id per_all_people_f.national_identifier%TYPE)
63 RETURN VARCHAR2;
64 --
65 END PER_BG_NUMBERING_METHOD_PKG;
[Home] [Help]