1 Package pqh_pei_ddf as
2 /* $Header: pqpeiddf.pkh 120.0 2005/05/29 02:16:39 appldev noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- |-------------------------------< ddf >--------------------------------------|
6 -- -----------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 -- This procedure controls the validation processing required for
11 -- developer descriptive flexfields by calling the relevant validation
12 -- procedures. These are called dependant on the value of the relevant
13 -- entity reference field value.
14 --
15 -- Pre Conditions:
16 -- A fully validated entity record structure.
17 --
18 -- In Arguments:
19 -- p_rec (Record structure for relevant entity).
20 --
21 -- Post Success:
22 -- Processing of the calling api continues.
23 --
24 -- Post Failure:
25 -- A failure can only occur under two circumstances:
26 -- 1) The value of reference field is not supported.
27 -- 2) If when the reference field value is null and not all
28 -- the information arguments are not null(i.e. information
29 -- arguments cannot be set without a corresponding reference
30 -- field value).
31 --
32 -- Developer Implementation Notes:
33 -- Developer defined.
34 --
35 -- Access Status:
36 -- Internal Development Use Only.
37 --
38 -- {End of Comments}
39 -- -----------------------------------------------------------------------------
40 procedure ddf
41 (
42 p_person_extra_info_id in number ,
43 p_person_id in number ,
44 p_information_type in varchar2 ,
45 p_request_id in number ,
46 p_program_application_id in number ,
47 p_program_id in number ,
48 p_program_update_date in date ,
49 p_pei_attribute_category in varchar2 ,
50 p_pei_attribute1 in varchar2 ,
51 p_pei_attribute2 in varchar2 ,
52 p_pei_attribute3 in varchar2 ,
53 p_pei_attribute4 in varchar2 ,
54 p_pei_attribute5 in varchar2 ,
55 p_pei_attribute6 in varchar2 ,
56 p_pei_attribute7 in varchar2 ,
57 p_pei_attribute8 in varchar2 ,
58 p_pei_attribute9 in varchar2 ,
59 p_pei_attribute10 in varchar2 ,
60 p_pei_attribute11 in varchar2 ,
61 p_pei_attribute12 in varchar2 ,
62 p_pei_attribute13 in varchar2 ,
63 p_pei_attribute14 in varchar2 ,
64 p_pei_attribute15 in varchar2 ,
65 p_pei_attribute16 in varchar2 ,
66 p_pei_attribute17 in varchar2 ,
67 p_pei_attribute18 in varchar2 ,
68 p_pei_attribute19 in varchar2 ,
69 p_pei_attribute20 in varchar2 ,
70 p_pei_information_category in varchar2 ,
71 p_pei_information1 in varchar2 ,
72 p_pei_information2 in varchar2 ,
73 p_pei_information3 in varchar2 ,
74 p_pei_information4 in varchar2 ,
75 p_pei_information5 in varchar2 ,
76 p_pei_information6 in varchar2 ,
77 p_pei_information7 in varchar2 ,
78 p_pei_information8 in varchar2 ,
79 p_pei_information9 in varchar2 ,
80 p_pei_information10 in varchar2 ,
81 p_pei_information11 in varchar2 ,
82 p_pei_information12 in varchar2 ,
83 p_pei_information13 in varchar2 ,
84 p_pei_information14 in varchar2 ,
85 p_pei_information15 in varchar2 ,
86 p_pei_information16 in varchar2 ,
87 p_pei_information17 in varchar2 ,
88 p_pei_information18 in varchar2 ,
89 p_pei_information19 in varchar2 ,
90 p_pei_information20 in varchar2 ,
91 p_pei_information21 in varchar2 ,
92 p_pei_information22 in varchar2 ,
93 p_pei_information23 in varchar2 ,
94 p_pei_information24 in varchar2 ,
95 p_pei_information25 in varchar2 ,
96 p_pei_information26 in varchar2 ,
97 p_pei_information27 in varchar2 ,
98 p_pei_information28 in varchar2 ,
99 p_pei_information29 in varchar2 ,
100 p_pei_information30 in varchar2
101 );
102
103
104 Procedure chk_default_role
105 (
106 p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
107 ,p_information_type in per_people_extra_info.information_type%TYPE
108 ,p_person_id in per_people_extra_info.person_id%TYPE
109 ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
110 ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
111 );
112
113
114 --
115 --
116 end pqh_pei_ddf;