APPS.PAY_PGP_UPD dependencies on HR_API

Line 27: If (p_rec.group_name = hr_api.g_varchar2) then

23: -- p_rec plsql record structure
24: -- to see if a system default is being used. If a system default
25: -- is being used then we must set to the 'current' argument value.
26: --
27: If (p_rec.group_name = hr_api.g_varchar2) then
28: p_rec.group_name :=
29: pay_pgp_shd.g_old_rec.group_name;
30: End If;
31: If (p_rec.id_flex_num = hr_api.g_number) then

Line 31: If (p_rec.id_flex_num = hr_api.g_number) then

27: If (p_rec.group_name = hr_api.g_varchar2) then
28: p_rec.group_name :=
29: pay_pgp_shd.g_old_rec.group_name;
30: End If;
31: If (p_rec.id_flex_num = hr_api.g_number) then
32: p_rec.id_flex_num :=
33: pay_pgp_shd.g_old_rec.id_flex_num;
34: End If;
35: If (p_rec.summary_flag = hr_api.g_varchar2) then

Line 35: If (p_rec.summary_flag = hr_api.g_varchar2) then

31: If (p_rec.id_flex_num = hr_api.g_number) then
32: p_rec.id_flex_num :=
33: pay_pgp_shd.g_old_rec.id_flex_num;
34: End If;
35: If (p_rec.summary_flag = hr_api.g_varchar2) then
36: p_rec.summary_flag :=
37: pay_pgp_shd.g_old_rec.summary_flag;
38: End If;
39: If (p_rec.enabled_flag = hr_api.g_varchar2) then

Line 39: If (p_rec.enabled_flag = hr_api.g_varchar2) then

35: If (p_rec.summary_flag = hr_api.g_varchar2) then
36: p_rec.summary_flag :=
37: pay_pgp_shd.g_old_rec.summary_flag;
38: End If;
39: If (p_rec.enabled_flag = hr_api.g_varchar2) then
40: p_rec.enabled_flag :=
41: pay_pgp_shd.g_old_rec.enabled_flag;
42: End If;
43: If (p_rec.start_date_active = hr_api.g_date) then

Line 43: If (p_rec.start_date_active = hr_api.g_date) then

39: If (p_rec.enabled_flag = hr_api.g_varchar2) then
40: p_rec.enabled_flag :=
41: pay_pgp_shd.g_old_rec.enabled_flag;
42: End If;
43: If (p_rec.start_date_active = hr_api.g_date) then
44: p_rec.start_date_active :=
45: pay_pgp_shd.g_old_rec.start_date_active;
46: End If;
47: If (p_rec.end_date_active = hr_api.g_date) then

Line 47: If (p_rec.end_date_active = hr_api.g_date) then

43: If (p_rec.start_date_active = hr_api.g_date) then
44: p_rec.start_date_active :=
45: pay_pgp_shd.g_old_rec.start_date_active;
46: End If;
47: If (p_rec.end_date_active = hr_api.g_date) then
48: p_rec.end_date_active :=
49: pay_pgp_shd.g_old_rec.end_date_active;
50: End If;
51: If (p_rec.segment1 = hr_api.g_varchar2) then

Line 51: If (p_rec.segment1 = hr_api.g_varchar2) then

47: If (p_rec.end_date_active = hr_api.g_date) then
48: p_rec.end_date_active :=
49: pay_pgp_shd.g_old_rec.end_date_active;
50: End If;
51: If (p_rec.segment1 = hr_api.g_varchar2) then
52: p_rec.segment1 :=
53: pay_pgp_shd.g_old_rec.segment1;
54: End If;
55: If (p_rec.segment2 = hr_api.g_varchar2) then

Line 55: If (p_rec.segment2 = hr_api.g_varchar2) then

51: If (p_rec.segment1 = hr_api.g_varchar2) then
52: p_rec.segment1 :=
53: pay_pgp_shd.g_old_rec.segment1;
54: End If;
55: If (p_rec.segment2 = hr_api.g_varchar2) then
56: p_rec.segment2 :=
57: pay_pgp_shd.g_old_rec.segment2;
58: End If;
59: If (p_rec.segment3 = hr_api.g_varchar2) then

Line 59: If (p_rec.segment3 = hr_api.g_varchar2) then

55: If (p_rec.segment2 = hr_api.g_varchar2) then
56: p_rec.segment2 :=
57: pay_pgp_shd.g_old_rec.segment2;
58: End If;
59: If (p_rec.segment3 = hr_api.g_varchar2) then
60: p_rec.segment3 :=
61: pay_pgp_shd.g_old_rec.segment3;
62: End If;
63: If (p_rec.segment4 = hr_api.g_varchar2) then

Line 63: If (p_rec.segment4 = hr_api.g_varchar2) then

