APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_VISIT_INST_ROUTINGS_S

Line 1221: l_inst_routing_id := AHL_VISIT_INST_ROUTINGS_S.NEXTVAL;

1217: END IF;
1218: CLOSE validate_instance_csr;
1219:
1220: -- fetch the next value from the sequence
1221: l_inst_routing_id := AHL_VISIT_INST_ROUTINGS_S.NEXTVAL;
1222:
1223: -- insert a record in the AHL_VISIT_INST_ROUTINGS table
1224: INSERT INTO AHL_VISIT_INST_ROUTINGS
1225: (

Line 1332: UPDATE AHL_VISIT_INST_ROUTINGS SET

1328: RETURN;
1329: END IF;
1330:
1331: -- update a record in the AHL_VISIT_INST_ROUTINGS table
1332: UPDATE AHL_VISIT_INST_ROUTINGS SET
1333: inst_routing_code = p_inst_routing_code,
1334: object_version_number = object_version_number + 1,
1335: security_group_id = NULL,
1336: last_update_date = SYSDATE,