APPS.PQH_RBC_STAGE dependencies on PQH_UTILITY

Line 165: l_node1_desc := pqh_utility.get_display_value(p_value => p_char_value1,

161: elsif p_val_type_cd ='VAL_SET' then
162: hr_utility.set_location('based on vset'||p_value_set_id,40);
163: if p_crit_col_dtyp ='C' then
164: hr_utility.set_location('char based vset',40);
165: l_node1_desc := pqh_utility.get_display_value(p_value => p_char_value1,
166: p_value_set_id => p_value_set_id);
167: hr_utility.set_location('val1 is '||l_node1_desc,40);
168: if p_range_flag = 'Y' and p_char_value2 is not null then
169: l_node2_desc := pqh_utility.get_display_value(p_value => p_char_value2,

Line 169: l_node2_desc := pqh_utility.get_display_value(p_value => p_char_value2,

165: l_node1_desc := pqh_utility.get_display_value(p_value => p_char_value1,
166: p_value_set_id => p_value_set_id);
167: hr_utility.set_location('val1 is '||l_node1_desc,40);
168: if p_range_flag = 'Y' and p_char_value2 is not null then
169: l_node2_desc := pqh_utility.get_display_value(p_value => p_char_value2,
170: p_value_set_id => p_value_set_id);
171: hr_utility.set_location('val2 is '||l_node2_desc,40);
172: l_node_desc := l_node1_desc ||' - '||l_node2_desc;
173: else

Line 178: l_node1_desc := pqh_utility.get_display_value(p_value => to_char(p_number_value1),

174: l_node_desc := l_node1_desc ;
175: end if;
176: elsif p_crit_col_dtyp ='N' then
177: hr_utility.set_location('num based vset',40);
178: l_node1_desc := pqh_utility.get_display_value(p_value => to_char(p_number_value1),
179: p_value_set_id => p_value_set_id);
180: hr_utility.set_location('val1 is '||l_node1_desc,40);
181: if p_range_flag = 'Y' and p_number_value2 is not null then
182: l_node2_desc := pqh_utility.get_display_value(p_value => p_number_value2,

Line 182: l_node2_desc := pqh_utility.get_display_value(p_value => p_number_value2,

178: l_node1_desc := pqh_utility.get_display_value(p_value => to_char(p_number_value1),
179: p_value_set_id => p_value_set_id);
180: hr_utility.set_location('val1 is '||l_node1_desc,40);
181: if p_range_flag = 'Y' and p_number_value2 is not null then
182: l_node2_desc := pqh_utility.get_display_value(p_value => p_number_value2,
183: p_value_set_id => p_value_set_id);
184: hr_utility.set_location('val2 is '||l_node2_desc,40);
185: l_node_desc := l_node1_desc ||' - '||l_node2_desc;
186: else

Line 233: pqh_utility.init_query_date;

229: where rate_matrix_node_id = p_rate_matrix_node_id;
230: begin
231: -- get the node details
232: hr_utility.set_location('get node value for '||p_rate_matrix_node_id,10);
233: pqh_utility.init_query_date;
234: pqh_utility.set_query_date(p_effective_date => p_effective_date);
235: if p_node_short_code is null then
236: begin
237: select criteria_short_code

Line 234: pqh_utility.set_query_date(p_effective_date => p_effective_date);

230: begin
231: -- get the node details
232: hr_utility.set_location('get node value for '||p_rate_matrix_node_id,10);
233: pqh_utility.init_query_date;
234: pqh_utility.set_query_date(p_effective_date => p_effective_date);
235: if p_node_short_code is null then
236: begin
237: select criteria_short_code
238: into l_crit_short_code

Line 293: pqh_utility.get_valueset_sql(p_value_set_id => l_crt_rec.col2_value_set_id,

289: hr_utility.set_location('before node 2 l_crt_rec.allow_range_validation_flag'||l_crt_rec.allow_range_validation_flag,200);
290: hr_utility.set_location('before node 2 i.number_value1'||i.number_value1,200);
291: hr_utility.set_location('before node 2 i.char_value1'||i.char_value1,200);
292: if (l_crt_rec.crit_col2_val_type_cd = 'VAL_SET' and l_crt_rec.crit_col1_val_type_cd = 'VAL_SET') then
293: pqh_utility.get_valueset_sql(p_value_set_id => l_crt_rec.col2_value_set_id,
294: p_validation_type => l_valuset_val_type,
295: p_sql_stmt => l_valuset_sql_stmt,
296: p_error_status => l_valuset_err_st);
297: hr_utility.set_location('value set query '||substr(l_valuset_sql_stmt,1,100), 200);

Line 325: l_node2_desc := pqh_utility.get_display_value(p_value => l_value3,

321: l_value3 := to_number(i.number_value3);
322: l_value4 := to_number(i.number_value4);
323: end if;
324:
325: l_node2_desc := pqh_utility.get_display_value(p_value => l_value3,
326: p_value_set_id => l_crt_rec.col2_value_set_id,
327: p_prnt_valset_nm => l_val_set_name,
328: p_prnt_value => l_prnt_value1);
329: if l_crt_rec.allow_range_validation_flag2 = 'Y' then

Line 330: l_node2_desc := l_node2_desc||' - '||pqh_utility.get_display_value(p_value => l_value4,

326: p_value_set_id => l_crt_rec.col2_value_set_id,
327: p_prnt_valset_nm => l_val_set_name,
328: p_prnt_value => l_prnt_value1);
329: if l_crt_rec.allow_range_validation_flag2 = 'Y' then
330: l_node2_desc := l_node2_desc||' - '||pqh_utility.get_display_value(p_value => l_value4,
331: p_value_set_id => l_crt_rec.col2_value_set_id,
332: p_prnt_valset_nm => l_val_set_name,
333: p_prnt_value => l_prnt_value1);
334: end if;