59: If (p_rec.segment3 = hr_api.g_varchar2) then
60: p_rec.segment3 :=
61: pay_pgp_shd.g_old_rec.segment3;
62: End If;
63: If (p_rec.segment4 = hr_api.g_varchar2) then
64: p_rec.segment4 :=
65: pay_pgp_shd.g_old_rec.segment4;
66: End If;
67: If (p_rec.segment5 = hr_api.g_varchar2) then

Line 67: If (p_rec.segment5 = hr_api.g_varchar2) then

63: If (p_rec.segment4 = hr_api.g_varchar2) then
64: p_rec.segment4 :=
65: pay_pgp_shd.g_old_rec.segment4;
66: End If;
67: If (p_rec.segment5 = hr_api.g_varchar2) then
68: p_rec.segment5 :=
69: pay_pgp_shd.g_old_rec.segment5;
70: End If;
71: If (p_rec.segment6 = hr_api.g_varchar2) then

Line 71: If (p_rec.segment6 = hr_api.g_varchar2) then

67: If (p_rec.segment5 = hr_api.g_varchar2) then
68: p_rec.segment5 :=
69: pay_pgp_shd.g_old_rec.segment5;
70: End If;
71: If (p_rec.segment6 = hr_api.g_varchar2) then
72: p_rec.segment6 :=
73: pay_pgp_shd.g_old_rec.segment6;
74: End If;
75: If (p_rec.segment7 = hr_api.g_varchar2) then

Line 75: If (p_rec.segment7 = hr_api.g_varchar2) then

71: If (p_rec.segment6 = hr_api.g_varchar2) then
72: p_rec.segment6 :=
73: pay_pgp_shd.g_old_rec.segment6;
74: End If;
75: If (p_rec.segment7 = hr_api.g_varchar2) then
76: p_rec.segment7 :=
77: pay_pgp_shd.g_old_rec.segment7;
78: End If;
79: If (p_rec.segment8 = hr_api.g_varchar2) then

Line 79: If (p_rec.segment8 = hr_api.g_varchar2) then

75: If (p_rec.segment7 = hr_api.g_varchar2) then
76: p_rec.segment7 :=
77: pay_pgp_shd.g_old_rec.segment7;
78: End If;
79: If (p_rec.segment8 = hr_api.g_varchar2) then
80: p_rec.segment8 :=
81: pay_pgp_shd.g_old_rec.segment8;
82: End If;
83: If (p_rec.segment9 = hr_api.g_varchar2) then

Line 83: If (p_rec.segment9 = hr_api.g_varchar2) then

79: If (p_rec.segment8 = hr_api.g_varchar2) then
80: p_rec.segment8 :=
81: pay_pgp_shd.g_old_rec.segment8;
82: End If;
83: If (p_rec.segment9 = hr_api.g_varchar2) then
84: p_rec.segment9 :=
85: pay_pgp_shd.g_old_rec.segment9;
86: End If;
87: If (p_rec.segment10 = hr_api.g_varchar2) then

Line 87: If (p_rec.segment10 = hr_api.g_varchar2) then

83: If (p_rec.segment9 = hr_api.g_varchar2) then
84: p_rec.segment9 :=
85: pay_pgp_shd.g_old_rec.segment9;
86: End If;
87: If (p_rec.segment10 = hr_api.g_varchar2) then
88: p_rec.segment10 :=
89: pay_pgp_shd.g_old_rec.segment10;
90: End If;
91: If (p_rec.segment11 = hr_api.g_varchar2) then

Line 91: If (p_rec.segment11 = hr_api.g_varchar2) then

87: If (p_rec.segment10 = hr_api.g_varchar2) then
88: p_rec.segment10 :=
89: pay_pgp_shd.g_old_rec.segment10;
90: End If;
91: If (p_rec.segment11 = hr_api.g_varchar2) then
92: p_rec.segment11 :=
93: pay_pgp_shd.g_old_rec.segment11;
94: End If;
95: If (p_rec.segment12 = hr_api.g_varchar2) then

Line 95: If (p_rec.segment12 = hr_api.g_varchar2) then

91: If (p_rec.segment11 = hr_api.g_varchar2) then
92: p_rec.segment11 :=
93: pay_pgp_shd.g_old_rec.segment11;
94: End If;
95: If (p_rec.segment12 = hr_api.g_varchar2) then
96: p_rec.segment12 :=
97: pay_pgp_shd.g_old_rec.segment12;
98: End If;
99: If (p_rec.segment13 = hr_api.g_varchar2) then

Line 99: If (p_rec.segment13 = hr_api.g_varchar2) then

95: If (p_rec.segment12 = hr_api.g_varchar2) then
96: p_rec.segment12 :=
97: pay_pgp_shd.g_old_rec.segment12;
98: End If;
99: If (p_rec.segment13 = hr_api.g_varchar2) then
100: p_rec.segment13 :=
101: pay_pgp_shd.g_old_rec.segment13;
102: End If;
103: If (p_rec.segment14 = hr_api.g_varchar2) then

