APPS.AHL_MC_NODE_PVT dependencies on AHL_MC_REL_POS_KEY_S

Line 237: SELECT ahl_mc_rel_pos_key_s.nextval INTO p_x_node_rec.position_key FROM DUAL;

233: Validate_Node(p_x_node_rec);
234:
235: IF (p_x_node_rec.position_key IS NULL)
236: THEN
237: SELECT ahl_mc_rel_pos_key_s.nextval INTO p_x_node_rec.position_key FROM DUAL;
238: ELSE
239: -- 3j.i. Validate p_x_node_rec.position_key is unique within this MC
240: OPEN check_dup_poskey;
241: FETCH check_dup_poskey INTO l_dummy_varchar;

Line 694: SELECT ahl_mc_rel_pos_key_s.nextval INTO p_x_node_rec.position_key FROM DUAL;

690: Validate_Node(p_x_node_rec);
691:
692: IF (p_x_node_rec.position_key IS NULL)
693: THEN
694: SELECT ahl_mc_rel_pos_key_s.nextval INTO p_x_node_rec.position_key FROM DUAL;
695: ELSE
696: -- 3j.i.Validate p_x_node_rec.position_key is unique within this MC
697: OPEN check_poskey_update;
698: FETCH check_poskey_update INTO l_dummy_varchar;