1 PACKAGE PQH_DE_CONT_EMPLOYMENT_PKG as
2 /* $Header: pqhdespd.pkh 120.0.12000000.1 2007/01/16 22:58:55 appldev noship $ */
3
4 /*---------------------------------------------------------------------------------------------+
5 Procedure Check_Contact_Employment
6 ----------------------------------------------------------------------------------------------+
7 Description:
8 This is intended to run as before insert user hook on Person Extra Information to validate
9 German Public Sector Spouse Details. The processing is as follows
10 1. Checks if the information type is DE_PQH_SPOUSE_DETAILS.
11 2. If the Spouse is employed in public sector then
12 i) Check for employment type.
13 11)check for employment region.
14 iii)check for Number of Working Hours.
15 3. If atlest one on the above three details is missing raise error
16
17
18 In Parameters:
19 1.PEI_INFORMATION_TYPE IN VARCHAR2
20 2.PEI_INFORMATION1 IN VARCHAR2
21 3.PEI_INFORMATION2 IN VARCHAR2
22 4.PEI_INFORMATION3 IN VARCHAR2
23 5.PEI_INFORMATION4 IN VARCHAR2
24
25
26 Post Success:
27 Does nothing there by allowing the record to be inserted.
28
29 Post Failure:
30 Raises application failure there by preventing the insertion of the record
31 Developer Implementation Notes:
32 For PEI_INFORMATION_TYPE 'DE_PQH_SPOUSE_DETAILS' the structure is as follows
33 1.PEI_INFORMATION1 Employed in Public Sector.
34 2.PEI_INFORMATION2 Employment Type.
35 3.PEI_INFORMATION3 Region
36 4.PEI_INFORMATION4 Number of Working Hours
37
38
39 -------------------------------------------------------------------------------------------------*/
40 PROCEDURE Check_Contact_Employment(P_INFORMATION_TYPE IN VARCHAR2,
41 P_PEI_INFORMATION1 IN VARCHAR2,
42 P_PEI_INFORMATION2 IN VARCHAR2,
43 P_PEI_INFORMATION3 IN VARCHAR2,
44 P_PEI_INFORMATION4 IN VARCHAR2);
45
46
47 /*---------------------------------------------------------------------------------------------+
48 Procedure Update_Contact_Employment
49 ----------------------------------------------------------------------------------------------+
50 Description:
51 This is intended to run as before update user hook on Person Extra Information to validate
52 German Public Sector Spouse Details. The processing is as follows
53 1. Checks if the information type is DE_PQH_SPOUSE_DETAILS.
54 2. If the Spouse is employed in public sector then
55 i) Check for employment type.
56 11)check for employment region.
57 iii)check for Number of Working Hours.
58 3. If atlest one on the above three details is missing raise error
59
60
61 In Parameters:
62 1.PEI_INFORMATION_TYPE IN VARCHAR2
63 2.PEI_INFORMATION1 IN VARCHAR2
64 3.PEI_INFORMATION2 IN VARCHAR2
65 4.PEI_INFORMATION3 IN VARCHAR2
66 5.PEI_INFORMATION4 IN VARCHAR2
67
68
69 Post Success:
70 Does nothing there by allowing the record to be updated.
71
72 Post Failure:
73 Raises application failure there by preventing the updation of the record
74 Developer Implementation Notes:
75 For PEI_INFORMATION_TYPE 'DE_PQH_SPOUSE_DETAILS' the structure is as follows
76 1.PEI_INFORMATION1 Employed in Public Sector.
77 2.PEI_INFORMATION2 Employment Type.
78 3.PEI_INFORMATION3 Region
79 4.PEI_INFORMATION4 Number of Working Hours
80
81
82 -------------------------------------------------------------------------------------------------*/
83
84 PROCEDURE Update_Contact_Employment(P_PEI_INFORMATION_CATEGORY IN VARCHAR2,
85 P_PEI_INFORMATION1 IN VARCHAR2,
86 P_PEI_INFORMATION2 IN VARCHAR2,
87 P_PEI_INFORMATION3 IN VARCHAR2,
88 P_PEI_INFORMATION4 IN VARCHAR2);
89
90 END PQH_DE_CONT_EMPLOYMENT_PKG;