Line 103: If (p_rec.segment14 = hr_api.g_varchar2) then

99: If (p_rec.segment13 = hr_api.g_varchar2) then
100: p_rec.segment13 :=
101: pay_pgp_shd.g_old_rec.segment13;
102: End If;
103: If (p_rec.segment14 = hr_api.g_varchar2) then
104: p_rec.segment14 :=
105: pay_pgp_shd.g_old_rec.segment14;
106: End If;
107: If (p_rec.segment15 = hr_api.g_varchar2) then

Line 107: If (p_rec.segment15 = hr_api.g_varchar2) then

103: If (p_rec.segment14 = hr_api.g_varchar2) then
104: p_rec.segment14 :=
105: pay_pgp_shd.g_old_rec.segment14;
106: End If;
107: If (p_rec.segment15 = hr_api.g_varchar2) then
108: p_rec.segment15 :=
109: pay_pgp_shd.g_old_rec.segment15;
110: End If;
111: If (p_rec.segment16 = hr_api.g_varchar2) then

Line 111: If (p_rec.segment16 = hr_api.g_varchar2) then

107: If (p_rec.segment15 = hr_api.g_varchar2) then
108: p_rec.segment15 :=
109: pay_pgp_shd.g_old_rec.segment15;
110: End If;
111: If (p_rec.segment16 = hr_api.g_varchar2) then
112: p_rec.segment16 :=
113: pay_pgp_shd.g_old_rec.segment16;
114: End If;
115: If (p_rec.segment17 = hr_api.g_varchar2) then

Line 115: If (p_rec.segment17 = hr_api.g_varchar2) then

111: If (p_rec.segment16 = hr_api.g_varchar2) then
112: p_rec.segment16 :=
113: pay_pgp_shd.g_old_rec.segment16;
114: End If;
115: If (p_rec.segment17 = hr_api.g_varchar2) then
116: p_rec.segment17 :=
117: pay_pgp_shd.g_old_rec.segment17;
118: End If;
119: If (p_rec.segment18 = hr_api.g_varchar2) then

Line 119: If (p_rec.segment18 = hr_api.g_varchar2) then

115: If (p_rec.segment17 = hr_api.g_varchar2) then
116: p_rec.segment17 :=
117: pay_pgp_shd.g_old_rec.segment17;
118: End If;
119: If (p_rec.segment18 = hr_api.g_varchar2) then
120: p_rec.segment18 :=
121: pay_pgp_shd.g_old_rec.segment18;
122: End If;
123: If (p_rec.segment19 = hr_api.g_varchar2) then

Line 123: If (p_rec.segment19 = hr_api.g_varchar2) then

119: If (p_rec.segment18 = hr_api.g_varchar2) then
120: p_rec.segment18 :=
121: pay_pgp_shd.g_old_rec.segment18;
122: End If;
123: If (p_rec.segment19 = hr_api.g_varchar2) then
124: p_rec.segment19 :=
125: pay_pgp_shd.g_old_rec.segment19;
126: End If;
127: If (p_rec.segment20 = hr_api.g_varchar2) then

Line 127: If (p_rec.segment20 = hr_api.g_varchar2) then

123: If (p_rec.segment19 = hr_api.g_varchar2) then
124: p_rec.segment19 :=
125: pay_pgp_shd.g_old_rec.segment19;
126: End If;
127: If (p_rec.segment20 = hr_api.g_varchar2) then
128: p_rec.segment20 :=
129: pay_pgp_shd.g_old_rec.segment20;
130: End If;
131: If (p_rec.segment21 = hr_api.g_varchar2) then

Line 131: If (p_rec.segment21 = hr_api.g_varchar2) then

127: If (p_rec.segment20 = hr_api.g_varchar2) then
128: p_rec.segment20 :=
129: pay_pgp_shd.g_old_rec.segment20;
130: End If;
131: If (p_rec.segment21 = hr_api.g_varchar2) then
132: p_rec.segment21 :=
133: pay_pgp_shd.g_old_rec.segment21;
134: End If;
135: If (p_rec.segment22 = hr_api.g_varchar2) then

Line 135: If (p_rec.segment22 = hr_api.g_varchar2) then

131: If (p_rec.segment21 = hr_api.g_varchar2) then
132: p_rec.segment21 :=
133: pay_pgp_shd.g_old_rec.segment21;
134: End If;
135: If (p_rec.segment22 = hr_api.g_varchar2) then
136: p_rec.segment22 :=
137: pay_pgp_shd.g_old_rec.segment22;
138: End If;
139: If (p_rec.segment23 = hr_api.g_varchar2) then

Line 139: If (p_rec.segment23 = hr_api.g_varchar2) then

135: If (p_rec.segment22 = hr_api.g_varchar2) then
136: p_rec.segment22 :=
137: pay_pgp_shd.g_old_rec.segment22;
138: End If;
139: If (p_rec.segment23 = hr_api.g_varchar2) then
140: p_rec.segment23 :=
141: pay_pgp_shd.g_old_rec.segment23;
142: End If;
143: If (p_rec.segment24 = hr_api.g_varchar2) then

