1 PACKAGE pe_fr_additional_org_rules AS
2 /* $Header: pefrorgh.pkh 120.0 2005/05/31 08:59:46 appldev noship $ */
3
4 PROCEDURE fr_validate_org_info_ins
5 (p_effective_date IN DATE
6 ,p_organization_id IN NUMBER
7 ,p_org_info_type_code IN VARCHAR2
8 ,p_org_information1 IN VARCHAR2
9 ,p_org_information2 IN VARCHAR2
10 ,p_org_information3 IN VARCHAR2
11 ,p_org_information4 IN VARCHAR2
12 ,p_org_information5 IN VARCHAR2
13 ,p_org_information6 IN VARCHAR2
14 ,p_org_information7 IN VARCHAR2
15 ,p_org_information8 IN VARCHAR2
16 ,p_org_information9 IN VARCHAR2
17 ,p_org_information10 IN VARCHAR2
18 ,p_org_information11 IN VARCHAR2
19 ,p_org_information12 IN VARCHAR2
20 ,p_org_information13 IN VARCHAR2
21 ,p_org_information14 IN VARCHAR2
22 ,p_org_information15 IN VARCHAR2
23 ,p_org_information16 IN VARCHAR2
24 ,p_org_information17 IN VARCHAR2
25 ,p_org_information18 IN VARCHAR2
26 ,p_org_information19 IN VARCHAR2
27 ,p_org_information20 IN VARCHAR2
28 );
29
30 PROCEDURE fr_validate_org_info_upd
31 (p_effective_date IN DATE
32 ,p_org_info_type_code IN VARCHAR2
33 ,p_org_information1 IN VARCHAR2
34 ,p_org_information2 IN VARCHAR2
35 ,p_org_information3 IN VARCHAR2
36 ,p_org_information4 IN VARCHAR2
37 ,p_org_information5 IN VARCHAR2
38 ,p_org_information6 IN VARCHAR2
39 ,p_org_information7 IN VARCHAR2
40 ,p_org_information8 IN VARCHAR2
41 ,p_org_information9 IN VARCHAR2
42 ,p_org_information10 IN VARCHAR2
43 ,p_org_information11 IN VARCHAR2
44 ,p_org_information12 IN VARCHAR2
45 ,p_org_information13 IN VARCHAR2
46 ,p_org_information14 IN VARCHAR2
47 ,p_org_information15 IN VARCHAR2
48 ,p_org_information16 IN VARCHAR2
49 ,p_org_information17 IN VARCHAR2
50 ,p_org_information18 IN VARCHAR2
51 ,p_org_information19 IN VARCHAR2
52 ,p_org_information20 IN VARCHAR2
53 ,p_org_information_id IN NUMBER
54 ,p_object_version_number IN NUMBER
55 );
56
57 PROCEDURE fr_validate_org_info
58 (p_effective_date IN DATE
59 ,p_org_info_type_code IN VARCHAR2
60 ,p_org_information1 IN VARCHAR2
61 ,p_org_information2 IN VARCHAR2
62 ,p_org_information3 IN VARCHAR2
63 ,p_org_information4 IN VARCHAR2
64 ,p_org_information5 IN VARCHAR2
65 ,p_organization_id IN NUMBER default null /* ins only */
66 ,p_org_information_id IN NUMBER default null /* upd only */
67 ,p_object_version_number IN NUMBER default null /* upd only */ );
68
69 END pe_fr_additional_org_rules;
[Home] [Help]