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 3850: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;

3846: 'Counter rule validation successful'
3847: );
3848: END IF;
3849:
3850: SELECT ahl_ctr_update_rules_s.nextval INTO p_x_counter_rule_rec.ctr_update_rule_id FROM DUAL;
3851: p_x_counter_rule_rec.object_version_number := 1;
3852: p_x_counter_rule_rec.security_group_id := null;
3853:
3854: INSERT INTO AHL_CTR_UPDATE_RULES

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

4346: );
4347: END IF;
4348:
4349: -- Set values for p_x_subconfig_rec
4350: SELECT ahl_mc_config_rel_s.nextval INTO p_x_subconfig_rec.mc_config_relation_id FROM DUAL;
4351: p_x_subconfig_rec.object_version_number := 1;
4352: p_x_subconfig_rec.security_group_id := null;
4353:
4354: -- Create association record for destination node

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

4838: );
4839: END IF;
4840:
4841: -- Set values for l_subconfig_csr_rec
4842: SELECT ahl_mc_config_rel_s.nextval INTO l_mc_config_rel_id FROM DUAL;
4843:
4844: -- Create association record for destination node
4845: INSERT INTO AHL_MC_CONFIG_RELATIONS
4846: (