APPS.AHL_MC_NODE_PVT dependencies on DUAL

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 276: SELECT ahl_mc_relationships_s.nextval INTO p_x_node_rec.relationship_id FROM DUAL;

272: 'Node validation successful'
273: );
274: END IF;
275:
276: SELECT ahl_mc_relationships_s.nextval INTO p_x_node_rec.relationship_id FROM DUAL;
277: p_x_node_rec.object_version_number := 1;
278: p_x_node_rec.security_group_id := null;
279:
280: -- 4. Insert the node record into AHL_MC_RELATIONSHIPS table

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;

Line 3876: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;

3872: 'Counter rule validation successful'
3873: );
3874: END IF;
3875:
3876: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;
3877: p_x_counter_rule_rec.object_version_number := 1;
3878: p_x_counter_rule_rec.security_group_id := null;
3879:
3880: INSERT INTO AHL_CTR_UPDATE_RULES

Line 4376: SELECT ahl_mc_config_rel_s.nextval INTO p_x_subconfig_rec.mc_config_relation_id FROM DUAL;

4372: );
4373: END IF;
4374:
4375: -- Set values for p_x_subconfig_rec
4376: SELECT ahl_mc_config_rel_s.nextval INTO p_x_subconfig_rec.mc_config_relation_id FROM DUAL;
4377: p_x_subconfig_rec.object_version_number := 1;
4378: p_x_subconfig_rec.security_group_id := null;
4379:
4380: -- Create association record for destination node

Line 4868: SELECT ahl_mc_config_rel_s.nextval INTO l_mc_config_rel_id FROM DUAL;

4864: );
4865: END IF;
4866:
4867: -- Set values for l_subconfig_csr_rec
4868: SELECT ahl_mc_config_rel_s.nextval INTO l_mc_config_rel_id FROM DUAL;
4869:
4870: -- Create association record for destination node
4871: INSERT INTO AHL_MC_CONFIG_RELATIONS
4872: (