APPS.PQH_RBC_STAGE dependencies on HR_GENERAL

Line 133: l_node1_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,

129: hr_utility.set_location('based on lkp',10);
130: hr_utility.set_location('lkp_type'||p_lookup_type,40);
131: hr_utility.set_location('lkp_code'||p_char_value1,40);
132: if p_char_value1 is not null then
133: l_node1_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
134: p_lookup_code => p_char_value1);
135: else
136: l_node1_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
137: p_lookup_code => p_number_value1);

Line 136: l_node1_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,

132: if p_char_value1 is not null then
133: l_node1_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
134: p_lookup_code => p_char_value1);
135: else
136: l_node1_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
137: p_lookup_code => p_number_value1);
138: end if;
139: if p_range_flag = 'Y' then
140: if p_char_value2 is not null then

Line 141: l_node2_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,

137: p_lookup_code => p_number_value1);
138: end if;
139: if p_range_flag = 'Y' then
140: if p_char_value2 is not null then
141: l_node2_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
142: p_lookup_code => p_char_value2);
143: else
144: l_node2_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
145: p_lookup_code => p_number_value2);

Line 144: l_node2_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,

140: if p_char_value2 is not null then
141: l_node2_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
142: p_lookup_code => p_char_value2);
143: else
144: l_node2_desc := hr_general.decode_lookup(p_lookup_type => p_lookup_type,
145: p_lookup_code => p_number_value2);
146: end if;
147: l_node_desc := l_node1_desc ||' - '||l_node2_desc;
148: else

Line 154: l_org_desc := hr_general.decode_organization(p_organization_id => p_number_value2);

150: end if;
151: elsif p_val_type_cd ='ORG_HIER' then
152: hr_utility.set_location('based on oh'||p_number_value1||' : '||p_number_value2,40);
153: l_oh_desc := get_oh_name(p_number_value1);
154: l_org_desc := hr_general.decode_organization(p_organization_id => p_number_value2);
155: l_node_desc := l_oh_desc ||' - '||l_org_desc;
156: elsif p_val_type_cd ='POS_HIER' then
157: hr_utility.set_location('based on ph'||p_number_value1||' : '||p_number_value2,40);
158: l_ph_desc := get_ph_name(p_number_value1);

Line 159: l_pos_desc := hr_general.decode_position(p_position_id => p_number_value2);

155: l_node_desc := l_oh_desc ||' - '||l_org_desc;
156: elsif p_val_type_cd ='POS_HIER' then
157: hr_utility.set_location('based on ph'||p_number_value1||' : '||p_number_value2,40);
158: l_ph_desc := get_ph_name(p_number_value1);
159: l_pos_desc := hr_general.decode_position(p_position_id => p_number_value2);
160: l_node_desc := l_ph_desc ||' - '||l_pos_desc;
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