9: P_PEI_INFORMATION4 IN VARCHAR2 ) is
10:
11: Begin
12: -- Check if DE is installed
13: IF hr_utility.chk_product_install('Oracle Human Resources', 'DE') THEN
14:
15: --
16: savepoint Check_Contact_Employment;
17: --
23: or P_PEI_INFORMATION4 is null --Number of Working Hours not specified
24: )
25: )
26: then
27: hr_utility.set_message(800,'DE_PQH_SPOUSE_DETAILS');
28: hr_utility.raise_error;
29:
30: end if;
31: end if;
24: )
25: )
26: then
27: hr_utility.set_message(800,'DE_PQH_SPOUSE_DETAILS');
28: hr_utility.raise_error;
29:
30: end if;
31: end if;
32: --
41: P_PEI_INFORMATION4 IN VARCHAR2) is
42:
43: Begin
44: -- Check if DE is installed
45: IF hr_utility.chk_product_install('Oracle Human Resources', 'DE') THEN
46:
47: --
48: savepoint Update_Contact_Employment;
49: --
55: or P_PEI_INFORMATION4 is null --Number of Working Hours not specified
56: )
57: )
58: then
59: hr_utility.set_message(800,'DE_PQH_SPOUSE_DETAILS');
60: hr_utility.raise_error;
61:
62: end if;
63: end if;
56: )
57: )
58: then
59: hr_utility.set_message(800,'DE_PQH_SPOUSE_DETAILS');
60: hr_utility.raise_error;
61:
62: end if;
63: end if;
64: --