[Home] [Help]
PACKAGE: APPS.HR_RU_UTILITY
Source
1 PACKAGE hr_ru_utility AUTHID CURRENT_USER AS
2 /* $Header: peruutil.pkh 120.0 2005/05/31 20:19:48 appldev noship $ */
3
4 PROCEDURE check_lookup_value (
5 p_argument IN VARCHAR2,
6 p_argument_value IN VARCHAR2,
7 p_lookup_type IN VARCHAR2,
8 p_effective_date IN DATE
9 );
10
11 FUNCTION validate_spifn (spif_number VARCHAR2, p_session_date DATE)
12 RETURN NUMBER;
13
14 PROCEDURE validate_mil_reg_board_code (p_military_reg_board_code VARCHAR2);
15
16 PROCEDURE check_spif_number_unique (
17 p_spifn VARCHAR2
18 ,p_person_id NUMBER
19 ,p_business_group_id NUMBER
20 );
21
22 FUNCTION per_ru_full_name (
23 p_first_name IN VARCHAR2
24 ,p_middle_names IN VARCHAR2
25 ,p_last_name IN VARCHAR2
26 ,p_known_as IN VARCHAR2
27 ,p_title IN VARCHAR2
28 ,p_suffix IN VARCHAR2
29 ,p_pre_name_adjunct IN VARCHAR2
30 ,p_per_information1 IN VARCHAR2
31 ,p_per_information2 IN VARCHAR2
32 ,p_per_information3 IN VARCHAR2
33 ,p_per_information4 IN VARCHAR2
34 ,p_per_information5 IN VARCHAR2
35 ,p_per_information6 IN VARCHAR2
36 ,p_per_information7 IN VARCHAR2
37 ,p_per_information8 IN VARCHAR2
38 ,p_per_information9 IN VARCHAR2
39 ,p_per_information10 IN VARCHAR2
40 ,p_per_information11 IN VARCHAR2
41 ,p_per_information12 IN VARCHAR2
42 ,p_per_information13 IN VARCHAR2
43 ,p_per_information14 IN VARCHAR2
44 ,p_per_information15 IN VARCHAR2
45 ,p_per_information16 IN VARCHAR2
46 ,p_per_information17 IN VARCHAR2
47 ,p_per_information18 IN VARCHAR2
48 ,p_per_information19 IN VARCHAR2
49 ,p_per_information20 IN VARCHAR2
50 ,p_per_information21 IN VARCHAR2
51 ,p_per_information22 IN VARCHAR2
52 ,p_per_information23 IN VARCHAR2
53 ,p_per_information24 IN VARCHAR2
54 ,p_per_information25 IN VARCHAR2
55 ,p_per_information26 IN VARCHAR2
56 ,p_per_information27 IN VARCHAR2
57 ,p_per_information28 IN VARCHAR2
58 ,p_per_information29 IN VARCHAR2
59 ,p_per_information30 IN VARCHAR2
60 )
61 RETURN VARCHAR2;
62
63 FUNCTION per_ru_full_name_initials (
64 p_first_name IN VARCHAR2,
65 p_middle_names IN VARCHAR2,
66 p_last_name IN VARCHAR2,
67 p_genitive_last_name IN VARCHAR2 DEFAULT NULL,
68 p_known_as IN VARCHAR2 DEFAULT NULL,
69 p_title IN VARCHAR2 DEFAULT NULL,
70 p_suffix IN VARCHAR2 DEFAULT NULL,
71 use_genitive IN BOOLEAN DEFAULT TRUE
72 )
73 RETURN VARCHAR2;
74
75 FUNCTION validate_tax_no (p_org_info VARCHAR2)
76 RETURN NUMBER;
77
78 FUNCTION validate_ogrn (p_org_info IN VARCHAR2)
79 RETURN NUMBER;
80
81 FUNCTION check_tax_number_unique (p_tax_no VARCHAR2, p_org_id NUMBER, p_org_info_code VARCHAR2)
82 RETURN NUMBER;
83
84 FUNCTION validate_kpp (p_kpp VARCHAR2)
85 RETURN NUMBER;
86
87 FUNCTION validate_si (p_si VARCHAR2)
88 RETURN NUMBER;
89
90 FUNCTION validate_okogu (p_okogu VARCHAR2)
91 RETURN NUMBER;
92
93 FUNCTION validate_okpo (p_okpo VARCHAR2)
94 RETURN NUMBER;
95
96 FUNCTION validate_org_spifn (p_spifn VARCHAR2)
97 RETURN NUMBER;
98
99 FUNCTION validate_okved (p_okved VARCHAR2)
100 RETURN NUMBER;
101
102 FUNCTION validate_bik (p_bank_bik VARCHAR2)
103 RETURN NUMBER;
104
105 FUNCTION validate_acc_no (p_bank_acc_no VARCHAR2)
106 RETURN NUMBER;
107
108 FUNCTION validate_bank_info (p_bank_inn VARCHAR2)
109 RETURN NUMBER;
110
111 FUNCTION chk_id_format (p_id IN VARCHAR2, p_format_string IN VARCHAR2)
112 RETURN VARCHAR2;
113
114 FUNCTION check_segment_number (entry_value IN VARCHAR2)
115 RETURN VARCHAR2;
116
117 FUNCTION check_contract_number_unique (
118 p_contract_number VARCHAR2
119 ,p_assignment_id NUMBER
120 ,p_business_group_id NUMBER
121 ) RETURN VARCHAR2;
122
123 FUNCTION check_assign_category (
124 p_eff_start_date DATE
125 ,p_eff_end_date DATE
126 ,p_assignment_id NUMBER
127 ,p_person_id NUMBER
128 ,p_business_group_id NUMBER
129 ) RETURN VARCHAR2;
130
131 END hr_ru_utility;