APPS.AHL_MC_MASTERCONFIG_PVT dependencies on DUAL

Line 210: SELECT ahl_mc_headers_b_s.nextval INTO p_x_mc_header_rec.mc_header_id FROM dual;

206: );
207: END IF;
208:
209: -- 6. Select next value from the AHL_MC_HEADERS_B_S sequence
210: SELECT ahl_mc_headers_b_s.nextval INTO p_x_mc_header_rec.mc_header_id FROM dual;
211:
212: -- 7. Set values for p_x_mc_header_rec
213: p_x_mc_header_rec.object_version_number := 1;
214: p_x_mc_header_rec.security_group_id := null;

Line 280: SELECT ahl_mc_relationships_s.nextval INTO p_x_node_rec.relationship_id FROM dual;

276: );
277: END IF;
278:
279: -- 9. Select next value from the AHL_MC_RELATIONSHIPS_S sequence
280: SELECT ahl_mc_relationships_s.nextval INTO p_x_node_rec.relationship_id FROM dual;
281:
282: -- 10. Set values for p_x_node_rec
283: p_x_node_rec.mc_header_id := p_x_mc_header_rec.mc_header_id;
284: p_x_node_rec.parent_relationship_id := null;

Line 294: SELECT ahl_mc_rel_pos_key_s.nextval INTO p_x_node_rec.position_key FROM dual;

290: END IF;
291:
292: IF (p_x_node_rec.position_key IS NULL)
293: THEN
294: SELECT ahl_mc_rel_pos_key_s.nextval INTO p_x_node_rec.position_key FROM dual;
295: END IF;
296:
297: IF (p_x_node_rec.position_necessity_code <> 'MANDATORY')
298: THEN

Line 2837: SELECT TO_NUMBER(SUBSTR(p_x_mc_header_rec.revision,i,1)) INTO l_temp_num FROM DUAL;

2833:
2834: -- There should be something faster than the following iterative approach
2835: FOR i IN 1..l_str_len
2836: LOOP
2837: SELECT TO_NUMBER(SUBSTR(p_x_mc_header_rec.revision,i,1)) INTO l_temp_num FROM DUAL;
2838: END LOOP;
2839:
2840: FND_MESSAGE.Set_Name('AHL','AHL_MC_NO_ALPHA_REV');
2841: FND_MSG_PUB.ADD;