APPS.CZ_ATP_CALLBACK_UTIL dependencies on DUAL

Line 152: COMP_CODE_DELIMITER,-1,1)+1) INTO l_item_id_str FROM dual;

148: instr(decode(substr(p_item_key,1,3),'PRJ',null,'PRD',
149: substr(p_item_key,
150: instr(p_item_key,ITEM_KEY_DELIMITER,-1,1)+1),
151: substr(p_item_key,1,instr(p_item_key,ITEM_KEY_DELIMITER)-1)),
152: COMP_CODE_DELIMITER,-1,1)+1) INTO l_item_id_str FROM dual;
153:
154: return cz_utils.conv_num(l_item_id_str);
155:
156: END inv_item_id_from_item_key;

Line 176: INTO l_comp_code_str FROM dual;

172: 'PRD',
173: substr(p_item_key,
174: instr(p_item_key,ITEM_KEY_DELIMITER,-1,1)+1),
175: substr(p_item_key,1,instr(p_item_key,ITEM_KEY_DELIMITER)-1))
176: INTO l_comp_code_str FROM dual;
177:
178: return l_comp_code_str;
179: END component_code_from_item_key;
180:

Line 195: into l_delim_pos from dual;

191: BEGIN
192:
193: LOOP
194: select instr(l_input_str,p_delimiter)
195: into l_delim_pos from dual;
196:
197: IF l_delim_pos = 0 THEN
198: l_token := l_input_str;
199: ELSIF l_delim_pos IS NULL THEN