1 Package HR_CGD_ins AUTHID CURRENT_USER as
2 /* $Header: hrcgdrhi.pkh 115.4 2002/12/03 09:09:36 hjonnala ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------------< ins_or_sel >-----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This procedure controls the processing required to insert a new
10 -- combination or return the the combination id for an existing
11 -- combination.
12 -- 1. If a combination does not exist a new combination is inserted
13 -- returning the new p_cagr_grade_def_id, if id_flex_num is given.
14 -- 2. If the segments are null (i.e. a null combination) then the out
15 -- arguments are set to null.
16 -- 3. If a combination does exist and the id_flex_num is given,
17 -- the p_cagr_grade_def_id is returned.
18 -- 4. The INS_OR_SEL parameter indicates if a combination was inserted
19 -- or selected, or is set to 'NUL' for a null combination
20 --
21 --
22 -- Pre Conditions:
23 --
24 -- In Arguments:
25 -- p_id_flex_num
26 -- p_business_group_id
27 --
28 -- Out Arguments
29 -- p_cagr_grade_def_id
30 -- p_concatenated_segments
31 -- p_ins_or_sel
32 --
33 -- Post Success:
34 -- If a combination already exists the out arguments are returned.
35 -- If a combination does not exist then the combination is inserted into
36 -- the soft coded table and the out arguments are returned.
37 -- Processing continues.
38 --
39 -- Post Failure:
40 -- This process has no specific error handling and will only error if an
41 -- application error has ocurred at a lower level.
42 --
43 -- Developer Implementation Notes:
44 -- None.
45 --
46 -- Access Status:
47 -- Internal Development Use Only.
48 --
49 -- {End Of Comments}
50 -- ----------------------------------------------------------------------------
51 procedure ins_or_sel
52 (p_segment1 in varchar2 default null,
53 p_segment2 in varchar2 default null,
54 p_segment3 in varchar2 default null,
55 p_segment4 in varchar2 default null,
56 p_segment5 in varchar2 default null,
57 p_segment6 in varchar2 default null,
58 p_segment7 in varchar2 default null,
59 p_segment8 in varchar2 default null,
60 p_segment9 in varchar2 default null,
61 p_segment10 in varchar2 default null,
62 p_segment11 in varchar2 default null,
63 p_segment12 in varchar2 default null,
64 p_segment13 in varchar2 default null,
65 p_segment14 in varchar2 default null,
66 p_segment15 in varchar2 default null,
67 p_segment16 in varchar2 default null,
68 p_segment17 in varchar2 default null,
69 p_segment18 in varchar2 default null,
70 p_segment19 in varchar2 default null,
71 p_segment20 in varchar2 default null,
72 p_id_flex_num in number default null,
73 p_business_group_id in number,
74 p_cagr_grade_def_id out nocopy number,
75 p_concatenated_segments out nocopy varchar2);
76 --
77 end hr_cgd_ins;