9: --
10: -- ----------------------------------------------------------------------------
11: -- |-----------------------------< convert_defs >-----------------------------|
12: -- ----------------------------------------------------------------------------
13: Procedure convert_defs(p_rec in out nocopy hr_cgd_shd.g_rec_type) is
14: --
15: l_proc varchar2(72) := g_package||'convert_defs';
16: --
17: Begin
24: -- is being used then we must set to the 'current' argument value.
25: --
26: If (p_rec.id_flex_num = hr_api.g_number) then
27: p_rec.id_flex_num :=
28: hr_cgd_shd.g_old_rec.id_flex_num;
29: End If;
30: If (p_rec.summary_flag = hr_api.g_varchar2) then
31: p_rec.summary_flag :=
32: hr_cgd_shd.g_old_rec.summary_flag;
28: hr_cgd_shd.g_old_rec.id_flex_num;
29: End If;
30: If (p_rec.summary_flag = hr_api.g_varchar2) then
31: p_rec.summary_flag :=
32: hr_cgd_shd.g_old_rec.summary_flag;
33: End If;
34: If (p_rec.enabled_flag = hr_api.g_varchar2) then
35: p_rec.enabled_flag :=
36: hr_cgd_shd.g_old_rec.enabled_flag;
32: hr_cgd_shd.g_old_rec.summary_flag;
33: End If;
34: If (p_rec.enabled_flag = hr_api.g_varchar2) then
35: p_rec.enabled_flag :=
36: hr_cgd_shd.g_old_rec.enabled_flag;
37: End If;
38: If (p_rec.start_date_active = hr_api.g_date) then
39: p_rec.start_date_active :=
40: hr_cgd_shd.g_old_rec.start_date_active;
36: hr_cgd_shd.g_old_rec.enabled_flag;
37: End If;
38: If (p_rec.start_date_active = hr_api.g_date) then
39: p_rec.start_date_active :=
40: hr_cgd_shd.g_old_rec.start_date_active;
41: End If;
42: If (p_rec.end_date_active = hr_api.g_date) then
43: p_rec.end_date_active :=
44: hr_cgd_shd.g_old_rec.end_date_active;
40: hr_cgd_shd.g_old_rec.start_date_active;
41: End If;
42: If (p_rec.end_date_active = hr_api.g_date) then
43: p_rec.end_date_active :=
44: hr_cgd_shd.g_old_rec.end_date_active;
45: End If;
46: If (p_rec.segment1 = hr_api.g_varchar2) then
47: p_rec.segment1 :=
48: hr_cgd_shd.g_old_rec.segment1;
44: hr_cgd_shd.g_old_rec.end_date_active;
45: End If;
46: If (p_rec.segment1 = hr_api.g_varchar2) then
47: p_rec.segment1 :=
48: hr_cgd_shd.g_old_rec.segment1;
49: End If;
50: If (p_rec.segment2 = hr_api.g_varchar2) then
51: p_rec.segment2 :=
52: hr_cgd_shd.g_old_rec.segment2;
48: hr_cgd_shd.g_old_rec.segment1;
49: End If;
50: If (p_rec.segment2 = hr_api.g_varchar2) then
51: p_rec.segment2 :=
52: hr_cgd_shd.g_old_rec.segment2;
53: End If;
54: If (p_rec.segment3 = hr_api.g_varchar2) then
55: p_rec.segment3 :=
56: hr_cgd_shd.g_old_rec.segment3;
52: hr_cgd_shd.g_old_rec.segment2;
53: End If;
54: If (p_rec.segment3 = hr_api.g_varchar2) then
55: p_rec.segment3 :=
56: hr_cgd_shd.g_old_rec.segment3;
57: End If;
58: If (p_rec.segment4 = hr_api.g_varchar2) then
59: p_rec.segment4 :=
60: hr_cgd_shd.g_old_rec.segment4;
56: hr_cgd_shd.g_old_rec.segment3;
57: End If;
58: If (p_rec.segment4 = hr_api.g_varchar2) then
59: p_rec.segment4 :=
60: hr_cgd_shd.g_old_rec.segment4;
61: End If;
62: If (p_rec.segment5 = hr_api.g_varchar2) then
63: p_rec.segment5 :=
64: hr_cgd_shd.g_old_rec.segment5;
60: hr_cgd_shd.g_old_rec.segment4;
61: End If;
62: If (p_rec.segment5 = hr_api.g_varchar2) then
63: p_rec.segment5 :=
64: hr_cgd_shd.g_old_rec.segment5;
65: End If;
66: If (p_rec.segment6 = hr_api.g_varchar2) then
67: p_rec.segment6 :=
68: hr_cgd_shd.g_old_rec.segment6;
64: hr_cgd_shd.g_old_rec.segment5;
65: End If;
66: If (p_rec.segment6 = hr_api.g_varchar2) then
67: p_rec.segment6 :=
68: hr_cgd_shd.g_old_rec.segment6;
69: End If;
70: If (p_rec.segment7 = hr_api.g_varchar2) then
71: p_rec.segment7 :=
72: hr_cgd_shd.g_old_rec.segment7;
68: hr_cgd_shd.g_old_rec.segment6;
69: End If;
70: If (p_rec.segment7 = hr_api.g_varchar2) then
71: p_rec.segment7 :=
72: hr_cgd_shd.g_old_rec.segment7;
73: End If;
74: If (p_rec.segment8 = hr_api.g_varchar2) then
75: p_rec.segment8 :=
76: hr_cgd_shd.g_old_rec.segment8;
72: hr_cgd_shd.g_old_rec.segment7;
73: End If;
74: If (p_rec.segment8 = hr_api.g_varchar2) then
75: p_rec.segment8 :=
76: hr_cgd_shd.g_old_rec.segment8;
77: End If;
78: If (p_rec.segment9 = hr_api.g_varchar2) then
79: p_rec.segment9 :=
80: hr_cgd_shd.g_old_rec.segment9;
76: hr_cgd_shd.g_old_rec.segment8;
77: End If;
78: If (p_rec.segment9 = hr_api.g_varchar2) then
79: p_rec.segment9 :=
80: hr_cgd_shd.g_old_rec.segment9;
81: End If;
82: If (p_rec.segment10 = hr_api.g_varchar2) then
83: p_rec.segment10 :=
84: hr_cgd_shd.g_old_rec.segment10;
80: hr_cgd_shd.g_old_rec.segment9;
81: End If;
82: If (p_rec.segment10 = hr_api.g_varchar2) then
83: p_rec.segment10 :=
84: hr_cgd_shd.g_old_rec.segment10;
85: End If;
86: If (p_rec.segment11 = hr_api.g_varchar2) then
87: p_rec.segment11 :=
88: hr_cgd_shd.g_old_rec.segment11;
84: hr_cgd_shd.g_old_rec.segment10;
85: End If;
86: If (p_rec.segment11 = hr_api.g_varchar2) then
87: p_rec.segment11 :=
88: hr_cgd_shd.g_old_rec.segment11;
89: End If;
90: If (p_rec.segment12 = hr_api.g_varchar2) then
91: p_rec.segment12 :=
92: hr_cgd_shd.g_old_rec.segment12;
88: hr_cgd_shd.g_old_rec.segment11;
89: End If;
90: If (p_rec.segment12 = hr_api.g_varchar2) then
91: p_rec.segment12 :=
92: hr_cgd_shd.g_old_rec.segment12;
93: End If;
94: If (p_rec.segment13 = hr_api.g_varchar2) then
95: p_rec.segment13 :=
96: hr_cgd_shd.g_old_rec.segment13;
92: hr_cgd_shd.g_old_rec.segment12;
93: End If;
94: If (p_rec.segment13 = hr_api.g_varchar2) then
95: p_rec.segment13 :=
96: hr_cgd_shd.g_old_rec.segment13;
97: End If;
98: If (p_rec.segment14 = hr_api.g_varchar2) then
99: p_rec.segment14 :=
100: hr_cgd_shd.g_old_rec.segment14;
96: hr_cgd_shd.g_old_rec.segment13;
97: End If;
98: If (p_rec.segment14 = hr_api.g_varchar2) then
99: p_rec.segment14 :=
100: hr_cgd_shd.g_old_rec.segment14;
101: End If;
102: If (p_rec.segment15 = hr_api.g_varchar2) then
103: p_rec.segment15 :=
104: hr_cgd_shd.g_old_rec.segment15;
100: hr_cgd_shd.g_old_rec.segment14;
101: End If;
102: If (p_rec.segment15 = hr_api.g_varchar2) then
103: p_rec.segment15 :=
104: hr_cgd_shd.g_old_rec.segment15;
105: End If;
106: If (p_rec.segment16 = hr_api.g_varchar2) then
107: p_rec.segment16 :=
108: hr_cgd_shd.g_old_rec.segment16;
104: hr_cgd_shd.g_old_rec.segment15;
105: End If;
106: If (p_rec.segment16 = hr_api.g_varchar2) then
107: p_rec.segment16 :=
108: hr_cgd_shd.g_old_rec.segment16;
109: End If;
110: If (p_rec.segment17 = hr_api.g_varchar2) then
111: p_rec.segment17 :=
112: hr_cgd_shd.g_old_rec.segment17;
108: hr_cgd_shd.g_old_rec.segment16;
109: End If;
110: If (p_rec.segment17 = hr_api.g_varchar2) then
111: p_rec.segment17 :=
112: hr_cgd_shd.g_old_rec.segment17;
113: End If;
114: If (p_rec.segment18 = hr_api.g_varchar2) then
115: p_rec.segment18 :=
116: hr_cgd_shd.g_old_rec.segment18;
112: hr_cgd_shd.g_old_rec.segment17;
113: End If;
114: If (p_rec.segment18 = hr_api.g_varchar2) then
115: p_rec.segment18 :=
116: hr_cgd_shd.g_old_rec.segment18;
117: End If;
118: If (p_rec.segment19 = hr_api.g_varchar2) then
119: p_rec.segment19 :=
120: hr_cgd_shd.g_old_rec.segment19;
116: hr_cgd_shd.g_old_rec.segment18;
117: End If;
118: If (p_rec.segment19 = hr_api.g_varchar2) then
119: p_rec.segment19 :=
120: hr_cgd_shd.g_old_rec.segment19;
121: End If;
122: If (p_rec.segment20 = hr_api.g_varchar2) then
123: p_rec.segment20 :=
124: hr_cgd_shd.g_old_rec.segment20;
120: hr_cgd_shd.g_old_rec.segment19;
121: End If;
122: If (p_rec.segment20 = hr_api.g_varchar2) then
123: p_rec.segment20 :=
124: hr_cgd_shd.g_old_rec.segment20;
125: End If;
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
159: p_concatenated_segments out nocopy varchar2
160: ) is
161: --
162: l_proc varchar2(72) := g_package||'upd_or_sel';
163: l_rec hr_cgd_shd.g_rec_type;
164: l_concatenated_segments varchar2(2000);
165: l_segs_changed boolean;
166: --
167: begin
208: hr_api.validate_bus_grp_id (p_business_group_id);
209: --
210: -- convert args into record format
211: l_rec :=
212: hr_cgd_shd.convert_args (
213: p_cagr_grade_def_id => p_cagr_grade_def_id,
214: p_id_flex_num => p_id_flex_num,
215: p_summary_flag => null,
216: p_enabled_flag => null,
239: );
240: --
241: -- check to see if we are updating a row
242: --
243: if hr_cgd_shd.api_updating
244: (p_cagr_grade_def_id => l_rec.cagr_grade_def_id) then
245: --
246: hr_utility.set_location(l_proc, 10);
247: --