Line 143: If (p_rec.segment24 = hr_api.g_varchar2) then

139: If (p_rec.segment23 = hr_api.g_varchar2) then
140: p_rec.segment23 :=
141: pay_pgp_shd.g_old_rec.segment23;
142: End If;
143: If (p_rec.segment24 = hr_api.g_varchar2) then
144: p_rec.segment24 :=
145: pay_pgp_shd.g_old_rec.segment24;
146: End If;
147: If (p_rec.segment25 = hr_api.g_varchar2) then

Line 147: If (p_rec.segment25 = hr_api.g_varchar2) then

143: If (p_rec.segment24 = hr_api.g_varchar2) then
144: p_rec.segment24 :=
145: pay_pgp_shd.g_old_rec.segment24;
146: End If;
147: If (p_rec.segment25 = hr_api.g_varchar2) then
148: p_rec.segment25 :=
149: pay_pgp_shd.g_old_rec.segment25;
150: End If;
151: If (p_rec.segment26 = hr_api.g_varchar2) then

Line 151: If (p_rec.segment26 = hr_api.g_varchar2) then

147: If (p_rec.segment25 = hr_api.g_varchar2) then
148: p_rec.segment25 :=
149: pay_pgp_shd.g_old_rec.segment25;
150: End If;
151: If (p_rec.segment26 = hr_api.g_varchar2) then
152: p_rec.segment26 :=
153: pay_pgp_shd.g_old_rec.segment26;
154: End If;
155: If (p_rec.segment27 = hr_api.g_varchar2) then

Line 155: If (p_rec.segment27 = hr_api.g_varchar2) then

151: If (p_rec.segment26 = hr_api.g_varchar2) then
152: p_rec.segment26 :=
153: pay_pgp_shd.g_old_rec.segment26;
154: End If;
155: If (p_rec.segment27 = hr_api.g_varchar2) then
156: p_rec.segment27 :=
157: pay_pgp_shd.g_old_rec.segment27;
158: End If;
159: If (p_rec.segment28 = hr_api.g_varchar2) then

Line 159: If (p_rec.segment28 = hr_api.g_varchar2) then

155: If (p_rec.segment27 = hr_api.g_varchar2) then
156: p_rec.segment27 :=
157: pay_pgp_shd.g_old_rec.segment27;
158: End If;
159: If (p_rec.segment28 = hr_api.g_varchar2) then
160: p_rec.segment28 :=
161: pay_pgp_shd.g_old_rec.segment28;
162: End If;
163: If (p_rec.segment29 = hr_api.g_varchar2) then

Line 163: If (p_rec.segment29 = hr_api.g_varchar2) then

159: If (p_rec.segment28 = hr_api.g_varchar2) then
160: p_rec.segment28 :=
161: pay_pgp_shd.g_old_rec.segment28;
162: End If;
163: If (p_rec.segment29 = hr_api.g_varchar2) then
164: p_rec.segment29 :=
165: pay_pgp_shd.g_old_rec.segment29;
166: End If;
167: If (p_rec.segment30 = hr_api.g_varchar2) then

Line 167: If (p_rec.segment30 = hr_api.g_varchar2) then

163: If (p_rec.segment29 = hr_api.g_varchar2) then
164: p_rec.segment29 :=
165: pay_pgp_shd.g_old_rec.segment29;
166: End If;
167: If (p_rec.segment30 = hr_api.g_varchar2) then
168: p_rec.segment30 :=
169: pay_pgp_shd.g_old_rec.segment30;
170: End If;
171:

