1 Package pay_pgp_upd AUTHID CURRENT_USER as
2 /* $Header: pypgprhi.pkh 115.0 99/07/17 06:22:06 porting ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------------< convert_defs >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- The Convert_Defs procedure has one very important function:
11 -- It must return the record structure for the row with all system defaulted
12 -- values converted into its corresponding argument value for update. When
13 -- we attempt to update a row through the Upd business process , certain
14 -- arguments can be defaulted which enables flexibility in the calling of
15 -- the upd process (e.g. only attributes which need to be updated need to be
16 -- specified). For the upd business process to determine which attributes
17 -- have NOT been specified we need to check if the argument has a reserved
18 -- system default value. Therefore, for all attributes which have a
19 -- corresponding reserved system default mechanism specified we need to
20 -- check if a system default is being used. If a system default is being
21 -- used then we convert the defaulted value into its corresponding attribute
22 -- value held in the g_old_rec data structure.
23 --
24 -- Pre Conditions:
25 -- This private function can only be called from the upd process.
26 --
27 -- In Arguments:
28 -- A Pl/Sql record structre.
29 --
30 -- Post Success:
31 -- The record structure will be returned with all system defaulted argument
32 -- values converted into its current row attribute value.
33 --
34 -- Post Failure:
35 -- No direct error handling is required within this function. Any possible
36 -- errors within this procedure will be a PL/SQL value error due to conversion
37
38 -- of datatypes or data lengths.
39 --
40 -- Developer Implementation Notes:
41 -- None.
42 --
43 -- Access Status:
44 -- Internal Table Handler Use Only.
45 --
46 -- {End Of Comments}
47 -- ----------------------------------------------------------------------------
48 Procedure convert_defs(p_rec in out pay_pgp_shd.g_rec_type);
49 --
50 -- ----------------------------------------------------------------------------
51 -- |-------------------------------< upd_or_sel >-----------------------------|
52 -- ----------------------------------------------------------------------------
53 -- {Start Of Comments}
54 --
55 -- Description:
56 -- This procedure controls the processing required to either insert a new
57 -- combination or update the existing one. This procedure has the same
58 -- functionality of pay_pgp_ins.ins_or_sel except is has to take into
59 -- account the building of a partially specified interface by making calls
60 -- in convert_args and convert_defs.
61 -- 1. If a combination does not exist a new combination is inserted
62 -- returning the new p_people_group_id.
63 -- 2. If a combination exists the out arguments are set.
64 -- 4. If the segments are null (i.e. a null combination) then the out
65 -- arguments are set to null.
66 --
67 -- Pre Conditions:
68 --
69 -- In Arguments:
70 -- p_business_group_id => is specified to enable the derivation of the
71 -- id_flex_num within the process
72 -- pay_pgp_shd.segment_combination_check.
73 --
74 -- Post Success:
75 -- If a combination already exists the out arguments are returned.
76 -- If a combination does not exist then the combination is inserted into
77 -- the pay_people_groups table and the out arguments are returned.
78 -- Processing continues.
79 --
80 -- Post Failure:
81 -- This process has no specific error handling and will only error if an
82 -- application error has ocurred at a lower level.
83 --
84 -- Developer Implementation Notes:
85 -- None.
86 --
87 -- Access Status:
88 -- Internal Development Use Only.
89 --
90 -- {End Of Comments}
91 -- ----------------------------------------------------------------------------
92 procedure upd_or_sel
93 (p_segment1 in varchar2 default hr_api.g_varchar2,
94 p_segment2 in varchar2 default hr_api.g_varchar2,
95 p_segment3 in varchar2 default hr_api.g_varchar2,
96 p_segment4 in varchar2 default hr_api.g_varchar2,
97 p_segment5 in varchar2 default hr_api.g_varchar2,
98 p_segment6 in varchar2 default hr_api.g_varchar2,
99 p_segment7 in varchar2 default hr_api.g_varchar2,
100 p_segment8 in varchar2 default hr_api.g_varchar2,
101 p_segment9 in varchar2 default hr_api.g_varchar2,
102 p_segment10 in varchar2 default hr_api.g_varchar2,
103 p_segment11 in varchar2 default hr_api.g_varchar2,
104 p_segment12 in varchar2 default hr_api.g_varchar2,
105 p_segment13 in varchar2 default hr_api.g_varchar2,
106 p_segment14 in varchar2 default hr_api.g_varchar2,
107 p_segment15 in varchar2 default hr_api.g_varchar2,
108 p_segment16 in varchar2 default hr_api.g_varchar2,
109 p_segment17 in varchar2 default hr_api.g_varchar2,
110 p_segment18 in varchar2 default hr_api.g_varchar2,
111 p_segment19 in varchar2 default hr_api.g_varchar2,
112 p_segment20 in varchar2 default hr_api.g_varchar2,
113 p_segment21 in varchar2 default hr_api.g_varchar2,
114 p_segment22 in varchar2 default hr_api.g_varchar2,
115 p_segment23 in varchar2 default hr_api.g_varchar2,
116 p_segment24 in varchar2 default hr_api.g_varchar2,
117 p_segment25 in varchar2 default hr_api.g_varchar2,
118 p_segment26 in varchar2 default hr_api.g_varchar2,
119 p_segment27 in varchar2 default hr_api.g_varchar2,
120 p_segment28 in varchar2 default hr_api.g_varchar2,
121 p_segment29 in varchar2 default hr_api.g_varchar2,
122 p_segment30 in varchar2 default hr_api.g_varchar2,
123 p_business_group_id in number,
124 p_people_group_id in out number,
125 p_group_name out varchar2,
126 p_validate in boolean default false);
127 --
128 end pay_pgp_upd;