Line 182: (p_segment1 in varchar2 default hr_api.g_varchar2,

178: -- |-------------------------------< upd_or_sel >-----------------------------|
179: -- ----------------------------------------------------------------------------
180: --
181: procedure upd_or_sel
182: (p_segment1 in varchar2 default hr_api.g_varchar2,
183: p_segment2 in varchar2 default hr_api.g_varchar2,
184: p_segment3 in varchar2 default hr_api.g_varchar2,
185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,

Line 183: p_segment2 in varchar2 default hr_api.g_varchar2,

179: -- ----------------------------------------------------------------------------
180: --
181: procedure upd_or_sel
182: (p_segment1 in varchar2 default hr_api.g_varchar2,
183: p_segment2 in varchar2 default hr_api.g_varchar2,
184: p_segment3 in varchar2 default hr_api.g_varchar2,
185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,

Line 184: p_segment3 in varchar2 default hr_api.g_varchar2,

180: --
181: procedure upd_or_sel
182: (p_segment1 in varchar2 default hr_api.g_varchar2,
183: p_segment2 in varchar2 default hr_api.g_varchar2,
184: p_segment3 in varchar2 default hr_api.g_varchar2,
185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,

Line 185: p_segment4 in varchar2 default hr_api.g_varchar2,

181: procedure upd_or_sel
182: (p_segment1 in varchar2 default hr_api.g_varchar2,
183: p_segment2 in varchar2 default hr_api.g_varchar2,
184: p_segment3 in varchar2 default hr_api.g_varchar2,
185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,

Line 186: p_segment5 in varchar2 default hr_api.g_varchar2,

182: (p_segment1 in varchar2 default hr_api.g_varchar2,
183: p_segment2 in varchar2 default hr_api.g_varchar2,
184: p_segment3 in varchar2 default hr_api.g_varchar2,
185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,

Line 187: p_segment6 in varchar2 default hr_api.g_varchar2,

183: p_segment2 in varchar2 default hr_api.g_varchar2,
184: p_segment3 in varchar2 default hr_api.g_varchar2,
185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,

Line 188: p_segment7 in varchar2 default hr_api.g_varchar2,

184: p_segment3 in varchar2 default hr_api.g_varchar2,
185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,

Line 189: p_segment8 in varchar2 default hr_api.g_varchar2,

185: p_segment4 in varchar2 default hr_api.g_varchar2,
186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,

Line 190: p_segment9 in varchar2 default hr_api.g_varchar2,

186: p_segment5 in varchar2 default hr_api.g_varchar2,
187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,

Line 191: p_segment10 in varchar2 default hr_api.g_varchar2,

187: p_segment6 in varchar2 default hr_api.g_varchar2,
188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,

Line 192: p_segment11 in varchar2 default hr_api.g_varchar2,

188: p_segment7 in varchar2 default hr_api.g_varchar2,
189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,

Line 193: p_segment12 in varchar2 default hr_api.g_varchar2,

189: p_segment8 in varchar2 default hr_api.g_varchar2,
190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,

Line 194: p_segment13 in varchar2 default hr_api.g_varchar2,

190: p_segment9 in varchar2 default hr_api.g_varchar2,
191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,

Line 195: p_segment14 in varchar2 default hr_api.g_varchar2,

191: p_segment10 in varchar2 default hr_api.g_varchar2,
192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,

Line 196: p_segment15 in varchar2 default hr_api.g_varchar2,

192: p_segment11 in varchar2 default hr_api.g_varchar2,
193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,

Line 197: p_segment16 in varchar2 default hr_api.g_varchar2,

193: p_segment12 in varchar2 default hr_api.g_varchar2,
194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,

Line 198: p_segment17 in varchar2 default hr_api.g_varchar2,

194: p_segment13 in varchar2 default hr_api.g_varchar2,
195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,

Line 199: p_segment18 in varchar2 default hr_api.g_varchar2,

195: p_segment14 in varchar2 default hr_api.g_varchar2,
196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,

Line 200: p_segment19 in varchar2 default hr_api.g_varchar2,

196: p_segment15 in varchar2 default hr_api.g_varchar2,
197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,

Line 201: p_segment20 in varchar2 default hr_api.g_varchar2,

197: p_segment16 in varchar2 default hr_api.g_varchar2,
198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,

Line 202: p_segment21 in varchar2 default hr_api.g_varchar2,

198: p_segment17 in varchar2 default hr_api.g_varchar2,
199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,

Line 203: p_segment22 in varchar2 default hr_api.g_varchar2,

199: p_segment18 in varchar2 default hr_api.g_varchar2,
200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,

Line 204: p_segment23 in varchar2 default hr_api.g_varchar2,

200: p_segment19 in varchar2 default hr_api.g_varchar2,
201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,

Line 205: p_segment24 in varchar2 default hr_api.g_varchar2,

201: p_segment20 in varchar2 default hr_api.g_varchar2,
202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,
209: p_segment28 in varchar2 default hr_api.g_varchar2,

Line 206: p_segment25 in varchar2 default hr_api.g_varchar2,

202: p_segment21 in varchar2 default hr_api.g_varchar2,
203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,
209: p_segment28 in varchar2 default hr_api.g_varchar2,
210: p_segment29 in varchar2 default hr_api.g_varchar2,

Line 207: p_segment26 in varchar2 default hr_api.g_varchar2,

203: p_segment22 in varchar2 default hr_api.g_varchar2,
204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,
209: p_segment28 in varchar2 default hr_api.g_varchar2,
210: p_segment29 in varchar2 default hr_api.g_varchar2,
211: p_segment30 in varchar2 default hr_api.g_varchar2,

Line 208: p_segment27 in varchar2 default hr_api.g_varchar2,

204: p_segment23 in varchar2 default hr_api.g_varchar2,
205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,
209: p_segment28 in varchar2 default hr_api.g_varchar2,
210: p_segment29 in varchar2 default hr_api.g_varchar2,
211: p_segment30 in varchar2 default hr_api.g_varchar2,
212: p_business_group_id in number,

Line 209: p_segment28 in varchar2 default hr_api.g_varchar2,

205: p_segment24 in varchar2 default hr_api.g_varchar2,
206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,
209: p_segment28 in varchar2 default hr_api.g_varchar2,
210: p_segment29 in varchar2 default hr_api.g_varchar2,
211: p_segment30 in varchar2 default hr_api.g_varchar2,
212: p_business_group_id in number,
213: p_people_group_id in out number,

Line 210: p_segment29 in varchar2 default hr_api.g_varchar2,

206: p_segment25 in varchar2 default hr_api.g_varchar2,
207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,
209: p_segment28 in varchar2 default hr_api.g_varchar2,
210: p_segment29 in varchar2 default hr_api.g_varchar2,
211: p_segment30 in varchar2 default hr_api.g_varchar2,
212: p_business_group_id in number,
213: p_people_group_id in out number,
214: p_group_name out varchar2,

Line 211: p_segment30 in varchar2 default hr_api.g_varchar2,

207: p_segment26 in varchar2 default hr_api.g_varchar2,
208: p_segment27 in varchar2 default hr_api.g_varchar2,
209: p_segment28 in varchar2 default hr_api.g_varchar2,
210: p_segment29 in varchar2 default hr_api.g_varchar2,
211: p_segment30 in varchar2 default hr_api.g_varchar2,
212: p_business_group_id in number,
213: p_people_group_id in out number,
214: p_group_name out varchar2,
215: p_validate in boolean default false) is

Line 285: if (l_rec.segment1 = hr_api.g_varchar2) then

281: -- arguments if they are using a system default value
282: -- to null otherwise the segments will have the system default
283: -- values when being inserted
284: --
285: if (l_rec.segment1 = hr_api.g_varchar2) then
286: l_rec.segment1 := null;
287: end if;
288: if (l_rec.segment2 = hr_api.g_varchar2) then
289: l_rec.segment2 := null;

Line 288: if (l_rec.segment2 = hr_api.g_varchar2) then

284: --
285: if (l_rec.segment1 = hr_api.g_varchar2) then
286: l_rec.segment1 := null;
287: end if;
288: if (l_rec.segment2 = hr_api.g_varchar2) then
289: l_rec.segment2 := null;
290: end if;
291: if (l_rec.segment3 = hr_api.g_varchar2) then
292: l_rec.segment3 := null;

Line 291: if (l_rec.segment3 = hr_api.g_varchar2) then

287: end if;
288: if (l_rec.segment2 = hr_api.g_varchar2) then
289: l_rec.segment2 := null;
290: end if;
291: if (l_rec.segment3 = hr_api.g_varchar2) then
292: l_rec.segment3 := null;
293: end if;
294: if (l_rec.segment4 = hr_api.g_varchar2) then
295: l_rec.segment4 := null;

Line 294: if (l_rec.segment4 = hr_api.g_varchar2) then

290: end if;
291: if (l_rec.segment3 = hr_api.g_varchar2) then
292: l_rec.segment3 := null;
293: end if;
294: if (l_rec.segment4 = hr_api.g_varchar2) then
295: l_rec.segment4 := null;
296: end if;
297: if (l_rec.segment5 = hr_api.g_varchar2) then
298: l_rec.segment5 := null;

Line 297: if (l_rec.segment5 = hr_api.g_varchar2) then

293: end if;
294: if (l_rec.segment4 = hr_api.g_varchar2) then
295: l_rec.segment4 := null;
296: end if;
297: if (l_rec.segment5 = hr_api.g_varchar2) then
298: l_rec.segment5 := null;
299: end if;
300: if (l_rec.segment6 = hr_api.g_varchar2) then
301: l_rec.segment6 := null;

Line 300: if (l_rec.segment6 = hr_api.g_varchar2) then

296: end if;
297: if (l_rec.segment5 = hr_api.g_varchar2) then
298: l_rec.segment5 := null;
299: end if;
300: if (l_rec.segment6 = hr_api.g_varchar2) then
301: l_rec.segment6 := null;
302: end if;
303: if (l_rec.segment7 = hr_api.g_varchar2) then
304: l_rec.segment7 := null;

Line 303: if (l_rec.segment7 = hr_api.g_varchar2) then

299: end if;
300: if (l_rec.segment6 = hr_api.g_varchar2) then
301: l_rec.segment6 := null;
302: end if;
303: if (l_rec.segment7 = hr_api.g_varchar2) then
304: l_rec.segment7 := null;
305: end if;
306: if (l_rec.segment8 = hr_api.g_varchar2) then
307: l_rec.segment8 := null;

Line 306: if (l_rec.segment8 = hr_api.g_varchar2) then

302: end if;
303: if (l_rec.segment7 = hr_api.g_varchar2) then
304: l_rec.segment7 := null;
305: end if;
306: if (l_rec.segment8 = hr_api.g_varchar2) then
307: l_rec.segment8 := null;
308: end if;
309: if (l_rec.segment9 = hr_api.g_varchar2) then
310: l_rec.segment9 := null;

Line 309: if (l_rec.segment9 = hr_api.g_varchar2) then

305: end if;
306: if (l_rec.segment8 = hr_api.g_varchar2) then
307: l_rec.segment8 := null;
308: end if;
309: if (l_rec.segment9 = hr_api.g_varchar2) then
310: l_rec.segment9 := null;
311: end if;
312: if (l_rec.segment10 = hr_api.g_varchar2) then
313: l_rec.segment10 := null;

Line 312: if (l_rec.segment10 = hr_api.g_varchar2) then

308: end if;
309: if (l_rec.segment9 = hr_api.g_varchar2) then
310: l_rec.segment9 := null;
311: end if;
312: if (l_rec.segment10 = hr_api.g_varchar2) then
313: l_rec.segment10 := null;
314: end if;
315: if (l_rec.segment11 = hr_api.g_varchar2) then
316: l_rec.segment11 := null;

Line 315: if (l_rec.segment11 = hr_api.g_varchar2) then

311: end if;
312: if (l_rec.segment10 = hr_api.g_varchar2) then
313: l_rec.segment10 := null;
314: end if;
315: if (l_rec.segment11 = hr_api.g_varchar2) then
316: l_rec.segment11 := null;
317: end if;
318: if (l_rec.segment12 = hr_api.g_varchar2) then
319: l_rec.segment12 := null;

Line 318: if (l_rec.segment12 = hr_api.g_varchar2) then

314: end if;
315: if (l_rec.segment11 = hr_api.g_varchar2) then
316: l_rec.segment11 := null;
317: end if;
318: if (l_rec.segment12 = hr_api.g_varchar2) then
319: l_rec.segment12 := null;
320: end if;
321: if (l_rec.segment13 = hr_api.g_varchar2) then
322: l_rec.segment13 := null;

Line 321: if (l_rec.segment13 = hr_api.g_varchar2) then

317: end if;
318: if (l_rec.segment12 = hr_api.g_varchar2) then
319: l_rec.segment12 := null;
320: end if;
321: if (l_rec.segment13 = hr_api.g_varchar2) then
322: l_rec.segment13 := null;
323: end if;
324: if (l_rec.segment14 = hr_api.g_varchar2) then
325: l_rec.segment14 := null;

Line 324: if (l_rec.segment14 = hr_api.g_varchar2) then

320: end if;
321: if (l_rec.segment13 = hr_api.g_varchar2) then
322: l_rec.segment13 := null;
323: end if;
324: if (l_rec.segment14 = hr_api.g_varchar2) then
325: l_rec.segment14 := null;
326: end if;
327: if (l_rec.segment15 = hr_api.g_varchar2) then
328: l_rec.segment15 := null;

Line 327: if (l_rec.segment15 = hr_api.g_varchar2) then

323: end if;
324: if (l_rec.segment14 = hr_api.g_varchar2) then
325: l_rec.segment14 := null;
326: end if;
327: if (l_rec.segment15 = hr_api.g_varchar2) then
328: l_rec.segment15 := null;
329: end if;
330: if (l_rec.segment16 = hr_api.g_varchar2) then
331: l_rec.segment16 := null;

Line 330: if (l_rec.segment16 = hr_api.g_varchar2) then

326: end if;
327: if (l_rec.segment15 = hr_api.g_varchar2) then
328: l_rec.segment15 := null;
329: end if;
330: if (l_rec.segment16 = hr_api.g_varchar2) then
331: l_rec.segment16 := null;
332: end if;
333: if (l_rec.segment17 = hr_api.g_varchar2) then
334: l_rec.segment17 := null;

Line 333: if (l_rec.segment17 = hr_api.g_varchar2) then

329: end if;
330: if (l_rec.segment16 = hr_api.g_varchar2) then
331: l_rec.segment16 := null;
332: end if;
333: if (l_rec.segment17 = hr_api.g_varchar2) then
334: l_rec.segment17 := null;
335: end if;
336: if (l_rec.segment18 = hr_api.g_varchar2) then
337: l_rec.segment18 := null;

Line 336: if (l_rec.segment18 = hr_api.g_varchar2) then

332: end if;
333: if (l_rec.segment17 = hr_api.g_varchar2) then
334: l_rec.segment17 := null;
335: end if;
336: if (l_rec.segment18 = hr_api.g_varchar2) then
337: l_rec.segment18 := null;
338: end if;
339: if (l_rec.segment19 = hr_api.g_varchar2) then
340: l_rec.segment19 := null;

Line 339: if (l_rec.segment19 = hr_api.g_varchar2) then

335: end if;
336: if (l_rec.segment18 = hr_api.g_varchar2) then
337: l_rec.segment18 := null;
338: end if;
339: if (l_rec.segment19 = hr_api.g_varchar2) then
340: l_rec.segment19 := null;
341: end if;
342: if (l_rec.segment20 = hr_api.g_varchar2) then
343: l_rec.segment20 := null;

Line 342: if (l_rec.segment20 = hr_api.g_varchar2) then

338: end if;
339: if (l_rec.segment19 = hr_api.g_varchar2) then
340: l_rec.segment19 := null;
341: end if;
342: if (l_rec.segment20 = hr_api.g_varchar2) then
343: l_rec.segment20 := null;
344: end if;
345: if (l_rec.segment21 = hr_api.g_varchar2) then
346: l_rec.segment21 := null;

Line 345: if (l_rec.segment21 = hr_api.g_varchar2) then

341: end if;
342: if (l_rec.segment20 = hr_api.g_varchar2) then
343: l_rec.segment20 := null;
344: end if;
345: if (l_rec.segment21 = hr_api.g_varchar2) then
346: l_rec.segment21 := null;
347: end if;
348: if (l_rec.segment22 = hr_api.g_varchar2) then
349: l_rec.segment22 := null;

Line 348: if (l_rec.segment22 = hr_api.g_varchar2) then

344: end if;
345: if (l_rec.segment21 = hr_api.g_varchar2) then
346: l_rec.segment21 := null;
347: end if;
348: if (l_rec.segment22 = hr_api.g_varchar2) then
349: l_rec.segment22 := null;
350: end if;
351: if (l_rec.segment23 = hr_api.g_varchar2) then
352: l_rec.segment23 := null;

Line 351: if (l_rec.segment23 = hr_api.g_varchar2) then

347: end if;
348: if (l_rec.segment22 = hr_api.g_varchar2) then
349: l_rec.segment22 := null;
350: end if;
351: if (l_rec.segment23 = hr_api.g_varchar2) then
352: l_rec.segment23 := null;
353: end if;
354: if (l_rec.segment24 = hr_api.g_varchar2) then
355: l_rec.segment24 := null;

Line 354: if (l_rec.segment24 = hr_api.g_varchar2) then

350: end if;
351: if (l_rec.segment23 = hr_api.g_varchar2) then
352: l_rec.segment23 := null;
353: end if;
354: if (l_rec.segment24 = hr_api.g_varchar2) then
355: l_rec.segment24 := null;
356: end if;
357: if (l_rec.segment25 = hr_api.g_varchar2) then
358: l_rec.segment25 := null;

Line 357: if (l_rec.segment25 = hr_api.g_varchar2) then

353: end if;
354: if (l_rec.segment24 = hr_api.g_varchar2) then
355: l_rec.segment24 := null;
356: end if;
357: if (l_rec.segment25 = hr_api.g_varchar2) then
358: l_rec.segment25 := null;
359: end if;
360: if (l_rec.segment26 = hr_api.g_varchar2) then
361: l_rec.segment26 := null;

Line 360: if (l_rec.segment26 = hr_api.g_varchar2) then

356: end if;
357: if (l_rec.segment25 = hr_api.g_varchar2) then
358: l_rec.segment25 := null;
359: end if;
360: if (l_rec.segment26 = hr_api.g_varchar2) then
361: l_rec.segment26 := null;
362: end if;
363: if (l_rec.segment27 = hr_api.g_varchar2) then
364: l_rec.segment27 := null;

Line 363: if (l_rec.segment27 = hr_api.g_varchar2) then

359: end if;
360: if (l_rec.segment26 = hr_api.g_varchar2) then
361: l_rec.segment26 := null;
362: end if;
363: if (l_rec.segment27 = hr_api.g_varchar2) then
364: l_rec.segment27 := null;
365: end if;
366: if (l_rec.segment28 = hr_api.g_varchar2) then
367: l_rec.segment28 := null;

Line 366: if (l_rec.segment28 = hr_api.g_varchar2) then

362: end if;
363: if (l_rec.segment27 = hr_api.g_varchar2) then
364: l_rec.segment27 := null;
365: end if;
366: if (l_rec.segment28 = hr_api.g_varchar2) then
367: l_rec.segment28 := null;
368: end if;
369: if (l_rec.segment29 = hr_api.g_varchar2) then
370: l_rec.segment29 := null;

Line 369: if (l_rec.segment29 = hr_api.g_varchar2) then

365: end if;
366: if (l_rec.segment28 = hr_api.g_varchar2) then
367: l_rec.segment28 := null;
368: end if;
369: if (l_rec.segment29 = hr_api.g_varchar2) then
370: l_rec.segment29 := null;
371: end if;
372: if (l_rec.segment30 = hr_api.g_varchar2) then
373: l_rec.segment30 := null;

Line 372: if (l_rec.segment30 = hr_api.g_varchar2) then

368: end if;
369: if (l_rec.segment29 = hr_api.g_varchar2) then
370: l_rec.segment29 := null;
371: end if;
372: if (l_rec.segment30 = hr_api.g_varchar2) then
373: l_rec.segment30 := null;
374: end if;
375: end if;
376: hr_utility.set_location(l_proc, 15);